
Solvative•1d ago
Foundit
Data Engineer
Ahmedabad, India
Remote
Mid Level
Full Job Description
Role Overview
We are seeking a Data Engineer (2-4 years experience) with strong SQL and programming skills. You will design, build, optimize scalable data pipelines, model data thoughtfully using star/snowflake schemas or lakehouse patterns, and own end-to-end pipeline operations including monitoring, quality, lineage, and cost.
Key Responsibilities:
• SQL: Advanced proficiency including window functions and query optimization.
• Programming: Strong skills in Python or Scala/Java.
• Pipelines: Experience with ETL/ELT tools like Airflow, dbt, Dagster, or Luigi.
• Distributed Processing: Knowledge of Spark or Flink (Hadoop for legacy).
• Cloud Platform: Azure cloud services.
Engineering Fundamentals:
Since you will work directly with US-based clients, fluent written/spoken English is non-negotiable. You must be able to explain technical concepts clearly, manage expectations professionally across time zones, and translate ambiguous client needs into concrete plans.
To Thrive Here:
We are seeking a Data Engineer (2-4 years experience) with strong SQL and programming skills. You will design, build, optimize scalable data pipelines, model data thoughtfully using star/snowflake schemas or lakehouse patterns, and own end-to-end pipeline operations including monitoring, quality, lineage, and cost.
Key Responsibilities:
- Design and maintain robust batch/streaming data pipelines (Ingestion -> Transformation -> Consumption).
- Write clean, performant SQL and code in Python or Scala/Java that is testable and extendable.
- Collaborate with analysts, scientists, and business stakeholders to deliver reliable data products from ambiguous requirements.
• SQL: Advanced proficiency including window functions and query optimization.
• Programming: Strong skills in Python or Scala/Java.
• Pipelines: Experience with ETL/ELT tools like Airflow, dbt, Dagster, or Luigi.
• Distributed Processing: Knowledge of Spark or Flink (Hadoop for legacy).
• Cloud Platform: Azure cloud services.
Engineering Fundamentals:
- Version control with Git and robust CI/CD practices.
- Code quality: Testing, modularity, documentation.
- Infrastructure-as-code (Terraform) and containerization (Docker, Kubernetes).
Since you will work directly with US-based clients, fluent written/spoken English is non-negotiable. You must be able to explain technical concepts clearly, manage expectations professionally across time zones, and translate ambiguous client needs into concrete plans.
To Thrive Here:
- Ownership without ego.
- Curiosity about the "why" behind tools and choices.
- A bias toward clarity in documentation and requirements.
Company
Solvative
Solvative is a technology organization headquartered in Dallas, USA with development centers in Ahmedabad, Gujarat, India.BenefitsPremium Apple laptops for enhanced mobility and productivity.Comprehen...
Ahmedabad, India
Posted on Foundit
Practice this interview
A voice mock interview for Data Engineer at Solvative, with questions from this job description and your resume, and a scored report afterwards.
Set up interview