ETL Developer

    • Intelliswift - An LTTS Company
  • Alameda, CA
  • Posted 5 hours ago | Updated 5 hours ago

Overview

On Site
Full Time

Skills

Data Integration
Health Insurance
Data Warehouse
Business Intelligence
Performance Analysis
Quality Assurance
XML
Design Patterns
Database
Root Cause Analysis
IT Management
Computer Science
Transact-SQL
Interfaces
ERwin
Microsoft SQL Server
Database Administration
Visual Basic .NET
ASC X12
Writing
Technical Drafting
Microsoft SSIS
Defense Travel System
Data Transformation Services
Stored Procedures
Informatica
Pentaho
SQL
Scripting
Management
Extract
Transform
Load
Extraction
Data Loading
Health Care
Electronic Data Interchange
Critical Thinking
Conflict Resolution
Problem Solving

Job Details

Job Description

Must Have skills:

ETL

SSIS

SQL

T-SQL

EDI

Healthcare


Overview: Analyze, design, implement and maintain ETL programs. The Senior ETL Developer reports to the Data Integration Manager and works with Data Integration Manager and the and ETL team in accelerated development and deployment of healthcare ETL, EDI and proprietary interfaces. Working closely with developers, a data architect, analysts, and business users, the Sr. ETL Developer is challenged with implementing robust, reusable development for SSIS and ETL packages with strong emphasis on Healthcare Insurance, SQL Server, Understanding of EDI 834/837 and FHIR concepts.

Principal responsibilities include:

Create and manage SSIS packages, ETL packages, triggers, stored procedures, views, SQL transactions.

Develop new secure data feeds with external parties as well as internal applications including the data warehouse and business intelligence applications.

Performance analysis and QA.

Lead SQL and SSIS programming initiatives.

Work to train key IT Staff on advanced SSIS, SQL, XML (x12) and EDI techniques and design patterns.

Diagnose ETL and database related issues, perform root cause analysis, and recommend corrective actions to management.

Work with a project team to support the design, development, implementation, monitoring, and maintenance of new ETL programs.

Complete other related duties and special projects as assigned by IT management.

Provide support to IT management with developing and implementing a comprehensive ETL & EDI strategy.


Technical Skills:

Bachelor s Degree in Computer Science, Professional experience in a healthcare setting

. Core competency required in TSQL, EDI interfaces, SSIS, Erwin, x12, SQL Server 2008R2 - 2014 ETL development, database administration and analysis.

Experience in SSIS package versions 2008R2/2012.

Working knowledge of Visual Basic/.NET programming is required.

Expert knowledge of and significant experience with x12 EDI transaction sets. Excellent skills in writing technical design specifications.

Superior problem solving and troubleshooting capabilities.

Minimum eight years experience in ETL programming utilizing SSIS packages, DTS, stored procedures, Informatica, Pentaho and SQL scripts.

Minimum seven years demonstrated professional experience in IT development and support roles with at least 4 years of direct ETL experience.

At least 3 years of building EDI file sets including data extraction/consumption and data loading from/to EDI file sets.

Experience working with Healthcare-related EDI files (834, 835, 837, etc.).

Strong critical thinking and problem solving skills required

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.