ETL DEVELOPER

TOP REQUIREMENTS:

1. DataStage, SQL Server 2008 R2 or later

2. Oracle 11gR2

3. Experience gathering requirements for projects

4. Prefer some architecture/modeling experience but not required

JOB SUMMARY

Job comprises of various Data Integration ETL tasks with custom interfaces to external data sources & systems. This job also includes various internal Applications data load, reconciliation, on time as well as near real time data delivery tasks. Prior experience in reusable ETL interfaces is needed.

EDUCATION/EXPERIENCE REQUIREMENTS

• Good understanding of IBM Information server platform
• Ability to troubleshoot ETL processes failures or warnings and provide technical support for all ETL- DataStage related issues.
• Basic Knowledge in MS-SQL Server 2008 DB.
• Strong UNIX / Linux Scripting
• Experience in SSIS preferred
• Experience with IBM CDC/ IBM® Info SphereTM Data Replication preferred
• Basic knowledge Database Netezza or Oracle preferred
• 7+ years of experience in ETL-IBM Data Stage development for data movement, data quality, data cleansing and other ETL- related activities.
• DataStage Administration experience preferred

ESSENTIAL JOB FUNCTIONS

• Design and develop ETL jobs from function specification.
• Develop reusable interface frame works with reasonable assumptions of future specs.
• Performance tuning of ETL jobs to keep data loads within SLA.
• Other duties as needed.

• Graduation from a 4-year college or university with major course work in a discipline related to the requirements of the position is preferred.

1. Good comm skills are a big priority
2. Duration: 3 Months CTH