HBITS: HBITS-08-14963
Expert, Database Architect
30 month contract
Interview: Virtual Interview
Work model: 50% telecommuting, 50% Office per week
--- Project Description ---
ITS is recruiting an expert candidate for the Office of Mental Health for
both the Health Information Exchange (HIE) project (a high priority
project), as well as InfoSphere MDM (a P1 application). Expert Skill
Level is being requested for this Database Architect position.
--- Day-to-Day Tasks ---
1. Working with Oracle data warehouses, data marts and OLTP
databases.
2. Overseeing the creation/modification of Oracle database tables of
the appropriate type for the situation.
3. 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.
4. Guiding the ETL team in the development and monitoring of ETL
processes and test plans using Informatica Power Center and
Rhapsody.
5. Guiding the ETL team in shaping, enhancing and recommending
best practices to the overall ETL (Informatica/Rhapsody) architecture
6. Investigating and resolving difficult design and build issues, data
loading and data integrity issues.
7. Performance tuning Informatica/Rhapsody workflows.
8. Using Informatica/Rhapsody to develop ETL mappings and
workflows including the use of mapplets, reusable transformations and
worklets.
--- Required Qualifications ---
" 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
MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.