Job Description

The Data Integration Lead is specializes in the design and development of the ETL and ELT environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. The role must have the skills necessary to understand the overall data warehouse architecture & provide directions to the project Data Integration team. The Consultant will overlook his team work and provide directions in the designs and builds the ETL environment with the specific toolset required by the client. The Data Integration Lead will participates in making decisions on database design and overall solution architecture.
Responsibility
Capture ETL Requirements
Design, develop, test, support processes for extracting, transforming and loading data from source systems to DWH and Data Marts
Design the processes to meet service level agreements for data timeliness and frequency
Analyze and optimization current solutions, physical model optimization, query tuning
Mentoring junior members of the team in data integration development best practices
Analyze and improve query and solution performance, optimize physical model
Developing project deliverable documentation
Qualifications
Knowledge of any enterprise relational database (Teradata, Oracle, IBM)
Knowledge of one of industrial ETL tool (Informatica, DataStage, ODI, SAS DI or others)
Strong SQL and Shell scripting
6+ years of experience with DWH and 8+ Data Engineering experience
Experience in implementing ETL solutions for large, enterprise-grade customers
Knowledge of any programming language (Java, Python, Scala and others) is an advantage
Any ETL tools, DB certified is an advantage
Experience Unix/Linus OS
Experience in Enterprise Data Warehouse SQL Optimization
Experience using Jira, Git, Jenkins is an advantage
Knowledge of Metadata driven approach is an advantage
Experience in Physical Model Optimization
Advanced Communication skills: being able to communicate with heads of business departments
Teradata highly values diversity and equal opportunity in all aspects of our business. We are excited by the unique qualities, abilities and perspectives each person brings, and candidates are considered on all the attributes they may bring to the role and the team.