SSIS Developer with Healthcare USC GC only at Remote, Remote, USA |
Email: [email protected] |
From: shaik, Convextech [email protected] Reply to: [email protected] Job title : SSIS Developer with Healthcare experience Location: Remote Visa restrictions: USC or GC Duration: 18+ months contract to permanent Type of engagement CTC, CTH or FT: CTC Job Description: POSITION SUMMARY: (Briefly describe the purpose of the position): Under general direction, responsible for designing and/or creating, maintaining, deploying, and managing SSIS packages for internal business teams and our customers. Candidates will work collaboratively with IT staff, and business stakeholders to create, maintain, and support ETL packages in a compliant, regulated environment. Escalate concerns to project management or Team Lead, assist in determining best practices and provide suggestions on how to improve current practices. ESSENTIAL FUNCTIONS Duties and Responsibilities (List all essential duties and responsibilities in order of importance) o Ability to Develop, test, manage and implement SSIS Packages from development server to production server using package configuration. o Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. o Ability to automate the execution of SSIS packages using SQL Server Agent Jobs. o Formulate and document ETL process design based on business requirements and system specification including source to target mapping and transformations. o Implement Database administration tasks like Scheduling and monitoring the ETL Jobs, Collated customer requirements, coordinated with different stakeholders. o Work with customers, Business SMEs and application development teams to understand requirements o Proactively engage on continuous improvement efforts o Experience diagnosing and resolving in incident tickets and errors o Developed ETL specifications, data mapping and other documentation required for ETL development. o Uses SQL, data models, data element dictionary and schema to perform data and business analysis o This individual is responsible for understanding business data and performing quality assurance testing to ensure the data presented is correct. o Create documentation and best practices o At least 1 year of experience using Microsoft SQL Server Database, SSIS is required Knowledge, Skills, and Abilities ( List all knowledge, skills and abilities that are necessary to perform the job satisfactorily) o 2 to 3 years of experience using Microsoft SQL Server BI Suite and SSIS o 2 to 3 years of experience with MS-SQL scripting (required) o 2+ years SQL Server version 2014 or higher (required) o Experience in a Healthcare IT working with claims, member and provider data strongly desired. o Analytical skills in a SQL environment o Experience with QNXT or FACETS Healthcare Payer Platforms preferred o Excellent verbal and written communication skills o Ability to abide by Gainwell policies o Ability to maintain attendance to support required quality and quantity of work o Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA) o Ability to establish and maintain positive and effective work relationships with co-workers, clients, and customers Keywords: business intelligence information technology green card microsoft Colorado |
[email protected] View all |
Fri Feb 23 23:46:00 UTC 2024 |