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 modern 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.
• Robust 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 (Noida)
🏢 Anaptyss
📍 Noida