Job Description:
Experience in Migration project from DataStage to Java APIs Experience in using source databases DB2, Teradata, files(XML files) and load data into Target DB2 and XML files Develop shell scripts to clean the datasets and SFTP files Experience in DataStage(Enterprise) upgrade from 11.5 to 11.7 Develop SQL queries, triggers, functions, cursors and stored procedures, Enforced data Integrity rules, Business Rules. Experience Insurance data warehouse migration from SQL to Teradata, Enhancement on existing system Use Hierarchal stage in DataStage 11.5 to load the data to XML files Use Rapid deployment tool to deploy the DataStage code across Dev, QA and Prod environments Experience in managing all stages of Software Development Life Cycle (SDLC), from analysis and design to implementation and maintenance. Expert in gathering the requirements from the business users to create mapping document Expert in presenting the developed ETL flows to the supervisors Good knowledge in scheduling tools Control-M and CA7Experience with Agile Development Methodologies
Functional Skills / Responsibilities
- Strong team player; able to work effectively within a team and more broadly with people from a variety of backgrounds and areas across the organization.
- Able to deal with significant ambiguity and translate into more tangible outcomes
- Elicit requirements using interviews, document analysis, requirements workshops, and task/process/workflow analysis selecting the appropriate means of representing the requirement and ensuring traceability back to source
- Demonstrates a metrics and financial mindset to ensure ROI for business
- Possess SQL skills and data analysis skills
- Experience working with Rally tool
- Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.