CACI International Jobs

Job Information

CACI International Data Conversion Analyst in Herndon, Virginia

Data Conversion Analyst

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Local

CACI is seeking a highly motivated, experienced Data Conversion Analyst to join our team that supports a custom-built food distribution management system, Integrated Food Management System (IFMS), for the USDA’s Food Distribution Program on Indian Reservations (FDPIR). This position will be responsible for developing and managing data conversion applications using data profiling, data conversion / transformation rules and data enriching techniques to produce data in the required format for the new system. It will also assist with loading the converted data into the Salesforce application.

What You’ll Get to Do:

  • Work with Business Analysts and solution architects to understand the business requirements, develop data conversion design.

  • Maintain tools for data processing, data cleansing, and verification of the integrity of data prior to processing and loading

  • Load data into Salesforce objects into test training and production environments using Salesforce Data Loader tool.

  • Understand business processes, gather, and document project requirements and translate them into SQL code/reports independently

  • Collaborate with Team Members, Project Stakeholders and End Users to manage transfer of course and target data

  • Develop standardized procedures for common SQL tasks.

  • Produce concise and clear technical specifications and other related technical documentation.

  • Determine testing needed to assure the functionality and integrity of data conversion solutions.

  • Create ad-hoc queries and reports as requested and provide on-going support to fine tune and evaluate queries.

  • Provide architecture thought leadership and actively participate in the design, implementation, and roll-out data conversion efforts.

  • Implement security and data protection solutions.

You’ll Bring These Qualifications:

  • Experience in error handling, debugging, error logging for production support in SSIS

  • Experience in bulk importing CSV, XML and Flat files data using Bulk copy program (BCP)

  • Hands on experience in performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes

  • Experienced in normalizing and de-normalizing the tables and maintaining referential integrity by using triggers and primary and foreign keys

  • Over 5 years of experience in developing and maintaining ETL and Business Intelligence Solutions using SSIS / SSRS, and expertise in designing and implementing Relational Database models per business needs

  • Experienced in scripting in Script Tasking in SSIS (utilizing C#) to control the flow of SSIS package

  • Excellent analytical skills and problem solver

  • 5+ years Database management

  • 5+ years SQL experience

  • 5+ years SSIS experience

  • Familiarity with Microsoft Access using Linked Tables and VBA.

  • Bachelor’s degree

  • Favorable NACI background investigation

These Qualifications Would be Nice to Have:

  • Experience with Salesforce and Salesforce ATA loader tool

  • AWS experience with RDS, S3 and EC2

  • Experience with Agile-SCRUM environment with corresponding sprint cycles and work products

Company Overview: 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 an Equal Opportunity Employer – Females/Minorities/Protected Veterans/Individuals with Disabilities.