Job Description :
Candidates should have 8-10 years minimum DataStage experience and MUST HAVE HEALTHCARE EXPERIENCE


Design, develop, test, debug, implement and maintain ETL workflows, shell scripts, and stored procedures to support new solution development
Monitor performance of production ETL processes and correct any identified issues or problems
Perform root cause analysis on problematic queries and ETL jobs
Ensure standards & processes are followed including documented ETL design and specifications
Minimum of 8 years of formal ETL experience using Datastage
Ability to multi-task across multiple projects within different repository contexts
Extensive hands-on experience designing information driven solutions
Advanced knowledge of DataStage 8.5 & Datstage 9.1 ETL tool and it’s administration
High proficiency in SQL, DB2 and Teradata
Proficiency using major data modeling tools such as Erwin
Excellent understanding of data modeling techniques and processes for Data Warehouse and Data Marts
Experience in Large Data Warehouse projects and with large volumes of data