Data Engineer – Database Migration

Role Overview

• Analyze existing Oracle schemas, tables, views, stored procedures, functions, indexes, and related database objects
• Support the migration of database structures and data from Oracle to Azure SQL
• Identify compatibility gaps between Oracle and Azure SQL and propose remediation approaches
• Convert or refactor Oracle SQL, PL/SQL, stored procedures, functions, and views into Azure SQL-compatible equivalents
• Support source-to-target mapping, data profiling, and migration analysis
• Perform data validation, reconciliation, and quality checks between Oracle and Azure SQL
• Optimize migrated database objects for performance, scalability, and maintainability
• Collaborate with ETL / ADF engineers to ensure pipelines align with the target data model
• Document migration findings, conversion decisions, validation results, and technical recommendations
• Support testing, defect resolution, production migration, and post-migration stabilization activities
• Troubleshoot performance, compatibility, and data quality issues throughout the migration lifecycle

Requirements

• 5+ years of professional experience working with relational databases and data engineering initiatives
• Strong experience with SQL Server and/or Azure SQL environments
• Strong hands-on experience with Oracle databases, including SQL and PL/SQL
• Experience migrating schemas, tables, views, stored procedures, functions, indexes, and related database objects
• Ability to analyze and convert Oracle SQL / PL-SQL logic into Azure SQL-compatible equivalents
• Strong understanding of relational database design principles
• Experience with query optimization, indexing strategies, and performance tuning
• Strong experience troubleshooting database compatibility and migration issues
• Experience performing data profiling, source-to-target mapping, and migration analysis
• Strong experience with data validation, reconciliation, and migration testing
• Experience identifying and resolving data quality and consistency issues
• Ability to support production migration and post-migration stabilization activities
• Advanced Transact-SQL (T-SQL)
• Strong SQL development experience across Oracle and Microsoft SQL environments
• Experience optimizing complex queries, stored procedures, and database objects
• Strong understanding of scalability, maintainability, and database performance best practices
• Experience working with Azure SQL environments
• Experience collaborating with ETL and Azure Data Factory (ADF) teams
• Strong documentation and communication skills
• Ability to work cross-functionally with QA, architecture, engineering, and business stakeholders

Tech Stack

• Azure
• ETL
• Oracle
• SQL

Benefits

• Monetary compensation
• Year-end Bonus
• IMSS, AFORE, INFONAVIT
• Major Medical Expenses Insurance
• Life Insurance
• Funeral Expenses Coverage
• TDU Membership
• MediAccess
• Health Check-Up Subsidy
• Preferential rates for car insurance
• Vacations
• Official Mexican Holidays
• Life Happens Days
• Bereavement Leave
• Civil Marriage Leave
• English Classes
• Certifications
• Educational Agreements (Talisis, U-ERRE, UNID, TecMilenio, Tec de Monterrey, UDEM, SPIS)
• Corporate Agreements & Discounts (Sorteos Tec, Envia Flores, TopGolf)
• Taquitos Rewards
• Birthday Bonus
• Work-from-home Bonus
• Laptop Policy**