Database Architect Expert

1 week ago


Menands, New York, United States Five Cubes, Inc. Full time
Job Title: Database Architect Expert

Job Summary:

We are seeking an experienced Database Architect Expert to join our team at Five Cubes, Inc. The ideal candidate will have a strong background in database design, development, and implementation, with expertise in Informatica, ETL, and Unix scripting.

Key Responsibilities:

  • Analyze client operations and applications to determine database structural requirements
  • Design and develop complex database mappings using Informatica 10.x or higher
  • Implement Fine Grain Access Control Audit (FGACA) and Virtual Private Database (VPD) to protect sensitive data
  • Lead the ETL team in shaping and enhancing the overall ETL architecture using Informatica
  • Write complex UNIX scripts to validate and FTP files, and for calling Informatica workflows
  • Convert complex SQL, PL/SQL, and SAS code to Informatica mappings
  • Specify and conduct system testing and user acceptance testing

Requirements:

  • 84+ months experience using Informatica 10.x or higher in a data warehouse environment
  • 48 months experience with Informatica Data Quality processes and approaches
  • 72 months experience implementing FGACA and VPD to protect sensitive data
  • 72 months experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica
  • 72 months experience writing complex UNIX scripts
  • 72 months experience converting complex SQL, PL/SQL, and SAS code to Informatica mappings
  • 72 months experience in dimensional data modeling

Benefits:

Competitive salary range: $63.44 to $73.44 DOE

Hybrid work arrangement

Candidates with valid work permits in the US are encouraged to apply



  • Menands, New York, United States Five Cubes, Inc. Full time

    Job Title: Database Architect ExpertLocation: HybridDuration: 30 MonthsDirect ClientJob Description:We are seeking a highly skilled Database Architect Expert to join our team at Five Cubes, Inc. The ideal candidate will have extensive experience in designing and implementing complex databases, data warehouses, and ETL processes.Key Responsibilities:Analyze...


  • Menands, New York, United States Avenues International Full time

    Job Title: Software ArchitectWe are seeking a highly skilled Software Architect to join our team at Avenues International Inc. in Albany, NY.The ideal candidate will have extensive experience in designing and implementing large-scale technical projects, with a strong focus on delivering high-quality solutions that meet project scope and requirements.Key...


  • Menands, New York, United States Five Cubes, Inc. Full time

    Job Title: Software Architect ExpertFive Cubes, Inc. is seeking a highly skilled Software Architect Expert to join our team.Job Description:The Software Architect Expert will be responsible for designing and implementing Information Technology Solutions using the Java programming language. Key responsibilities include:Reviewing program specifications and...


  • Menands, New York, United States Five Cubes, Inc. Full time

    Job Title: Software Architect ExpertAt Five Cubes, Inc., we are seeking a highly skilled Software Architect Expert to join our team. As a key member of our IT department, you will be responsible for designing and implementing Information Technology Solutions using the Java programming language.Key Responsibilities:Review program specifications and provide...


  • Menands, New York, United States Donato Technologies, Inc Full time

    Job Title: Java ArchitectDonato Technologies, a leading IT service provider, is seeking a highly skilled Java Architect to lead technical architecture for computer application development in support of the MRC-STTRONG grant.Job SummaryThe successful candidate will oversee and manage the technical architecture for the SERVNY application, providing technical...

  • Senior Data Architect

    2 weeks ago


    Menands, New York, United States GENESYS Consulting Services Full time

    Job Opportunity at GENESYS Consulting ServicesThis is a 30-month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension).Key Responsibilities:Design and create DataMarts, a Data warehouse using Star & Snowflake Schemas in the Insurance industry.Develop and maintain predictive systems written in R, or...


  • Menands, New York, United States GENESYS Consulting Services Full time

    Job Opportunity at GENESYS Consulting ServicesThis is a 30-month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension).Required Experience:84-months experience in designing and creating DataMarts, Data warehouses using Star & Snowflake Schemas in the Insurance industry84 months of experience with...


  • Menands, New York, United States Donato Technologies, Inc Full time

    Job OpportunityAbout Donato Technologies, Inc.Donato Technologies, Inc. is a leading IT service provider established in 2012, renowned for delivering exceptional staffing experiences and prioritizing the needs of clients and employees. We specialize in staffing, consulting, software development, and training, catering to small and medium-sized enterprises....

  • Database Architect

    6 hours ago


    Menands, United States V Group Inc Full time

    Client: State of New York Job Title: Database Architect Duration: 30 Months Start Date: ASAP Location: Menands, NY 12204 (Hybrid) Position Type: Contract Interview Type: In Person/Web Came Working Hours: 40 Hours per Week Department: New York State Department of Health Description: New York State of Health (NYSoH) is New York's official health plan...

  • Database Architect

    5 hours ago


    Menands, United States 3A Soft Inc Full time

    84 months of experience writing complex SQL for queries, stored procedures/triggers/functions in DB2/Oracle for data extraction and data integration purposes in multi-terabyte database.84 months of experience in gathering reporting and analysis requirements and translating them into reporting structure data models, including aggregate tables, pivoted tables,...