Required Skills

Database Architect

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 13th Nov 2025

JOB DETAIL

  • 84 months of experience writing complex SQL for queries, stored procedures/triggers/functions in DB2/Oracle for data extraction and data integration purposes in multi-terabyte database.
  • 84 months of experience in gathering reporting and analysis requirements and translating them into reporting structure data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) marts.
  • 84 months of experience with data modeling, including logical, conceptual, and physical modeling of data warehouse projects and data warehouse loading techniques (Change Data Capture (CDC) and Slowly Changing Dimensions).
  • 84 months of experience with various reporting tools, including COGNOS.
  • 84 months of experience working on ETL framework for data warehouse projects, which includes Informatica / Data stage tools.
  • 56 months of experience working with the Affordable Care Act or Medicaid.
  • 48 months of experience working with OSC and KPMG auditors for analyzing and debugging Enrollment and Eligibility data.
  • 48 Months of experience with Medicaid Data Warehouse (MDW).
  • Bachelor’s degree in information technology or computer science or similar field of study.
  • Résumé
  • 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.)

Company Information