Contract ODI ETL Developer - Hybrid Onsite in Boston, MA OR Jersey City, NJ - USC OR GC ONLY (No Visas)

Please send current resumes directly to bhagyashree.yewle@yoh.com
Bhagyashree Yewle, Principal Lead Recruiter - YOH SPG
https://www.linkedin.com/in/bhagyashreeyewle/

Contract ODI Developer - Hybrid Onsite in Jersey City, NJ OR  Boston, MA - USC OR GC ONLY (No Visas)

• Location: Boston, MA OR Jersey City NJ
• Hybrid: 3 days on site
• Potential Convert: Yes, USC/GC ONLY no exceptions. WILL NOT SPONSOR

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

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

Estimated Min Rate: $55.00

Estimated Max Rate: $72.00


What’s In It for You?
We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:

• Medical, Prescription, Dental & Vision Benefits (for employees working 20 hours per week)
• Health Savings Account (HSA) (for employees working 20 hours per week)
• Life & Disability Insurance (for employees working 20 hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

By applying and submitting your resume, you authorize Yoh to review and reformat your resume to meet Yoh’s hiring clients’ preferences. To learn more about Yoh’s privacy practices, please see our Candidate Privacy Notice: https://www.yoh.com/privacy-notice