Data Engineering - Aws

Data Engineering - Aws

Company: Globallogic Ukraine

Job Location: Noida, Uttar Pradesh, India

Employment Type: Full-time

Data Engineer

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.

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.

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.

Maintain documentation of data flows, models, and transformation logic.

Monitor, troubleshoot, and resolve pipeline failures and data discrepancies.

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!

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. .