• Developed end-to-end ETL (Data extraction, transformation, load) jobs using Informatica Power Center & Informatica Cloud (IICS), AWS Glue, and Azure Data Factory (ADF) for Data Migration and Integration projects.• Migrated on-premises data integration process to AWS cloud platform, demonstrating expertise in data engineering, ETL, and cloud migration.• Collaborated with stakeholders to gather and analyze requirements, identify dependencies, and implement creative solutions that meet business requirements.• Designed and implemented data pipeline for extraction, parsing, and processing data from APIs, XML, JSON formats, flat files, relational databases, SOAP/REST APIs, SAP, and CSV files.• Created and managed provisioning and dependencies of AWS resources, including VPC, RDS database, lambda, SNS, SQS, Glue crawlers, s3 buckets, and Athena queries using AWS CDK.• Built automated data pipelines in Cloud Platforms for data cleansing, data standardization, deduplication, and handling missing values, improving data consistency and quality.• Created and orchestrated DAGs using Apache Airflow and defined tasks, parameters, and dependencies between jobs.• Led four data migration projects, guiding and mentoring a team of 10 members to achieve successful project completion, developing a proficient team that consistently meets objectives.

• Developed data pipelines for ETL jobs using Informatica and Glue to efficiently extract, transform, and load data from various sources to data lakes, data marts, and data warehouses.• Built automated data pipelines to process data for new customer onboarding, updating demographic changes, and capturing transactions in data marts.• Designed data models, and implemented data lake and warehousing solutions for reporting purposes by loading daily data from OLTP to OLAP dimensions and fact tables.• Implemented Slowly Changing Dimension (SCD1 and SCD2) to process changes in source data and capture historical data in a data warehouse.• Troubleshot ETL job failures and performance issues to ensure timely and accurate data processing to improve data integrity and operational efficiency.• Experienced in troubleshooting, performance Tuning, and debugging of existing Informatica mappings and workflows.• Created SQL queries, stored procedures, views, materialized views, user-defined functions, and relational database models for data cleansing, transformation, and quality check.• Developed custom scripts to generate dynamic configuration files for concurrent execution of data pipelines, resulting in a reduction of overall processing time by 30%.