Snowflake Senior Technical Lead

Chennai, Tamil Nadu

Job Summary

The Senior Technical Lead will be responsible for leading technical teams and projects related to Snowflake, DBT, SQL, and Python. The role involves overseeing the design, development, and implementation of data solutions leveraging these technologies to meet business requirements.

Senior Data Engineer – Informatica to dbt MigrationWe are seeking an experienced Senior Data Engineer to support a large-scale data modernization initiative involving the migration of Informatica workflows to dbt on Snowflake. The role will be part of a factory-based delivery model responsible for workflow analysis, code conversion, testing, reconciliation, deployment, and certification.The engineer will analyze Informatica workflows, mappings, sessions, mapplets, reusable transformations, parameter files, source-to-target mappings, and workflow dependencies. The role requires identifying transformation logic, business rules, lookups, joins, filters, aggregations, update strategies, pre/post SQL, scripts, and unsupported patterns that may require redesign.The engineer will convert Informatica mappings into modular and maintainable dbt models using Snowflake SQL. Responsibilities include developing staging, intermediate, and presentation-layer models, reusable macros, incremental models, snapshots, seeds, and dbt tests. The engineer will also review and remediate code generated through automated conversion tools and ensure compliance with project coding, naming, documentation, and architecture standards.A major responsibility will be validating dbt output against the corresponding Informatica output. This includes row-count validation, column-level comparison, aggregate checks,



null and duplicate checks, checksum validation, business-rule validation, and reconciliation reporting. The engineer will support parallel runs, investigate data discrepancies, resolve defects, and prepare evidence required for technical and business certification.The role will also support unit testing, system integration testing, regression testing, performance testing, user acceptance testing, production deployment, smoke testing, and post-production validation. The engineer will assist with Git-based code management, pull requests, CI/CD pipelines, deployment documentation, Control-M or equivalent scheduling, rollback planning, and hypercare support.Candidates should have 5–10 years of data engineering or ETL experience with strong hands-on expertise in Informatica PowerCenter, dbt, Snowflake, and advanced SQL. Experience with workflows, mappings, mapplets, parameterization, incremental processing, stored procedures, reconciliation, and ETL modernization is required. Knowledge of Git, CI/CD, Agile delivery, data quality, and performance optimization is also expected.Experience in the insurance domain, factory-based migration programs, Control-M, automated conversion accelerators, and Snowflake or dbt certification is preferred. The candidate should possess robust analytical, troubleshooting, communication,



documentation, and stakeholder-management skills.Success will be measured through conversion productivity, first-time-right quality, reconciliation accuracy, low defect leakage, adherence to standards, timely certification, and reliable production deployment.

Key Responsibilities

1. Lead and manage technical teams in the development and implementation of snowflake data solutions.
2. Design, build, and optimize data models using snowflake and dbt for efficient data processing.
3. Develop and optimize sql queries for data extraction, transformation, and loading processes.
4. Utilize python for scripting and automation of data processes and workflows.
5. Collaborate with cross functional teams to understand data requirements and ensure the successful delivery of technical solutions.
6. Conduct code reviews, provide technical guidance, and mentor team members to enhance overall technical capabilities.
7. Troubleshoot technical issues and provide resolutions in a timely manner to ensure smooth project execution.

Skill Requirements

1. Proficiency in snowflake for data warehousing and cloud data platform.
2. Experience with dbt (data build tool) for data transformation and modeling.
3. Strong command of sql for querying and manipulating data in databases.
4. Proficient in python programming for scripting, automation, and data manipulation.
5. Excellent problem-solving skills and the ability to communicate effectively with technical and nontechnical stakeholders.
6. Strong leadership skills to effectively lead and motivate technical teams towards project success.

📌 Snowflake Senior Technical Lead (India)
🏢 HCLTech
📍 India