Our Career Transformation Program Phases

Registration

  • Submit your CV to careers@efreya.com
  • Aspiring candidates with minimum 4 years of IT experience

Career Transition Skills

  • 8 Weeks program
  • Every day 2 hours
  • Assessments and feedback
  • Upskilling of technical skills
  • Personality development
  • Interview prep
  • Mock interviews
  • Consultative support
  • Industry based projects
  • Program completion certificate
Global Placement Positioning

Global Placement Positioning

Positioning you for possible roles through our Global Deployment Team ( GDT )

Program Objectives

The objective of this program is to build expertise in creating a cloud based data warehouse and use ETL effectively

Data Warehouse Program Outline

  • Data Warehouse & cloud
  • Introduction to data warehouse
  • Introduction to cloud
  • Introduction to cloud data warehouse
  • Understanding a data warehouse & its platform architecture
  • Creating database objects & loading
  • Understanding data & loading
  • Understanding database language and commands
  • Understanding DDL & DML commands
  • Understanding joins, operators and case statements
  • Functions – string & date time functions
  • Functions – aggregate functions
  • Caching, time travel
  • Data movement
  • User management & security in a data warehouse
  • Data storage & security
Data Warehouse Course Outline
ETL Course Outline

ETL Program Outline

  • ETL overview
  • Setup for ETL
  • ETL architecture
  • Facts & dimensions
  • Creating ETL jobs
  • Handing incremental loads
  • Use cases
  • Projects

Personality Development Program Outline

  • Interview prep
  • Assessment & feedback
  • Mock interviews
  • Activity-based communication skills
  • Expert guided sessions
    • Communicate with confidence
    • Elements of communication
    • Presentations
    • Discussions & debates
    • Business communication

Methodology

  • Theory / concepts
  • Demonstration
  • Exercises
  • Simulation
  • Case studies
  • Assessments
  • Self-learning through platform
  • Mock Interviews evaluation and feedback
  • Industry based project
ETL Course Outline