Job TitleResponsibilitiesResponsible for analysis of source systems to determine required transformations.Writes the design and mapping specifications for ETL development.Identifies methods of improving performance in ETL design and development.Analyses customer requirements, improving performance on existing scripts/process/procedures, and document detailed user requirements and program functions.Monitors database performance, support application users, determine cost of database changes, and train team members on applications.Coordinates the work of others to develop, test, install, and modify programs and establish physical database parameters.Required SkillsBachelor’s Degree in Computer Science, Information technology (or related fields) from an accredited college or university or equivalent work experience.Strong ETL experience 5-6 years using IBM Datastage V7 or higherStrong knowledge on Teradata architecture and loading utilities like TPT, TEQ, FLOAD and MLOADStrong SQL writing ability and data analysis skillsUnix commands and shell scriptingGood understanding of IT fundamentals, architecture, and the system development life cycle.Ability to reason logically and creatively, and use a variety of analytical and research techniques to solve complex problems.Communicate effectively both verbally and in writing with a variety of audience typesPreferred SkillsKnowledge of 837 and NCPDP HIPAA TransactionsExperience using Erwin to design data modelsKnowledge of Healthcare with Medicaid or Public Health dataExperience using XML with DataStageExperience reading, understanding and importing COBOL copybooks into InfoSphere DataStageExperience using QualityStage