Photon Logo

Photon

Software Engineer - Data Modeling, SQL, Oracle - CHN

Posted 3 Days Ago
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

5 Hours Ago
Remote or Hybrid
Senior level
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Manage US sales and use tax compliance across jurisdictions, including preparing and filing returns, tax data extraction and reconciliations, month-end accruals and GL reconciliations, supporting state and local tax audits, improving tax processes and automation, and partnering with Tax, Accounting, IT, and business teams on tax treatment and reporting.
Top Skills: AlteryxAvalaraClaudeExcelOnesourceOraclePower BISAPVertex
14 Hours Ago
Remote or Hybrid
India
Expert/Leader
Expert/Leader
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The role involves managing finance change, regulatory reporting, project management, and software testing, requiring extensive experience in financial services and team leadership.
Top Skills: Automation Testing ToolsExcelSQL
14 Hours Ago
Remote or Hybrid
India
Senior level
Senior level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Manage projects in the transaction banking sector with an emphasis on compliance and retail payments, using Agile methodologies and strong stakeholder management.
Top Skills: ConfluenceIso20022JIRA

What you need to know about the Delhi Tech Scene

Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account