Specialist - Data Engineering

Location- Chennai, Bangalore
Experience - 5 to 8years
Shift- 2:30 pm to 12 am Hybrid

SAS Developer SAS to Snowflake Migration

Job Description Data Analytics

Role Snapshot

Role TitleSAS Lead Developer SAS Migration Specialist

FunctionData Analytics Data Modernisation

Experience 5 to 8 years with at 5 years handson in SAS

EngagementFulltime

Reports to Principal Architecture Data Analytics

Role Overview

We are looking for an experienced SAS developer to join a legacy modernisation programme that is moving an established SAS estate onto Snowflake The person in this role will be the teams authority on what the existing SAS code actually does reading Base SAS and SAS macro programs tracing the data lineage behind them and translating that logic into Snowflake and modern ELT pipelines without changing business outcomes

This is a handson engineering role rather than a support role Expect to spend most of your time in code in reconciliation and in conversation with the business users who rely on the reports and datasets being migrated The work is well suited to someone who has lived inside a large SAS codebase and now wants to carry that knowledge into a cloud data platform

Key Responsibilities

Analyse and document the existing SAS estate Base SAS programs macros PROC SQL DATA steps scheduled jobs and stored processes and produce the code inventory complexity rating and dependency map that drive the migration wave plan

Convert SAS logic into equivalent Snowflake stored procedures and ELT pipelines preserving business rules joins aggregations formats and edgecase handling rather than reimplementing from assumption

Own data reconciliation between the SAS output and the Snowflake output build rowcount controltotal and recordlevel comparison scripts investigate breaks and sign off each migrated object against agreed tolerance

Reengineer SAS data access layers that read from files RDBMS sources and SAS datasets so they land in Snowflake through the programmes chosen ingestion pattern

Work with the architecture team on target data models translating SASera structures into curated Snowflake schemas that suit setbased processing

Tune migrated workloads for cost and performance warehouse sizing clustering pruning and query rewrites so that converted jobs meet or beat their existing batch windows

Engage report owners and business analysts to confirm interpretation of legacy logic retire redundant code instead of migrating it and support user acceptance testing through to cutover

Maintain migration artefacts mapping documents conversion standards test evidence and runbooks and mentor junior engineers on reading SAS code safely

MustHave Skills

Strong handson Base SAS SAS Macro PROC SQL and DATA step development including formats informats arrays hash objects and bygroup processing

Proven ability to read and reverseengineer undocumented longlived SAS programs and explain what they do in business terms

Advanced SQL with practical exposure to Snowflake virtual warehouses stages streams tasks time travel cloning and micropartition behaviour

Experience on at least one completed legacytocloud data migration with responsibility for validation and reconciliation not only code conversion

Working knowledge of Python or a comparable scripting language for conversion accelerators automated comparison and repetitive refactoring

Comfortable with version control structured testing and defect tracking in a deliverymanaged environment