Senior Technical Lead

Technology, Data & Digital · Data, AI & Analytics · Data Engineering

In short

Responsible for designing, developing, and supporting enterprise data solutions for banking, finance, and operational reporting. Works closely with stakeholders to integrate, transform, validate, reconcile, and automate data flows. Requires expertise in Snowflake, Advanced SQL, ETL/ELT, and Data Warehousing Concepts.

Responsibilities

Design and maintain scalable data models, pipelines, and database structures within Snowflake.
Perform impact analysis for schema and table changes to ensure downstream processes are not affected.
Implement and manage data cloning, migration, and deployment activities across environments.
Troubleshoot and resolve SQL, ETL, and data quality issues.
Support ingestion and processing of banking data, including MT940 statements and ISO 20022 message formats.
Monitor daily bank statement and transaction feeds and investigate missing or delayed files.
Improve operational efficiency by reducing manual intervention in data workflows.
Provide technical guidance and support for business-critical data requests.

Requirements

Snowflake
Advanced SQL
ETL/ELT Design and Development
Data Warehousing Concepts
Database Performance Optimization
File Processing (CSV, XML parsing)
Banking Operations
ISO 20022 Standards
MT940-950 Bank Statements

Skills

SnowflakeSQLETLELTData WarehousingDatabase PerformanceFile ProcessingBanking OperationsISO 20022MT940MT950

#data solutions#banking#finance#reporting#data integration#data transformation#data reconciliation#data automation#data architecture#data engineering#data pipelines#database structures#Snowflake#SQL#ETL#ELT#data quality#MT940#ISO 20022

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

See all open jobs at HCLTech Read more about HCLTech Website