Find the right job for you in

Back to Results

ETL/DW Developer (PowerCenter)

Columbus, OH 01-04-2019

Location: Columbus, OH

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: We are looking for Informatica Developer who has experience with the latest versions of  PowerCenter who can design, build and deploy complex Informatica ETL’s and Mapplets. This position offers you an opportunity to help build out an entire ETL architecture from the ground up. It will allow you the flexibility and opportunity to influence technical decisions.  You will create prototype ideas and design data driven solutions from queries and scripts and help with the deployment of features in the production database and data warehouse including obtaining data from multiple external API’s. You will design and develop automated processes to perform scheduled tasks and data validation. You will work with Solution Architects and business area teams to build detailed technical design and specification documents, to meet business needs, considering capabilities, risks, and system dependencies. You will communicate insights and recommend areas for further data platform enhancements. You must have proven experience with testing and debugging ETL code

Responsibilities Include

  • Analyzing, planning, and executing ETL development, monitoring and enhancements
  • Collaborating, designing and developing backup and recovery plan and processes
  • Building, testing and coordinating deployment with platform teams for enterprise applications and integration services
  • Architecting and building a high level process overview of ingestion process for raw files
  • Creating header & detail level tables from raw flat files
  • Combing through file folder/sub-folder locations and create meta data related to where files are found and link it to the raw data contained within each file
  • Adhering to SDLC standards for software development

Educational Requirements: 4 year Bachelor’s degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline

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.

  • We'd love to hear from you! To be considered for this position, please fill out this form.

  • (pdf or doc file, 2mb limit)
    Accepted file types: pdf, doc, docx.
  • This field is for validation purposes and should be left unchanged.