Snowflake Data Engineer Chennai, Tamil Nadu

Job Summary

The Developer specializing in Snowflake and SQL will be responsible for developing, and maintaining data solutions using Snowflake cloud data platform and SQL databases. The role involves optimizing data pipelines, ensuring data quality, and supporting data analytics initiatives.

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 solid 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 strong 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 stable production deployment.

Key Responsibilities

1. Develop, and implement data solutions using snowflake and sql technologies.

- Optimize and tune snowflake data pipelines for performance and scalability.
- Collaborate with data analysts and data scientists to support data analytics projects.
- Ensure data quality and implement data governance best practices.
- Troubleshoot and resolve issues related to data processing and data warehousing.
- Stay updated with the latest trends and advancements in snowflake and sql technologies.

Skill Requirements

1. Knowledge of snowflake cloud data platform and sql databases.
- Handson familiarity with designing and developing data pipelines using snowflake.
- Knowledge of writing complex sql queries and optimizing database performance.
- Familiarity with data modeling, etl processes, and data warehousing concepts.
- Knowledge of data visualization tools and data analytics platforms.
- Analytical and problem-solving skills.
- Good communication and collaboration abilities.

Other Requirements

1.SnowPro Core Certification is preferred.

📌 Snowflake Data Engineer (Chennai)
🏢 HCLTech
📍 Chennai