Quick overview
Job description
Headquartered in Princeton New Jersey, AH Infotech LLC, (4105 US Route 1, Unit 4, Monmouth Junction, NJ 08852) is an IT consulting and services company committed to offering customized technology solutions for businesses. Founded in 2015, the company employs over 200 people with global operations and provides impactful results to its customers across North America, Europe, and Asia -Pacific. AH Infotech provides services in cloud migration, cloud operations, enterprise services, and cloud enablement. AH Infotech is an organization focused on delivering high-quality technology solutions for business; we help our clients in digital transformation in ways that meets security, affordability, and scalability concerns.
We are looking for a highly experienced Snowflake Migration Architect / Technical Lead / Senior Developer to lead the migration of large-scale on-premises databases and data warehouse platforms to Snowflake Cloud Data Platform.
The ideal candidate must have strong hands-on Snowflake expertise, experience designing and executing complex database/data warehouse migrations, and prior experience working within the Healthcare domain.
This is a senior hands-on role requiring the candidate to participate in architecture, design, development, migration planning, performance optimization, testing, cutover, and post-production stabilization.
- Lead end-to-end migration of on-premises databases/data warehouses to Snowflake.
- Assess the existing on-prem environment, database objects, schemas, ETL processes, dependencies, data volumes, interfaces, and workloads.
- Define the Snowflake target architecture and migration strategy, including migration waves, cutover approach, rollback strategy, and production stabilization.
- Design scalable Snowflake architecture including databases, schemas, warehouses, storage, compute, roles, security, and access controls.
- Perform hands-on development using Snowflake SQL, SnowSQL, Stored Procedures, Streams, Tasks, Dynamic Tables, Snowpipe, and related Snowflake capabilities.
- Migrate large volumes of historical and incremental data from legacy/on-prem databases into Snowflake.
- Re-engineer or modernize existing ETL/ELT pipelines for the Snowflake platform.
- Design data ingestion patterns including batch, incremental/CDC, and near-real-time processing where required.
- Perform source-to-target mapping, data reconciliation, validation, and migration testing.
- Optimize Snowflake workloads for query performance, warehouse utilization, scalability, and cost.
- Identify and remediate performance bottlenecks in SQL queries, data models, pipelines, and warehouse configurations.
- Design appropriate data security, RBAC, masking, encryption, auditing, and governance controls.
- Ensure solutions meet applicable healthcare data security and privacy requirements.
- Work with application, infrastructure, security, data engineering, DBA, business, and healthcare teams throughout the migration.
- Lead technical design reviews and provide guidance to developers and data engineers.
- Support production cutover, troubleshooting, hypercare, and post-migration optimization.
- Prepare architecture diagrams, migration plans, technical specifications, runbooks, and operational documentation.
Candidates must have previous experience working with healthcare data/platforms. Experience with areas such as patient/member data, claims, providers, eligibility, clinical data, EHR/EMR, payer/provider systems, PHI/PII, HIPAA-controlled environments, HL7, or FHIR is highly preferred.
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- SI
Developer Associate (SAP Concur Travel Engineering AI & Core team)Recently posted Auto Apply
SAP IT Business Systeme · Bengaluru · Hybrid · Posted 18 Nov 2026 🇮🇳
Prompt EngineeringTechnologySalary not listed - SI
Developer (SAP Concur Travel Engineering AI & Core team)Recently posted Auto Apply
SAP IT Business Systeme · Bengaluru · Hybrid · Posted 18 Nov 2026 🇮🇳
AgileTechnologySalary not listed - SM
Senior Creatio DeveloperRecently posted Auto Apply
SmartDev · Ahmedabad, GJ · Remote · Posted 16 Nov 2026 🇮🇳
CRMGenerative AITechnologySalary not listed - MI
Senior Amazon Connect Routing DeveloperRecently posted Auto Apply
Miratech · India · Remote · Posted 18 Nov 2026 🇮🇳
Stakeholder ManagementSQLGit+4TechnologySalary not listed - AS
SAP Integration Suite DeveloperRecently posted Auto Apply
ASSYSTEM · Gurugram, HR · On-site · Posted 18 Nov 2026 🇮🇳
Project ManagementTechnologySalary not listed - BG
ServiceNow Developer – KM & VARecently posted Auto Apply
Bosch Group · bengaluru · On-site · Posted 18 Nov 2026 🇮🇳
NLPJavaLLM+5TechnologySalary not listed - BG
STIBO Sr. Developer Auto Apply
Bosch Group · bangalore · On-site · Posted 3 Nov 2026 🇮🇳
JavaRESTSOAP+1TechnologySalary not listed - CA

Full Stack developerRecently posted Auto Apply
Capco · Bengaluru · Hybrid · Posted 18 Nov 2026 🇮🇳
DjangoDockerFastAPI+26TechnologySalary not listed - MI
FullStack / Infra EngineerRecently posted Auto Apply
Mico · Bengaluru · Hybrid · Posted 18 Nov 2026 🇮🇳
OnboardingDockerMySQL+18TechnologySalary not listed - FT

Full Stack Software Engineer Auto Apply
Fortaegis Technologies · Bengaluru · Hybrid 🇮🇳
RustSQLAWS+8TechnologySalary not listed - VE

Webflow DeveloperRecently posted Auto Apply
Vectra · Bengaluru · Hybrid · Posted 17 Nov 2026 🇮🇳
HTMLFigmaCSS+1TechnologySalary not listed - MA
Shopify DeveloperRecently posted Auto Apply
Mattel · Hyderabad · On-site · Posted 17 Nov 2026 🇮🇳
ScrumAgileTechnologySalary not listed