Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

For Employers

Add office photos

Employer? Claim Account for FREE

PwC

Compare

3.4

based on 9.2k Reviews

Video summary

2255 PwC Jobs

US Tech - ETL Automation Architect - Manager

Pricewaterhouse Coopers Private Limited

3.4

based on 9.2k Reviews

10-13 years

Hyderabad / Secunderabad, Bangalore / Bengaluru

1 vacancy

US Tech - ETL Automation Architect - Manager

PwC

posted 1mon ago

Job Role Insights

Flexible timing

Key skills for the job

Python SQL Oracle Automation Testing Database Administration MySQL

+ 4 more

Job Description

1. ETL Project Feasibility and Design

Assess ETL project feasibility based on project requirements and business goals.

Design and implement ETL automation frameworks/solutions aligned with industry best practices.

Evaluate and recommend tools, such as Datagaps and Python plugins, to streamline ETL validation and testing processes.

2. Validation and Troubleshooting

Conduct thorough validation of all data sources, including relational databases, nonrelational databases, APIs, BI tools, flat files, Excel, and CSV.

Provide guidance and troubleshooting support to ETL Automation Leads and Engineers.

Assist with complex ETL automation troubleshooting and debug issues related to pipeline configuration, tool bugs, and data quality.

3. Vendor Collaboration

Serve as a liaison with vendors to address issues related to Datagaps and other automation tools.

Follow up with vendors on bugs, tool fixes, and feature enhancements.

4. Automation Strategy and Frameworks

Develop and implement the overall ETL automation strategy for company programs.

Create POCs (Proof of Concepts) and pilot projects to assess the feasibility of new market technologies and trends, including GenAI and nextgeneration tools.

Design and execute CI/CD pipelines for ETL processes, leveraging Datagaps tools and Azure DevOps.

5. Training and Documentation

Conduct demos and training sessions for nextgeneration automation tools and solutions.

Develop comprehensive documentation, including training materials, frameworks, and process guidelines.

6. Evaluation and Innovation

Stay uptodate with market trends and emerging ETL technologies.

Evaluate new tools and requirements for ETL automation, providing recommendations to stakeholders.

Drive innovation through the adoption of cuttingedge technologies and practices.

Qualifications

Required Skills

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.

Handson experience with various data sources, including relational databases (e.g., SQL Server, Oracle, MySQL) and nonrelational sources (e.g., NoSQL, MongoDB).

Familiarity with APIs, BI tools, flat files, Excel, and CSV data integration, Databricks.

Experience with CI/CD pipeline configuration for ETL processes.

Preferred Skills

Datagaps experience

Knowledge of GenAI and its applications in automation.

Understanding of cloud platforms (e.g., AWS, Azure, GCP) for ETL and data workflows.

Strong analytical and troubleshooting skills.

Excellent collaboration and communication skills to work effectively with crossfunctional teams and vendors.

Additional Requirements

Ability to manage multiple projects and deliver results in a fastpaced environment.

Willingness to take ownership and lead initiatives.

Strong organizational and problemsolving skills.

Employment Type: Full Time, Permanent

Read full job description

Prepare for Automation Architect roles with real interview advice

What people at PwC are saying

What PwC employees are saying about work life

based on 9.2k employees

75%

88%

58%

88%

Flexible timing

Monday to Friday

No travel

Day Shift

View more insights

Compare PwC with

Deloitte

3.8

Compare

Ernst & Young

3.4

Compare

Accenture

3.8

Compare

TCS

3.7

Compare

Cognizant

3.7

Compare

Infosys

3.6

Compare

IBM

4.0

Compare

Capgemini

3.7

Compare

KPMG India

3.5

Compare

Google

4.4

Compare

BCG

3.7

Compare

Wipro

3.7

Compare

Amazon

4.1

Compare

Grant Thornton

3.7

Compare

BDO

3.3

Compare

RSM India

3.3

Compare

Crowe Horwath

4.1

Compare

Mazars

3.1

Compare

Baker Tilly Virchow Krause

3.5

Compare

Protiviti

3.2

Compare

Similar Jobs for you

Technology at Pricewaterhouse Coopers Private Limited

Hyderabad / Secunderabad, Bangalore / Bengaluru

10-14 Yrs

₹ 35-40 LPA

ETL Architect at IGT Solutions

Gurgaon / Gurugram

8-13 Yrs

₹ 20-30 LPA

Senior Manager at Pricewaterhouse Coopers Private Limited

Hyderabad / Secunderabad, Bangalore / Bengaluru

5-8 Yrs

₹ 40-50 LPA

Data Architect at Pricewaterhouse Coopers Private Limited

Hyderabad / Secunderabad, Bangalore / Bengaluru

11-12 Yrs

₹ 25-30 LPA

Data Architect at HashRoot

8-14 Yrs

₹ 35-45 LPA

Technology Architect at Pricewaterhouse Coopers Private Limited

Hyderabad / Secunderabad, Bangalore / Bengaluru

5-9 Yrs

₹ 40-50 LPA

Data Architect at Blazeclan Technologies

11-14 Yrs

₹ 35-45 LPA

Automation Architect at Juniper Networks India Pvt Ltd

Bangalore / Bengaluru

8-12 Yrs

₹ 25-30 LPA

Data Architect at Peepal consulting

8-12 Yrs

₹ 30-40 LPA

Senior Automation Architect at NetScaler

Kolkata, Mumbai + 5

9-14 Yrs

₹ 32.5-37.5 LPA

PwC Bangalore / Bengaluru Office Locations

View all

Bangalore / Bengaluru (2) Hyderabad / Secunderabad (1)

Bengaluru Office

PricewaterhouseCoopers Pvt Ltd, The Millenia, Tower D , # 1 & 2 Murphy Road, Ulsoor Bengaluru
Karnataka 560008

Bengaluru Office

Price waterhouse Coopers, Embassy Golf Links Road, Embassy Golf Links Business Park, Challaghatta Bengaluru
Karnataka 560071