Snowflake OR Snowflake SQL, Python, SQL Server OR SQL Refactoring OR Migration
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.
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.
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.
Education - B.E./B.Tech/M.Tech/MCA in Computer Science, Information Technology, or a related field
Regular
3– 6 yrs
5
Apply Now