Key skills
AzureCloudETLOracleSQLELTAzure SQLCloud StorageCommunication
About this role
Role Overview
- 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.
Requirements
- 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.
Tech Stack
- Azure
- Cloud
- 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**