MS SQL Developer with HRP & EDI

Company Overview

Company information not specified.

Job Summary

We are seeking an experienced MS SQL Developer with a strong background in HealthRules Payor and EDI transactions. The successful candidate will focus on optimizing and writing SQL queries to support data management and operations within our HealthRules Data Warehouse (HR DW). This role is crucial for ensuring efficient data transactions and integration.

Responsibilities

• Develop and optimize MS SQL Server queries and scripts for data extraction and analysis.
• Work with HealthRules Payor to understand the data model and leverage it within the HealthRules Data Warehouse.
• Implement and manage Electronic Data Interchange (EDI) transactions, specifically 834 and 837 transaction sets.
• Collaborate in the integration of data using ActiveBatch and Mapforce tools.
• Query the HealthRules Data Warehouse and generate reports using custom Operational Data Store (ODS) and Enterprise Data Warehouse (EDW).
• Troubleshoot and resolve queries and data-related issues in a timely manner.

Qualifications

• Proficiency in MS SQL Server, including experience with writing and optimizing queries.
• Strong knowledge of HealthRules Payor and its data model.
• Expertise in EDI transactions, particularly 834 and 837 formats.
• Familiarity with ActiveBatch and Mapforce tools for data integration.
• Experience working with custom ODS and EDW.
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 4 to 8 years of relevant experience in MS SQL development and data management.

Preferred Skills

• Familiarity with healthcare data standards.
• Experience in agile development methodologies.

Experience

• Minimum of 4 to 8 years of experience in MS SQL development, especially in healthcare-related projects.

Environment

• This is a Permanent position available in a Hybrid Model, with locations including Bangalore, Hyderabad, and Noida.

Salary

Salary information not specified.

Growth Opportunities

Career advancement opportunities within the company not specified.

Benefits

Benefits offered not specified.