ETL Developer

ETL Developer

Seattle, WA or Portland, OR

Responsibilities & Requirements:
This position participates in a team environment for the development, implementation, and maintenance of processes to populate multi-division data stores. Responsible for programming, debugging and testing of ETL work in a development environment. The successful candidate will be generally responsible for providing the team with technical oversight, code reviews, design reviews, and mentorship. This position provides technical, interpersonal, and administrative skills in performing day-to-day work.

Your Professional Experience and Education will include:

• Bachelor’s degree in Computer Science, Mathematics, Business Administration, or a related field. Appropriate additional experience beyond the minimum required experience may be substituted for education.
• Minimum 6 years relevant experience in a multi-platform environment, including, but not limited to application development or database development.
• Must be able to develop efficient and effective program and system solutions in solving highly complex business problems.
• Proven ability to implement and deliver software solutions through the iterative life cycles using Agile or Waterfall style methodologies.
• Must be able to effectively adapt to rapidly changing technologies and methodologies and apply them to technological and/or business needs.
• Must be able to analyze, diagnose and resolve complex programming and system problems independently.
• Able to work well with groups of business customers and IT partners.
• Able to provide direction to others in analyzing and solving program and system issues and problems.
• Able to provide technical direction and solutions to other team members.
• Strong familiarity with Oracle, SQL Server, Sybase, DB2, Microsoft Analysis Services/OLAP and mainframe database systems and reporting methodologies.
• Strong writing, documentation, and oral communication skills.
• Be able to plan and manage his/her own work.
• Thorough knowledge of all stages of the Software Development Life Cycle.
• Strong understanding of the principles of Data Warehousing, including the use of Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling.
• Strong knowledge of data modeling support for numerous strategic application development projects.
• Excellent experience working with Oracle, PL/SQL and writing stored procedures and triggers.

Tool set and COTS knowledge requirements:

• Extensive ETL tool experience using Ascential DataStage Version 7.5 or better, including designing and developing jobs using DataStage Designer, DataStage Manager, DataStage Director and DataStage Debugger and Parallel Extender
• Oracle
• Sybase
• MS SQL Server
• XML
• UNIX (AIX ksh)
• Harvest
• Facets 4.x data model knowledge

A successful candidate will demonstrate:

• Capability to Review and provide input to modify existing Data-Models.
• Involvement in Code Review meetings and ability to communicate suggestions based on Best-Practices.
• Development of DataStage jobs using various stages including Aggregator, Join, Transformer, Sort, Merge, Filter, Funnel, Surrogate Key generator, Modify, Row-generator, Column generator, Change Capture, Lookup, ODBC, Link Partitioner, Link Collector, Hash File, Head, and Peek

• Experience in Tuning DataStage transformations and SQL queries for jobs to enhance their performance.
• Capability to develop the technical specification documents from the functional documents and maintain the technical specification document.
• Experience to map multiple data sources to single target database by analyzing the business requirements specified in the functional specification or Data Mapping Document
• Knowledge to write korn shell scripts for scheduling of processes as well as the FTPing and Backup of required files, and maintenance of said backup files.

This position is posted at levels III or IV DOE.

About Us:
At Cambia, we advocate for transforming the health care system. You aren’t satisfied with the status quo and neither are we. We’re looking for individuals who are as passionate as we are about transforming the way people experience health care. We offer a competitive salary and a generous benefits package. We are an equal opportunity employer dedicated to workforce diversity and a drug and tobacco-free workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, age, sex, sexual orientation, gender identity, disability, protected veteran status or any other status protected by law. A drug screen and background check is required.

Cambia’s portfolio of companies spans health care information technology and software development; retail health care; health insurance plans that carry the Blue Cross and Blue Shield brands; pharmacy benefit management; life, disability, dental, vision and other lines of protection; alternative solutions to health care access; and free-standing health and wellness solutions.

We have nearly a century of experience in developing and providing health solutions to serve our members. We had our beginnings in the logging communities of the Pacific Northwest as innovators in helping workers afford health care. That pioneering spirit has kept us at the forefront as we build new avenues to improve access to and quality of health care for the future.