Sign in

ETL mappings, workflows, stored procedures, functions, & triggers

Company:
CareWorks Technologies
Location:
Columbus, Ohio, United States
Posted:
November 08, 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.

Job Description: We looking for an Informatica ETL Developer with a strong background in metadata-driven data integration with Informatica PowerCenter. You will be tasked with analyzing, documenting, designing, creating, installing, maintaining, testing, troubleshooting, optimizing and enhancing large enterprise scale complex software applications to schedule, extract, transform, load, and report on data processing workflows (design and automate ETL applications, scripts, reports and other automated procedures). Experience with multiple development platforms and knowledge of their unique constraints in order to meet non-functional requirements is required. This is an Agile team environment where collaboration, communication, and documentation will be essential. You will be required to Design, Develop, and Test your code. Experience with Informatica PowerCenter tools (designer, workflow manager, workflow monitor, debugger) and PowerCenter transformations (look-up, XML, filter, router etc.) is also required.

Required Experience:

A minimum of four (4) 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

Experience in all phases of the SDLC, Production Support

Understanding of dimensional data models (STAR Schema)

Strong performance tuning skills with ETL’s – experience in File processing & validation

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.