ETL Developer Resume

OBJECTIVE

To pursue a challenging IT career and to be part of a progressive and growth - oriented organization that gives me scope to enhance my knowledge and skills to cope up with the latest technological changes.

SUMMARY

Having 6.5 years of experience on strong ETL data integration experience using Informatica, responsible for handling various projects belong to offshore and onshore.
Extensive hands-on expertise using Informatica 9.x and 8.x with adequate business understanding of Energy and Infrastructure.
Extensive knowledge on in developing Informatica Mappings to extract data from different sources like Oracle, Flat files, XMLs and Global Dimensions.
Good understanding of relational database management systems like Oracle and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
Developed Informatica Mappings by using different Transformations like Normalizer, Router, Update strategy, HTTP and Parameter files, mapping variables etc.
Have experience in developing ETL mappings and testing them with various created test plan docs, test results and the code migration documents for SIT and PROD environment.
Experience in writing complex shell scripting for various ETL needs.
Conversant with ISO 9001 quality procedures, while executing my projects. I am also aware of the SDLC and CMM process used in my project.
Have fair idea of REST webservices usage through Informatica powercentre.

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

Assist in modifying existing software to correct errors, adapt it to new hardware or upgrade interfaces and improve performance.
Perform accurate analysis and effective diagnosis of client issues.
Developed complex mappings in Informatica and write shell scripts to meet client requirement for flat files and XMLs.
Provide production support when there are issues in existing interfaces and get them resolved in minimal time.
Work on production cut over replacing the old jobs with improvised jobs and monitoring the production jobs
Used to GET and POST data using REST webserive on .net server.

Confidential

Informatica Developer

Responsibilities:

Confidential

Informatica Developer

Responsibilities:

Confidential

Informatica Developer

Responsibilities:

Co-ordinated with different teams for requirement gathering.
Developed various mappings using Teradata as source and target.
Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedures.
Created and ran shell scripts in UNIX environment.