We love technology, and we enjoy what we do. We are always looking for innovation and continuous improvement. At Enroute, we are looking for a Data Engineer with strong database migration expertise to support the migration of enterprise Oracle environments into Azure SQL.This role will focus on analyzing existing Oracle databases, migrating schemas and data structures, converting PL/SQL logic into Azure SQL-compatible solutions, and ensuring migrated environments are optimized, scalable, and reliable.The ideal candidate has strong hands-on experience with Oracle, SQL Server/Azure SQL, Transact-SQL, database migrations, and performance optimization across enterprise environments.Requirements✅ Must-Have RequirementsDatabase Engineering & Migration5+ years of professional experience working with relational databases and data engineering initiativesStrong experience with SQL Server and/or Azure SQL environmentsStrong hands-on experience with Oracle databases, including SQL and PL/SQLExperience migrating schemas, tables, views, stored procedures, functions, indexes, and related database objectsAbility to analyze and convert Oracle SQL / PL-SQL logic into Azure SQL-compatible equivalentsStrong understanding of relational database design principlesExperience with query optimization, indexing strategies, and performance tuningStrong experience troubleshooting database compatibility and migration issuesData Migration & ValidationExperience performing data profiling, source-to-target mapping, and migration analysisStrong experience with data validation, reconciliation, and migration testingExperience identifying and resolving data quality and consistency issuesAbility to support production migration and post-migration stabilization activitiesSQL Development & OptimizationAdvanced Transact-SQL (T-SQL)Strong SQL development experience across Oracle and Microsoft SQL environmentsExperience optimizing complex queries, stored procedures, and database objectsStrong understanding of scalability, maintainability, and database performance best practicesCloud & CollaborationExperience working with Azure SQL environmentsExperience collaborating with ETL and Azure Data Factory (ADF) teamsStrong documentation and communication skillsAbility to work cross-functionally with QA, architecture, engineering, and business stakeholders🎯 ResponsibilitiesAnalyze existing Oracle schemas, tables, views, stored procedures, functions, indexes, and related database objectsSupport the migration of database structures and data from Oracle to Azure SQLIdentify compatibility gaps between Oracle and Azure SQL and propose remediation approachesConvert or refactor Oracle SQL, PL/SQL, stored procedures, functions, and views into Azure SQL-compatible equivalentsSupport source-to-target mapping, data profiling, and migration analysisPerform data validation, reconciliation, and quality checks between Oracle and Azure SQLOptimize migrated database objects for performance, scalability, and maintainabilityCollaborate with ETL / ADF engineers to ensure pipelines align with the target data modelDocument migration findings, conversion decisions, validation results, and technical recommendationsSupport testing, defect resolution, production migration, and post-migration stabilization activitiesTroubleshoot performance, compatibility, and data quality issues throughout the migration lifecycle✨ Nice-to-Have Requirements (Extras)Experience with Azure Data Factory (ADF)Exposure to cloud-native data architecturesExperience with automated migration tools and schema conversion toolsFamiliarity with CI/CD workflows for database deploymentsExperience supporting enterprise-scale modernization initiativesKnowledge of data governance and database security best practicesExposure to Agile/Scrum environmentsBenefitsMonetary 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 </