Sign upLog in
See more jobs

Database Architect

i-Link Solutions Inc
  • Menands,, NY
  • Quick Apply
1 day ago

Job Description

Job Title: Database Architect Expert
Task ID: HBITS-08-14963
Position Duration: 30 Months
Client: State of NY
Agency: Office of Mental Health

Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at

nysreqs@ilinksolutions.com



Description
Day-to-day tasks include, but are not limited to:
  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.
Mandatory Qualifications
1 84 Months Experience writing SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
2 84 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring and managing millions of records of data including XML and HL7 message formats
3 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
4 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
5 84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing
6 84 Months Experience working with Health Data with HIPAA, HL7 or similar standards
7 60 months experience developing project timelines, gathering and documenting business requirements
8 48 Months experience in programming public sector government IT projects.
9 Project Management Professional Certification
Required Documentation " Re sume
" Copy of Candidate Identification
(i.e., Driver's License/Green Card/Visa and Passport if applicable)
" Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.)

i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.

Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability

Numbers & Facts

LocationMenands,, NY

Skills

  • Acceptance Testingunmatched
  • Best Practicesunmatched
  • Business Caseunmatched
  • Computer Scienceunmatched
  • Data Martunmatched
  • Data Profilingunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Database Architectureunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Technologyunmatched
  • Governmentunmatched
  • HIPAA (Health Insurance Portability and Accountability Act)unmatched
  • HL7 (Health Level 7)unmatched
  • Informaticaunmatched
  • Information Technology & Information Systemsunmatched
  • Integration Testingunmatched
  • Metadataunmatched
  • Oracleunmatched
  • Oracle Databaseunmatched
  • Oracle PL-SQLunmatched
  • Performance Tuning/Optimizationunmatched
  • Project Management Certificationunmatched
  • Project Management Professional (PMP)unmatched
  • Psychiatry and Mental Healthunmatched
  • Quality Assuranceunmatched
  • Records Managementunmatched
  • Regression Testingunmatched
  • SQL (Structured Query Language)unmatched
  • Stored Proceduresunmatched
  • System Testunmatched
  • Testingunmatched
  • Transaction Processing/Managementunmatched
  • Unit Testunmatched
  • XML (EXtensible Markup Language)unmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder