Job Description :
Job Title

ETL Data Stage Developer

Relevant Experience (Yrs):

5+ Years in Designing and developing ETL jobs

Technical/Functional Skills:

· Develops logical and physical dataflow models for ETL applications. Perform tuning and performance enhancements when needed.

· Provide high level of technical support, perform root cause analysis for problems experienced within area of DataStage ETL Jobs.

· Develops design specifications for ETL jobs.

· Design, implement and support ETL programs.

· Creates integration testing strategy for ETL jobs/participates in integration testing in development/test environments.

· Performs code reviews against other developers Data Stage jobs-SQL/PLSQL scripts

· Good understanding of dimensional modeling and ETL designs for loading Different Schema models with having a good knowledge of Data warehouse house Concept.

· Develops logical and physical dataflow models for ETL applications. Perform tuning and performance enhancements when needed.

· Plans and conducts ETL unit and development tests; monitors results and takes corrective action. Oversees basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration

Experience Required

· Must have extensive 4+ years of hands on technical experience in design/development of ETL Jobs using IBM Data Stage 9

· Extensive development experience in Data stage 8.5 or above

· Experience in creating source to target mappings

· Experience in writing complex SQL in relational databases especially Teradata & Oracle

· Experience in ETL & query performance tuning

· Basic knowledge of UNIX Shell /Perl Scripting

· Efficient in all phases of SDLC Methodology (Agile / Scrum / Iterative Development, coherent with Data cleansing, data conversion, performance tuning and unit testing

· Proven experience with PL/SQL, SQL and Object Oriented concepts and design and relational database, Netezza, Oracle, etc.

· Basic knowledge of Quality Stage & IBM FastTrack

· Experience working with complex data loading processes for Data Warehouses, Data Marts and Operational data stores with multidimensional data modeling concepts

Roles & Responsibilities


· Design, develop and deliver data integration & extract solutions using IBM DataStage

· Create ETL Source to Target mappings

· Understand existing ETL Jobs, and make changes as per new requirements

· Identify, propose & implement improvements in ETL jobs

· Work closely with DBAs to fix performance bottlenecks

· Work closely with support teams for code migrations

Generic Managerial Skills:


Work Location




Work Status

US Person / US Citizen