Remote opportunity at
OmegaHiresData Warehouse ETL Developer
OmegaHires is seeking professionals for various data warehouse roles, including a Data Warehouse ETL Developer, a Senior Business Analyst for the Medicaid Enterprise Data Warehouse, and…
Career Tools
About This Role
OmegaHires is seeking professionals for various data warehouse roles, including a Data Warehouse ETL Developer, a Senior Business Analyst for the Medicaid Enterprise Data Warehouse, and a Quality Assurance Analyst. These on-site, full-time positions suit individuals with extensive experience in data integration, business analysis, or quality assurance within data warehousing environments. The Data Warehouse ETL Developer will focus on building and maintaining robust data integration solutions using Informatica PowerCenter, extracting…
Job Description
OmegaHires is seeking professionals for various data warehouse roles, including a Data Warehouse ETL Developer, a Senior Business Analyst for the Medicaid Enterprise Data Warehouse, and a Quality Assurance Analyst. These on-site, full-time positions suit individuals with extensive experience in data integration, business analysis, or quality assurance within data warehousing environments.
The Data Warehouse ETL Developer will focus on building and maintaining robust data integration solutions using Informatica PowerCenter, extracting information from diverse platforms and loading target environments efficiently. Meanwhile, the Senior Business Analyst supports Medicaid Enterprise Data Warehouse operations by acting as a bridge between technical teams and program stakeholders to translate complex rules into functional specifications. Additionally, the Quality Assurance Analyst ensures the reliability and accuracy of warehouse data through rigorous testing, validation, and defect tracking.
These roles are designed for analytical professionals who excel at problem-solving, collaboration, and data integrity verification. Candidates will work with structured schemas, coordinate with data architects, and contribute to system enhancement projects. OmegaHires requires deep domain expertise and structured methodologies for these positions, making them an ideal fit for experienced practitioners in data management and healthcare analytics.
Responsibilities
- Design, build, and deploy ETL workflows and mappings using Informatica PowerCenter
- Extract data from heterogeneous platforms like Oracle, SQL Server, and flat files for data warehouse loading
- Elicit, document, and validate business requirements for Medicaid data initiatives
- Analyze Medicaid data across claims, eligibility, and financial payment systems
- Create and execute test plans, test cases, and scripts for enterprise data warehouse enhancements
- Perform end-to-end data reconciliation and source-to-target validation using SQL
Requirements
- 8 to 10 years of professional experience in ETL development using Informatica PowerCenter
- 8 to 10 years of background as a Business Analyst supporting large data integration projects
- 5 years of experience working with healthcare or Medicaid data systems
- Strong proficiency in SQL, PL/SQL, and query performance tuning
- Solid understanding of dimensional modeling, star schemas, and snowflake schemas
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Information Systems, Data Analytics, or a related field
- Familiarity with real-time ETL and data streaming technologies
- Knowledge of scheduling software like Informatica Workflow Manager and IBM Workload Automation
- Experience with federal reporting compliance to the Centers for Medicare and Medicaid Services
- Acquaintance with Agile delivery methodologies and HIPAA data privacy rules
Core Skills
Frequently Asked Questions
What is the employment type for these roles?
The positions are offered as full-time employment.
What is the work location and remote policy?
The job posting specifies that the roles are on-site, though a specific geographic location is not provided in the text.
Is salary information provided in the job posting?
The posting does not specify the salary for these positions.
What core technical tool is required for the ETL Developer position?
The ETL Developer role requires hands-on experience using Informatica PowerCenter.
Sample Interview Questions
AI-generated questions tailored to this specific role — a preview of the full practice set.