Data Engineer-Data Warehouse

Overview

In this role, you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.

Your Role And Responsibilities

• Minimum 3 years of experience in developing applications programs to implement the ETL workflow by creating the ETL jobs, data models in datamarts using Snowflake, DBT, Unix, SQL technologies.
• Redesign Control M Batch processing for the ETL job build to run efficiently in Production.
• Study existing system to evaluate effectiveness and developed new system to improve efficiency and workflow.
• Responsibilities:
• Perform requirements identification; conduct business program analysis, testing, and system enhancements while providing production support.
• Developer should have good understanding of working in Agile environment, Good understanding of JIRA, Sharepoint tools. Good written and verbal communication skills are a MUST as the candidate is expected to work directly with client counterpart
  
  

• Intuitive individual with an ability to manage change and proven time management
• Proven interpersonal skills while contributing to team effort by accomplishing related results as needed
• Up-to-date technical knowledge by attending educational workshops, reviewing publications
  
  

• Responsible to develop triggers, functions, stored procedures to support this effort
• Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems. Assist with design, testing, support, and debugging of new and existing ETL and reporting processes.
• Perform data profiling and analysis using a variety of tools. Troubleshoot and support production processes. Create and maintain documentation