Oracle Data Integrator or ODI Developer

Overview

Welcome to Tech Projects! We specialize in IT System integration to help with some of the biggest names in the public sectors around New York state. Our company provides exceptional IT solutions for our clients, while also offering top-notch career opportunities for our employees.

At our firm, we work with a diverse range of clients, from cutting-edge startups to established industry leaders.

If you're a tech professional looking for a challenging and rewarding career, we'd love to hear from you. Our company offers competitive salaries, comprehensive benefits packages, and a range of professional development opportunities. Whether you're a seasoned veteran or just starting out in your career, we have a role that's perfect for you.

Thank you for considering our company as your potential employer. We look forward to hearing from you and discussing the exciting opportunities that await you at our firm.

Job Title:
Oracle Data Integrator (ODI) Developer

Location:
Edison, Nj (Hybrid)

We are seeking an experienced Oracle Data Integrator (ODI) Developer to design, develop, and maintain robust data integration solutions. The ideal candidate will have strong hands-on experience with ODI, Oracle databases, and ETL processes, and will work closely with business and technical teams to support data warehousing and analytics initiatives.

• Design, develop, test, and deploy ETL/ELT solutions using Oracle Data Integrator (ODI)
• Develop and maintain ODI mappings, packages, procedures, and load plans
• Perform data extraction, transformation, and loading from multiple source systems
• Optimize ODI jobs for performance, scalability, and reliability
• Troubleshoot and resolve data integration, performance, and production issues
• Work closely with DBAs, data architects, and business analysts to understand data requirements
• Ensure data quality, integrity, and compliance with defined standards
• Support deployment activities across development, test, and production environments
• Create and maintain technical documentation for ETL processes and workflows

• Strong hands-on experience with Oracle Data Integrator (ODI 11g/12c)
• Solid experience with Oracle Database (SQL, PL/SQL)
• Strong understanding of ETL/ELT concepts, data warehousing, and data modeling
• Experience working with large datasets and complex transformations
• Knowledge of performance tuning and optimization in ODI
• Experience with version control and deployment processes
• Strong analytical and problem-solving skills
• Excellent communication and documentation skills

• Experience with Oracle Data Warehouse (ODW) or similar platforms
• Exposure to Oracle Golden Gate, OBIEE, or Oracle Analytics Cloud
• Experience with Unix/Linux shell scripting
• Familiarity with cloud platforms (OCI, AWS, Azure)
• Experience in Agile/Scrum environments
• Experience with Go Anywhere (Managed File Transfer – MFT) is an added advantage

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience)