CACI International Interface/ETL Developer, Sr. in Arlington, Virginia

Job Description:

Work with a purpose! Interested in steering your career in a meaningful direction where you will have the opportunity to work in a collaborative and dynamic environment? CACI is making a significant impact to the Army by developing and integrating the Integrated Personnel and Pay System-Army (IPPS-A), the Army’s future Web-based Human Resources (HR) solution across all Army Components. Designed to alleviate the Army’s current reliance on over 70 stove-piped systems, IPPS-A will provide a centralized resource for Soldiers, Leaders, and HR Professionals to better manage personnel and pay information. CACI is looking for great people who are interested in making an impact with their work. Join us to be a part of this exciting and monumental effort – once complete, IPPS-A will be the largest integrated personnel and pay system in the world!


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

Required Qualifications:

  • 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

Desired Qualifications:

  • 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


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.

Company Description:

CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. Join CACI, where 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. A Fortune magazine World's Most Admired Company in the IT Services industry, CACI is a member of the Fortune 1000 Largest Companies, the Russell 2000 Index, and the S&P SmallCap600 Index. CACI provides dynamic careers for over 20,000 employees worldwide.

CACI is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities.