Location: Anywhere in India,Experience: 2 years - 4 years
Posted On: 21-Jul-2021 | Last Date to Apply: 30-Sep-2021 | No: of Vacancies : 1
Company Profile:
We are equally committed to our employees. With technology focus areas that include Advanced Product Engineering, DevOps, Cloud, Infrastructure & Security, Big Data & Analytics, Data Management & Governance, Digital and IoT, at Xoriant you have excellent opportunities for advanced technical learning and career progression. Grow your technical proficiency and nurture your passion for tech through regular company-wide hackathons and TechX, Xoriant’s premier technology event. As a diverse organization, we endeavor a work environment that offers equal opportunities to optimize performance and foster growth.
Job description:
Data Modeler:
Relevant years of experience in this skill set
Good understanding of Database concepts, Normalizations, ACID
Worked on any of the relational databases - Oracle, SQL Server, MySql. Oracle would be preferred
Conceptual understanding of no SQL database
Able to write and understand complex SQL queries
Create logical and physical data models for reporting and analytics use cases, using best practices to ensure high data quality, optimal performance and reduced redundancy.
Should have proven and practical hands on experience in various modeling methodology like Dimensional and relational Modeling etc
Expertise in Data warehousing concepts, Star and Snowflake schema, Relational Schema, Partitioning, Indexes etc.
Experience in Erwin and/or other similar data modeling tools with focus on reporting and analytical applications.
Should have good understanding of query optimization / understanding query plans / fine tuning queries
Should be clear on database deployment processes
Experience in working with Agile methodology / Scrum is preferred