Database Architect

For more details, please connect with Praveen H at View email address on us.fitly.work or call at View phone number on us.fitly.work .

End Client: Office of Mental Health



Job Title: Database Architect



Duration: 30 Months



Location: 800 North Pearl, Menands, NY 12204 (Hybrid)



Position Type: Contract



Hours Per Week: 40 Hours



Interview Type: Webcasting (Camera Required)



Ceipal ID: SNY_SQL963_PH



Job Code: HBITS-08-14963

Scope of Project

ITS is recruiting an expert candidate for the Office of Mental Health to support the Health Information Exchange (HIE) project and InfoSphere MDM application. The selected consultant will provide advanced database architecture leadership and expertise within Oracle, Informatica, and Rhapsody environments.

Responsibilities

• Work with Oracle data warehouses, data marts and OLTP databases.
• Oversee creation and modification of Oracle database tables.
• Write and execute SQL against Oracle databases and Informatica Metadata Repository.
• Guide ETL development and monitoring using Informatica Power Center and Rhapsody.
• Enhance and recommend ETL architectural best practices.
• Investigate and resolve design, build, data loading and integrity issues.
• Perform Informatica/Rhapsody workflow performance tuning.
• Develop ETL mappings and workflows including mapplets, reusable transformations and worklets.

Required Skills

• 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.

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.

If you are considering applying for a position with V Group, or partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Website:



LinkedIn:



Facebook:



Twitter: