Snowflake Technical Lead (IN)
HCLTech
HCLTech
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.
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.
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.
HCLTech
IT Consulting