Oracle/ Informatica IICS Developer

5 months ago


Maricopa, United States Syntricate Technologies Full time
Job Description:
  • In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux based Oracle 11g RAC 2 node cluster.
  • The Data Warehouse is currently under development and you will be an integral part of its design and implementation.
  • You will support key strategic initiatives, including the integration of new lines of business, design and implementation of data marts and subject areas, and key decisions around the future of the data warehouse.
  • You will also be involved with the implementation of new reporting tools, new ETL routines and other projects that are core to developing and enhancing the data warehouse environment. Essential Job Functions:1. Utilize excellent hands-on PL/SQL skills to design and implement data warehouse subject areas.2.
  • Develop high performing extraction, transformation and loading (ETL) routines for loading data from our production database into the data warehouse.3.
  • Create PL/SQL that performs well with large data sets, is written to scale for future growth and adheres to business rules.4.
  • Effectively integrate new lines of business into the DW requiring the addition of new data sources into existing tables and data marts.5.
  • Share knowledge and PL/SQL expertise and mentor team members in the design of efficient reporting queries.6.
  • Team with engineering, IT and business stakeholders to support projects of varying complexity;
  • gather reporting and data warehousing requirements, evaluate best approach and propose solutions.
Must Haves:
  • Informatica IICS, CDI
  • Oracle, PL/SQL, Python, Datamarts, Starschema and Production support


  • Maricopa, United States Diverse Lynx Full time

    10+ Years of experience required. In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux basedOracle 11g RAC 2 node cluster. The Data Warehouse is currently under development and you will be an integral part of its design and implementation. You will support key...


  • Maricopa, United States Syntricate Technologies Full time

    Job Title: Oracle PL/SQL Developer - Informatica Exp. Location: Maricopa, AZ Duration: Contract Job Description: In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux based Oracle 11g RAC 2 node cluster. The Data Warehouse is currently under development and...


  • Maricopa, United States Syntricate Technologies Full time

    Job Title: Oracle PL/SQL Developer - Informatica Exp. Location: Maricopa, AZ Duration: Contract Job Description: In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux based Oracle 11g RAC 2 node cluster. The Data Warehouse is currently under development and...


  • Maricopa, United States Diverse Lynx Full time

    Job Description Required 10 + Years of experience Required Skills: Oracle PL/SQL, Informatica CDI (Cloud Data Integration), PL/SQL In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux based Oracle 11g RAC 2 node cluster The Data Warehouse is currently under...


  • Maricopa, United States Diverse Lynx Full time

    Job Description Required 10 + Years of experience Required Skills: Oracle PL/SQL, Informatica CDI (Cloud Data Integration), PL/SQL In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux based Oracle 11g RAC 2 node cluster The Data Warehouse is currently under...

  • Oracle Data Architect

    2 months ago


    Maricopa, United States Syntricate Technologies Full time

    Required Skills: 10+ years of professional experience is required. Proficient experience as Data Architect Excellent understanding and hands on experience on a) Oracle b) PL/SQL, c) Informatica, d) IICS, e) Datawarehouse Architecture, Excellent written and verbal communication skills with clear, concise technical writing style. Think strategically and...


  • Maricopa, United States Diverse Lynx Full time

    Job Title: Informatica CDI Developer Location: Maricopa, AZ Job Type: ContractJob Description In this role you will serve as a senior dedicated technical resource responsible for Oracle PL/SQL development for our Data Warehouse running on a Linux based Oracle 11g RAC 2 node cluster. The Data Warehouse is currently under development and you will be an...