Previous Job
Previous
Datastage Lead
Ref No.: 18-21351
Location: Seattle, Washington
Position Type:Contract
Start Date: 03/29/2018
Technical/Functional Skills :         •             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 DataStage jobs-SQL/PLSQL scriptsExperience Required         :               •             Must have extensive 4+ years of hands on technical experience in design/development of ETL Jobs using IBM DataStage 9•             Extensive development experience in Datastage 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•            Basic knowledge of QualityStage & IBM FastTrackRoles & 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