Job description

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. • Good comm skills are a big priority • Duration: 3 Months CTH

Requirements

Must-haves

DataStage, SQL Server 2008 R2 or later
Oracle 11gR2
Experience gathering requirements for projects
Prefer some architecture/modeling experience but not required
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
7+ years of experience in ETL-IBM Data Stage development for data movement, data quality, data cleansing and other ETL- related activities.
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.
Good comm skills are a big priority
Duration: 3 Months CTH

Nice-to-haves

Experience in SSIS preferred
Experience with IBM CDC/ IBM® Info SphereTM Data Replication preferred
Basic knowledge Database Netezza or Oracle preferred
DataStage Administration experience preferred
Graduation from a 4-year college or university with major course work in a discipline related to the requirements of the position is preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium