Senior Data Integration Consultant

Key Areas of 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

Job Requirements

Requirements

• 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
• 3+ years of experience with DWH and 5+ Data Engineering experience
• Experience in implementing ETL solutions for large, enterprise-grade customers
• Experience in implementing ETL solutions in Hadoop environment is an advantage
• Knowledge of MPP system – Teradata, is an advantage
• 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 inEnterprise Data WarehouseSQL 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: beingable to communicate with heads of business departments