Database Architect

3 weeks ago


Albany, United States LanceSoft Full time
Responsibilities:
  • Working with large and complex Oracle data warehouses, data marts and OLTP databases.
  • Overseeing the creation/modification of Oracle database tables of the appropriate type for the situation.
  • Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.
  • Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Centre and Rhapsody.
  • Guiding the ETL team in shaping, enhancing, and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture
  • Investigating and resolving difficult design and build issues, data loading and data integrity issues.
  • Performance tuning Informatica/Rhapsody workflows.
  • Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets."

Required Skills:
  • 84 Months Experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings.
  • 48 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring, and managing millions of records of data including XML and HL7 message formats.
  • 84 Months Experience using Informatica 8.x or higher, including 10.2, in a data warehouse environment including warehousing concepts, design and development of complex mappings.
  • 84 Months Experience with Informatica Data Quality 8.x or higher, including 10.2, processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match, and merge.
  • 84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing.
  • 72 Months Experience working with Health Data with HIPAA, HL7 or similar standards.


  • Albany, United States Mindlance Full time

    Provide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Interact with Agency/business subject matter experts to...


  • Albany, United States Mindlance Full time

    Provide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Interact with Agency/business subject matter experts to...


  • Albany, United States Empire State Full time

    *Applicants MUST submit a cover letter with resume to be considered.*Position expected to work onsite and hybrid consistent with New York State.BASIC FUNCTION: For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements. Applicant must possess a...


  • Albany, United States Empire State Full time

    Job DescriptionJob Description*Applicants MUST submit a cover letter with resume to be considered.*Position expected to work onsite and hybrid consistent with New York State.BASIC FUNCTION: For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements....


  • Albany, United States Absolute Staffing & Consulting Solutions Full time

    Absolute Staffing is searching for a Database Administrator to work with our client.  Location: Albany, NY (12207) Duration: 24 Months Job Description: 84 months of Experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures. 84 months of Experience designing and...

  • Software Architect

    2 weeks ago


    Albany, United States Five Cubes, Inc. Full time

    Job Title: Software Architect - 13184 Location: Albany, NY Duration: 30 Months Direct ClientJob Description: Daily Tasks include but not limited to the following: Evaluate existing and emerging technology, business requirements for the purpose of architecting efficient, portable and scalable solutions. Analysis, modeling, design, coding, testing and...


  • Albany, United States Cedar Park Group Full time

    Cedar Park Group is looking for an Expert Software Architect. Full-time. 8:30am-5:00pm 30 month contract. Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large scale software system. Day-to-day Tasks: Analysis of...

  • Java / JEE Architect

    3 weeks ago


    Albany, United States Trigyn Technologies Full time

    Job Description: Trigyn's direct government client has an immediate need for a Java / JEE Architect in Albany, NY. Description: The consultant will design and assist with the implementation of both small and large-scale software systems. The Software Architect will design, develop, implement, support, and enhance, custom applications written in...


  • Albany, United States Omtech llc Full time

    Job DescriptionJob DescriptionJob description:As a Technical Solution Architect, you'll be responsible for designing and overseeing the implementation of technical solutions that meet business needs while adhering to all policies and standards. You'll collaborate with cross-functional teams to analyze requirements, architect solutions, and ensure...


  • Albany, United States Omtech llc Full time

    Job DescriptionJob DescriptionJob description:As a Technical Solution Architect, you'll be responsible for designing and overseeing the implementation of technical solutions that meet business needs while adhering to all policies and standards. You'll collaborate with cross-functional teams to analyze requirements, architect solutions, and ensure...


  • Albany, United States Docstrats Full time

    Job Description Technical Solution Architect Location: Albany OR NYC - Hybrid - The consultant will be expected to work onsite 50%. The remainer will be remote or traveling. Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately. Required Job Duties: • Design end-to-end technical solutions that address...


  • Albany, United States Experienced Recruiting Partners Full time

    Job DescriptionJob DescriptionContract roleLocation: Albany, NY Hybrid – The consultant will be expected to work onsite 50%. The remainder will be remote or traveling.Travel: Approximately 20-50%. This could vary based on client need. Length: currently until 7/30/2025Overview:As a Technical Solution Architect, you'll be responsible for designing and...


  • Albany, United States Experienced Recruiting Partners Full time

    Job DescriptionJob DescriptionContract roleLocation: Albany, NY Hybrid – The consultant will be expected to work onsite 50%. The remainder will be remote or traveling.Travel: Approximately 20-50%. This could vary based on client need. Length: currently until 7/30/2025Overview:As a Technical Solution Architect, you'll be responsible for designing and...


  • Albany, United States Themesoft Inc. Full time

    Technical Solution ArchitectLocation: Albany OR NYC – Hybrid – The consultant will be expected to work onsite 50%. The Remainer will be remote or traveling.Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately.Required Job Duties:Design end-to-end technical solutions that address business requirements...


  • Albany, United States Themesoft Inc. Full time

    Technical Solution ArchitectLocation: Albany OR NYC – Hybrid – The consultant will be expected to work onsite 50%. The Remainer will be remote or traveling.Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately.Required Job Duties:Design end-to-end technical solutions that address business requirements...


  • Albany, United States Themesoft Inc. Full time

    Technical Solution ArchitectLocation: Albany OR NYC – Hybrid – The consultant will be expected to work onsite 50%. The Remainer will be remote or traveling.Travel: Approximately 30-50%. This could vary based on client need. Travel expenses to be billed separately.Required Job Duties:Design end-to-end technical solutions that address business requirements...


  • Albany, United States INA Solution Inc Full time

    Job DescriptionJob DescriptionPosition: Software ArchitectLocation: Albany NY (Onsite/Hybrid)Duration: Long-TermShift: M-F 8.5-hour days (time ranging from 8:00 am-6:00 pm)Job QualificationsMakes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or...


  • Albany, United States Software People, Inc. Full time

    Job DescriptionJob DescriptionPhone/Skype Hire. Onsite from day 1 Location: Albany, NYDuration: 12 - 24+ months (High Possibility of Further Extensions)ResponsibilitiesDesign end-to-end technical solutions that address business requirements and align with architecture principles and standards. Develop solution architectures, technical specifications, and...


  • Albany, United States Software People, Inc. Full time

    Job DescriptionJob DescriptionPhone/Skype Hire. Onsite from day 1 Location: Albany, NYDuration: 12 - 24+ months (High Possibility of Further Extensions)ResponsibilitiesDesign end-to-end technical solutions that address business requirements and align with architecture principles and standards. Develop solution architectures, technical specifications, and...

  • Software Architect

    2 weeks ago


    Albany, United States PamTen Full time

    Implement Integrated Justice Portal standards related to application technologies, including UI standards, development methodology, and coding and style guides. • Act as the primary technical liaison with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance. • Work with the...