ODI Developer

• The engineer/developer is working closely with his team members and business teams to develop features according to a requirement.
• He must also ensure that developments are aligned with best practices and monitor what has been promoted on higher environments.
• Production or tests environments supports activities are also part of the position (job monitoring, issues solving, )

Responsibilities

- Participate to all the Agile ceremonies of the squad (Dailys, Sprint plannings, backlog refinements, reviews, etc)

- Communicate ASAP on the blocking points

- Estimate, design and build technical solution for business needs & requirements according to the Jira requirements (Change, bug fixing, ).

- Do the unit tests of the code developed to deliver the code for user acceptance test

- Design technical solution for business needs & requirements

- Maintain a clean code or a robust infrastructure (depending on developer / OPs expertise)

- Raise technical improvements and impediments

- Accountable to deliver the amount of jira tickets assigned to him/her during a sprint

- Accountable to do the daily support/monitoring

- Accountable to contribute to the Engineer Chapter events and Tribe community (Guild with the Engineer Techlead)

- Accountable on the platform behavior ensure platform is up and running (stability) with the tech lead and other members of the guild

- Proficiency in Oracle ODI tools and Oracle PL/SQL.

- In-depth knowledge of ODI Master and Work Repositories.

- Integrating ODI with multiple sources/targets.

- Managing errors using ODI and PL/SQL.

- Strong database development skills (SQL/PLSQL) for PL/SQL-based applications.

- Creating packages, procedures, functions, triggers, views, materialized views, and exception handling.

- Data migration using SQL*Loader, import/export.

- Solid understanding of ELT/ETL concepts, design, and coding.

- Experience with partitioning and indexing strategies for optimal performance.

• Be autonomous on his asset (Senior to expert level) and motivated on the daily tasks.
• Be an active member of the squad (often multi-technologies).
• Be proactive by raising alerts when its flagged, try to understand the global context and suggest how to solve an issue (without focusing only on his subpart). It will also help to understand better the rest of the team (who will not necessarily work on the same tool)
• Be able to provide proof that developments match the requirement (tests cases)
• Have proper communication with the Business. (English language)
• Have some knowledge regarding deployment/versioning tools (Git, Jenkins, )
• Have some knowledge on project tracking software (Jira, QC, )
• Have some knowledge regarding monitoring tools (Centreon, Dynatrace, )
• Have a strong background in SQL and be able to check some test cases on his own directly by launching some SQL requests on the different databases
• Provide his technical expertise to suggest optimization and technical enhancements
• Unix/Windows

Specific Technical skills required for this role:

• Oracle Data Integrator (currently v12.2.1.4) - Having some admin notions is not mandatory but can be an advantage
• Some knowledge of BI (data warehouse oriented) can be an advantage.
• SQL