Senior Data Engineer

PFI Innovation Centre India; Gurugram District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

PFI Innovation Centre India, a Prudential Financial, Inc. entity, seeks a Senior Data Engineer to design and maintain scalable data products using Denodo, AWS, and modern data-engineering practices.

You will partner with Solution Architects, Tech Leads, AI Engineers, and business experts to deliver governed, reusable data assets that power analytics and AI use cases.

Qualifications

• 5+ years of Data Engineering experience with hands-on Denodo development.
• Strong knowledge of SQL, data warehousing, and dimensional modelling.
• Experience with AWS Lambda, ETL/ELT development, APIs, and data-product development.

Responsibilities

• Design, build, and maintain scalable data products and semantic-layer solutions using Denodo and AWS.
• Collaborate with solution architects, tech leads, AI engineers, and business stakeholders.
• Develop and optimize ETL/ELT pipelines, data transformations, and data models.
• Ensure governed, reusable, and AI-consumable data assets.

Skills

Data engineering

Denodo development

SQL

AWS services

ETL/ELT development

Data modeling

Cross-functional collaboration

Tools

Denodo

APIs

Web services

Cloud platforms

Job description

PFI Innovation Centre India is an exciting new innovation center. We’re building a future that helps people live better lives longer – and we’re looking for bold thinkers and team players to help us do it.

Here, you’ll tackle complex challenges, collaborate with brilliant minds across the globe, and grow your career while helping millions achieve financial security.

A PURPOSE DRIVEN COMPANY – 150 YEARS

While the PFI Innovation Centre brand is new to India, you’ll be a part of the Prudential Financial, Inc. family.Founded in Newark, NJ, we serve 50 million customers across more than 50 countries. With $1.334 trillion in assets, we’re a global leader in institutional asset management. The 2 nd largest life insurer in the US and the 9 th largest institutional global asset manager.

At the PFI Innovation Centre India, you’ll find high-performance culture that’s flexible, collaborative, and grounded in respect. We engage with candor, take calibrated risks, and hold ourselves accountable – always focused on delivering for our customers. It’s the standard we choose every day as we grow, perform, and win as one team. We offer valuable leadership, mentoring and learning opportunities, paired with flexibility and support to help you thrive.

Whether you’re just starting out or ready to take your next step, we’ll help you grow with purpose and do the best work of your career.

What you will do:

Are you excited by the opportunity to make trusted data easier to access, understand, and use? As a Senior Data Engineer, you will design, build, and maintain scalable virtualized data products and semantic-layer solutions using Denodo, AWS, APIs, and modern data-engineering practices. You will partner with Solution Architects, Tech Leads, AI Engineers, and business subject-matter experts to deliver governed, reusable, and AI-consumable data assets.

What you can expect:

• Develop and maintain Denodo view layers and virtualized data products using enterprise naming, metadata, and development standards.
• Build and support reusable ETL/ELT pipelines and data transformations using AWS services, APIs, cloud platforms, and operational source systems.
• Create canonical data models and semantic-layer entities that enable consistent reporting, analytics, applications, and AI use cases.
• Optimize Denodo performance through caching, accelerator strategies, query tuning, and effective join and aggregation design.
• Troubleshoot complex data-integration and performance issues while collaborating with architecture, engineering, AI, and business partners.

What you will bring:

• 5+ years of Data Engineering experience, including 3+ years of hands-on Denodo development experience.
• Strong knowledge of virtual data models, data integration, SQL, data warehousing, and dimensional modeling.
• Experience with AWS Lambda, ETL/ELT development, APIs, web services, and data-product development.
• Experience implementing join strategies, aggregations, union operations, transformations, and data-standardization frameworks.
• Ability to collaborate effectively across technical and business teams to deliver trusted, governed data assets.

What will set you apart?

• Exposure to AI or agent-engineering ecosystems and LLMOps concepts.
• Knowledge of enterprise metadata, naming conventions, and business-data standards.

PFI Innovation Centre India welcomes all applicants, even if you don't meet every requirement. If your skills align with the role, we encourage you to apply.