Informatica Developer Resume

SUMMARY

7+ years of professional experience in Data Warehouse ETL Design and Implementation.
Experience in the Analysis, Design, Development, Testing and Implementation phases of data integration using Informatica Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
Expert knowledge in using Informatica Power Center for Extraction, Transformation and Loading of data using heterogeneous source & target systems like Flat files (fixed width and delimited), Oracle, SQL Server, Teradata .
Strong knowledge in Oracle, Sql server - Sql, Stored Procedures, Functions, Cursors, Triggers.
Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Sorter,Rank, Routers, Union, Unconnected / Connected dynamic Lookups, Aggregators, TransactionControl, Sql Transformation, Java Transformation, Normalizer, Stored Procedure Transformations.
Strong knowledge in Data warehouse life cycle - Requirement analysis, Design, Development, Testing, Support and Implementation.
Involved in supporting and performing Unit testing, System Integration testing, UAT and production support for issues raised by application users.
Experience in preparing the ETL Specifications and Technical Design documents.
Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member
Excellent problem-solving skills, analytical skills, good communication and interpersonal skills.

TECHNICAL SKILLS

Technical Skills: Informatica power center

Database: Oracle 10g & 11g, SQL Server 2008,Teradata

ETL Tools: Informatica Power center 9.x/8.x/7.x

Operating Systems: Windows 2000/XP/Vista, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

Majorly involved in enhancement activities and adhoc development and perform data analysis.
Managing a team of four and inducting the new comers providing basic technical training and project orientation.
Implemented slowly changing dimension (SCD) Type 1 and Type 2 for Change data capture.
Little exposure in Microsoft Sql server MDM implementation.
Implemented Aggregate table load using Sql server Stored Procedures.
Responsible for overall project ETL admin Activities - deployment of code into production environment from UAT.
Created mapping with Java transformation to convert unknown number of columns into rows.

Confidential

Informatica Developer

Responsibilities:

Actively involved in the entire DW life cyle- Requirement analysis(In this project, requirement gathered based on the analysis done from Genio code ), Design, Development, Testing, Support and Implementation
Analyzed the whole system of the project which was developed in the ETL tool, Genio and prepared the low level design document to migrate the same logic/code into Informatica 8.6.
Involved in Development phase of the project.
Involved in preparing the unit and SIT test cases and testing the mappings as per the test cases.
Performed data analysis between Genio and Informatica loaded targets and fixed the Informatica code if any.
Involved in UAT Bug fixing and deployment.

Confidential

Informatica Developer

Responsibilities:

Majorly involved in enhancement activities.
Performance tuned long running ETL jobs.
Created and used reusable transformations when required.
Extensively used mapping parameters, mapping variables and parameter files.
Involved in Unit and system testing.
Prepared Design document, Unit test case and System test case documents.
Worked as a team member and coordinated with team to deploy the deliverables in estimated duration.

Confidential

Project Abstract

Responsibilities:

Analysed the high level design documentation to understand the business requirements and transformed it to ETL specification.
Development of ETL mappings, sessions and workflows .
Performed unit testing.
Created a batch script to do a file check and trigger the workflow accordingly.
Created Sql queries for Test case Documentation.
Preparation of code delivery and migration documentation.
Awarded "Star of the Project" to recognize my best performance in the team as a fresher.