Specialist - Data Engineering

Role Description
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

Work arrangement
No