ROLE SUMMARY
Data Engineers with hands-on expertise in PySpark and Fivetran to design, build, and maintain scalable data ingestion and transformation pipelines, at two levels: Junior (execution-focused, guided work) and Senior (ownership of architecture, performance, and mentoring). Both levels will work on integrating data from SaaS, database, and API sources into the cloud data warehouse, and building distributed processing jobs to support analytics and reporting.
JUNIOR DATA ENGINEER — REQUIREMENTS
[Must-Have] 1–3 years of hands-on experience with PySpark (DataFrames, Spark SQL basics) — production or solid academic/project experience acceptable.
[Must-Have] Working knowledge of Fivetran or a similar ELT tool (Airbyte, Stitch) — setting up connectors, monitoring syncs.
[Must-Have] Solid SQL fundamentals and exposure to a cloud data warehouse (Snowflake / Redshift / BigQuery).
[Must-Have] Basic Python scripting ability for data tasks.
Exposure to at least one cloud platform (AWS / Azure / GCP), internship or project-level acceptable.
Eager to learn,



works well under guidance from senior engineers; not expected to design architecture independently.
SENIOR DATA ENGINEER — REQUIREMENTS
[Must-Have] 5+ years of hands-on experience with PySpark (DataFrames, Spark SQL, RDDs, performance tuning, job optimization) in production.
[Must-Have] 3+ years configuring and managing Fivetran connectors at scale (custom connectors, schema drift handling, sync orchestration, troubleshooting).
[Must-Have] Strong SQL and proven data modeling / warehouse design experience (Snowflake / Redshift / BigQuery).
[Must-Have] Deep experience with at least one major cloud platform (AWS, Azure, or GCP), including cost and performance optimization.
[Must-Have] Proven ability to design end-to-end pipeline architecture and lead technical decisions.
Experience mentoring junior engineers and reviewing code/pipeline designs.
NICE-TO-HAVE SKILLS (EITHER LEVEL)
Experience with Databricks and Delta Lake.

📌 Data Engineer (India)
🏢 Sonata Software
📍 India