Informatica PowerCenter Developer - Senior Associate

PwC; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

PwC Acceleration Center India in Bengaluru seeks an Informatica PowerCenter Developer - Senior Associate to transform data into insights. You will design, develop, and implement data solutions, mentor juniors, and drive data modernization within our Cloud Engineering, Data & Analytics network.

You’ll work with cross-functional teams to deliver high-impact analytics solutions. You will collaborate on data integration, data modeling, and security, using Snowflake, Databricks, and Spark, while

Qualifications

• Bachelor's degree required.
• 5+ years hands-on ETL/ELT development and data integration experience.
• Proficient with Informatica IICS/IDMC and PowerCenter.
• Experience migrating ETL workloads to cloud-native IICS/IDMC platforms.
• Experience with Snowflake/Databricks data warehousing and modeling.
• Knowledge of Databricks and Apache Spark for processing.
• Proficient in Python for automation and data processing.
• Experience with API integration and CAI.
• Data security best practices and access controls.

Responsibilities

• Develop and maintain data integration workflows using Informatica PowerCenter.
• Design data architecture solutions across AWS and Azure.
• Orchestrate pipelines with Apache Airflow for efficiency.
• Transform data for quality, accessibility, and analytics needs.
• Collaborate with cross-functional teams to address data challenges.
• Build scalable data infrastructure for large-scale analytics.
• Tune performance and optimize database systems.
• Lead data modeling and warehouse development efforts.
• Ensure data security protocols are implemented and maintained.
• Mentor junior team members and translate business requirements into technical specs.

Skills

Informatica PowerCenter

ETL/ELT development

Python programming

Cloud data platforms

Snowflake

Databricks

Apache Spark

API integration

Data modeling

Data security

Education

Bachelor's degree

Tools

Informatica IICS/IDMC

Cloud Data Integration (CDI)

Cloud Application Integration (CAI)

PowerCenter

Snowflake

Databricks

Apache Airflow

Python

AWS / Azure / GCP

Job description

Job Description:

Industry/Sector

Specialism

Product Innovation

Management Level

Senior Associate

Job Description & Summary

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’ll 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 firms 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 Bachelors 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

Travel Requirements

Not Specified