Will develop written technical specifications describing details necessary to build ETL jobs based on logical and physical data models and business functional objectives.
Will develop and unit test ETL jobs according to requirements in the technical specifications.
Must follow the SDLC processes and master the rules governing the project.
1. Participate as a team member on technical projects involving the use of DataStage for development of ETL processes.
2. Develop written Technical Specifications describing details necessary to build ETL jobs based on logical and physical data models and business functional objectives.
3. Develop and unit test ETL jobs according to requirements in the Technical Specifications.
4.Will be required to work on moderately to very complex tasks.
5.Follow SDLC processes and master the rules governing the project.
-- Minimum of 5 years experience in DataStage 8.X or higher. Knowledge on both Linux and Unix is a must.
-- Experience with Developing Parallel jobs running on a UNIX and LINUX platforms is a must.
-- Experience developing ETL processes using Oracle and columnar databases as Source and Client dataenvironments is a must.
-- Experience developing DataStage ETL processes with both XML inputs and outputs is a plus.
-- Experience using DataStage for accessing data as sources from the Mainframe, AS400, and SAP, and SQL Server is a must.
-- Working knowledge of Toad, Putty, SQL plus is a must.
-- Experience working in all phases of a full project life cycle is a must.
-- Excellent knowledge of Linux, Unix Bourne LINUX and Korn shell scripting is a must.
-- Must be a high energy team player with a positive working attitude and possess excellent documentation skills is preferred
-- Must be able to manage multiple assignments simultaneously is preferred
-- Excellent verbal and written communications skills is required.
-- Understanding of the pharma industry - is preferred.
Required skills 5+ years experience
-- Working knowledge of Oracle & Neteezza with respect to building Extract and Load process using DataStage.
-- Extensive experience with building Historical and Daily Incremental ETL load processes in a large terabyte database environment.
-- Expert knowledge of Enterprise DataStage 8.X or higher
-- Expert knowledge in development of Parallel processing jobs.
-- Expert knowledge in development of DataStage Job Sequencers for complex processes.
-- Linux, Unix Bourne and Korn shell scripting
-- Previous work with Enterprise scheduling tools such as UC4 for control DataStage job and sequencer execution.