IN_Associate_ SQL Data Engineer_D&A_Advisory_Mumbai

Job Description Job Description & Summary: At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals. In business intelligence at PwC, you will focus on leveraging data and analytics to provide strategic insights and drive informed decision-making for clients. You will develop and implement innovative solutions to optimize business performance and enhance competitive advantage. Job Position Title: IN_Associate_ SQL Data Engineer_D&A_Advisory_Mumbai Responsibilities: Design, develop, and maintain ETL/ELT data pipelines for ingesting and transforming data from multiple sources. Write complex and optimized SQL queries, stored procedures, views, functions, and scripts . Develop and maintain data warehouse and data mart solutions. Perform data extraction, transformation, cleansing, and validation. Design efficient data models , including fact and dimension tables. Implement Star Schema and Snowflake Schema where appropriate. Optimize SQL queries, database performance, indexes, and stored procedures. Develop data integration workflows using ETL tools or cloud-native services. Perform data profiling and implement data-quality checks. Troubleshoot data pipeline failures, data inconsistencies, and performance issues. Work with business analysts and stakeholders to understand data requirements. Ensure data pipelines are reliable, scalable, secure, and maintainable. Implement monitoring, logging, and alerting for data workflows. Maintain technical documentation for data pipelines, database objects, and processes. Participate in data migration and modernization projects. Mandatory skill sets: Data Engineering, ETL, or Database Development and SQL Preferred skill sets: Data Engineering & Sql Years of experience required: 2 to 4 years Education qualification: B.E/B.Tech/MBA/M.E/M.Tech

• Experience: 2+ years
• Seniority: Entry Level
• Education: Bachelor's degree preferred
• Languages: English