ETL Data Engineer

Persistent Systems; Pune District; Hybrid; INR 1,500,000 - 2,500,000; Full time

Benefits offered by this job

Hybrid work

Flexible hours

Long Service awards

Insurance coverage: group term life,个人

Education sponsorship and certs

Job summary

Persistent Systems seeks an experienced Data Engineer to design, develop, and support scalable ETL/ELT pipelines powering enterprise analytics across cloud and on‑prem environments. The role requires BFSI/Insurance domain experience for regulatory reporting and data modernization, with collaboration across stakeholders to deliver robust data platforms and governance.

You will optimize pipelines, ensure data quality, and contribute to modernization initiatives while enjoying a culture focused on

Qualifications

• 7–10 years of Data Engineering, ETL Development, and data integration experience.
• Mandatory BFSI/Insurance domain experience for regulatory reporting and data platforms.
• Strong SQL, data modeling, and database design skills.
• Hands-on with cloud data platforms (Azure/AWS/GCP) and modern ETL tools.
• Experience with data governance, security, and compliance requirements.

Responsibilities

• Design, develop, and maintain ETL/ELT workflows and data pipelines.
• Build and support Data Lake and Data Warehouse platforms for analytics.
• Source-to-target mapping, data transformation, cleansing, and validation.
• Develop cloud-based data engineering solutions and optimize pipelines.
• Troubleshoot production data integration issues and support migrations.
• Collaborate with stakeholders to gather requirements and deliver solutions.
• Enforce data quality, governance, and security standards across platforms.
• Participate in testing, deployment, and production support activities.

Skills

ETL development

Data integration

SQL

Data modeling

Stakeholder mgmt

Cloud platforms

CI/CD

Data governance

Regression testing

Regulatory reporting

Education

Bachelor's degree in CS/Eng or related field

Tools

Informatica

Azure Data Factory

Databricks

SSIS

SQL databases

Job description

We are seeking an experienced Data Engineer with strong expertise in ETL development and enterprise data engineering. The ideal candidate will be responsible for designing, developing, and supporting scalable data integration and transformation solutions that power critical business operations. This role requires mandatory BFSI/Insurance domain experience to support regulatory reporting, data modernization programs, and enterprise-scale analytics initiatives. The candidate will work closely with business stakeholders, architects, and cross-functional teams to build robust, secure, and high-performing data platforms across cloud and on-premises environments.

• Location: All Persistent Locations
• Experience: 7 to 10 Years
• Job Type: Full-Time Employment

What You'll Do:

• Design, develop, and maintain ETL/ELT workflows, data pipelines, and integration solutions for enterprise applications.
• Build, enhance, and support Data Lake and Data Warehouse platforms to enable reporting, analytics, and business intelligence initiatives.
• Perform source-to-target mapping, data transformation, cleansing, and validation to ensure data accuracy and consistency.
• Develop scalable cloud-based data engineering solutions using modern data integration technologies.
• Optimize ETL jobs, data processing workflows, and database performance to improve efficiency and reliability.
• Troubleshoot and resolve production issues related to data integration, transformation, and pipeline execution.
• Support enterprise data migration, modernization, and cloud adoption initiatives.
• Collaborate with business users, data analysts, architects, and development teams to gather requirements and deliver solutions.
• Implement and maintain data quality, governance, security, and compliance standards across data platforms.
• Participate in testing, deployment, release management, and production support activities.
• Enable enterprise-scale reporting, dashboarding, and advanced analytics capabilities through reliable data engineering solutions.
• Contribute to continuous improvement initiatives and adoption of best practices in data engineering and ETL development.

Expertise You'll Bring:

• 7 to 10 years of experience in Data Engineering, ETL Development, and Data Integration projects.
• Strong hands-on experience with ETL tools such as Informatica, Azure Data Factory (ADF), Databricks, SSIS, or similar technologies.
• Excellent SQL programming skills with strong experience in database design, development, and query optimization.
• Experience working with databases such as Snowflake, SQL Server, Oracle, PostgreSQL, BigQuery, or equivalent platforms.
• Strong understanding of Data Lake, Data Warehouse, Data Modeling, and data architecture concepts.
• Experience with cloud platforms including Microsoft Azure, AWS, or Google Cloud Platform (GCP).
• Solid understanding of OLTP systems, dimensional modeling, and enterprise data management principles.
• Experience with source control, CI/CD pipelines, Git, and DevOps practices.
• Knowledge of data governance, security frameworks, and regulatory compliance requirements.
• Strong analytical, troubleshooting, and problem-solving abilities.
• Excellent communication and stakeholder management skills with the ability to work in cross-functional teams.
• Mandatory experience in the BFSI or Insurance domain, with exposure to regulatory reporting and enterprise data platforms.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Let's unleash your full potential at Persistent - persistent.com/careers

"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."