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
Developer
· 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:
NA
Work Location
Bellevue
Preference
$80K
Work Status
US Person / US Citizen