ideaVat
Oracle with Informatica B2B Developer
ideaVat - San Diego, California, United States, 92189
Work at ideaVat
Overview
- View job
Overview
Job Description
OUR DIRECT CLIENT IS A MULTI BILLION DOLLAR GLOBAL NAME WITH OFFICES ALL OVER THE US; US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY Required Skills:
9 to 10+ years of overall IT/software development experience. 5+ years of recent experience as a senior 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 design and develop sophisticated workflows and data transformations involving Informatica B2B components – DX (Data Exchange) and DT (Data Transformation). 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. Recent and relevant experience as a Senior Oracle Developer. 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. Qualifications
US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY Additional 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; US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY Required Skills:
9 to 10+ years of overall IT/software development experience. 5+ years of recent experience as a senior 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 design and develop sophisticated workflows and data transformations involving Informatica B2B components – DX (Data Exchange) and DT (Data Transformation). 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. Recent and relevant experience as a Senior Oracle Developer. 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. Qualifications
US CITIZENS, GREEN CARD AND EAD GREEN CARD HOLDERS ONLY Additional Information
All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr