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
- Strong 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 simple 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)
🏢 Piramal Consumer Healthcare
📍 Mumbai