Senior Data Engineering 2

Role Overview

We are looking for an experienced Data Engineer with strong expertise in Snowflake and/or Greenplum, and hands-on experience in data pipeline development, SQL optimization, and cloud migration projects.You will work on end-to-end data modernization initiatives, including Greenplum → Snowflake migrations, ETL/ELT development, performance tuning, and automated data-processing workflows.This is a high-impact role where you will collaborate with architects, product teams, and clients to build secure, scalable, and efficient data ecosystems.

Key Responsibilities

Snowflake & Greenplum EngineeringDesign, develop, and optimize Snowflake objects—tables, views, stored procedures, tasks, streams, Snowpipe, COPY pipelines.Migrate existing logic from Greenplum / Hadoop / SQL Server / Oracle into Snowflake stored procedures and scripts.Support end-to-end migration cycles: schema migration, code refactoring, unit testing, data validation, performance tuning.Data Pipelines & ETL/ELTBuild and maintain ETL/ELT workflows using tools such as SSIS, Matillion, Talend, AWS Glue, or custom Python/SQL-based pipelines.Work on ingestion frameworks extracting data from relational, NoSQL, and cloud sources into Snowflake/Redshift/S3.Implement automation routines, pipeline orchestration, and job monitoring using Control-M, Lambda, or Azure/AWS DevOps.Data Optimization & Engineering Best PracticesTune and optimize complex SQL queries using Snowflake Query Profile, CTEs, dynamic SQL, clustering, partitioning, and caching techniques.Conduct data validation between legacy (Greenplum/Hadoop/Oracle) and target Snowflake environments.Ensure data quality, performance, and reliability across all pipelines.Collaboration & DeliveryWork closely with architects, analysts, and stakeholders to understand data requirements and translate them into scalable solutions.Contribute to cloud modernization initiatives, POCs, and performance benchmarking.Support DevOps practices using Git-based version control, CI/CD, automated deployments, and environment migration.

Required Skills

Core Technical Expertise
Strong hands-on experience with Snowflake (must have) including:
Stored procedures, UDFs, tasks, streams
Time Travel, Cloning, Fail-safe
Snowpipe, COPY INTO, Staging & Data Loading
Query optimization & profiling
Experience with Greenplum, PostgreSQL, or equivalent MPP systems.
Strong SQL development skills and ability to troubleshoot and optimize large-scale queries.
Experience with ETL tools: SSIS, Matillion, Talend, AWS Glue, Informatica, or similar.
Cloud experience (AWS/Azure) with S3 buckets, Lambda, Redshift, or Azure equivalents.

Tools / Tech Stack

Education - B.E./B.Tech/M.Tech/MCA in Computer Science, Information Technology, or a related field

Shift / Timing

Regular

Experience Range

2 – 4 yrs

Open Positions

4

Apply Now