Senior Data Integration Engineer

SUMMARY

📍Remote or hybrid (Kraków)

⏱ Project: 3 months

YOU WILL

• 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

MUST HAVE

• Strong commercial experience with PL/SQL, including:
  • packages and procedures
  • MERGE operations
  • JSON / JSON_TABLE
  • SAVEPOINTs and transaction management
  • autonomous transactions
  • structured exception handling
• Strong 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
• Python, Node.js or Java experience 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