ETL Data Engineer

About Position:

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.

• Role: Data Engineer - ETL
• 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.

Benefits:

• 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
• Annual health check-ups
• 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.