Oracle Data Integrator (ODI)

Company OverviewXIT Solutions Inc. is a dynamic leader in Tax Technology, bringing together a global network of experts dedicated to engaging, evolving, and automating innovative solutions. We are passionate about empowering organizations to harness the full potential of their data and technology landscapes. Job SummaryWe are seeking an energetic and detail-oriented Oracle Data Integrator (ODI) Specialist to join our team. In this role, you will drive the design, development, and optimization of data integration processes using Oracle Data Integrator, ensuring seamless data flow across diverse systems. Your expertise will help shape robust data pipelines that enable insightful analytics and strategic decision-making. Responsibilities Develop and maintain complex Fusion Data Intelligence (FDI) (Extract, Transform, Load) workflows using Oracle Data Integrator to support business intelligence and analytics initiatives Collaborate with database administrators and developers to optimize performance tuning for large-scale data environments Design and implement database structures, including schema design for databases such as Oracle, MySQL, SQL Server, and others Write efficient SQL queries, PL/SQL scripts, and shell scripts (Bash/Unix shell) for data manipulation and automation tasks Integrate linked data sources and utilize scripting to automate routine processes and troubleshoot issues effectively Conduct performance tuning on ETL jobs to ensure high efficiency and minimal downtime Support database administration tasks including backup, recovery, security management, and system upgrades Requirements Oracle Data Integrator (ODI) Fusion Data Intelligence (FDI) Oracle BI Apps (nice to have) Proven experience with Oracle Data Integrator (ODI) in designing scalable data integration solutions Strong proficiency in SQL, PL/SQL, MySQL, Microsoft SQL Server, and Oracle databases Hands-on experience with Fusion Data Intelligence Solid scripting skills in Bash (Unix shell), Shell Scripting, and general scripting languages for automation purposes Familiarity with Linux operating systems for server management and deployment of data solutions Knowledge of linked data concepts and how they can enhance data integration strategies Expertise in performance tuning techniques for databases and ETL workflows Analysis skills to interpret complex datasets and translate business requirements into technical solutions Understanding of database design principles and database administration best practices Join us at XIT Solutions Inc., where your expertise will directly impact the efficiency of our clients’ data ecosystems. We foster a vibrant environment that values innovation, continuous learning, and professional growth—empowering you to thrive in the ever-evolving world of data technology. Job Type: Contract Pay: $90,771.95 - $109,316.76 per year Work Location: Hybrid remote in Chelmsford, MA 01824