Industry/Sector

Not Applicable

Specialism

Assurance

Management Level

Senior Associate

Job Description & Summary

Job Specification

About the Job

Introduction to PwC

Acceleration Centre

PricewaterhouseCoopers Service Delivery Centre (Kolkata) Private Limited is a joint venture in India among members of the PricewaterhouseCoopers Network that will leverage the scale and capabilities of its network. It is a member firm of PricewaterhouseCoopers International Limited and has its registered office in Kolkata, India
The Delivery Centre will provide a professional with an opportunity to work in a dynamic environment where you will have the ability to develop process and quality-based skills.

Roles and Responsibilities

As a Senior Associate, you will play a key role in designing and developing innovative audit solutions.

ERP Data Extraction & Engineering:

Extract financial and operational data from SAP/Oracle/D365 backend tables (e.g., GL and subledgers) and validate mappings with SMEs.
Design performance-aware extract logic, including incremental loads and Change Data Capture (CDC).
• Optimise joins, keys and filters to minimise ERP load and support reliable refresh cycles.

ETL / ELT Pipeline Development:

Build, standardise and automate end-to-end pipelines using SQL, Python and Databricks (PySpark), with Alteryx where appropriate.
Implement schema evolution handling, robust error/retry logic, and completeness/reconciliation checks.
Orchestrate workloads with Azure Data Factory (pipelines, triggers, dependencies).

Cloud & Lakehouse:

Land raw and curated data in Azure Data Lake Storage (ADLS) with clear folder structures and access controls.
Create Delta Lake tables with ACID guarantees, versioning and auditability; apply cost-efficient design patterns in Azure.

Data Quality, Testing & Observability:

Define control totals, referential integrity and anomaly checks; implement automated data quality tests.
Write unit/integration tests for ETL; configure logging, monitoring and alerting with clear SLAs/SLOs.