CACI International (Ab Initio) ETL Developer in Arlington, Virginia

Job Description


Performs conversions, interface development, documentation and unit testing for the IPPS-A project, using the IPPS-A tools. Participates in development, integration and deployment of solutions. This role is responsible for designing, developing, and supporting application solutions and re-engineered components based on client requirements. Performs business and technical designer functions, including making contributions to business and technical architecture components of the enterprise solution. This role is responsible for supporting technical documentation using the project's toolset, code development based on design specifications, data management, and progress reviews with client stakeholders.


  • General responsibility in the design, development and delivery of human resources data integration between multiple external systems and PeopleSoft, using Ab Initio ETL

  • Develop technical solutions to business challenges and functional requirements

  • Create, update and edit functional and technical design specifications and solutions to satisfy project requirements

  • Interpret requirements, perform complex analyses and present options and recommendations to obtain desired results

  • Supports and independently owns tasks related to design, development of conversions and interfaces

  • Conduct Unit testing and resolve issues found in testing

  • Meet deadlines and manage multiple, dynamic priorities

  • Provides overall technical and logistical support to the program


  • Bachelor's degree in Computer Science or Information Systems or other technically relevant degree and 7-9 years of relative experience

  • At least 2 years of experience in design, development of conversions and interfaces with ETL tools such as Data Stage, Informatica or Ab Initio

  • Experience in reading/writing source to target mapping documents

  • Ability to work collaboratively in a team environment with a strong focus on customer service and solution ownership

  • Strong analytical skills and can demonstrate strong problem solving skills

  • Ability to communicate in a clear and concise manner and success working in Integrated Product Teams (IPTs)

  • Ability to meet deadlines and manage multiple, dynamic priorities.

  • Effective communication skills and demonstrated experience working in a team-oriented environment

  • Ability to attain active Secret clearance


  • Experience with Ab Initio ETL Platform (plans, graphs, psets, meta-programming, etc.)

  • Experience with PeopleSoft PeopleTools 8.5x and Integration Broker

  • Experience with PeopleSoft HCM 9.2

  • Experience as a data modeler and/or data architect

  • Experience with DoDAF Artifacts

  • Experience with existing Army Human Resources data and systems

Physical Demands:

Normal demands associated with an office environment. Ability to work on computer for long periods and communicate with individuals by telephone, email and face-to-face. Up to 10% of time for travel may be required.

Job Location


CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities.