Senior Data Integration Engineer

Infolet supports IT leaders by providing technology experts and operational support, including legalization of residence and work for international IT specialists. Their projects involve specialists in Java, JavaScript, embedded C, C++, PHP, mobile, software testing, network and system administration, and more.

• Strong commercial experience with PL/SQL including packages, procedures, MERGE operations, JSON / JSON_TABLE, SAVEPOINTs, transaction management, autonomous transactions, and structured exception handling
• Hands-on experience with Oracle Data Integrator 12c
• Very good knowledge of Oracle SQL, including analytical functions and complex data transformations
• Good knowledge of PostgreSQL, including schemas, indexes, PL/pgSQL, and JSONB
• Experience designing and implementing REST integrations
• Good understanding of data integration patterns, reliability, idempotency, and error handling
• Experience working with large and complex existing codebases
• Ability to independently analyse data flows and troubleshoot integration issues

Nice to have:

• Salesforce experience, particularly External Objects and Heroku Connect
• Experience with MuleSoft / DataWeave
• Knowledge of Oracle REST Data Services (ORDS)
• Experience with Heroku Postgres and Dynos
• Experience in Python, Node.js, or Java for monitoring, automation, or API development
• Experience with Oracle E-Business Suite
• Exposure to Salesforce Data Cloud or BigQuery
• Experience with Flyway, Git, and AI-assisted development tools

• Design and develop end-to-end data integration flows across enterprise systems
• Build and maintain ODI 12c mappings, procedures, and load plans
• Develop and enhance complex PL/SQL packages, procedures, and database logic
• Work with large-scale Oracle database environments, including staging and warehouse layers
• Design and maintain PostgreSQL schemas, indexes, and PL/pgSQL functions
• Implement reliable data processing mechanisms including idempotency, error handling, transaction management, and retry logic
• Design and maintain REST-based integrations and callbacks
• Lead data migrations including source profiling, data modelling, bulk loading, deduplication, validation, and cut-over
• Troubleshoot complex data issues and trace data lineage across multiple systems
• Maintain and evolve a large existing integration codebase while ensuring stability and backward compatibility
• Collaborate with teams working with Salesforce, APIs, and downstream customer-facing applications