Senior Informatica ETL

Farrukh Rahman

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

Clearance: Secret (DoD) *******.******@*****.*** • LinkedIn

Experienced Data ETL lead and developer with over a decade of experience in managing and executing data integration projects using primarily Informatica (PowerCenter on-premise tools and IDMC/IICS cloud). In addition to informatica, have familiarity and used MS Azure Data Factory and Palantir Foundry for ETL pipelines. Leveraged Informatica's data integration platform to prepare and manage data for visualization, collaborating with tools like Tableau and Power BI to create comprehensive reports.

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

MS Azure Data Factory

AWS Glue

Palantir

Datahub Data Catalog

IBM Data Stage

Oracle RDBMS

SQL Programming

PL/SQL Programming

Python Programming

Java Programming

MS SQL Server

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

MITRE Corporation Mar 2024 - Present

LEAD DATA ENGINEER – L146

As a Lead Data Professional at MITRE, I contribute to a wide array of projects, encompassing data integration, data cataloging, and the development of sophisticated data ontologies. I design innovative solutions by leveraging advanced methodologies and cutting-edge tools.

Advanced Battle Management System (ABMS) – US Airforce

The Advanced Battle Management System (ABMS) Data Strategy establishes a framework with data-as-a-service (DaaS) and governance to ensure quality data is controlled and accessible in the Advanced Battle Management System (ABMS). As part of the deliverables to the ABMS project.

Selected and implemented data catalog software - Datahub ( https://datahubproject.io/), for the prototype, evaluating its features against other tools and developing a comprehensive comparison document.

Designed an architectural framework for a distributed data mesh data catalog system, ensuring scalability and adaptability to the evolving data needs of the ABMS organization.

Researched and implemented optimal syncing strategies to maintain consistent metadata across all nodes, enhancing data reliability and accessibility. This is a key requirement of the ABMS Data Strategy to maintain a consistent metadata repository across all master and child nodes.

Explored and tested Datahub APIs using GraphQL scripts and the Python SDK, creating sample scripts to assist users with metadata searching.

Developed documentation for a highly available Datahub installation using AWS cloud services, Kubernetes, and Elasticsearch clusters, ensuring a resilient environment safe from DDIL (Denied, Disrupted, Intermittent, and Limited Impact).

CDC – NVSS Modernization Project

Modernizing CDC's National Vital Statistics System (NVSS) by transitioning from on-premises infrastructure to a hybrid cloud solution

Conducted a thorough analysis of existing processes (SSIS packages) with team members, and analyzed the technologies being used, which primarily involved Microsoft tools such as SQL Server, Integration Services, and SQL Server Analysis Services. Identified and documented data collection methods from multiple sources and the use of analytical cubes for management decision-making.

Following the initial analysis, I assisted in setting up a sandbox environment for team use, created databases and cubes, and developed various SSIS packages to replicate the existing CDC processes.

Created services on Azure, such as Managed Instances, Azure SQL databases, Azure Data Factory and Analysis Services, as part of a prototype to shift on-premises services to the cloud, converting the existing system into a hybrid cloud/on-premises environment.

As the main Data Engineer of the project, I assisted the team with setting up their accounts and permissions, as well as resolving other database-related issues encountered during their development.

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 Intelligent Cloud Services (IICS) assets, including tasks, mappings, and mapplets, to meet business requirements. Utilize advanced transformations and data integration features within IICS to implement end-to-end workflows and data pipelines. Collaborate with stakeholders to ensure accurate data synchronization and efficient ETL/ELT processes in a cloud-based environment.

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