Data Engineer

Job Summary

Role Overview

We are looking for an experienced Data Engineer with strong expertise in Python, ETL, Advanced SQL, CI/CD, DevOps, and Data Analytics. The ideal candidate should have hands-on experience designing and developing scalable data pipelines, transforming large datasets, and supporting data-driven applications.

Experience with Google Cloud Platform (GCP) will be an added advantage.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using Python and SQL.
• Develop complex and optimized SQL queries, stored procedures, and data transformations.
• Build and maintain reliable data integration workflows across multiple data sources.
• Perform data cleansing, validation, transformation, and quality checks.
• Analyze data and provide insights to support business and technical requirements.
• Implement and maintain CI/CD pipelines for data engineering applications.
• Work with DevOps practices and tools to automate deployments, monitoring, and infrastructure processes.
• Troubleshoot data pipeline failures, performance issues, and production incidents.
• Optimize data processing workflows for performance, scalability, and reliability.
• Collaborate with Data Analysts, Data Scientists, Developers, and other stakeholders.
• Follow best practices for version control, testing, documentation, and deployment.
• Contribute to cloud-based data engineering initiatives, preferably on GCP.

Required Skills

• 5–7 years of hands-on experience in Data Engineering.
• Strong programming skills in Python.
• Strong expertise in Advanced SQL and database concepts.
• Hands-on experience with ETL/ELT processes and data pipelines.
• Good understanding of Data Warehousing and Data Modeling concepts.
• Experience with CI/CD practices and tools.
• Strong understanding of DevOps principles, automation, and deployment processes.
• Strong data analytics and problem-solving skills.
• Experience working with large datasets and performance optimization.
• Good understanding of Git/version control and software development best practices.

Good to Have

• Hands-on experience with Google Cloud Platform (GCP).
• Exposure to GCP data services such as BigQuery, Cloud Storage, Dataflow, Composer, or Pub/Sub.
• Experience with containerization/orchestration technologies such as Docker/Kubernetes.
• Experience with workflow orchestration tools such as Airflow.
• Knowledge of cloud-based data architecture and distributed data processing.

Preferred Candidate Profile

• Strong analytical and problem-solving abilities.
• Good communication and stakeholder management skills.
• Ability to work independently as well as in a collaborative team environment.
• Strong ownership of data pipelines and production systems.
• Candidates who can join at short notice are preferred.

Mandatory Skills

 Data Engineer, Python , ETL, GCP, Advanced SQL, Strong Data Analytics skills, CICD, Devops

Shift: Second Shift (2:00 PM – 10:00 PM)

Joining: Immediate

About the Role

We are looking for an experienced Data Integration Developer with strong hands-on expertise in SQL, Python, ETL development, Snowflake, and AWS data services.

The ideal candidate should have extensive experience in designing, developing, and maintaining data integration solutions, building data warehouse architectures, and implementing scalable ETL pipelines. Strong SQL development and performance optimization skills are essential for this role.

This is a remote position; however, candidates must be available to visit our Mumbai or Bangalore location for three days during the onboarding process.

Key Responsibilities

SQL Development & Performance Optimization

• Develop complex SQL queries, stored procedures, and data transformation logic.
• Optimize SQL queries for performance, scalability, and efficiency.
• Perform advanced data analysis, validation, and reconciliation.
• Troubleshoot complex SQL and data-related issues.

ETL Development & Data Integration

• Design, develop, and maintain ETL pipelines and data integration workflows.
• Work with SQL and Python for data extraction, transformation, and loading.
• Ensure data accuracy, consistency, and integrity across systems.
• Identify and resolve data pipeline failures and integration issues.

Data Warehousing & Data Modeling

• Design and maintain data warehouse architectures.
• Develop data warehouse schemas based on business requirements.
• Work on dimensional data modeling, including Facts and Dimensions.
• Implement Slowly Changing Dimensions (SCD).
• Support data analysis and business information reconciliation.

Snowflake & AWS

• Develop and manage data solutions using Snowflake.
• Work with AWS services, particularly Amazon S3.
• Manage AWS connections and data access configurations.
• Build and maintain cloud-based data integration solutions.

Python & Apache Airflow

• Develop data processing and automation solutions using Python.
• Build, schedule, and monitor workflows using Apache Airflow.
• Troubleshoot workflow failures and improve pipeline reliability.

Agile & Development Lifecycle

• Participate in Agile development processes, sprint planning, and team discussions.
• Contribute throughout all stages of the software development lifecycle.
• Collaborate with cross-functional teams to understand business and technical requirements.
• Perform root cause analysis and implement appropriate corrective actions.

Required Skills

• Advanced SQL – Strong hands-on expertise is mandatory.
• Python Development
• ETL Development and Data Integration
• Snowflake
• Apache Airflow
• AWS Services, particularly Amazon S3
• AWS Connection Management
• Data Warehouse Architecture
• Data Modeling (Facts & Dimensions)
• Slowly Changing Dimensions (SCD)
• SQL Query Optimization and Performance Tuning
• Data Analysis and Reconciliation
• Troubleshooting and Root Cause Analysis
• Agile Development Methodologies
• Strong understanding of the Software Development Life Cycle (SDLC)

Experience & Qualifications

• 8–10 years of overall experience in Data Engineering / Data Integration / ETL Development.
• Strong professional experience in advanced SQL and Python.
• Hands-on experience with Snowflake, Apache Airflow, and AWS.
• Proven experience designing and developing data warehouse solutions.
• Experience working across the complete product development lifecycle.
• Ability to independently troubleshoot complex technical challenges.

Additional Requirements

• Immediate joiners preferred.
• Must be comfortable working in the second shift (2:00 PM – 10:00 PM).
• Position is remote, with a mandatory three-day onboarding visit to Mumbai or Bangalore.
• Strong communication, analytical, and problem-solving skills.
• Ability to work independently and collaboratively in an Agile environment.

Job Description

We are looking for an experienced ETL Developer with strong expertise in ETL development, Hadoop, PySpark, Python, and SQL. The candidate should have hands-on experience in developing data pipelines, processing and transforming large datasets, and working with data warehousing and big data technologies.

Key Responsibilities

• Design, develop, and maintain ETL processes and data pipelines.
• Work with Hadoop and PySpark to process and transform large volumes of data.
• Develop and optimize Python scripts for data processing and automation.
• Write complex SQL queries for data extraction, transformation, and validation.
• Perform data cleansing, integration, transformation, and validation.
• Work with data warehousing concepts and large-scale data processing systems.
• Optimize ETL workflows for performance, scalability, and reliability.
• Troubleshoot data pipeline failures and resolve data quality issues.
• Collaborate with data engineers, analysts, and other technical teams.
• Follow data governance, quality, and development best practices.

Required Skills

• Strong experience in ETL Development – Mandatory
• Hands-on experience with Hadoop – Mandatory
• Strong experience in PySpark – Mandatory
• Good programming skills in Python – Mandatory
• Strong knowledge of SQL – Mandatory
• Experience in Data Processing and Transformation – Mandatory
• Knowledge of Data Warehousing – Mandatory
• Experience with Big Data Technologies – Mandatory

Opportunity Details

Role: ETL Developer – Hadoop & PySpark

Experience: 6–10 Years

Location: Bangalore

Mandatory Skills

ETL Development | Hadoop | PySpark | Python | SQL | Data Processing & Transformation | Data Warehousing | Big Data Technologies

Hiring: ETL Developer – Hadoop & PySpark

Location: Bangalore

Experience: 6–10 Years

Budget: 25–30 LPA

Work Mode: Weekdays

Job Description

We are looking for an experienced ETL Developer with strong expertise in Hadoop, PySpark, Python, and SQL to design, develop, and optimize data processing and transformation solutions. The ideal candidate should have hands-on experience working with big data technologies, building scalable ETL pipelines, and managing data for data warehousing and analytics.

Key Responsibilities

• Design, develop, and maintain scalable ETL pipelines for large-scale data processing.
• Develop data transformation workflows using PySpark and Python.
• Work with Hadoop and other big data technologies to process and manage large datasets.
• Write complex SQL queries for data extraction, transformation, validation, and analysis.
• Implement data cleansing, data quality checks, and data validation processes.
• Develop and optimize data integration workflows for data warehousing solutions.
• Troubleshoot ETL failures, performance issues, and data discrepancies.
• Optimize PySpark jobs and SQL queries for performance and scalability.
• Collaborate with data engineers, architects, analysts, and other stakeholders to deliver reliable data solutions.
• Ensure data accuracy, consistency, and adherence to established data governance standards.

Mandatory Skills

• Strong hands-on experience in ETL development.
• Good experience with Hadoop and big data technologies.
• Proficiency in PySpark and Python programming.
• Strong SQL skills, including complex queries and data manipulation.
• Experience in data processing, data transformation, and data integration.
• Understanding of data warehousing concepts and architecture.
• Experience in developing, debugging, and optimizing ETL pipelines.

Required Experience

• 6–10 years of relevant experience in ETL development and data engineering.
• Practical experience handling large datasets using Hadoop and PySpark.
• Strong analytical, problem-solving, and troubleshooting skills.
• Ability to work independently and collaborate effectively within a team.

Interested candidates can share their updated resumes along with current CTC, expected CTC, notice period, and total relevant experience.

Dear Candidate,

Thanks for showing interest in the opportunity!!!

As discussed, we have an opening for ETL Developer – Hadoop & PySpark with Mphasis for the Bangalore location – Permanent.

Job Description:

We are looking for an experienced ETL Developer with strong expertise in ETL development, Hadoop, and PySpark. The candidate should have hands-on experience in data processing, building and maintaining ETL pipelines, data transformation, and handling large datasets using Big Data technologies.

Primary & Mandatory Skills:

• ETL Development
• Hadoop / HDFS
• PySpark / Apache Spark
• Data Extraction, Transformation & Loading
• SQL and Data Processing

Good to Have:

• Hive / Spark SQL
• Data Pipeline Development
• Big Data Processing
• Python Programming

Company: Mphasis

Role: ETL Developer – Hadoop & PySpark

Experience: As per requirement

Location: Bangalore

Employment Type: Permanent

Job Summary

We are seeking a highly skilled GCP Data Engineer with strong expertise in Google Cloud Platform (GCP), Python, ETL, and modern data engineering technologies. The ideal candidate should have hands-on experience designing and building scalable data pipelines using BigQuery, Dataflow, Pub/Sub, Airflow, and modern data lake technologies such as Apache Iceberg or Delta Lake.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines on Google Cloud Platform.
• Build and optimize data processing workflows using Python and Google Cloud Dataflow (Apache Beam).
• Develop and manage large-scale analytical data models in BigQuery.
• Implement event-driven data ingestion using Google Cloud Pub/Sub.
• Create, schedule, and monitor workflows using Apache Airflow and Autosys.
• Design and implement modern data lake architectures using Apache Iceberg or Delta Lake.
• Optimize query performance, storage, and compute costs in GCP.
• Ensure data quality, governance, security, and compliance across data platforms.
• Collaborate with Data Scientists, Analysts, and Application teams to deliver scalable data solutions.
• Troubleshoot production issues and continuously improve pipeline reliability and performance.

Mandatory Skills

• Strong hands-on experience with Google Cloud Platform (GCP).
• Proficiency in Python programming.
• Experience in designing and implementing ETL/ELT pipelines.
• Strong knowledge of BigQuery.
• Experience with Google Cloud Dataflow (Apache Beam).
• Experience with Google Cloud Pub/Sub.
• Hands-on experience with Apache Airflow.
• Experience in job scheduling using Autosys.
• Experience with modern table formats such as Apache Iceberg or Delta Lake.
• Strong SQL and data modeling skills.

Preferred Skills

• Experience with Cloud Storage, Dataproc, Cloud Composer, and Cloud Functions.
• Knowledge of CI/CD pipelines and DevOps practices.
• Experience with Docker and Kubernetes.
• Familiarity with Git and Agile/Scrum methodologies.
• Knowledge of data warehousing and dimensional modeling.
• Exposure to streaming and real-time data processing.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.
• 4–8+ years of experience in Data Engineering with hands-on expertise in GCP technologies.

Required Experience

• Strong experience in developing enterprise-grade data pipelines using Python and GCP.
• Hands-on experience with BigQuery, Dataflow, Pub/Sub, and Airflow.
• Experience scheduling and monitoring batch workflows using Autosys.
• Experience implementing modern data lake architectures using Apache Iceberg or Delta Lake.
• Strong understanding of ETL best practices, performance tuning, and data optimization.
• Excellent analytical, troubleshooting, and problem-solving skills.

Mandatory Skills

• Google Cloud Platform (GCP)
• Python
• ETL
• BigQuery
• Autosys
• Apache Airflow
• Google Cloud Pub/Sub
• Google Cloud Dataflow (Apache Beam)
• Apache Iceberg / Delta Lake
• SQL & Data Modeling

Job Title : Data Platform Engineer (SDE 2 / SDE 3)

Experience : 3 to 8 Years (SDE2 : 3 to 5 Years | SDE3 : 5.5 to 8 Years)

Location : Remote (Contract) → Pune (Post Conversion)

Employment Type : Contract-to-Hire (3 Months)

Mandatory Skills :

Java / Python / Go, SQL, Data Engineering, ETL / ELT, Apache Airflow, Apache Spark / Flink, Kafka, AWS/GCP/Azure, Distributed Systems, API Development, Docker, Kubernetes, CI/CD, System Design

Role Overview :

We are looking for a Data Platform Engineer with strong backend engineering expertise to build scalable, high-performance data platforms and distributed systems. The ideal candidate should have hands-on experience in developing production-grade backend applications along with designing and maintaining modern data pipelines.

Key Responsibilities :

• Build and maintain scalable ETL/ELT and data processing pipelines.
• Develop backend services and APIs using Java (preferred), Python, or Go.
• Design batch and real-time data pipelines using Spark, Flink, Kafka, and Airflow.
• Optimize SQL queries, data models, and distributed data systems.
• Work with cloud platforms (AWS, GCP, or Azure) and container technologies (Docker, Kubernetes).
• Implement CI/CD, monitoring, logging, and performance optimization.
• Collaborate with product and engineering teams on scalable system design and architecture.

Required Qualifications :

• SDE 2 : 3 to 5 years of Backend + Data Engineering experience.
• SDE 3 : 5.5 to 8 years of Backend + Data Engineering experience.
• Strong coding skills in Java (preferred), Python, or Go.
• Excellent SQL and data modeling knowledge.
• Hands-on experience with Airflow, Apache Spark / Apache Flink, or similar technologies.
• Experience building scalable backend services and APIs.
• Good understanding of distributed systems, system design. and scalable architecture.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Hands-on experience with Docker and Kubernetes.
• Strong understanding of CI/CD pipelines.
• Excellent problem-solving and debugging skills.

Good to Have :

• Experience with Snowflake, BigQuery, or Redshift.
• Understanding of Kafka, Kinesis, or Pub/Sub
• Performance optimization of large-scale distributed systems
• FinTech or high-scale distributed systems experience.
• Knowledge of data governance, security, and compliance.

Preferred Candidate Profile :

• Strong Backend + Data Engineering experience
• Experience building scalable production systems
• Strong ownership mindset
• Good system design knowledge
• Experience processing millions of events using Kafka/Spark
• Built APIs supporting data infrastructure
• Production engineering experience

Interview Process :

1. Take-home Coding Assignment (48 Hours)
2. Leadership & Strategy Round (1 Hour)
3. Technical Depth – Data Engineering & Performance (1 Hour)
4. Culture & Values Fit (30 Minutes)

Job Title : AWS Data Engineer / Data Lake Engineer

Experience : 2 to 4 Years

Location : Gurugram Sector 43

Work Mode : 5 Days WFO

Employment Type : Full-Time

About the Role :

We are looking for a skilled AWS Data Engineer with 2 to 4 years of experience in designing, developing, and maintaining data pipelines and cloud-based data platforms.

The candidate will work on an enterprise AWS Data Lake platform that collects data from multiple business systems, processes large datasets, and makes them available for analytics, reporting, and application development.

The ideal candidate should have strong hands-on experience with AWS data services, Python, PySpark, SQL, and Apache Airflow, along with an understanding of data warehousing and API-based data serving.

Mandatory skills :

AWS Data Lake, S3, EMR, Glue, Athena, Redshift, Lambda, RDS, DMS, IAM, Python, PySpark, Apache Airflow, Advanced SQL, ETL / ELT Pipelines, Data Modeling, PostgreSQL, Production Support.

Key Responsibilities :

• Develop, maintain, and optimize data ingestion and ETL / ELT pipelines on AWS.
• Work with AWS services such as S3, Glue, EMR, Athena, Redshift, Lambda, RDS, and DMS.
• Build and manage data processing workflows using Python, PySpark, and Apache Airflow.
• Implement data lake architecture with staging, curated, and consumption layers.
• Write complex SQL queries and perform data transformation, validation, and modeling.
• Work with PostgreSQL and RDS for structured data storage and consumption.
• Support API-based data access using Hasura GraphQL or similar technologies.
• Monitor production data pipelines, troubleshoot failures, and perform root cause analysis.
• Optimize Spark jobs, SQL queries, and data pipelines for performance and cost efficiency.
• Follow AWS security practices, IAM permissions, and data governance standards.
• Collaborate with application, analytics, and business teams to understand data requirements.

Mandatory Skills :

• 2 to 4 years of experience in Data Engineering, AWS Data Engineering, or Data Platform Development.
• Strong hands-on experience with AWS services : S3, Glue, EMR, Athena, Redshift, Lambda, RDS, DMS, and IAM.
• Good experience in Python and PySpark.
• Practical experience with Apache Airflow for workflow orchestration.
• Strong SQL skills and understanding of database concepts.
• Experience in building and supporting ETL / ELT pipelines.
• Understanding of Data Lake architecture, data warehousing, and data modeling.
• Working knowledge of PostgreSQL or similar relational databases.
• Experience handling production pipeline issues and troubleshooting.

Good to Have :

• Experience with Hasura GraphQL or any GraphQL-based API / data-serving platform.
• Knowledge of DBT (Data Build Tool).
• Understanding of Lakehouse architecture and table formats such as Apache Iceberg or Delta Lake.
• Experience with Kafka or other streaming data technologies.
• Knowledge of Amazon Redshift performance optimization, distribution keys, and sort keys.
• Experience with AWS Aurora and API Gateway.
• BFSI, Banking, or Insurance domain experience.

Ideal Candidate Profile :

• Strong hands-on technical and problem-solving skills.
• Experience working on real-time or batch-based production data pipelines.
• Good understanding of data processing, transformation, and storage concepts.
• Ability to troubleshoot technical issues and work independently.
• Good communication and collaboration skills.

Note : Candidates with strong practical experience in AWS Data Lake, PySpark, Airflow, Python, and SQL will be preferred. Real-world project experience is more important than theoretical knowledge or certifications.

Job Summary

We are looking for a skilled and experienced Data Engineer to join our growing data team. The ideal candidate will have strong expertise in Python, PySpark, Data Modeling, and Power BI, with hands-on experience in designing, developing, and optimizing scalable data solutions. The role requires working closely with business stakeholders, data architects, and analytics teams to build robust data pipelines and semantic models that enable data-driven decision-making.

Technical Skills

• Strong hands-on experience in Python and PySpark development.
• Expertise in building and optimizing Data Engineering solutions and ETL pipelines.
• Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Dimensional Modeling).
• Experience with Power BI Data Modeling and Semantic Layer development.
• Proficiency in DAX (Data Analysis Expressions).
• Experience designing and managing Semantic Models in Power BI.
• Strong SQL skills and experience working with large datasets.
• Knowledge of data warehousing concepts and best practices.

Preferred Skills

• Experience with cloud platforms such as Azure, AWS, or GCP.
• Exposure to modern data platforms like Databricks.
• Understanding of data governance and data quality frameworks.

Job Title : AWS Data Engineer

Experience : 4+ Years

Location : Bengaluru (HSR – Hybrid, 3 Days WFO)

Notice Period : Immediate Joiner

💡 Role Overview :

We are looking for a skilled AWS Data Engineer to design, build, and scale modern data platforms. The role involves working with AWS-native services, Python, Spark, and DBT to deliver secure, scalable, and high-performance data solutions in an Agile environment.

🔥 Mandatory Skills :

Python, SQL, Spark, AWS (S3, Glue, EMR, Redshift, Athena, Lambda), DBT, ETL/ELT pipeline development, Airflow/Step Functions, Data Lake (Parquet/ORC/Iceberg), Terraform & CI/CD, Data Governance & Security

🚀 Key Responsibilities :

• Design, build, and optimize ETL/ELT pipelines using Python, DBT, and AWS services
• Develop and manage scalable data lakes on S3 using formats like Parquet, ORC, and Iceberg
• Build end-to-end data solutions using Glue, EMR, Lambda, Redshift, and Athena
• Implement data governance, security, and metadata management using Glue Data Catalog, Lake Formation, IAM, and KMS
• Orchestrate workflows using Airflow, Step Functions, or AWS-native tools
• Ensure reliability and automation via CloudWatch, CloudTrail, CodePipeline, and Terraform
• Collaborate with data analysts and data scientists to deliver actionable insights
• Work in an Agile environment to deliver high-quality data solutions

✅ Mandatory Skills :

• Strong Python (including AWS SDKs), SQL, Spark
• Hands-on experience with AWS data stack (S3, Glue, EMR, Redshift, Athena, Lambda)
• Experience with DBT and ETL/ELT pipeline development
• Workflow orchestration using Airflow / Step Functions
• Knowledge of data lake formats (Parquet, ORC, Iceberg)
• Exposure to DevOps practices (Terraform, CI/CD)
• Strong understanding of data governance and security best practices
• Minimum 4–7 years in Data Engineering (3+ years on AWS)

➕ Good to Have :

• Understanding of Data Mesh architecture
• Experience with platforms like Data.World
• Exposure to Hadoop / HDFS ecosystems

🤝 What We’re Looking For :

• Strong problem-solving and analytical skills
• Ability to work in a collaborative, cross-functional environment
• Good communication and stakeholder management skills
• Self-driven and adaptable to fast-paced environments

📝 Interview Process :

1. Online Assessment
2. Technical Interview
3. Fitment Round
4. Client Round