> Markdown version of [/jobs/ext/3104502-lead-data-architect-oracle-to-databricks-migration](https://www.wearedevelopers.com/jobs/ext/3104502-lead-data-architect-oracle-to-databricks-migration). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Architect - Oracle to Databricks Migration - **Company:** Cognizant Technology Solutions Corporation - **Location:** New York, NY, United States - **Experience:** Expert - **Salary:** $155,000.0 - $175,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Big Data, Code Generation, Data Architecture, Information Engineering, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Warehousing, Oracle Exadata, Apache Hive, Oracle Databases, Oracle (Applications), Oracle Warehouse Builder, Performance Tuning, Cloud Services, Azure Data Lake, PL-SQL, Data Ingestion, Informatica Powercenter, Data Layers, Data Lakes, Pyspark, Databricks - **Published:** September 27, 2026 - **Apply:** https://dejobs.org/x/x/1CFA6FEE102A415691DFAEE92CDB80B2/job/ ## About the Role * 15+ years of experience in enterprise data engineering, data architecture, or large-scale data platform modernization initiatives. * Proven experience leading Oracle data warehouse migrations to Azure Databricks Lakehouse environments, including Oracle Exadata, Delta Lake, Databricks SQL, and cloud-native data architectures. * Strong hands-on expertise with Oracle databases, PL/SQL, schema design, performance tuning, and enterprise-scale data migration strategies. * Advanced experience developing and optimizing PySpark and Spark SQL solutions for complex data transformation and processing workloads. * Demonstrated success leading client-facing technical engagements, managing escalations, and driving issue resolution throughout all phases of project delivery. * Experience designing and implementing data governance, security, lineage, and access control frameworks using Unity Catalog or similar enterprise governance platforms. * Ability to lead and coordinate distributed teams across onshore and offshore locations while collaborating effectively with client stakeholders and delivery leadership. * Willingness to work onsite in New York, NY, a minimum of three days per week throughout the engagement. These will help you stand out * Experience with Databricks Lakebridge and automated migration acceleration frameworks. * Experience with Lakeflow Connect, data ingestion modernization, and large-scale historical and incremental data migration initiatives. * Knowledge of Informatica PowerCenter architecture, workflow migration, and ETL modernization strategies. * Experience supporting healthcare, payer, provider, clinical, or operational healthcare data environments. * Familiarity with AI-assisted development tools, automated code conversion frameworks, and human-in-the-loop engineering practices. * Experience leading enterprise testing, parallel run activities, production cutovers, and legacy platform decommissioning programs. We're excited to meet people who share our mission and can make an impact in a variety of ways. Don't hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role. ## Description As a Lead Data Architect - Oracle to Databricks Migration , you will make an impact by leading the end-to-end modernization of a large-scale enterprise data warehouse environment from Oracle Exadata to Azure Databricks Lakehouse. You will be a valued member of the Data Engineering team and work collaboratively with client stakeholders, Cognizant leadership, offshore delivery teams, and cross-functional data professionals to deliver a successful cloud transformation initiative. In this role, you will: * 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. Work model We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role's business requirements, this is a hybrid position requiring a minimum of three days per week in a client office in New York, NY . Regardless of your working arrangement, we are here to support a healthy work-life balance through our various wellbeing programs. The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations. ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)