Database Architect
Job in
City of Albany, Albany, Albany County, New York, 12201, USA
Listed on 2026-09-13
Listing for:
Oak Tree Software
Full Time
position Listed on 2026-09-13
Job specializations:
-
IT/Tech
Database Administrator, Data Engineering, Data Warehousing
Job Description & How to Apply Below
Duration: 30 Months
Role Type:
Onsite from day 1
Location:
Albany, NY 12226
Pay Rate: $65.00/hour on W2.
Eligibility : (USC & GC only, No C2C)
Description:
- Working with 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 Center 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.
Mandatory
Qualification:
- Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
- 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 SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
- 84 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
- 84 Months Experience working with Health Data with HIPAA, HL7 or similar standards
- 60 months experience developing project timelines, gathering and documenting business requirements
- 48 Months experience in programming public sector government IT projects.
- Project Management Professional Certification
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×