ideaVat
Oracle Developer with Informatica
ideaVat, San Diego, California, United States, 92189
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 HireFor 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 experience4+ 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.Job Type: ContractRequired Education:
Bachelor'sRequired Experience:
Oracle PL SQL: 6 yearsUnix Shell Scripting: 1 yearInformatica: 3 yearsQualifications
Oracle PL SQL: 6 yearsUnix Shell Scripting: 1 yearInformatica: 3 yearsAdditional Information
All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr
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 HireFor 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 experience4+ 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.Job Type: ContractRequired Education:
Bachelor'sRequired Experience:
Oracle PL SQL: 6 yearsUnix Shell Scripting: 1 yearInformatica: 3 yearsQualifications
Oracle PL SQL: 6 yearsUnix Shell Scripting: 1 yearInformatica: 3 yearsAdditional Information
All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr