Search jobs > Albany, NY > Software architect

Software Architect (ETL, Oracle Data Integrator, XML, Oracle 11g, Criminal Justice processing)

MVP Consulting
Albany, NY, United States
Full-time

HBITS-(phone number removed)

This individual will be expected to participate in the following activities :

Manages ETL solutions for medium to large scale data warehouse projects.

IT experience in ETL application analysis, design, development and implementation, including : data analysis, data access, data structures, data manipulation, data reporting solutions, database, and technical and user documentation.

Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.

Work with the Infrastructure team to execute activities such as performance test planning and execution failure failover planning and execution, endurance testing and deployment planning and testing.

Perform oversight of development activities which may include data analysis, data access, data structures, data manipulation, preparing logical database models, testing and implementation.

Prepare, and / or review technical documentation such as designs, schemas, etc, as appropriate.

Provide technical guidance to team of developers.

Software Architect

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.

Expert 84+ Months : Candidate is able to provide guidance to large teams and / or has extensive industry experience and is considered at the top of his / her field.

84 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents.

84 months experience using ETL tools, like Oracle Data Integrator to migrate data from various sources and targets including databases, flat files, and XML files.

84 months experience using Oracle Data Integrator 11g or later.

84 months experience working with Oracle 11g or later.

72 months experience in design, development and implementation of business intelligence architectures with experience in analysis, problem solving, technical writing, presenting and communicating with stakeholders.

36 months experience developing, implementing and integrating systems related to Criminal Justice processing at the state or federal level using Criminal Justice terminology and nomenclatures.

3 hours ago
Related jobs
Promoted
MVP Consulting
Albany, New York

Oracle and DB2 Data Modeling, creating logical data models, working with databases and experience with XML schemas (definition and automated generation). Database Architect: STAR/Real Property Tax Systems project. Determines database structural requirements by analyzing client operations, applica...

Promoted
Vichara
Albany, New York

Participating in the design of new DB2 and Oracle tables;. ...

Promoted
MVP Consulting
Albany, New York

Oracle Data Integrator (ODI) modeling for Oracle BI Applications. Analyze, design, build and test ETL components and data models for a BIApps Peoplesoft Financials data warehouse. Data Warehouse ETL experience in Oracle technologies. Oracle Data Integrator (ODI) modeling. ...

IIT Inc
Albany, New York

Oracle Streams AQ Administration. ...

Promoted
MVP Consulting
Albany, New York

Guide and engage in development activities which may include data analysis, data structures, data manipulation, preparing logical database models. Object Oriented or Service Oriented Architecture involving data structures, algorithms, software design and JEE Design Patterns. Designs multi-leveled ar...

Donato Technologies, Inc
Albany, New York

Requirements </b></div> <ul> <li>This is an 100% Onsite</li> <li>84 months of Data Warehouse ETL experience in Oracle technologies</li> <li>60 months of experience in Oracle Data Integrator (ODI) modeling</li> <li>60 months of experience i...

Sligo Software Solutions
Albany, New York

Mentor and assist other programmers, both state and consultant, providing guidance for debugging, troubleshooting, securing and deploying applications, data access, data communications and system architecture configurations. Oracle: Database design, PL SQL coding, stored procedures, packages, indexe...

VISTRADA
Albany, New York

Vistrada is seeking a highly motivated and experienced candidate to serve as an ETL Developer / Data Architect on our Business Intelligence ("BI") team supporting key clients. In this role, you will help address operational challenges associated with data modeling, system architectures, data warehou...

Vichara
Albany, New York

Oracle and DB2 Data Modeling, creating. Participating in the design of new DB2 and Oracle tables;. XML schemas (definition and automated generation). Sybase working with relational database. ...

Donato Technologies, Inc
Latham, New York

Role: </b>Oracle IAM Architect</div> <div><b>Location: </b>Latham, New York</div> <div><b>Duration: </b>24 Months</div> <div> </div> <div><b>Description </b></div> <div>Technical Lead and Arch...