Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in hyderabad
>
PepsiCo
>
Data Modeler (Erwin, ER Studios)

Data Modeler (Erwin, ER Studios)

PepsiCo

5 years

0 Lacs

hyderabad telangana india

Posted:2 days ago| Platform:

Apply

Skills Required

data modeler design storage integration model architecture logical management manufacturing azure sql spark documentation database governance engineering compliance etl support profiling security drive collaborative code planning sourcing technology teradata analytics mapping python communication databricks apache sap learning github agile devops power

Work Mode

On-site

Job Type

Full Time

Job Description

Overview

Role Overview

As a

Data Modeler

, you will partner with the D&A Data Foundation team to design and implement data models for global projects. This includes analyzing project data needs, identifying storage and integration requirements, and driving opportunities for data model reuse. You will advocate

Enterprise Architecture, Data Design standards, and best practices

, creating conceptual, logical, and physical data models for large-scale, cloud-based applications impacting PepsiCo’s flagship data products in areas like

Revenue Management, Supply Chain, Manufacturing, and Logistics

Responsibilities

Key Responsibilities

Design conceptual, logical, and physical data models for platforms such as Snowflake, Azure Synapse, SQL Data Warehouse, EMR, Spark, Databricks.
Govern data design and modeling, including metadata documentation and database object construction.
Collaborate with Data Governance, Data Engineering, and Data Architects to ensure compliance with standards.
Prepare Source-to-Target mappings and define data transformation rules for ETL and BI developers.
Support data lineage, profiling, and metadata management for enterprise data models.
Develop reusable data models with an extensible philosophy to minimize future rework.
Partner with IT and business teams to incorporate security, regulatory compliance, and privacy-by-design principles.
Drive collaborative reviews of design, code, and data security features.
Assist with data planning, sourcing, collection, profiling, and transformation.
Advocate data design patterns for scalable and efficient models.

Qualifications

Must-Have Qualifications

5+ years overall technology experience, including 2+ years in data modeling and systems architecture.
2+ years experience developing Enterprise Data Models.
Expertise in data modeling tools: ER/Studio, Erwin, IDM/ARDM.
Experience with Snowflake and at least one MPP database technology (Synapse, Teradata, Redshift).
2+ years experience with Data Lake Infrastructure, Data Warehousing, and Data Analytics tools.
Strong knowledge of Source-to-Target mapping and canonical model design.
Experience with multi-cloud integration (Azure) and on-premises technologies.
Basic SQL and/or Python skills.
Excellent verbal and written communication skills.

Education

Bachelor’s degree in Computer Science, Data Management/Analytics, Information Systems, or related discipline.

Desirable Skills

Knowledge of Azure Data Factory, Databricks, Azure Machine Learning.
Familiarity with data quality tools (Apache Griffin, IDQ, Great Expectations, Axon).
Azure Basic Level Certification.
Experience with metadata management, data lineage, and data glossaries.
Knowledge of SAP Master/Transactional Data and CPG industry.
Exposure to Machine Learning, GitHub, and CI/CD tools.
Working knowledge of Agile, DevOps, and DataOps concepts.
Familiarity with BI tools (Power BI).

More Jobs at PepsiCo

Software Engineering Associate Analyst

Hyderabad, Telangana, India

2 - 2 yrs

Salary: Not disclosed

Architect - Cloud Solution Architect

Hyderabad, Telangana, India

Experience: Not specified

Salary: Not disclosed

SR. SOFTWARE ENGINEER

Hyderabad, Telangana, India

2 - 2 yrs

Salary: Not disclosed

Maint/Engg Coordinator

Patiala, Punjab, India

2 - 5 yrs

Salary: Not disclosed

Architect- SAP Security

Hyderabad, Telangana

9 - 9 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

PepsiCo

Login to

Please Verify Your Phone or Email

Confirm Action

Data Modeler (Erwin, ER Studios)