Data Engineer
New
E
EnrouteData Engineering
Dinastía, Nuevo León, MexicoFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years
- Required Skills
- Microsoft SQL ServerOracle
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
- Advanced Transact-SQL (T-SQL)
- Strong documentation and communication skills
Responsibilities
- 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
View Full Description & ApplyYou'll be redirected to the employer's site