USM Business Systems

JB061527 - ODI Developer

USM Business Systems • $145K *
Boston, MA 02115Hybrid
Information Technology
5 - 7 years of experience
4 weeks ago
Job Overview by Ladders

Qualifications

  • 7+ years of experience in ODI, Oracle Data Warehouse, and PL/SQL coding.
  • Proficiency in scripting with Python and Unix.
  • Experience in building Pl/SQL queries and understanding data modeling principles.
  • Knowledge of ODI administration including agent setup and log configuration.
  • Familiarity with agile methodologies and CI/CD practices.

Responsibilities

  • Design and develop ETL/ELT pipelines using Oracle Data Integrator.
  • Build and manage ODI mappings, packages, and load plans for data integration.
  • Collaborate with cross-functional teams to define data requirements and solutions.
  • Monitor and troubleshoot ODI workflows and RMJ jobs in Linux.
  • Optimize ETL workflows for improved reliability and performance.
  • Document data processes and maintain best practices for reference.
  • Conduct technical research and provide solutions to enhance application design.

Benefits

  • Opportunity for long-term contract through 2026 with potential for extension.
  • Hybrid work arrangement with flexibility for local candidates.
  • Engagement in a collaborative team environment in the financial services sector.
Full Job Description
  • Start Date: Interview Types Video Call
  • Skills ETL/ELT,ODI,PL/SQL c.. Visa Types H1B, Green Card, US ..


    • Title: ODI Developer

    Location: Boston, MA(Hybrid)

    Duration: End of 2026 + extension

    Note: This is 3 days onsite role in Boston so looking for local candidates and client is not looking to consider relocation candidates.

    Rate: $70per hour on W2

    USC/GC/H1B

    Tope 5 Must haves:

    • ETL/ELT
    • ODI
    • PL/SQL coding
    • 7 years' experience
    • Knowledge on how to be an admin side of things (not day to day but is able to do that)
    • Scripting - Python & Unix Scripting


    Senior ODI Developer

    Role Overview:

    Seeking a highly skilled and experienced Sr. ODI Developer to join our Private Banking Systems team. The ideal candidate will possess expertise in a range of technologies, including ODI (Oracle Data Integrator), Oracle Data Warehouse, Linux, Python scripting, and have a deep understanding of the Banking domain is a big plus. As a Data Engineer, you will play a pivotal role in designing, developing, and maintaining data solutions.

    Key Responsibilities:

    • Build ODI mappings/interfaces, packages, procedures, scenarios, topology configuration, ODI Agent and load plans to integrate data from multiple enterprise systems.
    • Expertise in building Pl/SQL queries, procedures, data loading process, ensuring high-performance and scalability to meet the evolving data needs of the various applications.
    • Design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI).
    • Collaborate effectively with cross-functional teams, including other data engineers, DBA group, analysts, and business stakeholders, to understand data requirements and deliver solutions.
    • Monitor and troubleshoot RMJ jobs, ODI workflows, sessions, agents, and data pipelines on Linux environments.
    • Perform root cause analysis for failures related to ODI workflows, RMJ jobs, network connectivity, API integrations, and file transfers.
    • Optimize ETL workflows to improve reliability, performance, and scalability.
    • Use scripting and automation tools to support data processing and operational workflows.
    • Work in Linux/Unix environments, using command-line tools and shell scripts for job automation and troubleshooting.
    • Maintain comprehensive documentation of data processes, configurations, and best practices.
    • Participate in walk-throughs which review program specifications, source code, and all technical supporting documentation, including screens/reports. Provide feedback in accordance with team standards and guidelines.
    • Participate in implementation of changes, enhancements, and newly developed programs.
    • Conduct technical research and provide recommendations, develop proofs of concept or prototypes, contributing to technical design of applications.
    • Helping to identify coding patterns and anti-patterns and enforce implementation of the patterns through code reviews.
    • Quickly resolving issues encountered by business lines in the production environment, maintaining a helpful, "high touch" approach to working with business users, performing root cause analysis, technology evaluation, and performance tuning.


    Desired Qualifications:

    • Degree in Computer Science, Engineering or related technical area
    • 7+ years of extensive hands-on experience in ODI, Oracle Datawarehouse, Oracle PL/SQL, Linux, Python scripting, and ODI admin module (ODI Agent setup, logs configuration, certificate installation).
    • Must have experience in building Pl/SQL queries for Oracle Server (incl. stored procedures, functions...) and must understand basic principles of data modeling
    • Excellent collaborative and communication skills, particularly in high-stress situations
    • Experience with scripting Python and Linux scripting, CLE, networking fundamentals (API, IP/ports, SFTP/FTP connectivity)
    • High proficiency in development practices: unit testing, Continuous Integration (CI/CD), refactoring, clean code
    • Experience with Bitbucket/GIT source control management
    • Problem solving skills, able to determine upcoming risks & issues and address them accordingly.
    • Ability to interpret and troubleshoot applications using logs.
    • Pro-active approach and good communication skills.
    • Experience with agile methodologies (Scrum, Kanban) and tools (Jira)


    Nice to Have:

    • Private Banking domain experience.
    • Working experience in a financial service industry
    • Financial application knowledge like FIS AddVantage, CRD, CRM Pivotal.
    • Experience with Apache Airflow for workflow orchestration.
    • Knowledge of dbt (Data Build Tool) for modern data transformations.
    • Exposure to cloud data platforms or hybrid data architectures.


    Key Competencies:

    • Strong analytical and problem-solving skills
    • Ability to work with large-scale enterprise data environments
    • Excellent collaboration and communication skills
    • Ability to manage multiple priorities in a fast-paced environment
    • Commitment to continuous learning and technology innovation

    About USM Business Systems

    USM is a company which develops game apps for iPhone

    USM Careers

    Joining USM presents an unparalleled opportunity to become part of a leading team of professionals dedicated to pioneering innovations in their industry. USM stands as a beacon of excellence, offering a plethora of job opportunities that cater to a diverse range of skills and professional interests.

    Explore Career Opportunities

    USM is actively seeking talented individuals for various positions across the company. With a commitment to diversity and leadership development, USM provides an environment where every employee can thrive. The company values the growth of its team members and supports this with comprehensive benefits and professional development opportunities.

    Innovation and Leadership at USM

    At the core of USM's success is a culture steeped in innovation and leadership. The company is renowned for its dynamic approach to challenges and its ability to lead market trends. Professionals at USM are encouraged to lead projects that stretch their capabilities and foster significant industry advancements.

    USM's Commitment to Professional Growth

    Career advancement is a cornerstone of USM's ethos. The company offers extensive training programs, including leadership and diversity training, to ensure that all team members have the tools they need to succeed. USM's commitment to professional growth is evident in its robust internal promotion and career development pathways.

    Internship Programs and Entry-Level Positions

    For those starting their careers, USM provides a range of internship and entry-level job opportunities. These positions are designed to build foundational skills and integrate new professionals into the industry effectively. Interns at USM gain valuable hands-on experience, working alongside seasoned experts and contributing to impactful projects.

    Networking and Career Development

    USM encourages its employees to engage in networking within the professional community, enhancing their career prospects and industry knowledge. The company hosts regular events and seminars, fostering a network of motivated, forward-thinking professionals.

    Applying for a Position at USM

    To apply for a position at USM, candidates are encouraged to submit a resume that highlights relevant experience and skills. The hiring process at USM includes a comprehensive interview to assess fit both for the role and the company culture. This ensures that all team members are aligned with USM's values and goals.

    Stay Connected with USM Jobs and Careers

    Keep up to date with the latest from USM by following their careers page and signing up for job alert emails. These updates provide insights into new job opportunities, company news, and tips for applicants.

    Join USM

    Explore the exciting and rewarding career opportunities at USM. Search open positions that match your skills and interests. USM looks for passionate, curious, creative, and solution-driven team players.

    SEARCH USM JOBS

    Read Careers Blog

    Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the professionals at USM.

    Job Alert Emails

    Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding opportunities that await at USM.
    Learn more about USM Business Systems
    Industry
    Staffing
    * Ladders Estimates

    Similar Jobs

    Ad banner background

    Get Ready For Your
    Next Interview

    More Jobs at USM Business Systems

    More Information Technology Jobs

    Find similar JB061527 - ODI Developer jobs:

    NationwideBoston, MA