Lead Data Architect: Oracle to Databricks Lakehouse

Cognizant; New York (NY); Hybrid; USD 155,000 - 175,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

Paid holidays + PTO

401(k) plan

Job summary

Cognizant seeks a Lead Data Architect to modernize a large-scale data warehouse from Oracle Exadata to Azure Databricks Lakehouse. Lead architecture, design Bronze/Silver/Gold layers, and oversee migrations with a focus on data quality, security, and performance.

The role requires 15+ years in data engineering, strong Oracle and Databricks expertise, and willingness to be onsite in New York at least three days per week. Hybrid work model offered.

Qualifications

• 15+ years of experience in enterprise data engineering, data architecture, or large-scale data platform modernization initiatives.

Responsibilities

• Lead the technical architecture and delivery of Oracle Exadata-to-Databricks migrations, ensuring data integrity, performance, scalability, and alignment with business requirements.
• Design and oversee Azure Databricks Lakehouse solutions, including Bronze, Silver, and Gold data layers, Delta Lake architecture, ADLS Gen2 integration, and enterprise orchestration frameworks.
• Drive the modernization of ETL workloads by converting Informatica PowerCenter processes into PySpark and Spark SQL solutions while validating and optimizing AI-assisted code generation outputs.
• Establish and govern enterprise data quality, reconciliation, security, lineage, and compliance controls through Unity Catalog and standardized validation frameworks.
• Serve as the primary technical advisor and escalation point for the client, leading issue resolution, production readiness activities, performance optimization efforts, and successful production cutovers.

Skills

Oracle Exadata

Azure Databricks Lakehouse

Delta Lake

Databricks SQL

PySpark

Spark SQL

PL/SQL

Data governance

Unity Catalog

Data migration strategies

Leadership

Distributed teams

ADLS Gen2

ETL modernization

Oracle databases

Tools

Informatica PowerCenter

Unity Catalog

ADLS Gen2

Databricks

Lakehouse architectures

Job description

Cognizant seeks a Lead Data Architect to modernize a large-scale data warehouse from Oracle Exadata to Azure Databricks Lakehouse. Lead architecture, design Bronze/Silver/Gold layers, and oversee migrations with a focus on data quality, security, and performance.

The role requires 15+ years in data engineering, strong Oracle and Databricks expertise, and willingness to be onsite in New York at least three days per week. Hybrid work model offered.