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
Skills Required
- Bachelor's or master's degree in Computer Science, Data Science, or related technical field
- 7+ years hands-on relational, dimensional, and/or analytic experience
- Strong SQL knowledge and experience with Oracle, PostgreSQL, Snowflake, Teradata
- Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC experience
- Knowledge of metadata management and data modeling tools (Erwin or ER Studio or similar)
- Hands-on data modeling, ER diagram, and enterprise software design experience for OLTP and analytical systems
- Knowledge of data modeling principles, semantic data modeling concepts and multi-Fact models
- Ability to define data modeling standards and guide large-scale global implementations
- Experience supporting history handling, time-series data warehousing, and data transformations
- Strong verbal and written communication; experience communicating with engineers, architects and product management
- Ability to assess accuracy, completeness and consistency of data models and maintain documentation
- Experience with Alation or Collibra for data cataloging and data lineage
- Strong understanding of data governance processes and metadata repositories
- Ability to work in a fast-paced, iterative environment with short release cycles
- Ability to work on multiple projects/products simultaneously with minimal specifications
- Excellent communication and documentation skills
- Python knowledge
- Informatica
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
.jpeg)
