ETL Datastage Lead

Company: Diverse Lynx
Location: Chattanooga
Posted on: January 24, 2023

Job Description:

Job Title
ETL Datastage Lead


Relevant Experience (in Yrs)
Overall 12+ Years of IT Experience


Overview
For an Enterprise Data & Insights organization, need a strong and dynamic Datastage Lead wo has extensive experience in managing ETL development for migration and data lake projects


Experience Required

• 
  
• 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
  
  
  
  
  
  
  
  
  
  
  
  Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
  
  
  

Keywords: Diverse Lynx, Chattanooga , ETL Datastage Lead, Other , Chattanooga, Tennessee