Snowflake Senior Technical Lead (IN)
HCLTech
HCLTech
Join a large-scale data modernization initiative focused on migrating Informatica workflows to dbt on Snowflake. This role operates within a factory-based delivery model, emphasizing workflow analysis, code conversion, rigorous testing, and deployment.
Your expertise will be crucial in analyzing existing Informatica workflows, including mappings, sessions, and transformations, to identify and extract critical business logic. You'll translate this logic into modular and maintainable dbt models using Snowflake SQL, contributing to the development of robust staging, intermediate, and presentation layers.
A key aspect of this position involves validating the output of dbt models against Informatica results through comprehensive checks like row counts, column comparisons, aggregations, and business rule validation. You will actively support testing phases, troubleshoot data discrepancies, and contribute to the certification process.
Collaboration extends to supporting various testing cycles (unit, system integration, UAT), production deployments, and post-production validation. Proficiency in Git-based code management, CI/CD pipelines, and documentation is essential. Experience with Control-M or equivalent scheduling tools is also expected.
This role offers a fantastic opportunity to drive significant improvements in data infrastructure and processes within a dynamic environment.
Analyze Informatica workflows, mappings, sessions, and transformations to extract logic and identify unsupported patterns.
Convert Informatica mappings into modular and maintainable dbt models using Snowflake SQL, developing staging, intermediate, and presentation layers.
Develop reusable dbt macros, incremental models, snapshots, seeds, and dbt tests.
Validate dbt output against Informatica output through row-count, column-level, aggregate, null, duplicate, and business-rule checks.
Support unit testing, system integration testing, regression testing, performance testing, and user acceptance testing.
Assist with Git-based code management, pull requests, CI/CD pipelines, and deployment documentation.
Provide hypercare support post-production deployment and rollback planning.
Possess 5–10 years of data engineering or ETL experience with strong hands-on expertise in Informatica PowerCenter, dbt, Snowflake, and advanced SQL.
Demonstrated experience with Informatica workflows, mappings, mapplets, parameterization, incremental processing, stored procedures, reconciliation, and ETL modernization.
Proficiency in Git, CI/CD, Agile delivery methodologies, data quality best practices, and performance optimization techniques is expected.
Strong analytical, troubleshooting, communication, documentation, and stakeholder management skills are essential for success in this role.
Familiarity with the insurance domain, factory-based migration programs, Control-M, or automated conversion accelerators are considered advantageous.
HCLTech
IT Consulting