Overview
Role: ETL Data Engineer
Experience: 6-9 Years
Location: Noida/Pune/Chennai
Notice Period: 0-15 Days
Job Description:
Collaborate with analysts and data architects to develop and test ETL pipelines using SQL and Python in Google BigQury.
Perform related data quality checks and implement validation frameworks.
Optimize BigQuery queries for performance and cost-efficiency
Available for full-time engagement
Technical Requirements
SQL (Advanced level):
Strong command of complex SQL logic, including window functions, CTEs, pivot/unpivot, and be proficient in stored procedure/SQL script development.
Experience writing maintainable SQL for transformations.
Python for ETL:
Ability to write modular and reusable ETL logic using Python.
Familiarity with JSON manipulation and API consumption.
Google Big Query:
Hands-on experience developing within the Big Query environment.
Understanding of partitioning, clustering, and performance tuning.
ETL Pipeline Development:
Experienced in developing ETL/ELT pipelines, data profiling, validation, quality/health check, error handling, logging and notifications, etc.
Nice-to-Have Skills:
Experiences with Google Big Query platform.
Knowledge of CI/CD practices for data workflows.
Job Types: Full-time, Permanent
Pay: ₹2,500,000.00 - ₹3,000,000.00 per year
Benefits:
- Cell phone reimbursement
- Health insurance
- Paid time off
- Provident Fund
Schedule:
- Day shift
Work Location: In person