Data Engineer - Informatica ETL & Data Quality

Location:

South Windsor, CT

Posted:

July 24, 2026

Contact this candidate

Resume:

Al Billah

South Windsor, CT *****•**********@*****.***•860-***-****•https://www.linkedin.com/in/almoktafi-billah/

Data Engineer/ETL Developer/Administrator/ETL Tester/Data Quality /Data Migration

Accomplished Software Engineer with 10+ years of expertise in Business Intelligence and Data Integration, specializing in ETL development using Informatica Power Center, Informatica Data Quality (IDQ), and Informatica Intelligent Data Management Cloud (IDMC/IICS),SSIS. Proven success in architecting end-to-end ETL solutions, data cleansing, and enterprise-scale integrations across platforms including Oracle, DB2, Teradata, Netezza, and SQL Server. Strong background in relational databases, data modeling, and multidimensional data warehouse design, with advanced skills in performance tuning, XML integration, and Unix shell scripting for automation. Adept at partnering with business stakeholders and cross-functional teams to gather requirements, design solutions, and ensure successful project delivery. Proficient with Agile methodologies and DevOps tools such as JIRA, Control-M, and Jenkins for project management, scheduling, and deployment. Experienced in Data Quality, Data Governance, and best practices for data warehousing and BI solutions.

Core Competencies:

ETL Architecture & Data Integration Strategies

Data Quality Assurance & Cleansing Techniques

Dimensional Modeling & Relational Database Management

Performance Optimization & Query Tuning

XML Parsing & Transformation

Unix Shell Scripting & Automation

Business Intelligence & Data Warehousing

Data Governance & Big Data Technologies

Agile Project Management & DevOps Integration

CAI, CDI, and secure agent deployment models.

Technical Skills

ETL & Data Integration Tools:

Informatica PowerCenter (v10.2, 9.6, 9.5, 9.1, 8.6, 7.1), Informatica Data Quality (IDQ), Informatica IDMC (Informatica Data Management Cloud), Informatica MDM (v10.2), Informatica Axon, Microsoft Purview (v10.2, 9.6.1), Informatica PowerExchange (v9.6, 9.5, 9.0.1, 8.6)

Data Warehousing:

Multidimensional Model Design, Star Schema Development

Data Modeling Tools:

MS Visio (2010, 2007), ERwin Data Modeler (v4.5, 3.1)

Databases:

Oracle (12c, 11g, 10g, 9i), Microsoft SQL Server (2012, 2008, 2000), MS Access, Sybase, IBM DB2, MySQL, Teradata (v14, v13, v12), Netezza, Azure Databricks, Snowflake, AWS S3 (Simple Storage Service), AWS Glue,GCP

Programming & Big Data:

SQL, PL/SQL, HTML, Unix Shell Scripting, Hadoop HDFS, Hive, Spark, Python (Pandas, NumPy)

Reporting & Visualization Tools:

Power BI, IBM Cognos 7, QlikView 12, Qlik Sense 3, Matplotlib

Operating Systems:

Windows (7, XP), Linux, Sun Solaris, AIX, MS-DOS

Applications & Productivity Tools:

MS Office (2010, 2007), MS Project, Microsoft SharePoint, Toad (v9.2, 8.6), FrontPage

Deployment & Version Control:

Perforce, TeamCity

Defect & Task Tracking Tools:

HP Quality Center, JIRA, Agile Central (Rally)

Professional Experience

Lead Informatica MDM/ IDQ Developer ADM JAN 2026 – Present

As a Data Quality and MDM developer Translate functional requirements into technical specifications and develop code and interfaces for Global Business Services.

Different source system Profile source data and analyze all source data and metadata characteristics.

Design and execute mappings to cleanse, de-duplicate, transform, and load master data.

Implement and optimize data loading and quality processes, including transliteration, parsing, analysis, standardization, and enrichment for efficient batch execution.

Deploy and manage data mappings in scheduled, batch, or real-time environments.

Document all mappings, mapplets, and rules in detail and deliver documentation to stakeholders.

Utilize Informatica Developer to design and develop custom objects, rules, reference data tables, and create/import/export mappings.

Run ETL jobs for address standardization, email cleanup, name parsing, and validation using Informatica Data Quality (IDQ) and load data into Informatica MDM.

Analyze and provide data metrics to management on data loads and data quality improvements.

Write shell scripts to invoke mappings or workflows.

Develop and execute SQL queries for data verification.

Deploy and validate objects across different environments.

Perform unit testing and verify end results against business requirements.

Lead Informatica Data Quality / Data Steward LoanCare April 2024 – Dec 2025

Served as Senior ETL & Data Quality Developer on a data warehouse initiative, responsible for requirements gathering, mapping document preparation, end-to-end ETL architecture, and complex ETL development for Teradata, Oracle, DB2, and SQL Server targets.

Designed ETL workflows for data cleansing, file handling, error handling, and data migration.

Collaborated with data architects, BI architects, and data modeling teams to align with enterprise data models and warehouse standards.

Participated in functional and technical design reviews, providing leadership in solution design and data quality strategy.

Leveraged Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE) for profiling, scorecard generation, business rule validation, and data quality assessment.

Implemented IDQ transformations (Labeler, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, Classifier) to standardize, validate, deduplicate, and consolidate consumer data from vendors (e.g., Acxiom, Alliant), improving accuracy of master records.

Created and maintained reference data sets, regular expressions, and lookup tables for data standardization and anomaly detection.

Optimized IDQ mappings and workflows for performance tuning, ensuring high throughput on large datasets.

Developed reusable mapplets, transformations, and components to improve development efficiency and maintainability.

Integrated Informatica IDQ with Informatica PowerCenter, enabling data quality mappings and mapplets to be reused in ETL processes.

Applied Test Data Management (TDM) for sensitive data masking across development and QA environments.

Automated data loads and cleansing tasks via Unix/Linux shell scripts for Informatica workflows and ELT processes.

Worked with Oracle SQL Loader for high-volume flat file ingestion into Oracle tables.

Partnered with QA teams on environment setup, test case reviews, test execution, and defect resolution.

Authored release and implementation documentation, managed initial data loads and catch-up processes, and provided on-call production support to ensure SLAs (Service Level Agreements) were met.

Enhanced Business Objects universes by adding new data objects, classes, and contexts to support BI reporting.

Led enterprise-wide data stewardship efforts, overseeing data quality improvements for 100+ critical data elements, resulting in a 25% increase in regulatory reporting accuracy.

Lead Data Quality / Data Governance / ETL Developer / Administrator Boeing Jan 2023 – Apr 2024

Environment: Informatica PowerCenter 10.2, Informatica Data Quality (IDQ) 10.2, Teradata, Oracle 11i, Fastload, Multiload, Tpump, Toad, WinSQL, PuTTY, UltraEdit, JIRA, Jenkins, ServiceNow

Led end-to-end Data Quality, Data Governance, and ETL initiatives, including requirements gathering, solution design, implementation, and production support for large-scale data warehouse integration.

Designed and implemented Informatica Data Quality (IDQ), Customer Data Quality (CDQ), and Axon Data Catalog solutions, enabling consistent governance and improved master data management.

Performed data profiling, data validation, and cleansing using Informatica Data Explorer and IDQ, implementing matching, consolidation, and survivorship strategies to ensure accuracy of master data records.

Developed and optimized Informatica PowerCenter workflows and IDQ mappings, including performance tuning and leveraging Teradata utilities (Fastload, Multiload, Tpump) for high-volume data loads.

Automated ETL processes by developing PL/SQL procedures and Unix shell scripts, supporting data migration and modernization to Snowflake.

Installed, configured, and administered Informatica PowerCenter and IDQ across development, test, and production environments, ensuring high availability and performance.

Configured Informatica repositories, servers, and clients, established connectivity to diverse data sources (databases, flat files, applications), and managed backup, recovery, and repository security.

Scheduled, monitored, and supported ETL workflows using Control-M and Informatica Scheduler, improving on-time data delivery for business-critical reporting.

Partnered with data architects and BI teams on data modeling, source-to-target mapping, and documenting complex data flows and transformations.

Conducted gap assessments of data governance and cataloging processes, recommended improvements, and contributed to CDGC implementation to enhance compliance, lineage, and data quality.

Configured and maintained the data catalog, including user account provisioning, role-based access control, and metadata curation.

Created training materials and conducted workshops for business users, enabling adoption of Informatica tools and reinforcing governance standards.

Collaborated with data owners and custodians to resolve data quality issues, enforce governance policies, and align with compliance requirements.

PowerCenter / Informatica / IDMC (Intelligent Data Management Cloud) Developer Exelon Energy May 2021 – Dec 2022

Environment: Informatica PowerCenter 10.4, Informatica IDMC (CDI, CDQ, CAI), Oracle CC&B, Oracle RMS, Snowflake, AWS (S3, Redshift, Lambda), Azure, SQL Developer, SQL Loader, Linux, Toad, Winsql, Putty, Ultra Edit, XML, Jenkins, ADO, Python (Pandas, NumPy), PL/SQL

Spearheaded end-to-end ETL development for large-scale data warehouse initiatives, including requirements gathering, mapping documentation, and data flow architecture to optimize integration into target systems.

Designed and implemented Informatica PowerCenter and IDMC workflows to enable seamless data flow across on-premise and cloud platforms (AWS, Azure, Snowflake).

Migrated legacy ETL processes from PowerCenter to IDMC, reducing runtime by 30% and improving scalability and cloud adoption.

Built and maintained ETL pipelines using Informatica Cloud (CDI, CAI, Secure Agent), automating ingestion and transformation processes, reducing manual effort by 40%.

Created and configured mapping tasks, synchronization tasks, and replication tasks in IICS, leveraging Bulk API and Standard API as required.

Established Snowflake connections in IICS to load enterprise data from multiple source systems into cloud data warehouses, enabling downstream analytics.

Developed Python scripts (Pandas, NumPy) for data profiling, validation, and transformation, complementing Informatica workflows and improving data quality.

Automated workflows using Unix shell scripting to streamline Informatica job execution, cleansing, and loading activities.

Applied data quality rules (completeness, validity, accuracy) to ensure trusted and high-quality data across merchandising and operational datasets.

Collaborated with data architects, BI specialists, and modeling teams to align data integration and governance strategies with business requirements.

Delivered SQL-based validation test plans with execution results, ensuring stakeholder approval prior to production release.

Provided ongoing Informatica administration support: repository maintenance, performance optimization, service monitoring, and incident resolution.

Developed Python scripts (Pandas, NumPy) for data profiling, validation, and transformation, complementing Informatica workflows and improving data quality.

Integrated Oracle RMS with AWS S3 and Redshift for real-time retail analytics and reporting.

Led the migration of CAI and CDI workloads from legacy agents to the latest O3 Secure Agent, ensuring minimal downtime and seamless cutover.

Performed agent upgrade planning and execution, including pre-migration validation, dependency analysis, and post-deployment verification.

Reconfigured connections, runtime environments, and security settings to ensure compatibility with the new O3 agent architecture.

Validated and migrated Taskflows, Mappings, Mapping Tasks, and Application Integrations to run reliably on the O3 agent.

Troubleshot agent compatibility issues and optimized performance across CAI processes, CDI pipelines, and DVO test cases.

Coordinated with platform and network teams to ensure the O3 agent met resource, firewall, certificate, and proxy requirements.

Senior PowerCenter / Informatica / IDMC (Intelligent Data Management Cloud) Developer IEnergy Harbor Feb 2020 – Apr 2021

Environment: Informatica PowerCenter 10.2/9.6.1/9.5/8.6.1, Workflow Manager/Monitor, Power Connect/Power Exchange, Data Analyzer 8.1, Informatica Cloud (IICS/IDMC), CDGC, CDQ, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Snowflake, AWS, Python (Pandas, NumPy)

Gathered business requirements, performed analysis, and converted specifications into efficient ETL solutions.

Designed and developed mappings in Informatica PowerCenter (Designer, Repository Manager, Workflow Manager/Monitor).

Migrated data from SAP to Oracle using Informatica ETL processes.

Developed complex mappings with Type 1 and Type 2 Slowly Changing Dimensions (SCDs) to maintain data warehouse history.

Designed dimensional models (Star Schema) using Erwin for fact and dimension tables.

Extracted, transformed, and loaded data from flat files, SQL Server, Oracle, and Sybase into the enterprise data warehouse.

Automated workflows with Autosys; implemented workflow tasks such as sessions, events, decisions, email alerts, and worklets.

Integrated and migrated data between on-premises Informatica and IDMC/IICS, leveraging Secure Agent for hybrid cloud connectivity.

Configured source and target connections in IICS, creating mapping tasks, synchronization tasks, and replication tasks using Bulk API and Standard API.

Built secure pipelines from SFDC and SQL Server into AWS S3 and Snowflake.

Collaborated with admin team for runtime environment setup, version updates, and connectivity configurations.

Implemented data quality rules for cleansing, validation, and transformation (SKU matching, store code validation, missing value handling, markdown/promotion rules).

Created and managed tasks in Cloud Data Governance and Catalog (CDGC) and Cloud Data Quality (CDQ).

Utilized Python (Pandas, NumPy) for data validation, profiling, reconciliation, and automating test scripts to ensure high-quality ETL deliverables.

Authored test plan documentation, SQL validation scripts, and provided results with evidence for business sign-off prior to production deployment.

IDQ Developer /Informatica Developer/Informatica IDQ Administrator/ Azur data Brick/MDM /Sales Force Pratt & Whitney I FEB 2018-FEB2020

Served as Senior ETL Informatica and Data Quality (IDQ) Developer for a large-scale Data Warehouse initiative.

Designed and implemented end-to-end ETL workflows and complex data integration procedures.

Performed extensive data profiling and cleansing using Informatica Data Quality transformations.

Conducted matching and consolidation to eliminate redundancy and achieve master records.

Applied transformations such as Standardizer, Labeler, Parser, Address Validator, Match, Merge, and Consolidation.

Tuned performance for Informatica ETL and IDQ mappings to optimize system efficiency.

Built reference data objects, token sets, regular expressions, and lookup tables for cleansing and parsing.

Integrated Informatica Data Quality (IDQ) with Informatica PowerCenter for streamlined data operations.

Led end-to-end Salesforce data integration using Informatica IDQ and PowerCenter,

enabling seamless synchronization between Oracle/Teradata systems and Salesforce CRM.

Handled production and system testing defects, providing resolutions and ensuring SLAs were met.

Designed and optimized Salesforce data cleansing pipelines using IDQ transformations such

as Standardizer, Parser, Address Validator, and Match/Merge to improve record accuracy and eliminate duplicates for Master Data Management (MDM).

Implemented Salesforce PowerExchange connectors to extract, transform, and load

(ETL) enterprise data into Salesforce objects, ensuring data consistency across customer, product, and sales modules.

Supported production components post-deployment with on-call troubleshooting.

Environment: Informatica PowerCenter 10.2, Informatica Data Quality (IDQ) 10.2, Teradata, Oracle 11i, Fastload, Multiload, Tpump, TPT, TOAD, SQL Developer, JIRA, Jenkins, ServiceNow, Control-M, UNIX/Linux.