Intern-Data Engineering

Piramal Consumer Healthcare; Mumbai; On-site; INR 134,000 - 201,000; Full time

Job summary

Piramal Consumer Healthcare seeks a data intern to build a governed data foundation for discoverable datasets across teams.

You will document business logic, create mappings and data dictionaries, and collaborate with stakeholders to ensure data quality and consistency.

Qualifications

• 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.

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 clear business owners, controls and handover documentatio n.

Skills

Python

SQL

Data engineering concepts

ERDs

Communication

Education

B.Tech/B.E. in Computer Science/IT/Data Science

Tools

Pandas

Job description

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 clear business owners, controls and handover documentation.