Farrukh Rahman

Ashburn, Virginia 443-***-****

Clearance: Secret (DoD) ad3njv@r.postjobfree.com • LinkedIn

Experienced Data ETL lead and developer with over a decade of experience in managing and executing data integration projects using primarily Informatica ETL on-premise tools and IICS cloud. Knowledgeable in Datawarehouse design, data quality, data modeling, data governance, and data analysis. Skilled in SQL, PL/SQL, Python, and Shell scripting. Seeking a challenging role that leverages my technical and leadership skills to deliver innovative and efficient data solutions

TECHNOLOGIES:

IICS Data Integration (CDI)

Informatica PowerCenter

Informatica Data Quality

Informatica Power Exchange

Informatica MDM MDE

IBM Data Stage

Oracle RDBMS

MS SQL Server

SQL Programming

PL/SQL Programming

Python Programming

Java Programming

AWS Glue

MS Azure Data Factory

COMPETENCIES:

Data Integration (ETL) Processes

Data Mart Design

Data Warehouse Design

Data Quality, Data Profiling & Analysis

Database Application System Development

Data Migration

Legacy Conversion

System Synchronization

Instance Consolidation

PROFESSIONAL EXPERIENCE

INFORMATICA CORPORATION – Washington DC Metro Area 11/2005 – 11/2023

PRINCIPAL CONSULTANT – INFORMATICA PROFESSIONAL SERVICES

Provided data integration consulting services to Informatica customers as part of Informatica Professional Services. Offered subject matter expertise in the design, build, and deployment of project data integration components.

Provided expert guidance to clients in analyzing, evaluating, and setting up their Informatica domain as per industry best practices.

Gathered requirements from stakeholders to understand the business needs.

Developed source-target matrix to map the data flow between source and target systems.

Created ETL process documents to outline the data processing steps and data quality checks.

Design and develop Informatica PowerCenter mappings including transformations, mappings, mapplets as per business requirements.

Developed and implemented end-to-end- ETL process workflow consisting of sessions and other tasks to automate and control data flow.

Responsible for investigating and resolving data-related issues, troubleshooting ETL failures, and providing technical support.

Installed, upgraded and configured Informatica platform and services that included PowerCenter, Model Repository, Metadata Manager for single, multiple node (Grid), and High-Availability architectures.

On Data Quality projects profiled and analyzed multiple data sources. Conducted cleansing, de-duplication, and consolidation that addressed master data management problems across the enterprise.

On MDM projects configured MDM MDE hub, built landing and staging zones, loading data into base objects, configuring match and trust rules components.

On System data synchronization projects, developed processes to move data and create consistency across two or more internal systems by delivering synchronized data.

On Instance consolidation project design migration processes to reduce and consolidate data from multiple instances into a single or fewer instance to ensure data quality, facilitate data analysis, and support various reporting and business intelligence needs.

SRA INTERNATIONAL INC. – Rosslyn, VA 6/2004 – 10/2005

SENIOR DATA WAREHOUSE DEVELOPER

Served as a senior member of the technical staff working on the analysis and design of the Bureau of Global Health, USAID enterprise information system.

Addressed challenges in the existing system characterized by disparate data sources. Engaged in the timely retrieval of consolidated information.

Proposed and developed an Enterprise Information System (EIS) that consolidated data from existing systems into a single repository. Facilitated real-time access to consolidated information.

Scoped the project to identify and analyze relevant data sources and business processes. Designed a dimensional star schema for the data warehouse.

Utilized tools that included Erwin for data modeling, Informatica Power Center for ETL processes, and Cognos for Business Intelligence reporting.

Successfully loaded data from various sources into the data warehouse. Consolidated information and providing users with a single data source for informed decision-making.

AMERICAN UNIVERSITY – Washington, DC 12/2001 – 6/2004

APPLICATION ANALYST – E-ADMINISTRATION/INFORMATION SERVICES DEPARTMENT

Developed business process and functional requirements for applications and communicate these requirements to the design and build teams.

Served as the primary Developer for the University warehouse's data ETL process using the DataStage ETL tool. Developed and documented logical and physical data models, data dictionary, mapping of data elements to requirements, data analysis, specifications, and data flows using software development methodology.

Developed enterprise Web-based data-driven application utilizing Oracle Application Server using Oracle Web PL/SQL Toolkit, JavaScript, HTML to retrieve data from an Oracle RDBMS and format the data for display in a Web browser.

Provide application design, testing, and user documentation for the functional departments.

THOMSON FINANCIAL RESEARCH (A Thomson Financial Company)- Rockville, MD 8/1998 – 7/2001

DATABASE ENGINEER

Designed and implemented the Public View project that replaced the legacy delivery mechanisms that inhibited the flow of data to products. Delivered data at the lowest common denominator that enabled market groups more data manipulation flexibility.

Designed, implemented, and supported the IDF (Insider Data Feed) project that targeted replacing a legacy data extraction system.

Gather requirements from other technical staff, Project Managers, and users to perform the business analysis required to properly define the business problems and requirements that the designed system must address to support the Thomson Financial product.

Worked as a development team member on projects to successfully design and implement data loading, data transformation, and data extract processes to satisfy business requirements using SQL, PL/SQL, Java, Unix, and Perl shell scripting languages.

Maintain and enhance database schema using ER-Win entity-relationship diagramming/modeling tool.

Perform database administration tasks in the role of junior application DBA. Assist the senior DBA in establishing, and maintaining tablespaces, rollback segments, tables, views, database triggers, integrity constraints, indexes, stored procedures, schemas, roles, profiles, and synonyms, analyzing and tuning SQL scripts for performance issues. The Oracle Enterprise Manager and Toad were used to support the mentioned activities.

EDUCATION & PROFESSIONAL DEVELOPMENT

Master of Science in Management Information Systems, University of Baltimore, Baltimore, Maryland

Master of Science in Engineering Management, University of Maryland, College Park

Master of Science in Structural Engineering, University of Illinois, Chicago

Training & Professional Development:

IICS Cloud Data Integration

IICS Cloud Data Quality,

IICS Administration,

MDM MDE Configuration

Informatica PowerCenter Development

Informatica Data Quality Development

Developing PL/SQL Program Units

Oracle for Experienced SQL Users,

Oracle 8i: SQL Statement Tuning Workshop

ER-Win for Data Modeling,

Java Programming, Thomson University

Certifications:

IICS-CDI Implementation Practitioner Certification

Informatica Certified Developer

Informatica Data Quality Specialist

Informatica Certified Administrator

Oracle Certified Professional (OCP) - Developing PL/SQL Program Units

Oracle Certified Professional (OCP) - Oracle for Experienced SQL Users

Contact this candidate