Title: Senior ETL Developer
Location: Alameda,CA

Principal Responsibilities Include:
In close collaboration with users and trading partners, design, develop, test, and monitor EDI communications.
Create and manage 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.
Perform analysis and QA.
Diagnosis ETL and database related issues, perform root cause analysis, and recommend corrective actions to management.
Work with a small project team to support the design, development, implementation, monitoring, and maintenance of new ETL programs.
Complete other duties and special projects as assigned.

Essential Functions Of The Job:
Technical job knowledge: Core competency required in EDI interfaces, SSIS 2008R2 or 2012 ETL development, database administration and analysis.
Communications: Preparing written and oral reports and documenting related key information services.
Customer service: Building and maintaining working relationships with key personnel in other departments.
Compliance: Complying with the organization’s Code of Conduct, all regulatory and contractual requirements, organizational policies, procedures, and internal controls.

PHYSICAL REQUIREMENTS
Constant and close visual work at desk or computer.
Constant sitting and working at desk.
Constant data entry using keyboard and/or mouse.
Frequent use of telephone headset.
Constant verbal and written communication with staff and other business associates by telephone, correspondence, or in person.
Frequent lifting of folders and other objects weighing between 0 and 30 lbs.
Frequent walking and standing.
Occasional driving of automobiles.

Bachelor’s Degree in Computer Science.
Professional experience in a health care setting is highly desirable and a definite plus.

Minimum Years Of Additional Related Experience:
Minimum five years experience in ETL programming utilizing SSIS packages, DTS, stored procedures, Informatica, Pentaho and SQL scripts desired.
Minimum seven years demonstrated professional experience in IT development and support roles.

Special Qualifications:
Strong critical thinking and problem solving skills required.
Experience in SSIS package versions 2008R2/2012.
Working knowledge of Visual Basic/.NET programming is required.
Working knowledge of the health care industry EDI transaction sets including the 5010 file layouts.
Experience moving, manipulating, and integrating data between disparate systems is required.
Familiarity and experience working in a Unix-based system including the ability to read and perform basic maintenance on shell scripts.
Experience with Informatica and Automate tools a plus.
Strong customer service background and ability to work in a multidisciplinary company.
Strong interpersonal skills, mature judgment, and diplomacy required to interact effectively with a broad spectrum of people, both individually and in groups.
Experience in use of various computer system software as well as Windows, Visio, MS Word, Excel, Project, and PowerPoint.

Key Skills: