Sr. Software Engineer – Data Engineering (Oracle / ODI / OAS)

7 to 10 Years

United Kingdom

Sr. Software Engineer role focusing on Data Engineering - Data Analytics - ODI (Technical) and Data Engineering - Database - Oracle (Technical). Candidate must have relevant experience of 7 to 10 Years. The role involves designing, developing, and supporting Oracle-based data warehousing, ETL, and reporting solutions using ODI, Oracle Database, and OAS to enable robust analytics and reporting for the business.

• Designed, developed, and implemented ODI (Oracle Data Integrator) mappings for ETL processes.
• Designed, developed, and implemented Data Warehouse solutions including data modelling and integration.
• Developed and implemented OAS reports and dashboards to support business analytics and reporting needs.
• Provided production support for existing live OAS, ODI, data warehouse objects.
• Analysed and resolved data, ETL, and reporting issues to ensure system stability.
• Performed performance tuning of RPD objects, ODI mappings, queries, and reports.
• Maintained and documented standard processes, procedures, and technical documentation.
• Collaborate with cross-functional teams to understand data requirements and translate them into scalable data warehouse and reporting solutions.
• Ensure data quality, integrity, and consistency across data warehouse, ETL, and reporting layers.
• Participate in code reviews, design reviews, and continuous improvement of data engineering practices.
• Support release management, deployment activities, and post-release validation for ODI, Oracle, and OAS components.

• Strong problem-solving and analytical skills for diagnosing complex data and performance issues.
• Ability to work independently and as part of a distributed team in a fast-paced environment.
• Strong communication skills to interact with business stakeholders and technical teams.
• Attention to detail with a focus on quality, maintainability, and reusability of data solutions.
• Willingness to learn and adapt to new tools, technologies, and data engineering best practices.

• Good SQL/PLSQL and good ODI are required.
• General Oracle database knowledge in the Data Warehousing area.
• Hands-on experience with Data Engineering - Data Analytics - ODI (Technical).
• Hands-on experience with Data Engineering - Database - Oracle (Technical).
• Experience in designing, developing, and implementing ODI mappings for ETL processes.
• Experience in designing, developing, and implementing Data Warehouse solutions including data modelling and integration.
• Experience in developing and implementing OAS reports and dashboards to support business analytics and reporting needs.
• Experience providing production support for existing live OAS, ODI, and data warehouse objects.
• Experience analysing and resolving data, ETL, and reporting issues to ensure system stability.
• Experience performing performance tuning of RPD objects, ODI mappings, queries, and reports.
• Experience maintaining and documenting standard processes, procedures, and technical documentation.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent experience.