Snowflake Technical Lead (IN)

HCLTech

5–10 yrs India Full Time Remote
HCLTech logo
Posted : today
Actively hiring

Job description

Lead a large-scale data modernization initiative by migrating Informatica workflows to dbt on Snowflake. This role involves a factory-based delivery model focused on analyzing workflows, converting code, rigorous testing, reconciliation, seamless deployment, and final certification.

Dive deep into Informatica workflows, mappings, sessions, and mapplets. Identify complex transformation logic, business rules, and unsupported patterns that require innovative redesign. Convert intricate Informatica mappings into efficient, modular dbt models using Snowflake SQL. Develop staging, intermediate, and presentation-layer models, alongside reusable macros, incremental models, snapshots, seeds, and comprehensive dbt tests.

Responsibilities

Validate dbt output against Informatica results through detailed row-count, column-level, and aggregate checks. Investigate data discrepancies, resolve defects, and prepare crucial evidence for technical and business certification. Support various testing phases including unit, integration, regression, performance, and user acceptance testing. Assist with Git-based code management, CI/CD pipelines, deployment documentation, scheduling tools, rollback planning, and hypercare support.

Oversee and guide technical projects within Snowflake, DBT, SQL, and Python. Provide expert technical direction, mentor team members, and ensure the successful delivery of robust solutions. Collaborate closely with stakeholders to grasp project needs and translate them into effective technical strategies.

Qualifications

Possess 5-10 years of data engineering or ETL experience with a strong command of Informatica PowerCenter, dbt, Snowflake, and advanced SQL. Expertise in workflow management, parameterization, incremental processing, stored procedures, reconciliation, and ETL modernization is essential.

Proficiency in Snowflake for database development and management, coupled with dbt experience for data transformation and modeling. Demonstrate strong SQL skills for querying and advanced Python knowledge for data manipulation and ETL processes. Ability to thrive in a fast-paced environment, manage multiple priorities, and exhibit excellent problem-solving skills and attention to detail. Strong communication and leadership capabilities are vital for guiding and mentoring team members effectively.

Essential Skills

SnowflakedbtSQLPythonInformatica PowerCenterETLData ModernizationData TransformationDatabase ManagementData ModelingGitCI/CDAgileData QualityPerformance OptimizationTroubleshootingCommunicationStakeholder ManagementLeadership

Good to Have

Control-MSnowflake CertificationDBT CertificationSQL CertificationPython Certification

Highlights

  • Actively hiring

More Details

RoleSnowflake Technical Lead (IN)
DepartmentData Engineering
Employment TypeFull Time, Remote

About the Company

HCLTech logo

HCLTech

IT Consulting