Oracle Developer with Informatica

Jobsbridge

San Diego (CA)

On-site

USD 100,000 - 130,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading global recruiting firm is seeking an Oracle Developer in San Diego, California. This contract position requires strong expertise in Oracle PL/SQL, Unix Shell Scripting, and Informatica with at least 8 years of IT experience. Candidates must also possess performance tuning skills and experience working on large databases. The role can lead to full-time opportunities, and US citizens or green card holders are preferred, with strong H1B candidates considered under specific conditions.

Qualifications

Minimum of 3 years remaining on H1B visa at time of converting to FTE.
Cannot have an approved I-140.
Cannot be on F1 (OPT/CPT) or L1 visa.

Responsibilities

Develop comprehensive Informatica solutions for large OLTP systems.
Construct and optimize PL/SQL packages, triggers, and scripts.
Support production applications and monitor performance.

Skills

Oracle PL/SQL

Unix Shell Scripting

Informatica

Performance Tuning

SQL Server

Automotive Marketing/CRM

Education

Bachelor's degree

Job description

We recruit for product development teams as well as IT teams; we understand the difference in skill sets and personnel needed for both back-end and front-end. We have the resources and access to a global network of talent across various technologies and industries to provide your company with the right candidates you need and just when you need them

Job Description

OUR DIRECT CLIENT IS A MULTI BILLION DOLLAR GLOBAL NAME WITH OFFICES ALL OVER THE US IS LOOKING FOR ORACLE DEVELOPER WITH INFORMATICA

Duration: 8-9 months Contract to Hire

For this contract-to-hire position, our preference is for US citizen or green card holder candidates only. We may consider very strong H1B candidates but they must meet the following requirements to be considered:

• Candidate must have a minimum of 3 years remaining on their visa at the time of converting to FTE at the end of the 6 month contract phase (i.e. 3.5 yrs+ remaining when first submitted).

• Candidate cannot have an approved I-140.

• Candidate cannot be on an F1 (OPT/CPT) or L1 visa.

Required Skills:

Should have around 8 years of overall IT/software development experience
4+ years of recent experience as an Oracle developer.Strong development experience with Oracle PL/SQL: construction of packages, triggers and PL/SQL blocks and Unix Korn shell scripting.
Experience with working on large Oracle databases using SDLC methodologies (agile, waterfall).
Experience in performance tuning, application monitoring and support of production applications with distributed teams
Experience with writing detailed technical specifications for developers; design, validate and execute software test plans.Working knowledge of SQL Server and experience in automotive marketing and/or CRM applications preferred.
Oracle Certifications a plus.
Detailed and up-to-date knowledge of Informatica Power Center workflows and mapping components.
Ability to tune Informatica workflows; knowledge of optimal mapping techniques.
In-depth experience developing comprehensive Informatica solutions to run against large OLTP systems or data warehouses.
Working knowledge of file transfer protocol (FTP) in Unix.
Knowledge of database architecture and best practices for Oracle SQL and PL/SQL coding style and application tuning.
Ability to construct well-conceived, reusable PL/SQL packages, database triggers and PL/SQL blocks in Oracle, and Korn shell scripts as needed to support Informatica workflows and related file transfer processes.
Excellent impact-analysis skills and discipline. Carefully analyzes the existing code base as part of each design effort, to avoid redundancy and inconsistency and maximize code reuse.
Development experience in Oracle PL/SQL with good software methodology/practices.
Working knowledge of SQL Server preferred.Development experience in Unix Korn shell scripting.
Experience working on large Oracle databases (preferably over 1TB).
Experience in performance tuning, application monitoring and support of production applications.
Experience working with offshore teams preferred.Experience in automotive marketing and/or CRM applications preferred.
Experience with source control systems (VSS, TFS, etc.) preferred.