Job Description :
DataStage Architects or Senior Datastage developers
8+ months
Richardson TX
HCSC
Phone interview then a required in person interview
The successful candidate is expected to have a high degree of technical aptitude over a large scope of ETL & Data Warehouse software, hardware, and networking disciplines with a focus on

Business Data Analysis and Data Integration Solutions. He/She must have demonstrable Datastage & SQL skills, Healthcare IT experience and be forward thinking with a high degree of customer service focus and excellent communication skills.

Responsibilities
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
Optimize ETL processes for maximum efficiency
Perform source to target data mapping
Perform data analysis and profiling on data sources
Perform and assess business rules and project plans
Collaborate with IT & Business to provide required data, analysis and reports
Perform other related duties as assigned or required
Assist in the design and development of a data stores, including requirements gathering, data analysis and the rest of the data warehouse lifecycle functions.
Requirements
Minimum of 5 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
Solid experience in query performance analysis, and issue detection
Excellent understanding of relational and dimensional data models
Extensive experience in data profiling and data quality analysis
Experience with data migrations and planning
Experience in Unix Shell Scripting and hands-on experience in Linux
Expertise with Production operations and production scheduling tool – Zena

Client : Buddha Tech