About the position
At Certegy, we're helping to change the payments landscape by providing faster, and more efficient ways to securely connect retailers and consumers. Our technology provides both traditional and cutting-edge techniques for merchants to accept and verify payments. Our clients range in size from locally owned small businesses to the largest retailers in America, many of which have relied on us for over fifty years to provide check verification and warranty services, Automated Clearing House (ACH) payment solutions, and risk management expertise. As an Oracle ODI Developer, you will be responsible for designing, developing, and implementing data integration solutions using the Oracle Data Integrator toolset as well as developing and maintaining Oracle Apex applications. You will collaborate closely with stakeholders, including business analysts, project managers, and other technical teams to ensure successful delivery of Oracle projects.
Responsibilities
- Designing and developing ETL (Extract, Transform, Load) processes using Oracle Data Integrator (ODI) toolset.
- Collaborating with business analysts and business users to gather ETL requirements translating them into technical specifications.
- Developing and optimizing SQL queries and stored procedures for data extraction and transformation.
- Creating and maintaining technical documentation related to ETL processes and data integration workflows.
- Performing unit testing and supporting system testing and user acceptance testing phases.
- Troubleshooting and resolving issues related to data integration processes.
- Design, develop, and maintain Oracle Apex applications based on business requirements.
- Customizing and extending Oracle Apex applications using PL/SQL, SQL, HTML, CSS, and JavaScript.
Requirements
- Proven experience as an Oracle ODI Developer.
- Strong proficiency in Oracle Data Integrator (ODI) toolset, including ODI Studio, ODI Console, and ODI Agent.
- Solid understanding of data warehousing concepts and dimensional modeling.
- Proficiency in SQL programming and performance tuning techniques.
- Experience with Oracle databases (SQL, PL/SQL).
- Ability to design and implement Oracle Apex applications from scratch as well as customize existing applications.
- Experience developing with Python.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills.
Nice-to-haves
- Experience with JavaScript and HTML5.
- Familiarity with ACH payment solutions.
