Gargi Saha

- Creating mapping using ETL tool – Informatica Powercenter; Designing and implementing appropriate ETL mappings to extract and transform data from various sources to meet requirements.
- Requirement analysis, designing, developing, implementing and executing a project.
- Monitoring the running of process, Root cause analysis of incidents or business issues.
- Providing continuous and flexible support during production validation and product go-live.
- Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies

• SME in data warehousing using ETL tool – Informatica Powercenter
• Designing and implementing appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Worked on loading of data from several flat files to Data Warehousing system.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Monitoring sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Good working experience on writing SQL queries and Stored procedures, proficiency in developing SQL with various relational data bases like SQL server, MySQL, Teradata.
• Good working experience on Unix and Unix scripting
• Designing control-m jobs, scheduling jobs
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Optimizing performance tuning at source, target, mapping and session level.
• Use of advance ETL transformations like XML, Cobol source, java transformations etc
• Preparation of complete test case scenarios that covers the entire process and aligns with business requirements.