Be aware of scams on social media involving phony job postings. Learn more


Senior Data Integration Consultant

Location: Cairo, Cairo Governorate, Egypt

Notice

This position is no longer open.

Requisition Number: 211820

External Description:

The Senior Data Integration Consultant 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. This individual must have the skills necessary to understand the overall data warehouse architecture. The Consultant designs and builds the ETL environment with the specific toolset required by the client. The Senior DI Consultant participates in making decisions on database design and overall solution architecture.

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

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 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 is not your average place to work: we are inspiring and passionate people with a dynamic, relaxed and collaborative culture. This is your chance for you to join an organization with ambitious growth targets, where you can make your mark and shape the future.

 

Teradata is an equal opportunity employer 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 fundamentals they may bring to the role and the team.

CountryEEOText_Description: Why We Think You’ll Love Teradata We prioritize a people-first culture because we know our people are at the very heart of our success. We embrace a flexible work model because we trust our people to make decisions about how, when, and where they work. We focus on well-being because we care about our people and their ability to thrive both personally and professionally. We are an anti-racist company because our dedication to Diversity, Equity, and Inclusion is more than a statement. It is a deep commitment to doing the work to foster an equitable environment that celebrates people for all of who they are.

City: Cairo

State: Al Qahirah

Community / Marketing Title: Senior Data Integration Consultant

Job Category: Consulting

Company Profile:

Our Company

At Teradata, we believe that people thrive when empowered with better information. That’s why we built the most complete cloud analytics and data platform for AI. By delivering harmonized data, trusted AI, and faster innovation, we uplift and empower our customers—and our customers’ customers—to make better, more confident decisions. The world’s top companies across every major industry trust Teradata to improve business performance, enrich customer experiences, and fully integrate data across the enterprise.

LinkedIn Remote:

Location_formattedLocationLong: Cairo, Al Qahirah EG

.