Software Contractors' Guild

Job Description Page

1   IBM DataStage ETL developer

Date Posted: Apr 23 2008 Rate Range: 65-70/hr Job Duration: 6 months to one year Job location: princeton USA:New Jersey   Listed By: Automated Computer Services Contact Name: Sharon Perlman E-Mail: sharon@automated-computer.net Telephone: 215-702-0901   Third Party Inquiries Welcome Allow Independent Contractors Contract to Permanent Position

List of Skill sets required: Applications:Data Mapping Software Applications:Database:OLAP/Data Warehousing Applications:Database:Oracle Data Migration Data:Data Mart Data:Data Modeling Data:Data Warehouse Data:Data Warehousing:ETL:Ab Initio Data:Mining

Senior ETL DataStage BI/Data Warehouse Analyst / Developer –

• Must have strong experience with installation and configuration of the IBM Data Stage ETL tool
• Must have 3 -5 years working knowledge IBM Data Stage ETL tool
• Full functional knowledge of Data Warehouse concepts, development, and design
• Ability to develop and support data extracts, data transfers, and load jobs
• Development and implementation of ETL solutions for legacy and new development
• PL/SQL, Transact SQL a plus
• Provides technical expertise to the development and implementation of solutions using basic dimensional modeling techniques. Make recommendations for improvements in these areas, if necessary.
• Provide business expertise for the development of Business Intelligence solutions.
• Provides technical support for existing Data Warehouse ETL processes.
• Assures quality of design and implementation of projects.
• Trouble-shoots application software/hardware problems as they apply to design, implementation, or installation activities.
• Schedules and coordinates application maintenance activities.
• Participates in on-call, overnight off-hour production problem resolution activities when required.
• Follows DMS related standards and procedures, knows where they are located, and incorporates them. Follows ETS software development processes.
• Researches, evaluates, and tests new software and DW related tools and facilities as they pertain to the existing DW environment and applications.
• Monitors current DW applications and develops procedures, where necessary, to improve the DW environment as required.
• Identifies and supports quality improvement initiatives.
• Performs other assignments to comply with the IS&T corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic initiative/directive.
• Complies with all ETS security and audit standards.
• Manages the work of ETS vendors to achieve quality results at a market based price using ETS SR&T policies and procedures.



Knowledge, Skills, and Abilities:
• Must have extensive knowledge (3 -5 years working knowledge) with IBM Data Stage ETL experience.
• Must strong experience with install and configuration of IBM Data Stage ETL tool
• Must have extensive knowledge with IBM Data Quality experience
• Must have extensive knowledge in Oracle database programming skills with Oracle and PL/SQL
• Must have extensive technical skills in Linux environment
• Strong knowledge of Linux shell scripting
• Experience with Data Warehouse implementations and ETL skills
• Autosys Job Scheduler
• DMS Epress
• MicroFocus Cobol
• IBM Mainframe JCL/COBOL
• Follow Change Control concepts and policies
• Ability to work with offsite Vendor Technical Support for problem resolution
• Ability to express complex technical concepts effectively, both verbally and in writing
• Ability to work well with people from many different disciplines with varying degrees of technical expertise
• A plus to have broader IBM Quality Stage experience
• A plus to have IBM WebSphere replication experience from DB2 to Oracle



Education:

The candidate should have a Bachelor degree or Masters in Computer Science or 8 to 10 years of related experience in IT or a related field. The ideal candidate must have 5 years of applicable Data Warehouse experience.