US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 26th Feb 2024
As a Professional Programmer Analyst SSIS, at the client, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve - a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges.
Your role in our mission:
Develop, test, manage and implement SSIS Packages from development server to production server using package configuration.
Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.
Formulate and document ETL process design based on business requirements and system specification including source to target mapping and transformations.
Develop ETL specifications, data mapping and other documentation required for ETL development.
Use SQL, data models, data element dictionary and schema to perform data and business analysis.
Understand business data and perform quality assurance testing to ensure the data presented is correct.
Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.
Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing.
What we're looking for (top 5 only)
4+ years of experience using Microsoft SQL Server BI Suite and SSIS/SSRS
Analytical skills in a SQL environment
Ability to build complex queries and reports using Microsoft SQL.
Analytical and data analysis skills using Microsoft SQL (required)
Excellent verbal and written communication skills
Recommended Additional Skills/Experience
4+ years of experience with MS-SQL scripting (required)
4+ years SQL Server version 2014 or higher (required)
Experience in a Healthcare IT working with claims, member and provider data strongly desired.
Experience with QNXT or FACETS Healthcare Payer Platforms preferred.
Healthcare knowledge within a claims processing environment preferably in Medicaid