Photon Logo

Photon

Software Engineer - Data Modeling, SQL, Oracle - CHN

Reposted 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

3 Hours Ago
Remote or Hybrid
India
Junior
Junior
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Build data-driven solutions and BI using Python, Power BI, and SQL. Implement DevOps pipelines with GitHub Actions/Azure DevOps, deploy on Azure/AWS, integrate APIs, apply unit testing and automation, and collaborate in Agile/Scrum with global teams. Support solution design, effort estimates, and use ML/DL/LLMs for intelligent features.
Top Skills: APIsAutomationAWSAzureAzure DevopsCi/CdDeep LearningGitGitGithub ActionsLarge Language ModelsMachine LearningPower BIPythonSQLUnit Testing
3 Hours Ago
Remote or Hybrid
India
Entry level
Entry level
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Perform data cleansing, validation, reconciliation, and document uploads. Follow SOPs and quality checks, update trackers and MIS, report discrepancies, support quality reviews, and collaborate with team leads while learning process workflows.
Top Skills: ExcelMS OfficeMis
10 Hours Ago
In-Office or Remote
Senior level
Senior level
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Manage large enterprise accounts to retain and expand Atlassian product usage. Build and sustain senior/executive relationships, lead high-value renewals and complex sales cycles, forecast owned book of business, identify and mitigate customer risk, collaborate with Sales and channel partners, and use data and product knowledge to discover expansion opportunities.
Top Skills: Atlassian ProductsClariSalesforceTableau

What you need to know about the Kolkata Tech Scene

When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account