Job Description:
Trigyn's direct government client has an immediate need for Informatica/Rhapsody ETL Developer in Menands, NY.
Description;
• Working with large and complex Oracle data warehouses, data marts and OLTP databases.
• 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 Qualifications:
• Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
• 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 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.5, 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.5, 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.
For Immediate Response call 732-876-7635, or send your resume to RecruiterVS@Trigyn.com
For Immediate Response call 518-805-7401, or send your resume to RecruiterBP@Trigyn.com
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, , ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.