Pratima Pandey

An ETL Informatica Cloud developer with 6+ years of IT experience. My main responsibility is to design, develop,

and maintain data integration solutions using the Informatica cloud IICS and Informatica PowerCenter tool

• Excellent experience in designing and development of ETL Methodology using Informatica cloud IICS and

Informatica PowerCenter 10.5, 9.6.1/9.1.1

• Having experience in working with ORACLE 11g/10g, MySQL, SQL Server 2017/2014 databases.
• Expert in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x
• Worked extensively in Requirements gathering, Development, testing and Production deployment.
• Prepared various types of documents like Data Mapping, Test cases, Data dictionary etc.
• Expert in writing SQL query using multiple databases like ORACLE, SQL Server, MySQL etc.
• Extensive knowledge of Informatica tuning and SQL tuning.
• Experience in integration of various data sources into staging area.
• Experience on Informatica cloud Services (ICS) by using bundles, Integration Templates, Mappings, Task Flows,

Saved Queries, Input / Output Macro fields, Mapping Configuration Tasks and Cascading Filters.

• Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
• Designed and developed complex mappings, mapplets, tasks and workflows and tuned it.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Good understanding of the Data modeling concepts like Star-Schema, Snowflake Schema Modeling.
• Experience in optimizing the Mappings and implementing the complex business rules by creating reusable transformations like mapplets.
• Extensively used Slowly Changing Dimension (SCD) technique in business application.
• Used UNIX command for multiple file operation for data viewing, data parsing and filtering.
• Experience in migrating code through CI/CD pipeline using GIT and Bitbucket
• Experience in Performance tuning of ETL process using pushdown optimization.
• Understanding of AWS cloud and some of its Product like S3 Bucket, EC2 etc.
• Good experience in working with onshore, offshore team and End to End teams to ensure commitments are met.

Master in Science from Sam Higginbottom University of Agriculture Science & Technology, India