Database Architect

Details: 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 Job Requirements Details: 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