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