Data Science &

Data Management Tracks

2023–2024
Content

Program 1. Who May Apply?

Admission 2. Prerequisites
3. Selection Process
Arrangement
4. Delivery Approach
5. Student’s Deliverables

Market Needs 1. Programs Offered

and Stakeholders 2. Industry/Academy Stakeholders
3. Targeted Outcome
4. Certification
5. Graduates Job Profiles

Services & 1. Professional Training Program

Content

2
Program Admission Arrangement
Who May Apply?
Applicants must have a first degree from a recognized university or institution of higher education or
provide documentation indicating that they will earn such a first degree before enrolment in the training
program.

Prerequisites
These topics will be discussed with you in the interviews (Resources applicants can visit or study before interview)
• Database Fundamentals https://maharatech.gov.eg/course/view.php?id=740
• Career Talk in Data Analytics https://maharatech.gov.eg/course/view.php?id=514
• Good Fundamentals for Database and understanding the Data Analytics life cycle

Selection Process
• PH01 – Phase 1
IQ Test | English Test | Problem Solving Test
• PH02 – Phase 2
Knowledge base exam in the area of Data Analytics and Data Science
• PH03 – Phase 3
Applicants who pass the above exams will be promoted to technical and interpersonal skills interview. Those applicants would be
discussing with the interviewing panel their pre-work -“Before You Apply”- in a one-to-one interview
• PH04 – Phase 4
A second level interview would be held with ITI board members

Delivery Approach
• 75% face to face Learning| 25 % Online
• Common Hardware: : Laptop with at least 16 GB of RAM and Core i7

Students’ Deliverables
• Each student must deliver at lest ONE freelancing job and an internaltional certficate based on his track

3
 Data Analytics Tracks
4 Certifications
AWS Certified Machine Learning Specialty
Programs Offered EMC Data Science and Big Data Analytics
1 AWS Certified Data Analytics Specialty
 Professional Training Program: IBM Infosphere DataStage 11.5
• Data Science SAP Business Object
• Data Management Databricks Certified Data Engineer Associate
Microsoft Certified: Power BI Data Analyst Associate
 Intensive Code Camps:
• Data Analysis Graduates Job Profiles
• Data Visualization 5
Data Scientist
• Data Analysis & Visualization
A Data Scientist is responsible for building predictive and descriptive analytics models and data
 Online Services (MaharaTech, ITI Tech Leap) analysis services to be used to mine an organization’s data. Occupants of this role also models
complex problems, discovers insights and finds opportunities through out the use of statistical,
algorithmic, mining and visualization techniques.
They also validate the findings using experimental and iterative approaches. In addition to
communicating the results and ideas to key decision makers and stakeholders in an understandable
way.
2 Industry/Academy Stakeholders
Data Analyst
• Pluralsight • BBI Consultancy A Data analyst collect process and perform statistical analyses of data as well as identifying patterns
• Splunk • IBM and trends in data sets. They discover how data can be used to answer questions and solve
• SAS Institute problems. A data analyst's job is to take that data and use it to help companies make better business
decisions.
Ultimately, the work of a data analyst provides insights to the organization that can transform how
the business moves forward and grows successfully.

Big Data Analyst

Big Data Analyst is able to draw relevant information from the huge amounts of data being
3 Targeted Outcome processed every minute. They are Importing, Collecting, cleaning, converting and analyzing the data
• Employability to find insights and make conclusions. They are presenting data using graphs, charts and visualize
o Vodafone Egypt o CyShield trends, patterns and correlation of complex data sets
o VOIS o CIB
o BBI o Orange Egypt
o EFG Hermes o Valeo Data Warehouse Architect / Modeler
o Etisalat Misr o Integrant A Data Warehouse Modeler is responsible for developing, managing, and updating data models,
o AAIB o IBM including the physical and logical models of data warehouses, data marts, staging areas, and
o Fawry operational data stores. In addition to supporting model management activities on the enterprise
o Aman level.
 Data Analytics Tracks
5 Graduates Job Profiles – Cont’d
Data Integration Specialist
A Data Integration Specialist is to design, build, map and maintain integration solutions based on
integration needs from business users and load data across various sources into an organized and
unified view. s/he also responsible for the monitoring of data flow between databases, servers and
Cloud services to identify and implement the most suitable data integration architecture for the
organization’s needs.

Business Intelligence Analyst / Developer

A Business Intelligence Analyst / Developer is responsible for building reports and dashboards to help
inform decision-making by converting data into information and facilitating insightful solutions to complex
problems. In addition to translating the business requirements into technical specifications which are
used to implement the required reports and dashboard.

Big Data Engineer

A Big Data Engineer have knowledge of data analysis, end-user requirements analysis, and business
requirements analysis to develop a clear understanding of the business needs and to incorporate these
needs into technical solutions.
S/He develop, maintain, test and evaluate big data solutions in organizations. They build a robust, fault-
tolerant data pipeline that cleans, transforms, and aggregates unorganized and messy data into
databases or data sources. As well as building large-scale data processing systems, also should be an
expert in data warehousing solutions and should be able to work with the latest (NoSQL) database
technologies.

Data Engineer
They are responsible for designing, maintaining, and optimizing data infrastructure for data collection,
management, transformation, and access. They are in charge of creating pipelines that convert raw data
into usable formats for data scientists and other data consumers to utilize. They also create optimal
data warehouses, pipelines, and reporting systems to solve business problems.
9-Month Professional Training Program

6
Data Science 942 Hours
Program Content Structure
Soft Skills
Programming for Data Science Fundamental
Fundamental courses 5%
Courses
Operating Systems Fundamentals Python for Data Science 12%
Computer Networks Fundamentals R Programming for Data Science
Database Fundamentals SAS Programming Essentials
Object Oriented Paradigm Using Java
Core Courses
Red Hat System Administration I
Introduction to Agile Software Development Methodologies
Business courses Cloud Computing Fundamentals
Financial Accounting Data Warehousing Fundamentals and Data Modeling Core
Enterprise Systems Business Statistics courses
Project Management Systems Thinking 83%
Introduction to Modeling & Operations Research
SQL & Scripting Courses Machine Learning
Introduction to Oracle SQL and PL/SQL Advanced Machine Learning & Deep Learning
Oracle Advanced PL/SQL Optimization and Simulation Methods for Analytics
Analytical SQL Visualization & Storytelling
Bash Shell Scripting Data Preparation & Preprocessing
Time Series Analysis
Data Science & Big Data Tools Calculus for Data Science
Numerical Optimization for Data Science
Data Analysis using Excel
Linear Algebra for Data Science
Data Scientist Toolkit
Applied Analytics Using SAS Enterprise Miner Soft Skills Courses
Apache Hadoop Essentials
Apache Spark Essentials Progressive Teamwork (Workshop)
Data Science and Big Data Analytics Professional Demeanor (Workshop)
Best Practices For Remote Working (Workshop)
Communication Essentials for Professionals
High Impact Presentations
Job Seeking Skills

7
Data Management 900 Hours
Program Content Structure
Analytics, Integration & BI Tools Fundamental
Soft Skills
Fundamental courses 5%
Courses
Incorta Business Analytics 12%
Operating Systems Fundamentals
Informatica PowerCenter Basics
Computer Networks Fundamentals
IBM InfoSphere DataStage Essentials
Database Fundamentals
Business Objects Webi / Universe
Object Oriented Paradigm Using Java
Visualization & Storytelling using Tableau
Red Hat System Administration I

Business courses Big Data Tools & Techniques

Financial Accounting Apache Hadoop Essentials Core

Enterprise Systems Apache Kafka courses
Project Management Apache Spark Essentials 83%
Apache Scala Programming Language
SQL & Scripting Courses Apache pig, Hive and Impala
Introduction to Oracle SQL and PL/SQL Apache Airflow
Oracle Advanced PL/SQL Apache HBase Essentials
Analytical SQL Big Data Case Study
Bash Shell Scripting
SQL Tuning Soft Skills Courses
No SQL using Mongo DB
Progressive Teamwork (Workshop)
Core Concepts Professional Demeanor (Workshop)
Introduction to Agile Software Development Best Practices For Remote Working (Workshop)
Methodologies Communication Essentials for Professionals
Cloud Computing Fundamentals High Impact Presentations
Data Warehousing Fundamentals and Data Modeling Job Seeking Skills
Programming for Data Management
Data Management with Python
Advanced Java SE for Data Management
8