Senior ETL Developer Resume

SUMMARY:

Confidential is an ETL professional who designs overall technical solutions for end to end project implementation.
He has strong experience in ETL architecture by using IBM datastage tool with different databases such as IBM netezza, sql, DB2 and oracle along with unix shell scripting.
He has worked on data warehouse projects across different domains such as - Credit card and Payments, Investment Banking and Healthcare.
He has been actively participated in data modelling and profiling and agile scrum ceremonies.
He is trained on other ETL tools like Informatica and SSIS and flexible enough to work on any other tools or technologies.
Confidential has completed his Bachelors in Information Technology from West Bengal, India. He is a highly dedicated, passionate and motivated individual with experience in product development, solution delivery and client interaction.

TECHNICAL SKILLS:

ETL Tool: IBM Infosphere Datastage, SSIS, Informatica

Database: DB2,Oracle,Netezza, SQL

Conceptual Knowledge: Data warehouse, Data modelling

Language: Shell script

Methodology: Agile, Waterfall

Other Tool: Putty, WINSCP, Change data capture, Control-M, SVN

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Environment: Data Stage 11.5, DB2

Responsibilities:

Developed, analyzed and maintained all ETL jobs according to client standards.
Scheduled and monitored the ETL jobs.
Build and review functional and business specifications (S2T).
Provide the estimates for the ETL work.
Familiar with Agile methodologies.
Actively worked with Architect, Business Analyst, Data Analyst and Report Developers.
Worked with DBA’s on Database creation and performance tuning.
Troubleshooting and fixing the code.
Worked with gate keeper on promoting the data stage jobs to QA and Production.
Participated in code reviews and provided trainings.

Confidential

Senior ETL Developer

Environment: Data Stage 9.1, Netezza, UNIX

Responsibilities:

Responsible for end to end solution and provides optimized inputs to client.
Worked on data modelling from gathering initial requirement to implement it into database and tables.
Defined and developed the ETL model and flow.
Has taken a key role in infrastructure discussion.
Successfully implemented Netezza stored procedures.
Worked on making the ETL process optimized by applying advanced database and datastage techniques.
Created a sound audit process which will be beneficial for debugging issues and its resolution.
Worked on Datastage Admin related issues as well.

Confidential

Senior ETL Developer

Environment: Data Stage 8.1, Data Stage 9.1, Oracle, UNIX

Confidential

Senior ETL Developer

Environment: Data Stage 8.1, Oracle, UNIX

Confidential

Senior ETL Developer

Environment: Data Stage 8.7 PX, Netezza, UNIX