Sign in

ETL Developer Data Warehouse (Informatica/Oracle)

CareWorks Technologies
Columbus, Ohio, United States
November 09, 2018


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 ETL design and development. You will be 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. You will create and maintain 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. You will be 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.

Required Experience:

• A minimum of two (2) 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

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


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.