Senior Data Engineer

Principal Financial Group

Pune District

On-site

INR 1,400,000 - 2,000,000

Full time

6 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Principal Financial Group is seeking a data engineering professional to design, develop, and optimize ETL workflows with Informatica. The role focuses on data integration across systems, data quality, and scalable batch processing in a dynamic environment.

You will collaborate with analytics teams, support Power BI/BO reporting, and participate in deployment activities while mentoring junior engineers and driving best practices.

Qualifications

4-6 years of Data Engineering / ETL experience.
Strong Informatica PowerCenter/IICS experience.
Strong SQL and database expertise.
Data Warehousing concepts and dimensional modeling.
Power BI or Business Objects support experience.
Unix/Linux Shell Scripting.
Production support & troubleshooting experience.
Agile delivery experience.

Responsibilities

Build, develop, improve, and support ETL workflows using Informatica.
Build and maintain robust data integration solutions across multiple source and target systems.
Develop and optimize batch and scheduled data processing jobs.
Ensure data quality, consistency, and integrity throughout the data lifecycle.
Analyze and resolve ETL production issues and performance bottlenecks.
Collaborate with reporting and analytics teams to deliver reliable datasets for business consumption.
Support and maintain Power BI and Business Objects reporting environments.
Work with business collaborators to understand reporting and data requirements.
Enable self-service reporting through curated and trusted data assets.
Monitor ETL jobs and resolve production incidents within SLA timelines.
Automate operational processes using Shell Scripting.
Perform root cause analysis for data and reporting issues.
Support deployment activities and release management processes.
Mentor junior engineers and promote engineering guidelines.
Chip in to process improvements, documentation, and knowledge-sharing initiatives.

Skills

Informatica PowerCenter/IICS

SQL & database expertise

Data Warehousing concepts & modeling

Power BI or Business Objects support

Unix/Linux Shell scripting

Production support & troubleshooting

Agile delivery

Tools

Informatica PowerCenter/IICS

Job description

Responsibilities

Data Engineering & ETL Development

Build, develop, improve, and support ETL workflows using Informatica.
Build and maintain robust data integration solutions across multiple source and target systems.
Develop and optimize batch and scheduled data processing jobs.
Ensure data quality, consistency, and integrity throughout the data lifecycle.
Analyze and resolve ETL production issues and performance bottlenecks.

Database & Data Warehousing

Build, optimize, and maintain complex SQL queries, stored procedures, and database objects.
Support data warehouse development, improvements, and maintenance activities.
Perform data analysis, reconciliation, and validation to ensure data accuracy.
Implement guidelines for data modeling and database performance optimization.

Reporting & Analytics Support

Collaborate with reporting and analytics teams to deliver reliable datasets for business consumption.
Support and maintain Power BI and Business Objects reporting environments.
Work with business collaborators to understand reporting and data requirements.
Enable self-service reporting through curated and trusted data assets.

Operations & Production Support

Monitor ETL jobs and resolve production incidents within SLA timelines.
Automate operational processes using Shell Scripting.
Perform root cause analysis for data and reporting issues.
Support deployment activities and release management processes.

Collaboration & Leadership

Work closely with business analysts, data architects, reporting teams, and application teams.
Participate in technical build discussions and code reviews.
Mentor junior engineers and promote engineering guidelines.
Chip in to process improvements, documentation, and knowledge-sharing initiatives.

Qualifications

Requirements