Data Engineer: Integration Migration

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and strive to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn.

We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it. We care about who you are in the office and as an individual. We get involved, we like to know our people, we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.

At Enroute, we are looking for a Data Engineer: Integration Migration to join a high-impact team responsible for designing, building, and evolving a customer-facing application.

The ideal candidate is confident contributing code while also participating actively in design discussions, proactive cross team collaboration.

Skills

·      Strong hands-on experience with Azure Data Factory.

·      Experience designing, developing, and supporting ETL / ELT pipelines.

·      Experience with Boomi or similar integration platforms.

·      Experience integrating with databases, flat files, APIs, cloud storage, and enterprise applications.

·      Strong SQL skills and experience working with relational databases.

·      Understanding of pipeline orchestration, dependencies, scheduling, monitoring, retry logic, and error handling.

·      Experience with data mapping, transformation logic, data validation, and migration testing.

·      Ability to analyze existing integration processes and rebuild them in a new platform.

·      Strong troubleshooting, documentation, and communication skills.

·      Ability to collaborate with database engineers, QA, architecture, and business teams.

Key Responsibilities

• Analyze existing Boomi integrations, workflows, mappings, transformations, schedules, and dependencies.

• Design and develop equivalent data pipelines in Azure Data Factory.

• Rebuild data ingestion, transformation, orchestration, and data movement processes from Boomi into ADF.

• Connect ADF pipelines to source and target systems, including Oracle, Azure SQL, files, APIs, and other relevant systems.

• Implement pipeline scheduling, parameterization, monitoring, alerting, retry logic, and error handling.

• Collaborate with database migration engineers to ensure pipelines align with migrated Azure SQL data structures.

• Support source-to-target mapping, data transformation logic, and technical documentation.

• Perform pipeline testing, data validation, and defect resolution.

• Optimize ADF pipelines for reliability, performance, and maintainability.

• Support deployment, production cutover, and post-migration stabilization activities.

• 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
  

Equal employment

Enroute is committed to providing equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training