IntermediateSoftware trackUS-CP-40

Data Lakehouse for Retail Analytics (Medallion Architecture)

Internship role: Data Engineering Intern. Build bronze/silver/gold layers over retail transaction data with tests and lineage, and serve a sales dashboard; measured by pipeline test coverage.

10 Guided Steps480h Internship TierSubmit: GitHub repo or evidence pack + live demo / report + README + milestone logbookVerified CertificateAI Rubric Graded

Program Overview

Internship role: Data Engineering Intern. Build bronze/silver/gold layers over retail transaction data with tests and lineage, and serve a sales dashboard; measured by pipeline test coverage.

What you submit

GitHub repo or evidence pack + live demo / report + README + milestone logbook

Stack: dbt, DuckDB or Databricks Community, Airflow, Python

How it is graded

Works as specified30
Every feature in the brief runs end to end with real data, and the reviewer can follow the README to try it.
Code quality & design20
Clear structure, sensible names, input validation, no secrets in the repo, and a short note on the main design choices.
Testing & evidence20
Automated tests for the core paths, plus a live URL, screenshots or a short demo video.
Documentation15
README covers purpose, setup, how to run tests, and known limits.
Reasoning & presentation15
The write-up explains trade-offs and results in plain language, with numbers where they exist.

Pass 60% · Merit 75% · Distinction 90%

Learning Outcomes

480-hour United States programme. Medallion architecture and dbt are what US data teams expect interns to know.

Target Audience

Engineering Students

Diploma, B.Tech, B.E., BCA, MCA, or M.Tech students seeking practical experience.

Aspiring Developers

Developers who want to build proof-of-work capstone projects for tech resumes.

Job Seekers

Graduates looking for AI-evaluated code review & verified industry credentials.