Role Overview The intern is responsible to build a standardized, governed data foundation so datasets can be discovered, understood, mapped, refreshed and consumed consistently across teams.

Qualification

B.Tech/B.E. in Computer Science, IT, Data Science or a related field. Exposure to databases, APIs, cloud data platforms or workflow automation. Interest in analytics, data governance and enterprise data architecture. Structured thinking and strong documentation discipline

Relevant Experience
Python (Pandas, data processing, automation)
SQL (joins, aggregations, transformations, data validation)
Basic data engineering concepts: ETL/ELT, schemas, pipelines, keys and data quality
Ability to create ERDs, conduct EDA and document business logic
Solid communication and ability to work with multiple business stakeholders
Roles & Responsibilities
Partner with business teams to identify datasets, source systems, owners, refresh frequency, key fields and downstream use cases.




Create and maintain enterprise data dictionaries, source inventories, field definitions and business metadata.
Design mapping files to standardize entities such as SKU, brand, customer, distributor, channel, geography and time across sources.
Create ER diagrams and document table relationships, keys, dependencies and data lineage.
Perform EDA and data-quality checks to identify duplicates, missing values, inconsistent definitions and mapping gaps.
Use Python and SQL to clean, transform, reconcile and apply business logic to datasets.
Build straightforward repeatable pipelines/scripts so standardized datasets and mapping files are refreshed systematically.
Define ownership and update processes for mapping/master files with explicit business owners, controls and handover documentation.

📌 Intern Data Engineering Mumbai (India)
🏢 Piramal Consumer Healthcare
📍 India