Company:
Mindlance
Location: Menands
Closing Date: 27/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
- 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.
Share this job
Mindlance