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

Data Engineer

Moder Solutions

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

About the role

Data Engineer Job Description Job Title: Data Engineer Job Summary: We are seeking a skilled and detail-oriented Data Engineer to design, develop, and maintain scalable data pipelines and data infrastructure. The ideal candidate will work closely with data analysts, data scientists, and business stakeholders to ensure reliable, high-quality data is available for reporting, analytics, and machine learning initiatives. Key Responsibilities Design, develop, and maintain scalable ETL/ELT data pipelines. Build and optimize data integration solutions from multiple internal and external data sources. Develop and maintain data warehouses, data lakes, and data marts. Ensure data quality, integrity, security, and governance across enterprise systems. Monitor, troubleshoot, and optimize data pipeline performance. Collaborate with business analysts, data scientists, and software engineers to understand data requirements. Implement data models that support reporting, analytics, and operational systems. Automate data workflows and deployment using CI/CD best practices. Create technical documentation for data architecture, pipelines, and processes. Stay current with emerging data engineering technologies and recommend improvements. Required Qualifications Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field. 3+ years of experience in data engineering or a similar role. Strong proficiency in SQL and database design. Experience with Python, Scala, or Java. Hands-on experience with ETL/ELT tools and data integration frameworks. Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform. Knowledge of data warehousing concepts and dimensional modeling. Experience with version control systems such as Git. Strong analytical, problem-solving, and communication skills. Preferred Qualifications Experience with SSIS Apache Spark, Kafka, Airflow, or Databricks. Experience with Snowflake, Redshift, BigQuery, or Synapse. Familiarity with DevOps and Infrastructure as Code (Terraform, Docker, Kubernetes). Experience working in Agile/Scrum environments. Cloud certifications (AWS, Azure, or GCP) are a plus. Technical Skills SQL SSIS Python Apache Spark Apache Kafka Apache Airflow Snowflake Git CI/CD Soft Skills Strong problem-solving and analytical thinking Excellent communication and collaboration Attention to detail Time management and organizational skills Ability to work independently and within cross-functional teams Preferred Experience Experience designing enterprise-scale data platforms. Experience building real-time and batch data pipelines. Knowledge of data governance, security, and compliance standards. Experience supporting business intelligence and analytics solutions.

Eligibility & process

Who can apply

Experience: 7-12 Yrs. Open to matching qualifications.

Skills & stack

MWAA SQL Snowflake Apache Airflow Python Data Engineering Stored Procedure CI/CD

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 (MWAA, SQL, Snowflake, Apache Airflow, Python, Data Engineering, Stored Procedure, CI/CD) & 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 Moder Solutions 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 Moder Solutions as a Data Engineer?
Highlight Moder Solutions's market reputation, recent tech innovations, and how your skills in MWAA 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.
Moder Solutions 30-40 Lacs PA
Recruiter Resume Apply
Chat Chat with Kashii