Senior Data Integration Engineer (2/967)
InfoletSUMMARY
💰150 - 180 PLN/h on B2B
📍Remote or hybrid (Kraków)
🕐Project: 3 months
🧩 Working model: We offer a flexible engagement model – you can join us either full-time or part-time (20 hours per week). Working hours are flexible, allowing you to organize your schedule in a way that works best for you.
💼 Senior
PROJECT
We are looking for a Senior Data Integration Engineer to join a team responsible for a large-scale Customer & Partner Data Platform.
The platform integrates data from multiple enterprise systems, including ERP, CRM, ITSM, licensing, ticketing and legacy applications, and processes millions of records every day to support customer-facing solutions.
You will work with a mature integration ecosystem based primarily on Oracle Data Integrator, Oracle Database and PostgreSQL, taking ownership of existing data flows as well as designing and delivering new integrations.
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
OUR OFFER
- Benefits: Extended medical care (over 2000 medical facilities in Poland, 80 in Kraków) for you and your family; Multisport card; Life insurance