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

Jobs

Interviews

Home
>
Jobs in pune
>
Photon
>
Senior Data Modeler

Senior Data Modeler

Photon

4 - 9 years

8 - 12 Lacs

pune chennai bengaluru

Posted:2 days ago| Platform:

Apply

Skills Required

metadata management sql data modeling data governance metadata repository snowflake python metadata oracle data warehousing er studio erwin oltp postgresql modeler data transformation agile etl informatica data integration sql database

Work Mode

Work from Office

Job Type

Full Time

Job Description

About The Role
Location: Chennai
Experience: 6-9 Years
Job Summary:
We are looking for a highly skilled Senior Data Modeler with extensive experience in data modeling, SQL, metadata management, and data governance . The ideal candidate will have expertise in relational, dimensional, and analytic data modeling with hands-on experience in databases like Oracle, PostgreSQL, Snowflake, and Teradata . Strong knowledge of data governance, data cataloging tools (Alation, Collibra), and metadata repositories is essential.
Key Responsibilities:

Design, develop, and maintain relational, dimensional, and analytical data models for large-scale OLTP and analytical systems .

Perform hands-on data modeling, ER diagramming, and enterprise software design for diverse data ecosystems.

Define and enforce data modeling standards and best practices for scalable and high-performance solutions.

Work with SQL databases such as Oracle, PostgreSQL, Snowflake, and Teradata , optimizing performance and query tuning.

Collaborate with cross-functional teams (engineers, architects, product managers) to translate business requirements into effective data models .

Implement metadata management, data lineage, and data cataloging using tools like Alation and Collibra .

Ensure data accuracy, completeness, and consistency across data models and maintain comprehensive documentation.

Support history handling, time-series data warehousing, and complex data transformations .

Assist teams in adopting data modeling best practices for global, large-scale data-driven implementations.

Contribute to data governance initiatives and establish a centralized metadata repository .

Work in a fast-paced, agile environment with short release cycles and iterative development methodologies.

Required
Skills:

7+ years of experience in relational, dimensional, and analytical data modeling.

Strong SQL skills with hands-on experience in Oracle, PostgreSQL, Snowflake, and Teradata .

Experience with data modeling tools (Erwin, ER Studio, or similar).

Expertise in data governance processes and metadata repositories .

Knowledge of semantic data modeling concepts and multi-fact model designs.

Strong verbal and written communication skills to interact with engineers, architects, and product managers .

Ability to work on multiple projects/products simultaneously with minimal specifications.

Experience in Alation and Collibra for data cataloging and data lineage tracking .

Good to Have:

Knowledge of Python for data processing.

Experience with Informatica for ETL and data integration.

More Jobs at Photon

Backend Java Developer

Chennai, Bengaluru, Hyderabad

8 - 12 yrs

INR 8 - 17 Lacs

Java Developer + Angular

Chennai, Bengaluru

4 - 9 yrs

INR 0 - 0 Lacs

Full Stack Developer

Chennai, Bengaluru

6 - 10 yrs

INR 16 - 19 Lacs

SDET Engineer

Chennai

7 - 12 yrs

INR 11 - 12 Lacs

Delivery Manger/Delivery Head

Chennai

14 - 24 yrs

INR 27 - 42 Lacs

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

Photon

IT Services and IT Consulting

Tech City

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Senior Data Modeler