Photon Logo

Photon

Software Engineer - Data Modeling, SQL, Oracle - CHN

Posted Yesterday
Be an Early Applicant
Remote
Hiring Remotely in India
Senior level
Remote
Hiring Remotely in India
Senior level
Design, model, and optimize relational and analytical data structures for OLTP and data warehouse systems. Build ER diagrams, define modeling standards, manage metadata with tools like Erwin/ER Studio, and drive data cataloging/lineage using Alation/Collibra. Perform performance tuning, sandbox POCs, handle time-series/history, and collaborate with engineers, architects, and product teams while documenting and enforcing governance.
The summary above was generated by AI

Location: Chennai
Experience: 6 - 9 Years

Must Have -
• Bachelor’s or master’s degree in computer/data science technical or related experience
• 7+ years of experience hands-on relational, dimensional, and/or analytic experience.
• Strong SQL knowledge and work experience with databases such as Oracle, PostgreSQL, Snowflake, Teradata
• Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC
• Good knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
• Demonstrated, hands-on data modeling, ER diagram` and enterprise software design experience for OLTP (relational) and analytical systems
• Good knowledge of data modeling principles and standard methodologies including a good understanding of semantic data modeling concepts and multi-Fact model
• Ability to define data modelling standards and guidelines as well help teams adopt complex large-scale & global data driven implementations
• Strong experience in data modelling activities supporting history handling time series data warehousing & data transformations
• Ability to quickly grasp technological, business concepts, key domain and entities
• Strong verbal and written communication skills; experience communicating with engineers, architects and product management to explain technical and functional concepts
• Ability to assess the accuracy completeness and consistency of data models as well as maintaining relevant documentation
• Experience with Alation, Collibra to drive data cataloging and data lineage
• Strong understanding of data governance processes and metadata repositories
• Experience and desire to work within a fast-paced environment with short release cycles and an iterative development methodology.
• Able to work on multiple projects/products simultaneously and comfortable working with minimal specifications.
• Excellent communication and documentation skills
Good to Have:
Python knowledge is a plus
Informatica

Similar Jobs

21 Minutes Ago
Remote
India
Expert/Leader
Expert/Leader
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead clinical trial disclosure strategy and operations for Pfizer-sponsored interventional trials. Ensure timely, compliant posting of protocols, SAPs, CSRs, and clinical summaries per EMA Policy 70 and other regulations. Manage vendors, develop processes and technical solutions, represent Medical Writing on governance committees, and maintain regulatory knowledge and best practices to drive quality and consistency across disclosures.
3 Hours Ago
Remote
Gujarat, IND
Senior level
Senior level
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Lead product bring-up and sustain high-volume manufacturing for NAND/SSD products. Drive end-to-end yield improvement, failure analysis, and data-driven optimizations. Troubleshoot customer returns, define test flows and validation strategies, lead cross-functional task forces for qualification and ramp, and mentor junior engineers.
Top Skills: Data AnalyticsFailure AnalysisNandPcieSASSataSsd
3 Hours Ago
Remote
Gujarat, IND
Mid level
Mid level
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Analyze and troubleshoot failed memory module products, develop and implement module failure analysis processes, validate performance and reliability, document findings and corrective actions, collaborate with manufacturing and cross-functional teams, maintain SOPs/OCAPs, and apply FMEA to mitigate risks.
Top Skills: DramFailure AnalysisFmeaModule TechnologyNandNorStatistical Tools

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account