SUMMARY

• 6 years of experience in designing the architecture, development, implementation, documentation and support of ETL processes for large scale data warehouses using Informatica 8.x/9.1/9.6, B2B DX/DT v 8.0, SSIS, SSRS.
• Used different Informatica tools such as Informatica Power Center (Designer, Repository Manager, Workflow Manager, Workflow Monitor and Admin homepage for Repository & Integration services), IDQ and Informatica PowerExchange
• Extensively worked on data extraction, Transformations and loading data from various sources like Oracle, SQL Server and non - relational data sources like XML and Flat files
• Well versed in developing thecomplex SQL queries, unions, joins, views, PL/SQL(Stored Procedures, Functions, Triggers and Packages) and indexing.
• Well versed wif Transformations - Source Qualifier, Java, XML Parser, Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Stored Procedure, Normalizer, SQL and Rank
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions on 24/7 production support.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Good noledge and experience in Waterfall, Agile & Scrum methodologies
• Good at creating mappings documentation, Data flow diagrams and Data Modelling.
• Involved in writing test cases, performed unit testing.
• Used different schedulers like Control-M and Informatica Scheduling.
• Experience in developing mappings and tuning existing mappings and sessions for better performance
• Used InformaticaVersion Control for checking versions of the objects used in creating the mappings, workflows and to keep track of the changes in the development, test and production environment.
• Written post SQL and pre-SQL at session level. Worked on session log files and workflow log files.
• Successful in meeting new technical challenges and finding solutions to meet the needs of the client

TECHNICAL SKILLS

ETL/Informatica: Informatica 8.x/9.x, Informatica Powercenter (Designer, Workflow Manager, Workflow Monitor and Repository Manager), B2B DX/DT v 8.0, SSIS, SSRS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Programming: SQL, Store Procedures, Functions, Triggers, Views, Shell scripting, HTML, C, PL/SQL,Perl, Teradata Macros

Software Methodologies: Waterfall Model, Agile/Scrum Methodologies

Tools: Toad, SQL Developer, SQL*Plus, WinSCP, JIRA, Putty, Remedy, SharePoint

Databases: Oracle 11g/10g/9i/8i, SQL Server

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE

Informatica MDM Developer

Confidential, Columbus, Indiana

Responsibilities:

• Worked wif business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the gloden records to the target MDM database.
• Involved in MDM Design and Developmental activities
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Created mapping documents to outline data flow from sources to targets.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, Sequence Generator and Update Strategy.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Involved in writing test cases, performed unit testing, testing in the lower Environments
• Actively involved in coordination between onsite and offshore
• Involved in Maintenance and Support activities of the deliverables for one month after every deployments
• Trouble shooting production support issues
• Defect management

Module Lead

Confidential, Hoboken, New Jersey

Responsibilities:

• Worked wif business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the gloden records to the target MDM database.
• Provided task duration estimates based on detail design and provided task duration estimates.
• UsedTeradata utilities fastload, multiload, tpumpto load data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Delegating project work and stories to team members
• Involved in MDM Design and Developmental activities
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Created mapping documents to outline data flow from sources to targets.
• Identified data quality issues and their root causes.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, Sequence Generator and Update Strategy.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Designed Mappings using B2B Data Transformation Studio.
• Involved in writing test cases, performed unit testing, testing in the lower Environments
• Actively involved in coordination between onsite and offshore
• Evaluating team members’ performances
• Involved in Maintenance and Support activities of the deliverables for one month after every deployments
• Trouble shooting production support issues
• Review of project deliverables
• Defect management
• Managing Offshore Scrum calls and participating in Onsite Scrum calls

Team Lead

Confidential, Chicago, IL

Responsibilities:

• Worked wif business users and analysts to understand the requirements.
• Provided task duration estimates based on detail design and provided task duration estimates
• Delegating project work to the team members
• Developed the ETL mechanisms to load the data incrementally from the source database into the staging area and from there to feed the satellite applications in the form of flat files, XML files and relational tables. Most of the extract process was incremental, while others were full loads and snapshots.
• Design and Development of the requirements, documenting the Detail Design document and Test Strategy Document
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Valuable experience in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources like SQL Server, Oracle, Flat files, into Data Warehouse using various versions of Informatica.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Involved in writing test cases, performed unit testing, testing in the lower Environments
• Involved and lead the Production migration activities
• Actively involved in Coordination between onsite and offshore
• Evaluating team members’ performances
• Maintenance and Support
• Defect management

Team Member

Confidential

Responsibilities:

• Worked wif business users and analysts to understand the requirements.
• Design and Development of the requirements, documenting the Detail Design document and Test Strategy Document
• Involved in performance tuning and optimization of Informatica mappings and session using features like Partitions and data/index cache.
• Worked on the change data capture (CDC) process for extract the data
• Implemented Type 1 & Type 2 Slowly changing dimensions.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Extensively used Dynamic lookup to implement the type 2 changes.
• Used PMCMD commands of Informatica in UNIX scripts to schedule sessions and jobs.
• Testing in the lower Environments
• Maintenance and Support
• Review of project deliverables
• Defect management

Intern

Confidential

Responsibilities:

• Design and Development of the requirements, documenting the Detail Design document and Test Strategy Document
• Actively involved in bug fixes and trouble shooting
• Got familiarized wif importing data from various types of sources like XML and Excel sheets
• Testing in the lower Environments
• Maintenance and Support
• Defect management