Data Engineer

Persistent Systems; Bengaluru; Hybrid; INR 900,000 - 1,800,000; Full time

Benefits offered by this job

Hybrid work model

Professional development support

Medical insurance

Annual performance bonus

Flexible working hours

Job summary

Persistent Systems is seeking a skilled Data Engineer to design and build scalable data solutions. You will work on SQL-driven data pipelines, cloud data platforms, and data architecture that enable data-driven decisions across the organization.

The role requires 2–5 years of experience, hands-on with cloud warehouses like Snowflake, Redshift, and BigQuery, and proficiency in ETL/ELT tooling such as Airflow, ADF, AWS Glue, or Databricks. Collaborative and security-focused work culture awaits.

Qualifications

• 2–5 years of experience in data engineering or related field.
• Strong SQL including complex queries and optimization.
• Experience with cloud data warehouses (Snowflake, Redshift, BigQuery, Azure SQL).
• Experience building scalable data pipelines and ETL/ELT workflows.

Responsibilities

• Design, develop and optimize SQL queries, stored procedures, CTEs, and database objects.
• Tune queries, analyze execution plans, index and partition for performance.
• Build and maintain scalable data pipelines for ingestion and analytics.
• Design modern data architectures across ingestion, storage, processing, and compute layers.
• Develop and manage cloud data solutions across AWS, Azure, GCP.
• Integrate structured, semi-structured, unstructured data sources.
• Create and maintain ETL/ELT workflows with Airflow, ADF, AWS Glue, Databricks.
• Ensure data quality, governance, security and lineage.

Skills

SQL proficiency

Cloud data platforms

Data architecture

Data integration

Python

ETL/ELT pipelines

Data governance

Mentoring

Tools

Airflow

Azure Data Factory

AWS Glue

Databricks

Snowflake

BigQuery

Redshift

Job description

We are looking for a highly skilled Data Engineer with expertise in SQL, Cloud Data Platforms, Data Architecture, and Data Integration to design and build scalable, secure, and high-performance data solutions. The ideal candidate will be responsible for developing modern data architectures, building reliable data pipelines, optimizing data platforms, and enabling data-driven decision-making across the organization.

• Experience: 2 to 5 Years
• Job Type: Full-Time Employment

What You'll Do:

• Design, develop, and optimize complex SQL queries, stored procedures, CTEs, window functions, and database objects.
• Perform query tuning, execution plan analysis, indexing, and partitioning to improve database performance and scalability.
• Build and maintain scalable data pipelines for data ingestion, transformation, and analytics workloads.
• Design and implement modern data architectures covering ingestion, storage, processing, and compute layers.
• Work with cloud-based data warehouses including Snowflake, BigQuery, Redshift, and Azure SQL.
• Develop and manage cloud-native data solutions across AWS, Azure, and GCP platforms.
• Integrate data from multiple structured, semi-structured, and unstructured data sources.
• Develop and maintain ETL/ELT workflows using tools such as Airflow, Azure Data Factory (ADF), AWS Glue, Databricks, or similar platforms.
• Automate data processes to improve reliability, scalability, operational efficiency, and reduce manual intervention.
• Ensure data quality, governance, security, compliance, and data lineage standards are maintained across the data ecosystem.
• Collaborate with Data Analysts, Data Scientists, Product Managers, and Business Teams to understand business requirements.
• Translate business requirements into scalable and maintainable data engineering solutions.
• Monitor, troubleshoot, and optimize data pipelines, workflows, database performance, and platform health.
• Participate in architecture reviews and contribute to data platform modernization initiatives.
• Mentor junior data engineers and promote engineering best practices, coding standards, and technical excellence.
• Create technical documentation, architecture diagrams, operational runbooks, and deployment guides.

Expertise You'll Bring:

• 2to5 years of experience in Data Engineering, Data Warehousing, or related fields.
• Advanced expertise in SQL including complex query writing, stored procedures, CTEs, window functions, and query optimization.
• Strong experience in database performance tuning, execution plan analysis, indexing strategies, and partitioning.
• Handson experience with relational databases and cloud data warehouses such as Snowflake, BigQuery, Amazon Redshift, and Azure SQL
• Experience designing and implementing scalable data architectures and modern data platforms.
• Strong knowledge of AWS, Azure, and GCP cloud services for data engineering workloads.
• Experience building and managing ETL/ELT pipelines and enterprise data integration solutions.
• Handson experience with workflow orchestration tools such as Apache Airflow, Azure Data Factory (ADF), AWS Glue, Databricks, or similar platforms.
• Experience integrating structured, semi-structured, and unstructured data sources.
• Strong understanding of data modeling, data warehousing concepts, and analytics platforms.
• Proficiency in Python, SQL, or other data engineering programming languages.
• Knowledge of data governance, security, compliance, and data quality best practices.
• Experience working with large-scale data processing and analytics environments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Experience mentoring junior engineers and leading technical best practices.
• Ability to collaborate effectively with business and technical stakeholders in Agile delivery environments.
• 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 accessibilityfriendly, 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.”