KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
N #3176
Applications open Full-Time Job

Lead Data Engineer

Good co India

  • Remote, India
  • 25-40 Lacs PA
  • 5-10 Yrs
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Role & responsibilities Lead the design, development, and implementation of scalable, reliable, and high-performance data engineering solutions. Architect, build, and maintain robust ETL/ELT pipelines for batch and real-time data processing. Lead the development and optimization of data warehouses, data lakes, and lakehouse architectures.

Design and manage data ingestion, transformation, integration, and orchestration workflows. Work with large-scale datasets using Apache Spark, PySpark, Kafka, Hadoop, and other big data technologies. Implement and manage cloud-based data platforms using AWS, Microsoft Azure, or Google Cloud Platform.

Develop and optimize data models, database schemas, and data processing frameworks. Ensure data quality, consistency, security, governance, and regulatory compliance across data platforms. Implement workflow orchestration and automation using Apache Airflow, dbt, and related tools.

Monitor data pipelines, troubleshoot failures, and optimize system performance and infrastructure costs. Establish data engineering standards, best practices, documentation, and CI/CD processes. Collaborate with data scientists, data analysts, software engineers, and business stakeholders to deliver data-driven solutions.

Lead technical discussions, architecture reviews, code reviews, and technology evaluations. Mentor junior and mid-level data engineers and provide technical guidance to the engineering team. Drive continuous improvements in data infrastructure, scalability, reliability, and operational efficiency.

Preferred candidate profile Bachelor's or Master's degree in Computer Science, Information Technology, Data Science, Software Engineering, or a related technical field. 5 to 10 years of professional experience in data engineering, big data development, or data platform engineering. Strong proficiency in Python, SQL, PySpark, and experience with large-scale data processing. Hands-on experience designing and developing complex ETL/ELT pipelines and data integration workflows.

Strong knowledge of Apache Spark, Kafka, Airflow, Hadoop, and distributed data processing frameworks. Experience with modern data platforms such as Snowflake, Databricks, Amazon Redshift, Google BigQuery, or Azure Synapse Analytics. Proven expertise in cloud technologies, including AWS, Azure, or Google Cloud Platform.

Strong understanding of data warehousing, data lakes, lakehouse architecture, data modeling, and database optimization. Experience with real-time streaming, batch processing, and workflow orchestration. Knowledge of data governance, data quality frameworks, metadata management, and data security practices.

Experience with Docker, Kubernetes, Git, CI/CD pipelines, Terraform, and infrastructure automation. Ability to lead technical projects, define data architecture, and establish engineering best practices. Proven experience mentoring engineers, conducting code reviews, and collaborating with cross-functional teams.

Strong analytical, problem-solving, communication, and stakeholder-management skills. Ability to translate business requirements into scalable and efficient data engineering solutions.

Eligibility & process

Who can apply

Experience: 5-10 Yrs. Open to matching qualifications.

Skills & stack

Data Warehousing SQL Data Pipeline Architecture Advance Sql Integration Data Architecture Hadoop Python

Selection process

  1. Online Assessment / Technical Interview Rounds / HR Review

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Data Warehousing, SQL, Data Pipeline Architecture, Advance Sql, Integration, Data Architecture, Hadoop, Python) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Good co India Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Good co India as a Lead Data Engineer?
Highlight Good co India's market reputation, recent tech innovations, and how your skills in Data Warehousing directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Good co India 25-40 Lacs PA
Recruiter Resume Apply
Chat Chat with Kashii