Job Summary :

- We are seeking a Senior/Lead Developer with expertise in SQL, data integration, and cloud technologies (AWS preferred) to design, develop, and optimize enterprise data solutions.

- The ideal candidate should have 5+ years of experience working with health plan data (Enrollments, Claims, Payments), strong hands-on experience in SQL (Oracle, MS SQL), and the ability to troubleshoot data translation and performance issues.

- The role also requires scripting, ETL processes, and experience in handling Sev1/Sev2 incidents.

Key Responsibilities :

- Database Development & Optimization Design, develop, and optimize complex SQL queries for Oracle, MS SQL.

- Develop and maintain stored procedures, triggers, and database scripts.

- Troubleshoot and resolve data translation issues between source and target systems.

- Ensure data integrity and performance optimization across various systems.

- Data Integration & Development Develop, test, and deploy data integration solutions for enterprise applications.

- Work with ETL processes to ensure smooth data movement across systems. Automate and optimize data workflows using scripting.

- Assist in defining system architecture, data models, and performance tuning strategies.

Incident Management & Troubleshooting Support and troubleshoot Sev1/Sev2 incidents, ensuring quick resolution and minimal impact.

- Conduct root cause analysis and implement preventive measures for recurring data issues.

- Monitor and optimize system performance, ensuring high availability and scalability.

- Collaboration & Documentation Work closely with architects, technical leads, and business stakeholders to understand requirements.

- Document best practices, technical specifications, and integration workflows.

- Contribute to technical discussions, reviews, and knowledge-sharing sessions.

- Cloud & Process Improvement Collaborate with DevOps teams for CI/CD pipeline integration and deployment automation.

- Continuously explore process automation and efficiency improvements.

Skills :

- 5+ years of experience working with health plan data (Enrollments, Claims, Payments).

- Strong SQL expertise in Oracle, MS SQL. Experience developing and debugging stored procedures and SQL scripts.

- Good understanding of scripting for automation and troubleshooting.

- Experience in handling Sev1/Sev2 incidents and performing root cause analysis. Hands-on experience with ETL development and data integration.

- Strong problem-solving skills and ability to work in a fast-paced, time-sensitive environment.