IN Associate ETL Data and Analytics Advisory Mumbai

Line of Service

Advisory

Industry/Sector

FS X-Sector

Specialism

Data, Analytics & AI

Management Level

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 data analysis at PwC, you will focus on utilising advanced analytical techniques to extract insights from large datasets and drive data-driven decision-making. You will leverage skills in data manipulation, visualisation, and statistical modelling to support clients in solving complex business problems.

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.

Job Description & Summary: A career within Data and Analytics services will provide you with the opportunity to help organisations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organisational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organisations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.

Responsibilities:

4 - 6 years of professional experience with working knowledge in a Data and Analytics role with a Global organization · -Mandatory Hands-on Development Experience in ETL tool : Informatica Power center OR IICS or ODI or Talend · -Should have implemented end to end ETL life cycle, preparing ETL design frameworks and execution · -Must have rich experience building Operational Data stores, Data marts and Enterprise Data warehouse · -Must have very good SQL skills ( Specifically in Oracle, MySQL, Postgre) · -Should be able to create and execute ETL designs and test cases should be able to write complex SQL queries for testing/analysis depending upon the functional/technical requirement.

· -Should have worked on performance optimization, error handling, writing stored procedures, etc. · -Demonstrate ability to communicate effectively with both Technical & Business stakeholders · - Should have good knowledge of SCD Type 1, SCD Type 2 concepts. · -Should have Understanding of data modelling, Data warehousing concepts

Mandatory skill sets:

· Must have rich experience building Operational Data stores, Data marts and Enterprise Data warehouse · -Must have very good SQL skills ( Specifically in Oracle, MySQL, Postgre) · -Should be able to create and execute ETL designs and test cases should be able to write complex SQL queries for testing/analysis depending upon the functional/technical requirement.

Preferred skill sets:

· - Should have good knowledge of SCD Type 1, SCD Type 2 concepts. -Should have Understanding of data modelling, Data warehousing concepts

Years of experience required:

Experience 4- 6 years

Education qualification:

Bachelor's degree in computer science, data science or any other Engineering discipline. Master’s degree is a plus.

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

Degrees/Field of Study required: Bachelor Degree, Master Degree

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

ETL Tools, Informatica PowerCenter

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Algorithm Development, Alteryx (Automation Platform), Analytic Research, Big Data, Business Data Analytics, Communication, Complex Data Analysis, Conducting Research, Customer Analysis, Customer Needs Analysis, Dashboard Creation, Data Analysis, Data Analysis Software, Data Collection, Data-Driven Insights, Data Integration, Data Integrity, Data Mining, Data Modeling, Data Pipeline, Data Preprocessing, Data Quality {+ 33 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date