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 effective 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.

Must Have Skill

Murex,Python,TSQL

Good to Have Skill

Azure Data Factory (ADF),Azure Data Lake

Other Requirements

📌 Technical Lead (Chennai)
🏢 HCLTech
📍 Chennai