Informatica PowerCenter Developer - Senior Associate

PwC Acceleration Center India; Bengaluru; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

PwC Acceleration Center India is seeking an Informatica PowerCenter Developer - Senior Associate to transform data into insights within our Data and Analytics Engineering group. You will design, develop, and implement data solutions, mentor juniors, and nurture client relationships.

In this role, you will collaborate with Cloud Engineering and Analytics teams, leveraging Informatica technologies, Snowflake, Databricks, and Spark to modernize data platforms and deliver scalable pipelines that

Qualifications

• At least a Bachelor's degree.
• 5+ years of hands-on ETL/ELT development and data integration.
• Hands-on experience with Informatica IICS/IDMC, CAI and CDI, plus PowerCenter.
• Experience migrating ETL workloads to cloud-native platforms.
• Hands-on experience with Snowflake/Databricks, including data modeling and query tuning.
• Knowledge of Databricks and Apache Spark for processing.
• Experience with API integration and middleware using CAI.
• Proficiency in Python for automation and transformations.
• Experience building ETL/ELT pipelines integrating Snowflake from diverse sources.
• Design, develop, and unit test mappings and workflows using IICS/IDMC/PowerCenter.

Responsibilities

• Developing and maintaining data integration workflows using Informatica PowerCenter.
• Implementing data architecture solutions across AWS/Azure for data flow and storage.
• Using Apache Airflow to orchestrate data pipelines and improve processing.
• Designing data transformations to enhance quality and accessibility.
• Collaborating with cross-functional teams to tackle data challenges.
• Building scalable data infrastructure for large-scale analytics and reporting.
• Conducting performance tuning and query optimization for DBMS.
• Validating data security and implementing protections.
• Leading data modeling and dimensional modeling for data warehouses.
• Troubleshooting data warehouse issues and maintaining reliability.

Skills

ETL/ELT development

Informatica IICS/IDMC

Python

Snowflake

Databricks

Apache Spark

APIs

Data modeling

Education

Bachelor's degree

Tools

Informatica PowerCenter

Informatica IICS/IDMC

CAI

CDI

Snowflake

Databricks

Apache Spark

AWS

Azure

GCP

Job description

The Opportunity

Join our Acceleration Center India and help shape the future of business for our diverse client portfolio across geographies and jurisdictions. You’ll work at the heart of global teams across Advisory, Assurance, Tax and Business Services—solving real client challenges through connected collaboration. We’ll help you grow your skills so you can go further. With hands‑on learning, cutting‑edge tools and an inclusive culture, this is your opportunity to do inspiring work that makes a difference—every day.

As an Informatica PowerCenter Developer - Senior Associate, you will play a pivotal role in transforming data into valuable insights within our Data and Analytics Engineering group. You will be instrumental in designing, developing, and implementing data solutions that drive business decisions and enhance client outcomes. As a Senior Associate, you will leverage your skills to analyze complex problems, mentor junior team members, and maintain professional standards. You will focus on building meaningful client relationships and developing a deeper understanding of the business context, navigating increasingly complex situations to grow your personal brand and deepen your technical skills.

In this role at PwC Acceleration Center India, you will work within our Cloud Engineering, Data & Analytics network, contributing to data modernization efforts and product innovation. You will anticipate the needs of your teams and clients, delivering quality solutions while embracing ambiguity and using these moments as opportunities for growth. Your work will be integral to the firm's strategies, and you will use a broad range of methodologies and techniques to generate new ideas and solve problems, enhancing your strengths and addressing development areas.

Responsibilities

• Developing and maintaining data integration workflows using Informatica PowerCenter to support client data needs
• Implementing data architecture solutions to optimize data flow and storage across cloud platforms like AWS and Azure
• Utilizing Apache Airflow for orchestrating complex data pipelines and enhancing data processing efficiency
• Designing and executing data transformation strategies to improve data quality and accessibility
• Collaborating with cross-functional teams to address data challenges and drive innovation in data engineering practices
• Building scalable data infrastructure to support large-scale data analytics and reporting requirements
• Conducting performance tuning and query optimization to enhance database management systems
• Validating data security protocols and implementing best practices for database protection
• Leading efforts in data modeling and dimensional modeling to support data warehouse development
• Troubleshooting data warehouse issues and implementing solutions to maintain system reliability

What You Must Have

• At least a Bachelor's degree
• 5+ years of hands‑on experience in ETL/ELT development and data integration.
• Strong hands‑on experience with Informatica IICS/IDMC, including Cloud Application Integration (CAI) and Cloud Data Integration (CDI), and Informatica PowerCenter.
• Experience supporting migration of ETL workloads from PowerCenter to IICS/IDMC cloud‑native platforms.
• Strong hands‑on experience with Cloud Data Warehouse like Snowflake /Databricks, including data modeling, optimization, and query tuning.
• Working knowledge of Databricks and Apache Spark for data processing and transformation.
• Experience with API integration and middleware solutions using Informatica CAI.
• Proficient in Python programming to support automation, data processing, and advanced data transformations.
• Experience building and maintaining ETL/ELT pipelines integrating Snowflake with diverse sources via IICS.
• Design, develop, and unit test complex mappings, workflows, and tasks using IICS, IDMC, and PowerCenter.
• Collaborate with data architects and business analysts to translate business requirements into technical specifications and design.
• Knowledge and hands – on , Snowflake data objects including tables, views, stages, streams, and tasks with focus on performance and cost optimization.
• Should be aware of Snowflake features such as data sharing, events, and lake‑house patterns.
• Should have experience with data security and data access controls.
• Good to have AWS, Azure, or GCP data storage and management technologies such as S3, Blob/ADLS, and Google Cloud Storage.

What Sets You Apart

• Preference for at least one of the following fields of study: Management Information Systems, Computer and Information Science, Systems Engineering, Electrical Engineering, Chemical Engineering, Industrial Engineering, Mathematics, Statistics, Mathematical Statistics
• Demonstrating proficiency in Informatica PowerCenter for data integration
• Utilizing Amazon Web Services (AWS) and Microsoft Azure for cloud solutions
• Developing data pipelines and data transformation processes
• Excelling in data modeling and database optimization techniques
• Implementing data warehouse solutions using Snowflake and Databricks
• Navigating complex data engineering challenges with analytical thinking