- Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets
- Created Design Specification Documents including source to target mappings
- Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema
- Extracted data from various source systems like Oracle, SQL Server, XML and flat files and loaded into relational data warehouse and flat files
- Designed and developed complex mappings using various transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more
- Created and scheduled Sessions, Jobs based on on-demand using Workflow Manager
- Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger
- Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
- Experienced in designing and integrating the Enterprise Data warehouse and Data Marts in different environments like Teradata, Oracle
- Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
- Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and also helped to resolve various data issues
- Used SQL tools like Teradata SQL Assistant to run SQL queries and validate the data.
- Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse
- Provided 24x7 production support for business users and documented problems and solutions for running the workflows
Environment : Informatica PowerCenter 9.0.1, Teradata, MS SQL Server, Flat Files,UNIX, Windows,
CA workload Automation,SQL Server.