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