Apply Now    

Informatica Developer

Req #: 202134
Location: North Charleston, SC US
Job Category: Information Technology
Security Clearance: Secret
Clearance Status: Must Be Current

Job Description


  • Develop Informatica workflows to ingest data from multiple transactional system according to documented logic and source to target mappings
  • Migrate existing SQL scripts to Informatica workflows for data ingest
  • Follow specifications provided by the Chief Data Architect for development of Informatica Services based solutions for migrating data in a data warehouse environment
  • Develop triggers, functions, stored ETL procedures to support data ingestion and migration
  • Assist with design, testing, support, and debugging of new and existing ETL and reporting processes
  • Work with other developers, testers, DBAs, project managers, and client business users and developers to develop specifications and resolve issues
  • Perform data profiling and analysis using Informatica suite
  • Troubleshoot and support production processes
  • Create and maintain documentation
  • Monitor ETL workflows and logging, providing job reports and status as required
  • Perform ETL failure recovery when required

Required Skills:

  • 6+ years of software development experience
  • 3-5+ years of SQL Server experience with T-SQL, SSIS, SSRS
  • Experience with Informatica PowerCenter 9.5 or higher
  • Experience in a data warehouse and BI environment
  • Experience with Oracle RDMS and associated tools/infrastructure
  • At least 5 years in technical development on data warehouse related projects with experience designing and developing ETL tools
  • Experience retrieving data from various database platforms, web service APIs, flat files, etc.

Desired Skills:

  • SSAS knowledge
  • Experience with Tableau, SAS
  • Experience with additional ETL or reporting tools
  • Experience with PowerBI
  • Experience with Military Heath System data
  • Experience in working Agile/Scrum environment

Job Location

US-North Charleston-SC-CHARLESTON


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.

Apply Now    
Link for schema