ETL Lead- Datastage
Work Location Deerfield, IL
Duration 1 year
Mandatory Technical / Functional Skills
• At least 7+ years total experience as ETL Developer (Datastage)
• Good knowledge of SQL developer and understand and write SQL queries
• Good knowledge of Unix Scripts
• Excellent debugging skills.
• At least 5+ years experience in data warehousing and ETL job designs.
• Strong business/functional analysis skills and an understanding of the Software Development Life Cycle (SDLC).
• Excellent writing skills for documentation
• Good knowledge of various modules of healthcare and retail domain"
Roles and responsibility
• Understand Business/Functional/Technical Requirements.
• Performing the data analysis using SQL queries.
• Create and review Technical Design Document for requirements.
• Create and review UTC, STC, LLD for release requirements.
• Support QA testing.
• Production monitoring after release deployment.
• Participate in onsite and offshore call.
• Able to work with Business users and understand requirement.
• Ability to take ownership and initiative"
Desirable Technical / Functional Skills
• Good knowledge of other ETL tools
Total experience in required skill (years) 7+ years