JOB DESCRIPTION SSIS-SQL-EDI -Facets Developer
REQUIRED EXPERIENCE AND ABILITIES
- 5+ Hands on technical experience with SSIS,SQL
- 5+ years of strong SQL experience in Relational Database SQL Server. Development
- EDI 837
- Experience in understanding and working on map changes and Knowledge in EAM/Spec Builder for validating X12/HIPAA transactions for inbound and outbound
- Should have knowledge in EDI transactions (837, 834,278, etc)
- Strong experience/Knowledge in processing 837/834 (Inbound/Outbound) files
- Experience in healthcare especially in Medicare and Medicaid line of business.
- Experience in developing inbound and outbound solutions in at least 2 modules like Membership, Claims, Provider, Billing, Capitation, Encounter etc.
- Experience in working onsite offshore model.
- Experience in change management process and incident management
- Experience working with Schedulers eg : Tidal
- Knowledge Experience in automatic deployments and GIT
- Master or Bachelors Degree in Computer Science, Physics or Mathematics.
Required Technical Skill Set
Must have : Facets, MS SQL Server, , MSBI stack (SSIS)).
Must Have: EDI 837
Responsibilities
- Develop and/or enhance stored procedure or complex queries to process Facets data.
- Develop and/or enhance extensions using .Net/SQL
- Develop and/or enhance inbound/outbound batch interfaces using SSIS/SQL/.Net
- Develop and/or enhance RPAs using UI Path
- Write ad-hoc SQL queries to support data analysis.
- Working within an Agile SDLC process.
- Optimize code performance by analyzing indexes, joins and views.
- Performance tune the SQL queries to run fast
- Conduct design solution sessions with developers and formulate technical solution for the project.
- Estimations for the FeaturesEpic.
- Analyses and evaluates detailed business and technical requirements.
- Codes and maintains complex components of information systems
- Responsible for on-time development completion with low defect rate through close interactions / reviews with other senior developers.
Primary Skill Set: SSIS SQL dev -FACET and EDI as mandatory skills.
Skills: ssis,sql server,sql
