Atria Group LLC
ETL DEVELOPER
About the job
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.
Qualifications
• Graduation from a 4-year college or university with major course work in a discipline related to the requirements of the position is preferred.
Additional Information
• Good comm skills are a big priority
• Duration: 3 Months CTH