Sr. Data Engineer DataBricks at Exponentia.ai · Mumbai · 4 - 6 years · ₹12L - ₹19L / yr · Bootstrapped · Posted 18 Jul 2023

Job DescriptionPosition: Sr Data Engineer – Databricks & AWS
Experience: 4 - 5 Years
Company Profile:
Exponentia.ai is an AI tech organization with a presence across India, Singapore, the Middle East, and the UK. We are an innovative and disruptive organization, working on cutting-edge technology to help our clients transform into the enterprises of the future. We provide artificial intelligence-based products/platforms capable of automated cognitive decision-making to improve productivity, quality, and economics of the underlying business processes. Currently, we are transforming ourselves and rapidly expanding our business.
Exponentia.ai has developed long-term relationships with world-class clients such as PayPal, PayU, SBI Group, HDFC Life, Kotak Securities, Wockhardt and Adani Group amongst others.
One of the top partners of Cloudera (leading analytics player) and Qlik (leader in BI technologies), Exponentia.ai has recently been awarded the ‘Innovation Partner Award’ by Qlik in 2017.
Get to know more about us on our website: http://www.exponentia.ai/ and Life @Exponentia.
Role Overview:
· A Data Engineer understands the client requirements and develops and delivers the data engineering solutions as per the scope.
· The role requires good skills in the development of solutions using various services required for data architecture on Databricks Delta Lake, streaming, AWS, ETL Development, and data modeling.
Job Responsibilities
• Design of data solutions on Databricks including delta lake, data warehouse, data marts and other data solutions to support the analytics needs of the organization.
• Apply best practices during design in data modeling (logical, physical) and ETL pipelines (streaming and batch) using cloud-based services.
• Design, develop and manage the pipelining (collection, storage, access), data engineering (data quality, ETL, Data Modelling) and understanding (documentation, exploration) of the data.
• Interact with stakeholders regarding data landscape understanding, conducting discovery exercises, developing proof of concepts and demonstrating it to stakeholders.
Technical Skills
• Has more than 2 Years of experience in developing data lakes, and datamarts on the Databricks platform.
• Proven skill sets in AWS Data Lake services such as - AWS Glue, S3, Lambda, SNS, IAM, and skills in Spark, Python, and SQL.
• Experience in Pentaho
• Good understanding of developing a data warehouse, data marts etc.
• Has a good understanding of system architectures, and design patterns and should be able to design and develop applications using these principles.
Personality Traits
• Good collaboration and communication skills
• Excellent problem-solving skills to be able to structure the right analytical solutions.
• Strong sense of teamwork, ownership, and accountability
• Analytical and conceptual thinking
• Ability to work in a fast-paced environment with tight schedules.
• Good presentation skills with the ability to convey complex ideas to peers and management.
Education:
BE / ME / MS/MCA.

About Exponentia.ai
About
Data is the new Oil and AI is the most powerful value accelerator today - this is one of the most important belief we live by. We are an award-winning AI-Tech MNC transforming businesses through AI, ML and Data Analytics Solutions.
We help organizations solve complex business challenges by combining industry experience, data and AI first engineering practices, and our propriety technology solutions to achieve business outcomes at scale.
Our propriety solutions include - OneTAP for Voice Analytics, Intelligent Nudges, Customer Intelligence Platform and Engagely.ai and we specialise in Data (ML, BI, Cloud, DWH & Data Lakes) and AI Solutions (NLP, Conversational Analytics).
Exponentia.ai was founded in the year 2014 and is headquartered in Mumbai, India. We have expanded our services to the UK, Singapore and US. We’ve been honored with the Innovation Award by Qlik & Excellence in Business Process Automation by Automation Anywhere.
Visit our website- www.exponentia.ai to learn more about our products and services.
Tech stack
Product showcase
Connect with the team
Similar jobs (10)
Job Title : Senior Data Engineer – Databricks
Experience : 14 to 20 Years
Location : HSR Layout, Bangalore
Work Mode : Hybrid – 3 Days WFO
Shift : 11:30 AM – 07:30 PM IST
Positions : 2
Notice Period : Immediate Joiners Only
Interview : 1 Technical Round + 2 Client Rounds
Role Overview :
We are looking for a Senior Data Engineer to build and lead enterprise-scale data platforms for a Switzerland-based commodity client.
The role requires a strong hands-on Data Engineering professional with expertise in Databricks, PySpark, Python, SQL, and AWS, along with technical leadership and stakeholder management experience.
Must-Have Skills :
- 14 to 20 years of Data Engineering experience
- Databricks & Apache Spark / PySpark
- Python & SQL
- AWS Cloud
- Lakehouse Architecture
- ETL / ELT & Distributed Data Processing
- Batch & Streaming Pipelines
- Data Pipeline Optimization & Data Modeling
- CDC & Incremental Processing
- Git, CI/CD & Testing
- Data Quality, Monitoring & Observability
- Technical Leadership & Stakeholder Management
Key Responsibilities :
- Design and build scalable data pipelines using Databricks, PySpark, Python, SQL, and AWS.
- Own data products from design through production.
- Develop batch / streaming pipelines and reusable ETL / ELT frameworks.
- Optimize pipelines for performance, scalability, reliability, and cost.
- Design scalable data architectures and data models.
- Implement data quality, monitoring, lineage, and CI/CD practices.
- Lead technical discussions and mentor engineering teams.
- Collaborate with business stakeholders, architects, product owners, and engineering teams.
- Remain hands-on while providing technical leadership.
Ideal Candidate :
A 14 to 20 years experienced, hands-on Data Engineering leader with strong Databricks + PySpark + AWS expertise, excellent communication, stakeholder management, and experience delivering enterprise-scale data platforms.
🔴 Super Urgent : Only Bangalore-based immediate joiners.
SENIOR DATA ENGINEER – DATABRICKS & SNOWFLAKE
Experience: 7+ Years
Location: Remote
Employment Type: Full-Time
Budget: Up to ₹30 LPA
Time Zone: US Eastern Time (ET)
Shift: US ET Night Shift
Job Description
We are looking for an experienced Senior Data Engineer with strong expertise in Databricks, Snowflake, Apache Spark, and AWS to design, develop, and maintain scalable data engineering solutions.
The candidate will work on integrating data from multiple sources, building modern data pipelines, developing enterprise data models, and preparing data platforms for AI/ML applications.
Experience in healthcare, scientific data, or the histopathology domain will be an added advantage.
Key Responsibilities
- Design, build, and maintain scalable data pipelines to acquire, integrate, and manage data from diverse sources such as laboratory systems, MES, clinical supply, quality systems, and external partners.
- Develop and optimize data workflows for structured and unstructured data using Python, PySpark, R, SQL, Databricks, and Snowflake.
- Design and maintain enterprise-level data models and data repositories.
- Perform ETL development, data warehousing, database design, and data integration.
- Ensure data quality, versioning, traceability, and consistency to support AI/ML readiness.
- Collaborate with stakeholders and technical teams to translate business requirements into technical solutions.
- Manage multiple projects while ensuring scalability, performance, and reliability.
Required Skills
- 7+ years of experience in Data Engineering.
- Strong hands-on experience with Databricks and Snowflake.
- Excellent knowledge of Apache Spark / PySpark.
- Strong experience with AWS cloud services and AWS RDS.
- Experience with Oracle and Microsoft SQL Server (MSSQL).
- Proficiency in Python, R, and SQL.
- Strong understanding of ETL, Data Warehousing (DWH), data modeling, and database design.
- Experience with dbt and cloud-based data architectures.
- Knowledge of NoSQL and graph databases.
- Strong analytical, problem-solving, and stakeholder-management skills.
- Good English communication skills (B2 level or above).
- Willingness to work in the US Eastern Time (ET) night shift.
Preferred / Good to Have
- Experience in histopathology, healthcare, life sciences, or scientific data environments.
- Knowledge of CDISC, HL7, FHIR, OMOP, DICOM, or other regulated data standards.
- Experience handling high-dimensional data, including imaging and sensor data.
- Familiarity with MLOps and machine learning model deployment workflows.
- Knowledge of Manufacturing Execution Systems (MES) and Laboratory Information Management Systems (LIMS).
- Exposure to knowledge graphs and ontology-driven architectures.
Education
Bachelor's degree in Engineering, Data Science, Life Sciences, Computer Science, or a related field. A master's degree is preferred.
Interested candidates can apply with their updated resumes.
Job Description:
We are seeking a skilled Senior Data Engineer with expertise in Databricks to join our dynamic data team. The ideal candidate will design, build, and maintain scalable data pipelines and architectures to support our organization's data-driven initiatives and leverage Databricks to process large-scale datasets, optimize data workflows, enable advanced analytics and machine learning, and integrate Power BI for data visualization and reporting.
Key Responsibilities
· 5-8 years of professional work experience in a relevant field
· Proficient in Microsoft Fabric platform, Azure Databricks, ADF, Delta Lake, SQL Data Warehouse, Unity Catalog.
· Good Experience on Microsoft Dynamics 365
· Experience/ prior knowledge on semi structure data and Structured Streaming, Azure synapse, data lake, data warehouse.
· Proficient in creating Azure Data Factory pipelines for ETL/ELT processing; copy activity, custom Azure development etc.
· Good knowledge of SQL and Python for data manipulation, transformation, and analysis
· Understand business requirements to set functional specifications for reporting applications
- Data Pipeline Development: Design, develop, and maintain robust, scalable data pipelines using Databricks, Apache Spark, and other cloud-based technologies.
- Data Integration: Ingest, transform, and integrate data from diverse sources, including APIs, databases, streaming platforms, and third-party systems, into Databricks for analytics and reporting.
- Power BI Integration: Develop and optimize data models and datasets in Databricks for use in Power BI, ensuring efficient data connections and high-quality visualizations.
- Performance Optimization: Optimize data workflows, API calls, and queries on Databricks and Power BI for performance, cost-efficiency, and scalability.
- Data Modeling: Build and maintain data models to support business requirements, ensuring data quality, consistency, and accessibility for analytics and reporting.
- Cloud Integration: Implement data solutions on cloud platforms (e.g., AWS, Azure, GCP) integrated with Databricks, Power BI, and API ecosystems.
- Security & Compliance: Implement data governance, security, and compliance best practices within Databricks, Power BI, and API environments.
- Technical Skills:
- Proficiency in Databricks, including Delta Lake, Spark SQL.
- Strong programming skills in Python, Scala, or Java.
- Experience with Apache Spark for big data processing.
- Knowledge of SQL for querying and transforming data.
- Proficiency in Power BI for creating data models, DAX queries, and interactive dashboards.
Preferred Qualifications
- Databricks certification (e.g., Databricks Certified Data Engineer Associate/Professional).
Experience with real-time data processing and streaming
Company: Wissen Technology
Position: Databricks Engineer
Experience: 6-10 Years
Location: Bengaluru/Mumbai
Employment Type: Full-time
About Wissen Technology
Wissen Technology is a global technology services company focused on delivering innovative software engineering, data, and technology solutions to leading enterprises. The company works with clients across industries to build scalable, high-performance technology platforms and solve complex business and technology challenges.
With a strong focus on engineering excellence, innovation, and collaboration, Wissen Technology brings together skilled technology professionals across areas such as software engineering, data engineering, cloud, analytics, and digital transformation.
At Wissen Technology, employees have the opportunity to work on challenging technology projects, collaborate with experienced engineering teams, and contribute to solutions that create measurable business impact.
Key Responsibilities
- Design, develop, and maintain scalable data processing applications using Python, PySpark, and Spark.
- Develop and optimize data pipelines and workflows on Databricks.
- Collaborate with data engineers, data scientists, business stakeholders, and other technical teams to understand requirements and deliver high-quality solutions.
- Ensure data integrity, quality, performance, and reliability across data processing pipelines.
- Write clean, maintainable, scalable, and efficient code following established coding standards and best practices.
- Perform data analysis and implement appropriate data validation and quality checks.
- Monitor, troubleshoot, and optimize performance issues across data workflows and pipelines.
- Work with relational databases and develop efficient SQL queries for data extraction and transformation.
- Participate in code reviews, testing, deployment, and continuous improvement of data engineering solutions.
- Use Git/version control and follow established software development and deployment practices.
Required Skills & Qualifications
- Bachelor’s or Master’s degree in Computer Science, Engineering, Information Technology, or a related field.
- Proven experience as a Databricks Developer, Data Engineer, or similar role.
- Strong hands-on expertise in Apache Spark and PySpark.
- Strong programming skills in Python; experience with Scala is an advantage.
- Strong proficiency in SQL and hands-on experience with relational databases.
- Practical experience developing and optimizing data pipelines and data processing applications.
- Familiarity with Git and version control systems.
- Strong understanding of data engineering concepts, data transformation, and data validation.
- Excellent analytical and problem-solving skills.
- Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams.
🚀 Job Title : Data Engineer – AWS, PySpark & Airflow
Experience : 5+ Years
Industry : Health Insurance / BFSI
Location : Sector 43, Gurugram, Haryana
Work Mode : Work From Office (5 Days a Week)
Employment Type : Full-Time
Role Overview :
We are looking for an experienced Data Engineer with strong hands-on expertise in AWS Data Engineering, Data Lake Architecture, Python, SQL, PySpark, and Apache Airflow.
The candidate will be responsible for designing, developing, and maintaining scalable, reliable, and high-performance data pipelines using AWS cloud technologies. The role involves building end-to-end ETL / ELT workflows, implementing data transformation and processing solutions, optimizing pipeline performance, and ensuring the reliability of production data systems.
Mandatory Skills :
AWS Data Engineering | Data Lake Architecture | Amazon S3 | AWS Glue | Amazon EMR | Athena | Redshift | Python | SQL | PySpark | Apache Spark | Apache Airflow | ETL/ELT | PostgreSQL | Data Modelling | Pipeline Optimization | Production Support | Root Cause Analysis
Key Responsibilities :
- Design, develop, and maintain end-to-end data pipelines for data ingestion, staging, transformation, curation, and consumption.
- Build and manage AWS-based data lake solutions using Amazon S3, AWS Glue, Amazon EMR, Athena, and Redshift.
- Develop, maintain, and optimize ETL / ELT pipelines using Python, SQL, Apache Spark, and PySpark.
- Implement and manage workflow orchestration using Apache Airflow, including scheduling, dependency management, retries, monitoring, and failure handling.
- Integrate data from multiple structured and semi-structured sources.
- Design and maintain data models, dimensional models, and analytical data marts.
- Work with relational databases, including PostgreSQL and Amazon RDS.
- Optimize Spark jobs, SQL queries, data transformations, and cloud resource utilization.
- Implement data quality checks, validation rules, and error-handling mechanisms.
- Monitor production data pipelines, troubleshoot failures, and perform root cause analysis (RCA).
- Ensure pipeline reliability, scalability, performance, and compliance with service-level agreements (SLAs).
- Follow data security, access management, governance, and sensitive-data protection best practices.
- Collaborate with business, analytics, and application teams to deliver effective data solutions.
- Maintain technical documentation and follow established data engineering standards.
Required Technical Skills :
- AWS Data Engineering : Strong hands-on experience with AWS-based data engineering and data lake architecture.
- AWS Services : Amazon S3, AWS Glue, Glue Data Catalog, Amazon EMR, Athena, Redshift, AWS Lambda, and IAM.
- Programming : Strong proficiency in Python and SQL.
- Big Data Processing : Hands-on experience with Apache Spark and PySpark.
- Workflow Orchestration : Experience developing and managing workflows using Apache Airflow.
- ETL/ELT Development : Experience building scalable data ingestion, transformation, and processing pipelines.
- Database Technologies : Good understanding of relational databases and PostgreSQL concepts.
- Data Modelling : Experience with data modelling, data transformation, and analytical data structures.
- Production Support : Ability to monitor pipelines, troubleshoot failures, perform RCA, and resolve production issues.
- Performance Optimization : Experience optimizing SQL queries, Spark jobs, and data processing workflows.
Good-to-Have Skills :
- Experience with AWS Database Migration Service (DMS) and Amazon RDS.
- Familiarity with dbt for data transformation and modelling.
- Knowledge of Delta Lake, Apache Iceberg, or Apache Hudi.
- Exposure to Apache Kafka and real-time data streaming.
- Familiarity with GraphQL, Hasura, or similar data-serving technologies.
- Understanding of data governance and data quality frameworks.
- Experience in the BFSI, healthcare, or health insurance domain.
Candidate Requirements :
- 5+ years of relevant experience in Data Engineering.
- Proven hands-on experience building and maintaining production-grade data pipelines on AWS.
- Strong understanding of data lake architecture and large-scale data processing.
- Practical experience with Apache Airflow and Spark / PySpark-based transformations.
- Strong programming, analytical, debugging, and problem-solving skills.
- Experience handling production incidents, pipeline failures, and performance bottlenecks.
- Ability to take ownership of deliverables and work effectively with cross-functional teams.
- Good communication, collaboration, and technical documentation skills.
- Willingness to work from the Gurugram office five days a week.
Ideal Candidate :
The ideal candidate is a hands-on Data Engineer who can independently build, optimize, and maintain AWS-based data pipelines, work with large datasets using PySpark, orchestrate workflows through Airflow, and resolve production issues in a business-critical environment.
Technical Stack
- PySpark
- Databricks
- Microsoft Azure
- SQL
- Kubernetes
Key Responsibilities & Expectations
- Must be self-driven, proactive, and capable of independently delivering high-quality solutions.
- Demonstrate strong ownership and accountability for assigned tasks and deliverables.
- Ability to work with minimal supervision while consistently meeting project objectives and quality standards.
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.
About the Role
We are looking for a Senior Data Engineer with strong hands-on expertise in Databricks, Python, PySpark, and SQL to build scalable, high-performance data engineering solutions. You’ll architect and develop large scale, high-performance data pipelines capable of handling massive real-time and batch data volumes across multiple business systems. Databricks is the core enterprise data and processing platform for this role. You will also use Apache Airflow for workflow orchestration and dbt for ELT transformations, and will contribute to designing reliable, secure, and governed data platforms that enable analytics, reporting, and AI-driven use cases.
Key Responsibilities
- Design and implement large-scale data pipelines using Python/PySpark, Databricks, and Microsoft Fabric.
- Develop and optimize data processing workloads in Databricks using PySpark and Spark SQL, with a strong focus on scalability, reliability, performance, and maintainability.
- Develop and maintain dbt models including layered architecture, incremental models, snapshots, macros, testing, and documentation.
- Design, develop, and maintain Apache Airflow DAGs for orchestrating reliable, scalable, and observable data pipelines.
- Design and implement data quality, observability, and governance frameworks, including automated testing, monitoring, lineage, access control, and data privacy standards.
- Partner with analytics, product, and business stakeholders to turn requirements into trustworthy datasets, and raise the engineering bar through design discussions, code reviews, and mentoring junior engineers.
Required Skills
- Strong expertise in Python for developing scalable, modular, and production-ready data engineering applications.
- Strong expertise in PySpark, including DataFrame API, Spark SQL, Structured Streaming, partitioning strategies, joins, caching, handling data skew, and Spark performance optimization.
- Strong hands-on experience with Databricks for data ingestion, transformation, processing, and optimization, including Delta Lake, Unity Catalog, Databricks Workflows, notebooks, jobs, and Databricks-native data engineering capabilities.
- Strong experience in Databricks/Spark performance tuning, including query and job optimization, partitioning, file sizing, caching, join optimization, handling data skew, and efficient use of compute resources.
- Hands-on experience with Delta Lake, including transactional data processing, schema management, incremental data processing, and reliable batch and streaming data pipelines.
- Hands-on experience in developing dbt projects using layered architecture, incremental models, snapshots, macros/Jinja, testing, documentation, and deployment best practices.
- Expertise in advanced SQL and data modelling — dimensional modeling, slowly changing dimensions, schema evolution, and query optimization.
- Hands-on experience in developing and managing Apache Airflow DAGs, scheduling workflows, dependency management, retries, backfills, and operational monitoring.
- Hands-on experience with at least one major cloud platform (AWS, Azure or GCP).
- Strong problem-solving skills and the ability to work independently with business and analytics stakeholders.
Nice to Have
- Hands-on exposure to Microsoft Fabric for data integration and analytics.
- Experience using AI coding assistants (e.g. Claude Code, GitHub Copilot) as part of a development workflow.
- Familiarity with modern DevOps practices, including CI/CD pipelines, Infrastructure as Code (IaC), and containerization (Docker/Kubernetes).
- Domain expertise in financial services.
Job Title : Senior AWS Data Engineer – Data Lake Platform
Experience : 5+ Years
Location: Gurugram Sector 43, Haryana
Work Mode : Work From Office (5 Days a Week – Monday to Friday)
Open Positions : 8+
About the Role :
We are looking for a skilled Senior AWS Data Engineer with strong hands-on experience in building, managing, and optimizing enterprise-scale data lake platforms on AWS.
The ideal candidate will have expertise in AWS data services, PySpark, Apache Airflow, and large-scale data pipeline development. The role involves designing end-to-end data ingestion and processing workflows, maintaining data quality, optimizing platform performance, and supporting analytics and downstream data consumption requirements.
Mandatory skills :
AWS Data Lake, Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, IAM, PySpark, Apache Spark, Apache Airflow, Python, Advanced SQL, Data Modeling, Production Data Pipelines, Hasura/GraphQL, PostgreSQL, and Production Support.
Key Responsibilities :
- Design, develop, and maintain scalable AWS-based data lake platforms and end-to-end data pipelines.
- Build data ingestion, staging, transformation, curated, and consumption layers using AWS services.
- Develop and optimize data processing pipelines using PySpark, Apache Spark, and AWS EMR.
- Implement workflow orchestration and scheduling using Apache Airflow.
- Work with Amazon S3, AWS Glue, Glue Data Catalog, Amazon Athena, and Amazon Redshift for data storage, cataloging, processing, and analytics.
- Develop efficient SQL queries and implement data modeling strategies for enterprise reporting and analytics.
- Build and support data-serving solutions using Amazon RDS, AWS Lambda, API Gateway, and PostgreSQL-based platforms.
- Monitor pipeline performance, troubleshoot production issues, perform root-cause analysis, and ensure data pipeline SLAs.
- Implement data security, access controls, PII protection, and governance best practices across the platform.
- Optimize data processing performance, query execution, storage utilization, and AWS infrastructure costs.
- Collaborate with application, analytics, and business teams to deliver reliable and scalable data solutions.
Mandatory Skills :
- AWS Data Services : Amazon S3, EMR, Glue, Athena, Redshift, DMS, Lambda, RDS, and IAM.
- Data Engineering : Strong hands-on experience building and maintaining enterprise data lake platforms.
- Programming : Python, PySpark, and Apache Spark.
- Orchestration : Production experience with Apache Airflow.
- Database & SQL : Advanced SQL, data modeling, and query optimization.
- Data Architecture : Experience with data ingestion, staging, transformation, curated layers, and consumption architecture.
- Production Support : Pipeline monitoring, troubleshooting, root-cause analysis, and SLA management.
- API / Data Serving : Experience with Hasura or a similar GraphQL-based data-serving layer integrated with PostgreSQL.
- Platform Ownership : Ability to independently manage data pipelines, improve platform reliability, and collaborate with cross-functional teams.
Good-to-Have Skills :
- Experience with dbt for data transformation and modeling.
- Knowledge of data lakehouse architectures and table formats such as Apache Iceberg, Delta Lake, or Apache Hudi.
- Experience with Amazon Redshift workload optimization, distribution keys, sort keys, and Spectrum.
- Knowledge of Kafka and real-time or streaming data ingestion.
- Experience with PostgreSQL or Amazon Aurora as a data-serving layer.
- Familiarity with data governance, compliance, and sensitive-data management.
- Experience in the BFSI or health insurance domain.
Ideal Candidate Profile :
- 5+ years of hands-on experience in AWS Data Engineering.
- Strong experience building and supporting production-grade AWS data lake platforms.
- Practical expertise in PySpark, Apache Airflow, SQL, and AWS data services.
- Ability to troubleshoot complex data pipeline issues and optimize performance.
- Strong understanding of data architecture, data modeling, and production support practices.
- Candidates with experience in enterprise data platforms and insurance or BFSI environments will be preferred.
Responsibilities and JD
Job Description: We are looking for a Senior Developer with strong expertise in PySpark, Databricks, and Snowflake to build scalable data engineering solutions and enterprise data platforms.
Key Responsibilities:
- Design, develop, and maintain ETL/ELT pipelines using PySpark, Databricks, and Snowflake.
- Develop batch and real-time data processing solutions for structured and semi-structured data.
- Build and optimize Databricks notebooks, workflows, and Delta Lake solutions.
- Design and implement Snowflake databases, schemas, views, stored procedures, tasks, and streams.
- Develop scalable data models, data marts, and data warehouse solutions.
- Optimize PySpark jobs, Databricks workloads, and Snowflake queries for performance and cost efficiency.
- Implement data quality, validation, governance, and security controls.
- Collaborate with business stakeholders, architects, and cross-functional teams to deliver data solutions.
- Manage source control and CI/CD deployments using Git and Azure DevOps.
- Troubleshoot production issues, perform root cause analysis, and ensure pipeline reliability.
- Mentor junior team members and participate in code reviews and technical design discussions.
Required Skills: PySpark, Databricks, Snowflake, Python, SQL.
Experience: 5+ years of Data Engineering experience with strong hands-on expertise in PySpark, Databricks, and Snowflake.











