Location- Chennai, Bangalore

Experience - 5 to 8years

Shift- 2:30 pm to 12 am Hybrid

SAS Developer SAS to Snowflake Migration 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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

Role: Data Engineer,

Industry Type: IT Services & Consulting,

Department: Data Science & Analytics,

Employment Type: Full Time, Permanent

Role Category: Data Science & Machine Learning

Education

UG: Any Graduate

PG: Any Postgraduate

Key Skills advanced sqlanalyticsarchitecturebase sascloningcloudcloud dataclusteringdata analyticsdata engineeringdata lineagedata migrationdata modelsdata reconciliationdefect trackingeltmappingpythonrdbmssasscripting

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