Data Engineering IRC302471

GlobalLogic Inc.; India; Remote; INR 1,200,000 - 2,400,000; Full time

Benefits offered by this job

Flexible work schedules

Work from home

Paid time off

Job summary

GlobalLogic looks for a strong data engineering professional in India to design, develop, and optimize ETL/ELT pipelines feeding a data warehouse. You will build dimensional models and write complex SQL, ensuring data quality and performance at scale.

The role emphasizes hands-on SQL, data modeling, and orchestration tooling, with opportunities to work across global centers and client facilities.

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

Data warehousing

ETL/ELT design

Tools

SQL Server

PostgreSQL

Snowflake

Redshift

BigQuery

Azure Data Factory

SSIS

Airflow

dbt

Job description

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.

We value diversity and inclusion

EEO/DEI/diversity statements and equal opportunity: We welcome applications from all backgrounds and are committed to creating an inclusive environment for everyone.