Software Engineer - Data Modeling, SQL, Oracle - CHN

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