We are looking for a Senior Solution Architect with extensive hands-on technical expertise in SAS, SQL, Informatica IDMC, Snowflake, and Azure DevOps. The ideal candidate must be a hardcore technical architect with a strong development background who can analyze complex data processing solutions, design target-state architectures, and guide implementation across the enterprise data engineering lifecycle.

The role involves assessing SAS-based workloads, defining migration and integration strategies, translating legacy processing logic into up-to-date ETL/ELT architectures, and designing scalable solutions using Informatica IDMC and Snowflake. The candidate must be equally comfortable with architecture design, code-level analysis, development guidance, performance optimization, and troubleshooting. Azure Data Factory and Azure Databricks experience is desirable.

Key Responsibilities

- Design and guide end-to-end data integration architectures using SAS, Informatica IDMC, Snowflake, SQL, and related enterprise data technologies.
- Perform hands-on analysis of SAS programs, SAS DI jobs, DATA Step logic, PROC SQL, macros, transformations, scheduling, and dependencies.
- Evaluate workloads for migration, consolidation, optimization, or retirement based on business and technical requirements.
- Translate SAS processing logic into Informatica IDMC mappings, transformations, taskflows, and Snowflake-based SQL processing.
- Address functional differences between SAS and target platforms, including data types, null handling, sorting, joins, date processing, aggregations, and numeric precision.
- Define scalable ETL/ELT architecture patterns for ingestion, transformation, orchestration, validation, exception handling, and downstream delivery.
- Establish Informatica IDMC design standards for Cloud Data Integration, mappings, mapping tasks, taskflows, reusable components, parameterization, Secure Agents, and error recovery.
- Design Snowflake solutions covering data modeling, SQL transformations, stored procedures, incremental processing, pushdown optimization,



and performance tuning.
- Develop or review complex SAS programs, SQL queries, stored procedures, and integration logic to validate architecture decisions and resolve implementation challenges.
- Define source-to-target mappings, data models, data contracts, lineage requirements, data quality standards, and reconciliation frameworks.
- Establish engineering standards for Azure DevOps, Git, branching, code reviews, CI/CD, automated testing, and controlled deployments.
- Define environment promotion, configuration management, deployment validation, rollback, monitoring, logging, and operational recovery approaches.
- Conduct architecture reviews, code reviews, technical assessments, proof-of-concept development, and performance evaluations.
- Troubleshoot complex technical issues across SAS, Informatica IDMC, Snowflake, SQL, and associated data integration components.
- Provide hands-on technical leadership, mentor developers, challenge inefficient designs, and establish reusable engineering patterns.
- Ensure architecture addresses security, access control, auditability, scalability, maintainability, and operational support requirements.
- Collaborate with business analysts, data engineers, QA teams, security teams, infrastructure teams, and business stakeholders.
- Define technical acceptance criteria, production readiness standards, and implementation guidelines for reliable enterprise data solutions.

Required Qualifications

- 12+ years of experience in data engineering, solution architecture, enterprise data integration, or data platform development, with substantial hands-on delivery experience.




- Strong hands-on experience with SAS programming, including Base SAS, DATA Step, PROC SQL, SAS Macro, and SAS Data Integration Studio or comparable SAS ETL technologies.
- Demonstrated experience developing, analyzing, debugging, and optimizing complex SAS programs and data integration workflows.
- Strong SQL expertise, including complex joins, subqueries, analytical functions, stored procedures, query optimization, and database performance tuning.
- Extensive hands-on experience with Informatica IDMC, including Cloud Data Integration, mappings, transformations, mapping tasks, taskflows, parameterization, and workflow orchestration.
- Proven experience migrating SAS DI jobs or SAS-based ETL workflows to Informatica IDMC or equivalent Informatica cloud integration technologies.
- Strong understanding of SAS-to-Informatica migration, transformation equivalence, data type conversions, null handling, sorting, aggregation, and reconciliation.
- Strong hands-on experience with Snowflake architecture, SQL processing, data loading, data modeling, stored procedures, pushdown processing, and performance optimization.
- Experience designing and implementing end-to-end ETL/ELT solutions across legacy and modern data platforms.
- Strong hands-on experience with Azure DevOps and Git, including source control, branching, pull requests, CI/CD pipelines, and deployment automation.
- Experience establishing reusable frameworks, coding standards, automated testing, release controls, and production support practices.
- Ability to investigate complex technical issues across SAS, IDMC, Snowflake, SQL, and integration workflows.
- Experience producing architecture designs, technical specifications, data flow diagrams, migration strategies, and implementation standards.
- Strong understanding of data quality, lineage, metadata, security, access control, and enterprise data governance.
- Proven ability to perform code and design reviews, guide developers, and make implementation-level technical decisions.

📌 Senior Solution Architect – SAS, Informatica IDMC & Snowflake (Noida)
🏢 Anaptyss
📍 Noida