AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Engaged Employer
i
This company page is being actively managed by
Photon Interactive Team. If you also belong to the team, you
can get access from
here
Photon Interactive
Compare
All Filters
284 Photon Interactive Jobs
Senior Data Modeler
Photon Interactive
posted 12d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Location: Chennai
Experience: 6-9 Years
Job Summary: Experience: 6-9 Years
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.
- 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 .
- Knowledge of Python for data processing.
- Experience with Informatica for ETL and data integration.
Employment Type: Full Time, Permanent
Read full job descriptionPhoton Interactive Interview Questions & Tips
Prepare for Photon Interactive roles with real interview advice
Top Photon Interactive Senior Data Modeler Interview Questions
Q1. What are design patterns, and have you implemented any of the design pattern in your previous project, can you explain?
asked in
Software Engineer interview
Q2. What tools do you use and why do you required them?
asked in
Business Analyst interview
Q3. What is responsive design ? How will you develop responsive websites ?
asked in
Innovation Consultant interview
What people at Photon Interactive are saying
What Photon Interactive employees are saying about work life
based on 1.8k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Photon Interactive Benefits
View more benefits
Compare Photon Interactive with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
LTIMindtree
Compare
Mphasis
Compare
Hexaware Technologies
Compare
Persistent Systems
Compare
Xoriant
Compare
CitiusTech
Compare
Iris Software
Compare
HTC Global Services
Compare
HERE Technologies
Compare
iOPEX Technologies
Compare
Tietoevry
Compare
Collabera Technologies
Compare
Evalueserve
Compare
Unisys
Compare
Infogain
Compare
Similar Jobs for you
Photon Interactive Chennai Office Locations
Chennai Office
5th Block, 2nd Floor, DLF IT Park, 1/124, Mount Poonamallee Road, Sivaji Gardens, Manapakkam,
Chennai
Tamil Nadu 600089
Tamil Nadu 600089
Chennai Office
5th Block, 2nd Floor, DLF IT Park, 1/124, Mount Poonamallee Road, Sivaji Gardens, Manapakkam,
Chennai
Chennai – 600089
Chennai – 600089
Senior Software Engineer, Technical Lead
6-11 Yrs
Chennai, Bangalore / Bengaluru
Software Engineer - Angular, Node - BLR
3-5 Yrs
Kolkata, Mumbai, New Delhi +4 more
Share an Interview