Sign in

Junior ETL Developer

Company:
CareWorks Technologies
Location:
Columbus, Ohio, United States
Posted:
December 05, 2018

Description:

For more than 18 years, CareWorks Tech has been delivering technology solutions that drive results. As your advocate, the common thread across our associates is crafting the right tech-savvy solutions. Whether it’s IT Consulting, Infrastructure Services, Security, Enterprise Service Management or Interactive, we’re all about finding solutions that advance your career aspirations. Our ongoing client relationships speak to our long-term collaborative partnerships.

Position Description: You will develop complex data extracts, applications, and ad-hoc queries while participating in multi-organizational, multi-disciplinary teams to determine, articulate, & codify business requirements; models/designs and is responsible for Extract, Transformation & Loading (ETL) design and development.

Required Experience

Minimum of two (3) recent years of experience in ETL development (Informatica) and system analysis

Two (2) years of Dimensional Data Modeling and Data Profiling experience for data warehouse development

Experience integrating disparate systems of record into conformed dimensions and fact tables

Excellent documentation and communication skills

Strong performance tuning skills with ETL’s

Responsibilities Include

Designing and developing ETL’s in a data warehouse (with Informatica/Oracle) environment. You will conduct facilitated discussions with customers to review current specs & gather additional business requirements; analyze & write business requirements, scope documents, program specifications & system documentation as well as design test procedures & tests system for validity & reliability; ensures logical & systematic conversion of customer requirements into total systems solutions that acknowledge scope, schedule & cost constraints; provides data analysis, data architecture & design assistance to functional/systems analysts, application developers & users.

Creating and maintaining logical & physical data models & data dictionaries; write system requirements, general & detailed design documents; participates in management short & long-term planning & assists in agency-wide policy & program development as impacts automated systems.

Responsible for the development, testing, and maintenance of ETL processes while supporting the activities involved in troubleshooting and tuning of the ETL processes. It is expected that you will develop test, maintain, and support data flows, jobs, and processes based on requirements for the data warehouse and operational data stores; collaborate with senior ETL developers, Solutions Architect, and Data Architect to understand business requirements, data models, and ETL specifications; provide ETL repository administration services and enforce ETL object reusability; maintain ongoing knowledge of Informatica software and hardware environments (including future releases); perform problem assessment, resolution and documentation; recommend and implement improvements to the overall ETL development processes.

The CareWorks Family of Companies is committed to providing career opportunity and growth to all Associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.

CareWorks Tech Strategically-Led Technology Solutions

5555 Glendon, CT

Dublin, OH 43016

614-789-3767

david.horvay@careworkstech.com

Thank you for considering CareWorks Tech for your next career opportunity. CareWorks Tech is not your typical technology company. We are part of the CareWork’s family of companies which is one of Ohio’s largest managed care organizations, serving over 115,000 employers and owned by York Risk Services Group. We have 4 guiding principles: (1) Customer Commitment (2) Attitude of Service (3) Respect for the Individual and Team and (4) Exceeding Expectations. We invest in your training, professional development, benefits (medical, 401k, paid holidays/vacation, etc.) and personally focus on your career success. We have operations in 85 locations worldwide and employ 5,000+ people.