Data Engineer - ETL

Persistent Systems Limited; Pune District; Hybrid; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Flexible hours

Long service awards

Education sponsorship

Insurance coverage

Job summary

Persistent Systems Limited is seeking an experienced Data Engineer with strong ETL development skills to design, develop, and support scalable data platforms for enterprise reporting and analytics.

You will work across cloud and on‑prem environments, partnering with stakeholders to deliver robust data pipelines, governance, and security controls in a BFSI-focused setting.

Qualifications

• 7–10 years of experience in Data Engineering, ETL, and Data Integration projects.
• Mandatory BFSI/Insurance domain experience, with exposure to regulatory reporting.
• Experience with cloud platforms (Azure, AWS, GCP) and on‑prem environments.
• Strong SQL programming, data modeling, and data architecture understanding.

Responsibilities

• Design, develop, and maintain ETL/ELT workflows and data pipelines for enterprise apps.
• Build and support Data Lake/Warehouse platforms for reporting and analytics.
• Perform source-to-target mapping, data transformation, cleansing, and validation.
• Develop scalable cloud-based data engineering solutions using modern data integration technologies.
• Optimize ETL jobs and data pipelines for performance and reliability.
• Troubleshoot production issues related to data integration and migration.
• Support data modernization, cloud adoption, and regulatory reporting initiatives.
• Collaborate with stakeholders, architects, and cross-functional teams to deliver solutions.
• Implement data quality, governance, security, and compliance standards across platforms.
• Participate in testing, deployment, and production support activities.
• Enable enterprise-scale reporting and dashboards through reliable data engineering.
• Contribute to continuous improvement and best practices in data engineering.

Skills

ETL Development

Data Integration

SQL

Data Modeling

Data Lake/Warehouse

Cloud Platforms

BFSI Domain

Regulatory Reporting

Data Governance

Stakeholder Management

Tools

Informatica

Azure Data Factory

Databricks

SSIS

Job description

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what's next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem.

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

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