Data Engineering IRC302471

GlobalLogic; Dadri; On-site; INR 1,400,000 - 1,800,000; Full time

Benefits offered by this job

Flexible work arrangements

Paid time off

Competitive salary

Job summary

GlobalLogic is looking for a Data Engineer to design and optimize ETL/ELT pipelines, build dimensional models, and ensure data quality across data warehouses. You will write complex SQL, tune queries, and collaborate with BI teams to deliver clean data for reporting.

The role emphasizes hands-on SQL, warehousing fundamentals, and cloud/on-prem workflows with a focus on scalable data pipelines and data integrity.

Qualifications

• Strong, hands-on SQL — advanced query writing, optimization, and stored procedures (mandatory).
• Solid data warehousing fundamentals: dimensional modeling, ETL/ELT design, and schema design.
• Experience with a relational database / warehouse platform (SQL Server, PostgreSQL, Snowflake, Redshift, or BigQuery).
• Understanding of ETL tools or orchestration frameworks (e.g., Azure Data Factory, SSIS, Airflow, or dbt).
• Strong grasp of data quality, performance tuning, and troubleshooting.

Responsibilities

• Design, develop, and optimize ETL ELT pipelines to ingest data from multiple sources into the data warehouse.
• Build and maintain dimensional data models (star/snowflake schemas), fact and dimension tables, and slowly changing dimensions.
• Write complex, performant SQL — including joins, window functions, CTEs, and stored procedures — and tune queries for large datasets.
• Ensure data quality, integrity, and consistency through validation, reconciliation, and automated checks.
• Optimize warehouse performance via indexing, partitioning, and query tuning.
• Collaborate with BI/reporting teams to expose clean, well-documented datasets for downstream consumption.
• Maintain documentation of data flows, models, and transformation logic.
• Monitor, troubleshoot, and resolve pipeline failures and data discrepancies.

Skills

SQL mastery

Data warehousing

ETL/ELT design

Query optimization

Troubleshooting

Tools

SQL Server

PostgreSQL

Snowflake

Redshift

BigQuery

Azure Data Factory

SSIS

Airflow

dbt

Delta Lake

PySpark

Job description

Requirements

Strong, hands-on SQL — advanced query writing, optimization, and stored procedures (mandatory).

Description

Data Engineer

Requirements

• Strong, hands-on SQL — advanced query writing, optimization, and stored procedures (mandatory).
• Solid data warehousing fundamentals: dimensional modeling, ETL/ELT design, and schema design.
• Experience with a relational database / warehouse platform (SQL Server, PostgreSQL, Snowflake, Redshift, or BigQuery).
• Understanding of ETL tools or orchestration frameworks (e.g., Azure Data Factory, SSIS, Airflow, or dbt).
• Strong grasp of data quality, performance tuning, and troubleshooting.

Good-to-Have

• Databricks — experience with Delta Lake, Workflows, and the Medallion (bronze/silver/gold) architecture.
• PySpark — building and optimizing distributed data processing jobs.
• Experience with cloud data platforms (Azure, AWS, or GCP).
• Familiarity with BI tools (Power BI, Tableau).
• Python or scripting for automation.
• Version control (Git) and CI/CD for data pipelines.

Job responsibilities

• Design, develop, and optimize ETL ELT pipelines to ingest data from multiple sources into the data warehouse.
• Build and maintain dimensional data models (star/snowflake schemas), fact and dimension tables, and slowly changing dimensions.
• Write complex, performant SQL — including joins, window functions, CTEs, and stored procedures — and tune queries for large datasets.
• Ensure data quality, integrity, and consistency through validation, reconciliation, and automated checks.
• Optimize warehouse performance via indexing, partitioning, and query tuning.
• Collaborate with BI/reporting teams to expose clean, well-documented datasets for downstream consumption.
• Maintain documentation of data flows, models, and transformation logic.
• Monitor, troubleshoot, and resolve pipeline failures and data discrepancies.

What we offer

Exciting Projects:

We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.

Collaborative Environment:

You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!

Work-Life Balance:

GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.

Professional Development:

Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.

Excellent Benefits:

We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.

Fun Perks:

We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!

About GlobalLogic

GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.