Job description

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

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 optimise business performance and enhance competitive advantage.

*Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations.

Responsibilities:

· Design, develop, and maintain data integration processes using Oracle Data Integrator (ODI). · Create and manage ODI mappings, packages, and scenarios to meet business requirements. · Perform data extraction, transformation, and loading (ETL) processes to ensure data accuracy and consistency. · Collaborate with cross-functional teams to gather and understand business requirements and translate them into technical specifications. · Optimize and tune ODI processes for performance and scalability. · Implement data quality checks and error handling mechanisms in ODI. · Develop and maintain data warehouse (DWH) solutions, including data modeling, schema design, and ETL processes. · Implement and manage multiple data load strategies (e.g., incremental loads, full loads) based on business requirements and data volumes. · Write and optimize complex SQL queries for data extraction, transformation, and reporting. · Provide technical support and troubleshooting for ODI processes and data warehouse solutions. · Stay updated with the latest industry trends and best practices in data integration, SQL, and data warehousing.

Mandatory skill sets: ODI & SQL

Preferred skill sets:

DWH & ETL Processes

Years of experience required:

4 – 7 yrs

Education qualification:

B.tech/MBA/MCA

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required: Master of Business Administration, Bachelor of Technology

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills