ETL Developer Resume ETL Developer - Hire IT People

SUMMARY

5 Years of experience in ETL Development and Production support project using Informatica Power Center 8.x/ 9.x. and 1 Year in informatica cloud (IICS).
ETL mappings using Informatica Power Center to move data from multiple sources (like Flat Files, Oracle and DB2) such as Data Marts and Data Warehouse.
UNIX commands and FTP's. Shell scripts to execute Informatica workflow using PMCMD command
Reverse engineering project (Moving code from informatica PowerCenter to informatica cloud)
Designed and developed mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
Job Scheduling tools like DAC (Data warehouse Administration Console), Ad hoc scheduling tool DM4B.
Worked with QA team for production support and development project go live.
Pro - Active to production Issues resolutions meeting dead lines.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.x/9.x (Workflow Manager, Workflow Monitor, Repository Manager, Mapping Designer, Mapplets, Transformations)

Methodologies: Snow Flake and Star Schema

Databases: DB2,Oracle 10g,SQL Server, AWS Redshift

Business Intelligence Tools: Trained on BI Publisher, Informatica 8.1/8.6.1 / 9,Informatica cloud

Programming: ETL (Informatica 8.6.1, 9.1), DB2, Oracle, Unix basic commands, Unix FTP Scripting

Environment: UNIX, Win 95/98/XP

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Database: Oracle, AWS Redshift

ETL tool: Informatica PowerCenter 9.5.1, Informatica cloud

Scheduling Tool: DM4B

Responsibilities:

To understand the project requirement and to design flow diagrams in visio/excel.
To understand the existing legacy flow and prepare low/high level design document.
To study the legacy flow and ETL/database objects,prepare estimations documents.
As per design documents,split the work between the team members as an ETL lead.
Doing database query code anylysis and compare the data between legacy one and new one.
Analysed which approch is better suitable for new design.
Developed ETL(Informatica cloud) mapping,workflow,session as per legacy.
Doing gap analysis between legacy and new design.
Doing unit test,integration test,regression test propely.

Confidential

ETL Developer

Technology Used:

Database: Oracle

ETL tool: Informatica 9.5.1

Responsibilities:

To understand the project requirement and to design flow diagrams in visio.Create campaign in Siebel frontend to export the .csv file and used it in informatica side or keep in remote location.
Create segment in OBIEE so that segment extract in Siebel frontend to generate .csv files.
As SSE has sensitive data so we should create our own data for testing purpose.
To understand the source and target structure/format and to finalize the approach to handle them.
Did gap analysis for the list of table which were not included in the new database.
Understand the new database structure, identify key columns, and indentify the primary key/foreign key relationship between tables.
Worked on trouble shooting the mappings to improve performance by identifying bottlenecks.
Co-ordination with Customer on a weekly touch base for status updates.
Coding and testing the against the Unit test cases.
Doing Integration testing of the software against integration test cases.
Analyzing the time taken for each session to execute, so that it can be improved in next run.
Working with IGATE-PATNI since June 2010

We provide IT Staff Augmentation Services!

Resume

Etl, DevelopeR

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship