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

📌 Specialist - Data Engineering (Chennai)
🏢 LTM
📍 Chennai