Sr. Data Modeler

NTT DATA is looking for a Sr. Data Modeler to join their team in Bangalore, Karntaka (IN-KA), India. As a Sr. Data Modeler, your primary responsibility will be to design and implement dimensional (star/snowflake) and 3NF data models that are optimized for analytical and reporting needs in Azure Synapse and Power BI. You will also be required to perform STM (source to target mapping) from the data source to multiple layers in the data lake. Additionally, you will analyze and optimize Spark SQL queries and collaborate with cross-functional teams to ensure that the data models align with business requirements. The ideal candidate should have at least 7 years of experience in SQL and PySpark. Hands-on experience with Azure Synapse, ADLS, Delta format, and metadata-driven data pipelines is essential. You should also be experienced in implementing dimensional (star/snowflake) and 3NF data models, as well as in PySpark and Spark SQL, including query optimization and performance tuning. Experience in writing complex SQL, performing Source-to-Target Mapping (STM), and familiarity with CI/CD practices in Git and Azure DevOps are also required. In this role, you will be responsible for maintaining version control and CI/CD pipelines in Git and Azure DevOps, as well as integrating Azure Purview to enable access controls and implementing row-level security. Strong problem-solving and analytical skills for debugging and optimizing data pipelines in Azure Synapse are essential. If you are a passionate and innovative individual looking to be part of a forward-thinking organization, apply now to join NTT DATA and be a part of their inclusive and adaptable team dedicated to long-term success and digital transformation. Visit us at us.nttdata.com.,