Oracle Retail Data Architect

Tata Consultancy Services Limited; México; On-site; MXN 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services Limited in Mexico is seeking an experienced Oracle Retail Data Architect to define target data architecture and lead data modeling, migration, integration, governance, and quality initiatives across critical retail domains.

The ideal candidate will have strong experience with high-volume retail data and collaborate with functional, technical, integration, reporting, and business teams.

Qualifications

• 10–16 years of relevant experience in data architecture.
• Retail data modeling and architecture experience.
• Knowledge of retail domains: merchandising, inventory, pricing, invoicing, and sales.
• Experience with data migration, conversion, reconciliation, and archival for Oracle Retail.
• Strong Oracle Database, SQL, PL/SQL, and high-volume data processing skills.
• Understanding of Oracle Retail interfaces, RICS/RIB, batch processing and data flows.

Responsibilities

• Define target-state data architecture, canonical data models, data flows, and integration principles.
• Lead source-to-target mapping and data migration design.
• Manage data cleansing, transformation, reconciliation, archival, and cutover planning.
• Establish data quality, governance, security, retention, lineage, and audit controls.
• Collaborate with functional, technical, integration, reporting, and business teams to resolve data-design decisions.

Skills

Data Architecture

Data Modeling

Stakeholder Collaboration

Data Governance

Tools

Oracle Database

SQL

PL/SQL

Job description

We are looking for an experienced Oracle Retail Data Architect to support a large-scale Oracle Retail transformation. This role will be responsible for defining the target data architecture and leading data modeling, migration, integration, governance, and quality initiatives across critical retail domains.

The ideal candidate has strong experience working with high-volume retail data and collaborating with functional, technical, integration, reporting, and business teams.

Key responsibilities

• Define target-state data architecture, canonical data models, data flows, and integration principles.
• Lead source-to-target mapping and data migration design.
• Manage data cleansing, transformation, reconciliation, archival, and cutover planning.
• Establish data quality, governance, security, retention, lineage, and audit controls.
• Collaborate with functional, technical, integration, reporting, and business teams to resolve data-design decisions.

Required qualifications

• 10–16 years of relevant experience.
• Strong experience in data architecture and data modeling within retail environments.
• Knowledge of retail merchandising, inventory, pricing, invoice matching, and sales domains.
• Experience designing data migration, conversion, reconciliation, and archival solutions for Oracle Retail implementations.
• Strong knowledge of Oracle Database, SQL, PL/SQL, data-quality controls, and high-volume retail data processing.
• Understanding of Oracle Retail interfaces, RICS/RIB, batch processing, and upstream/downstream data flows.

Nice to have

• Oracle Retail SaaS Cloud or Oracle Cloud Infrastructure experience.
• Knowledge of Oracle Integration Cloud, REST APIs, reporting platforms, and data integration.
• Experience with metadata management, data lineage, security, and master data management.
• Performance tuning and reconciliation-framework experience