Technical Lead (IN)

HCL TechnologiesIN

Posted 10 days agoStill open, checked 13m ago

About the job

Job Summary

Need data analyst candidate with 5+ years of experience.

Key Responsibilities

Design, develop, maintain, and optimize Python applications, reusable modules, prototypes, and automation scripts.

· Analyze and reconcile data across Murex, FDR, data warehouses, and other internal applications.

· Use Python to ingest, transform, validate, compare, reconcile, and export data across JSON, XML, CSV, Excel, databases, APIs, web services, and legacy sources.

· Perform data analysis and profiling to understand source structures, trends, variances, anomalies, completeness, and data-quality issues.

· Prepare and validate source-to-target mappings, field-level mappings, transformation rules, business rules, data dictionaries, data lineage, and end-to-end traceability documentation.

· Design and implement relational and analytical data structures, including tables, constraints, indexes, views, materialized views, functions, and stored procedures.

· Develop complex SQL and T-SQL for data retrieval, transformation, validation, reconciliation, migration, root-cause analysis, and efficient processing of large datasets.

Build or support Azure data components using Azure Data Factory, Azure Functions, Azure SQL Database, Blob Storage or ADLS Gen2, Key Vault, Entra ID, and Azure DevOps, as applicable.

Skill Requirements

Design, develop, maintain, and optimize Python applications, reusable modules, prototypes, and automation scripts.

· Analyze and reconcile data across Murex, FDR, data warehouses, and other internal applications.

· Use Python to ingest, transform, validate, compare, reconcile, and export data across JSON, XML, CSV, Excel, databases, APIs, web services, and legacy sources.

· Perform data analysis and profiling to understand source structures, trends, variances, anomalies, completeness, and data-quality issues.

· Prepare and validate source-to-target mappings, field-level mappings, transformation rules, business rules, data dictionaries, data lineage, and end-to-end traceability documentation.

· Design and implement relational and analytical data structures, including tables, constraints, indexes, views, materialized views, functions, and stored procedures.

· Develop complex SQL and T-SQL for data retrieval, transformation, validation, reconciliation, migration, root-cause analysis, and efficient processing of large datasets.

Build or support Azure data components using Azure Data Factory, Azure Functions, Azure SQL Database, Blob Storage or ADLS Gen2, Key Vault, Entra ID, and Azure DevOps, as applicable.

Other Requirements

Similar jobs