Database Architect

Listed on: 4/10/2024 8:42:00 AMPST
Location: Albany, NY 12204
Industry: Information Technology
Salary: Open
Description: L.J Gonzer Associates is looking for individuals to join our pool of qualified candidates for potential assignment as a Database Architect. *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 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
Requirements: 

• 7 years of experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
• 4 years of experience developing Rhapsody routes, including Rhapsody 7, acquiring and managing millions of records of data including XML and HL7 message formats
• 7 years of experience using Informatica 8.x or higher, including 10.2, in a data warehouse environment including warehousing concepts, design and development of complex mappings
• 7 years of 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
• 7 years of experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing
• 6 years of experience working with Health Data with HIPAA, HL7 or similar standards

L. J. Gonzer Associates is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected Veteran status.

Apply Here