Azure Data Architect: Delta Lake, Synapse & Pipelines

HCL Technologies Limited; Washington (District of Columbia); Hybrid; USD 150,000 - 190,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

401(k) retirement plan

Paid time off

Job summary

HCLTech in Washington, DC is seeking a senior Azure data engineer to design and implement scalable data pipelines, manage data architecture, and drive cloud migration initiatives. The role emphasizes Azure Data Factory, Synapse, Delta Lake, and real-time data warehousing across large enterprise environments.

The ideal candidate will have 15+ years of experience in data migration, architecture, and integration, with strong SQL/Oracle skills and a track record of delivering end-to-end Azure

Qualifications

• Expertise on Azure platforms including Azure Databricks, ADLS, and its various components.
• In-depth knowledge and hands-on experience in Microsoft Azure data stack i.e., Azure Data Factory, Azure SQL Database, Azure Functions, Logic apps, Spark and Python programming etc.
• Expertise on Azure platforms including Azure Databricks and its various components, including Delta Lake.
• Strong understanding of data architecture and data management principles.
• In-depth Knowledge on designing ETL Pipelines for Batch and Real time in Azure data factory and Azure datafactory.
• Hands on experience on Function apps, Event Hubs, Web apps, API M.
• Good have to experience on Migration to Salesforce
• Strong experience with designing ETL/ELT Pipelines/Data flows using Azure Data Factory as Primary skill and SSIS/Informatica as additional skills.
• Proficiency in programming languages such as Python, SQL, Spark notebooks and Scala.
• Must have strong development & design skills in leading RDBMS environments e.g. MS SQL Server and Oracle 10g.
• Experience of Big data approach, architectural concepts, data sourcing/ ingestion/ curation and storage mechanisms.
• Experience with real-time / near-real-time Data warehousing concepts and Design approaches.
• 8 – 10 years of experience in Data Modeling, Data/ Information Architecture, Metadata Management, Master Data management, Data Governance & Data Quality.
• Should have executed end-to-end projects focusing on Azure Synapse Delta lake.
• Leveraging components like Azure Automation, Azure Power Shell Scripting, Az Copy, Devops/ARM Templates.
• Should have thorough understanding of Data-lakes, Delta-lakes, raw/enriched/curated layer concepts and ETL within Azure framework
• Overall professional experience of 15+ years, with strong focus on enterprise data migration, system modernization, and integration initiatives.
• Deep understanding of Oracle PL/SQL logic and database behavior, with demonstrated ability to analyze and reverse engineer complex legacy implementations.
• Proven experience translating legacy database logic into cloud based data migration and integration solutions.
• Strong hands on experience with Azure Data Factory, Azure Data Lake, and cloud based data processing workflows.

Responsibilities

Skills

Azure Databricks

Azure Data Factory

Azure Synapse

Python

SQL

Spark

Scala

Oracle SQL

ETL/ELT Pipelines

Tools

MS SQL Server

Oracle

SSIS

Informatica

Job description

HCLTech in Washington, DC is seeking a senior Azure data engineer to design and implement scalable data pipelines, manage data architecture, and drive cloud migration initiatives. The role emphasizes Azure Data Factory, Synapse, Delta Lake, and real-time data warehousing across large enterprise environments.

The ideal candidate will have 15+ years of experience in data migration, architecture, and integration, with strong SQL/Oracle skills and a track record of delivering end-to-end Azure