gammaticatech

AWS Data Engineering & Analytics

Learning Format

Online mode

Total training duration

120 hrs (3 months)

Syllabus

8 weeks

Certification

Yes

AWS Data Engineering & Analytics

This course focuses on building and managing data pipelines and analytics solutions using AWS services. Learners will work with AWS Glue, Redshift, S3, Lambda, Kinesis, and Athena to collect, process, and analyze large datasets. The program covers data warehousing, ETL workflows, and real-time analytics on the AWS cloud.

Syllabus Summary

Data Lakes with S3

  • Data Lake Concepts & Architecture
  • Partitioning, Versioning, Lifecycle Rules
  • Data Ingestion Patterns (Batch vs Streaming)
  • Hands-on: Create S3 Data Lake
  • Assignment

AWS Glue ETL

  • Crawlers, Catalogs, Schema Detection
  • ETL Jobs in PySpark
  • Schema Evolution & Partitions
  • Hands-on: Raw → Curated ETL Pipeline
  • Assignment

Amazon Redshift

  • Cluster Setup & Node Types
  • COPY/UNLOAD Commands
  • Redshift Spectrum with S3
  • Hands-on: Create Data Warehouse & Load Data
  • Assignment

Real-Time Streaming with Kinesis

  • Kinesis Streams
  • Kinesis Firehose Delivery to S3/Redshift
  • Kinesis Analytics SQL Queries
  • Hands-on: Real-Time Pipeline (Kinesis → Redshift)
  • Assignment
  • Mock Interview 1

Serverless Analytics with Athena

  • Query S3 Data with Athena
  • Integrate with Glue Catalog
  • Cost Optimization
  • Hands-on: Query JSON/CSV logs from S3
  • Assignment

Visualization with QuickSight

  • Data Sources, Datasets
  • Dashboard Creation
  • Integration with Redshift & Athena
  • Hands-on: Sales Dashboard
  • Assignment

Big Data with EMR

  • EMR Cluster Setup
  • Spark & Hive Jobs
  • EMR-S3 Integration
  • Hands-on: Large Dataset Processing
  • Assignment

Capstone Project & Interview Preparation

  • Project: Real-time ETL pipeline (Kinesis → S3 → Glue → Redshift → QuickSight Dashboard)
  • Resume Preparation for AWS Data Engineer Role
  • Assignment
  • Mock Interview 2

Course Summary

Eligibility

Tech & Non-Tech Working professional, Freshers, Graduate from any domain.

Live Doubt Solving

Get your queries solved with daily dedicated doubts solving sessions.

Instructor

Experts and trainer for top-tech companies.

Certification

10+ ISO Globally recognized certified

Mode of Learning

100% Live Learning with experienced instructors and hands-on sessions.

Real time projects

Get practical experience with real-world projects for a career in analytics.

Certification

Scroll to Top