ETL Automation Architect Manager PwC Acceleration Centers in India

10.0 - 14.0 years

0 Lacs

karnataka

On-site

At PwC, the focus in data and analytics engineering is on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. As a data engineer at PwC, your role will involve transforming raw data into actionable insights to enable informed decision-making and drive business growth. You will primarily concentrate on designing and building data infrastructure and systems to facilitate efficient data processing and analysis. Your responsibilities will include developing and implementing data pipelines, data integration, and data transformation solutions. The ideal candidate for this position should possess a strong background in Data warehouse and Data migration projects. They should demonstrate expertise in ETL processes, data comparison/profiling, and source to target validation across various platforms, including relational and non-relational databases, APIs, BI tools, flat files, Excel, CSV, XML, Jsons, and others. The ETL Test Automation Architect will be instrumental in assessing project feasibility, recommending solutions, collaborating with vendors, and leading automation strategies. Proficiency in Python and experience with Datagaps tool are highly desirable. With 10 to 13 years of experience, your key responsibilities will include assessing ETL project feasibility based on project requirements and business goals, designing and implementing ETL automation frameworks/solutions, and evaluating and recommending tools to streamline ETL validation and testing processes. You will conduct thorough validation of all data sources, provide guidance and troubleshooting support, collaborate with vendors, develop and implement automation strategies, and stay updated with market trends and emerging ETL technologies. Required skills for this role include extensive experience in data warehouse and data migration projects, strong knowledge of ETL processes, database validation, and diverse data source validation, expertise in tools like Datagaps for ETL validation and automation, proficiency in Python for scripting and plugin development, hands-on experience with various data sources, familiarity with APIs, BI tools, flat files, Excel, and CSV data integration, and experience with CI/CD pipeline configuration for ETL processes. Preferred skills include Datagaps experience, knowledge of GenAI and cloud platforms, strong analytical and troubleshooting skills, and excellent collaboration and communication skills. Additional requirements for this role include the ability to manage multiple projects, deliver results in a fast-paced environment, willingness to take ownership and lead initiatives, and strong organizational and problem-solving skills.,

Posted 3 days ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.