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.
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.