Technical Lead (IN)

HCLTech

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

Job description

Seeking a seasoned Data Analyst with a minimum of 5 years of professional experience to join our team. This role involves deep dives into data, ensuring accuracy, and optimizing data processes.

We are looking for an individual proficient in Python and SQL to build robust data solutions and drive data integrity across various platforms. The ideal candidate will possess strong analytical skills and a keen eye for detail, essential for complex data reconciliation tasks.

Responsibilities

Key responsibilities include the design, development, maintenance, and optimization of Python applications, reusable modules, prototypes, and automation scripts. You will be responsible for analyzing and reconciling data across Murex, FDR, data warehouses, and other internal applications.

Leverage Python for data ingestion, transformation, validation, comparison, reconciliation, and export across diverse formats including JSON, XML, CSV, Excel, databases, APIs, web services, and legacy sources. Perform in-depth data analysis and profiling to understand source structures, identify trends, anomalies, 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 advanced SQL and T-SQL queries for data retrieval, transformation, validation, reconciliation, migration, root-cause analysis, and efficient processing of large datasets. Build or support Azure data components utilizing Azure Data Factory, Azure Functions, Azure SQL Database, Blob Storage or ADLS Gen2, Key Vault, Entra ID, and Azure DevOps as required.

Qualifications

This role requires a candidate with at least 5 years of experience in data analysis and development. Proficiency in Python is essential for creating and optimizing applications and automation scripts.

Strong capabilities in SQL and T-SQL are necessary for complex data manipulation, retrieval, and processing. Experience with data reconciliation across various systems like Murex and FDR is crucial.

Familiarity with cloud platforms, particularly Azure, is important for building and supporting data components. This includes hands-on experience with services such as Azure Data Factory, Azure Functions, Azure SQL Database, Blob Storage, ADLS Gen2, Key Vault, Entra ID, and Azure DevOps.

Essential Skills

PythonData AnalysisData ReconciliationSQLT-SQLAzure Data FactoryAzure FunctionsAzure SQL DatabaseBlob StorageADLS Gen2Key VaultEntra IDAzure DevOps

Highlights

  • Actively hiring

More Details

RoleTechnical Lead (IN)
Employment TypeFull Time, Remote

About the Company

HCLTech logo

HCLTech

IT Consulting