Db2-databricks Consulting Partner

Tata Consultancy Services; Oregon; Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Family Support Leaves

401K Plan

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services Limited is seeking a senior consultant to lead enterprise-scale DB2-to-Databricks modernization and migration programs. You will guide migration strategy, target-state architecture, data governance, and security while shaping scalable modernization approaches.

The role requires 10+ years of experience in DB2 consulting and data architecture, with a focus on automation, AI-enabled capabilities, and risk mitigation.

Qualifications

• Experience in enterprise data architecture and consulting.
• DB2 consulting and migration experience to Databricks.
• Designing migration strategies, target architectures, and data architecture standards.
• Knowledge of data governance, security, and reconciliation.

Responsibilities

• Provide senior consulting and technology leadership for enterprise-scale DB2-to-Databricks modernization and migration programs.
• Define migration strategies, target-state architectures, design patterns, and data architecture standards.
• Lead current-state assessments and migration planning.
• Identify architectural gaps, dependencies, risks, and remediation strategies.
• Define repeatable frameworks for DB2 object assessment, schema and data migration, SQL translation, ETL modernization, reconciliation, testing, and cutover.
• Promote automation-first migration using accelerators and AI-enabled capabilities.
• Advise customer leadership on complex migration decisions.
• Partner with engineering and architecture teams to address legacy dependencies, SQL compatibility, workload redesign, data quality, performance, and scalability.
• Establish architecture governance and guardrails aligned with enterprise data strategy.
• Collaborate on reusable assets, automation frameworks, and migration expertise.
• Provide thought leadership and executive guidance through transformation.
• Identify opportunities to scale the approach across more DB2 workloads.

Skills

DB2 consulting

Databricks architecture

Migration strategy

Data governance

SQL translation

ETL modernization

Migration automation

Insurance domain

Enterprise data architecture

Migration planning

Job description

Role - DB2-Databricks Consulting Partner

Location - Remote

Experience Required - 10+ years

Job Summary

Provide senior consulting and technology leadership for enterprise-scale DB2-to-Databricks modernization and migration programs. Guide migration strategy, target-state architecture, data architecture, governance, security, performance, and the development of repeatable migration approaches. Serve as a technology advisor on complex architecture decisions and support the scalable modernization of DB2 workloads.

Must Have Technical/Functional Skills

• Enterprise data architecture and consulting
• DB2 consulting
• DB2-to-Databricks migration
• Database migration experience
• Databricks architecture
• Migration strategy and planning
• Data architecture, catalogs, security, and governance
• SQL and script translation
• ETL modernization
• Data reconciliation, testing, and cutover planning
• Migration automation and reusable frameworks
• Insurance domain experience

Roles & Responsibilities

• Provide senior consulting and technology leadership for enterprise-scale DB2-to-Databricks modernization and migration programs.
• Define migration strategies, target-state architectures, design patterns, and data architecture standards.
• Lead current-state assessments and migration planning.
• Identify architectural gaps, technical dependencies, migration risks, and remediation strategies.
• Define repeatable frameworks for DB2 object assessment, schema and data migration, SQL and script translation, ETL modernization, reconciliation, testing, and cutover.
• Promote an automation-first migration approach using accelerators and AI-enabled capabilities.
• Advise customer leadership on complex DB2-to-Databricks migration and architecture decisions.
• Partner with engineering and architecture teams to address legacy dependencies, SQL compatibility, workload redesign, data quality, performance, and scalability.
• Es tablish architecture governance and technical guardrails aligned with enterprise data strategy.
• Collaborate with internal practice and center-of-excellence teams on reusable assets, automation frameworks, and migration expertise.
• Provide thought leadership and executive-level guidance throughout the transformation.
• Identify opportunities to standardize and scale the migration approach across additional DB2 workloads.

Generic Managerial Skills, If any

• Provide end-to-end program leadership for DB2-to-Databricks migration.
• Establish a migration-factory operating model and wave-based execution approach.
• Coordinate parallel migration workstreams and remove cross-team dependencies and bottlenecks.
• Govern architecture, development, testing, data validation, cutover, and hypercare activities.
• Promote reusable migration patterns, automation, KPI-based execution, and timely decision-making.
• Maintain data quality, production stability, and business continuity throughout migration.

Base Salary Range : $120,000 to $150,000 Per Annum

TCS Employee Benefits Summary:

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Location

Remote, OR