EY - Data Modeler - ETL/SQL

Location : Mumbai, Pune, Chennai, Bangalore, Gurgaon, Kolkata Experience : 5-10 Years Job Criteria : - Having 8 years of working experience in Data Engineering and Data Analytic projects in implementing Data Warehouse, Data Lake and Lakehouse and associated ETL/ELT patterns. - Worked as a Data Modeler in one or two implementations in creating and implementing Data models and Data Base designs using Dimensional, ER models. - Good knowledge and experience in modelling complex scenarios like many to many relationships, SCD types, Late arriving fact and dimensions etc. - Hands on experience in any one of the Data modelling tools like Erwin, ER/Studio, Enterprise Architect or SQLDBM etc. - Experience in working closely with Business stakeholders/Business Analyst to understand the functional requirements and translating it into Data Models and database designs. - Experience in creating conceptual models and logical models and translating it into physical models to address both functional and non-functional requirements. - Strong knowledge in SQL, able to write complex queries and profile the data to understand the relationships and DQ issues. - Very strong understanding of database modelling and design principles like normalization, denormalization, isolation levels. - Experience in Performance optimizations through database designs (Physical Modelling). Good communication skills. - Only Immediate Joiners to 30 Days notice period is preferred (ref:hirist.tech)

Location: in, IN

Posted Date: 11/14/2024