Madhupal Mettu

• Created ETL Mappings to move and transform data from various sources into a centralized repository.
• Utilized IDMC / IICS to develop mappings and tasks.
• Performed advanced analytics on structured and unstructured data using SQL, Python and Snowflake.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy. Translated business rules and functionality requirements into ETL procedures.
• Streamlined data integration process by creating Informatica mappings to load information from various sources like Relational tables, Flat files, and Oracle tables into Datawarehouse, Teradata, and Greenplum databases.
• Proficient in working with Snowflake SQL queries and optimizing performance.
• Hands-on experience with AWS cloud service.

Proficient in developing mappings/transformations/mapplets using mapping designer, transformation developer, and mapplet designer in Informatica Power Center and BDE.

Implemented optimized workflows and applications using Informatica BDE.

Demonstrated expertise in effectively using transformations like Lookup, Update Strategy, Expression ,Filter,R outer ,Joiner and Aggregate.

· Dedicated efforts towards improving performance by extensively working with SQL override in Source Qualifier Transformation.

Created test plans for unit-tests, system integration tests, and UAT efforts. Ensured comprehensive code testing across all development phases.

Developed ETL standards, implemented effective Naming Conventions, and documented ETL flow processes.

Implemented the use of AutoSys for running parallel informatica jobs effectively.

Loaded data from Hadoop into Greenplum databases using BDE

Developed mappings, workflows, and applications using Informatica BDE developer.

Successfully implemented Informatica BDE to facilitate streamlined Data Extraction, transformation, and loading procedures in adherence to best practices.

Achieved the successful parallel execution of Informatica and Hadoop jobs by utilizing Control M system.

Developed efficient workflows by incorporating mappings, command tasks, and decision models.

Ensured accuracy and efficiency by consistently monitoring mappings, workflows, and applications using Informatica BDE Monitor.

Performed Unit testing, Integration testing and System testing of Informatica mappings and applications.

Created tables using Hive tables internally/externally, worked on optimizing Hive SQL queries and tuning.

Proficient with Hadoop Hive and HDFS.

Designed and implemented Informatica BDE mappings, workflows, and applications to efficiently load data from various sources (Relational tables, Flat files, Oracle tables) into Hadoop and Netezza databases

Created and executed comprehensive test plans for unit-test, System Integration Test, and UAT phases.

Implemented parallel execution of Informatica and Hadoop jobs using Tidal

Executed extensive use of Informatica BDE for supporting ETL processes including Data Extraction, transformations, and loading.

Implemented views in Hive database to facilitate data transfer into both Hive and Netezza databases.

Leveraged Informatica Power center for efficient extraction, transformation and loading of data from both relational and non-relational sources.

Extensively utilized various transformations including Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Lookup (Static and Dynamic), Update Strategy, Source Qualifier Joiner and Normalizer.

Developed Informatica mappings, re-usable transformations, and Mapplets for efficient data loading to the data warehouse.

Designed, developed and tuned PL/SQL stored procedures and SQL queries, enhancing performance

Wrote complex SQL queries to perform data validation and profiling, including joining multiple tables.