Data Migration Specialist

7 days ago


Washington, Washington, D.C., United States CAI Full time

Job Title: Data Migration Consultant

Job Summary:

We are seeking a highly skilled Data Migration Consultant to join our team at CAI. As a Data Migration Consultant, you will be responsible for designing, developing, and maintaining ETL scripts and programs to extract, transform, and load data from Oracle data sources to API endpoints and directly into a SQL Server database.

Key Responsibilities:

  • Create SSIS packages to extract data from the database according to specified criteria
  • Develop Java programs for ETL when warranted by data needs and constraints
  • Apply necessary data transformations to ensure data is in the correct format for export
  • Load data via API endpoints or directly into SQL Server tables
  • Test and validate SSIS packages and Java programs to ensure they are extracting and transforming data correctly

Requirements:

  • Strong proficiency in ETL tools (e.g., SSIS, Informatica)
  • Proficiency in programming languages (e.g., Java)
  • Experience with APIs
  • Understanding of data modeling and database design principles
  • Knowledge of data quality and validation techniques
  • Strong analytical and problem-solving skills
  • Excellent communication and documentation skills

Physical Demands:

  • Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
  • Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
  • Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard and monitor

Equal Employment Opportunity Policy Statement:

CAI is an equal opportunity employer and welcomes applications from diverse candidates. We are committed to creating an inclusive work environment that values diversity, equity, and inclusion.



  • Washington, Washington, D.C., United States Tilo Dynamics Full time

    Job DescriptionJob SummaryTilo Dynamics is seeking a highly skilled Data Migration Specialist to join our team. As a Data Migration Specialist, you will be responsible for testing the data migrated from historic enterprise data sources into a cloud-based enterprise data platform.Key ResponsibilitiesTest the data migrated from historic enterprise data sources...


  • Washington, Washington, D.C., United States Tilo Dynamics Full time

    Job DescriptionJob Summary:Tilo Dynamics is seeking a highly skilled Cloud Data Migration Specialist to join our team. As a key member of our data migration team, you will be responsible for migrating historic enterprise data from antiquated data sources into a cloud-based enterprise data platform.Key Responsibilities:Migrate large datasets from on-premises...


  • Washington, Washington, D.C., United States Tilo Dynamics Full time

    Job DescriptionJob Summary:Tilo Dynamics is seeking a highly skilled Cloud Data Migration Specialist to join our team. As a key member of our data migration team, you will be responsible for migrating historic enterprise data from antiquated data sources into a cloud-based enterprise data platform.Key Responsibilities:Migrate large datasets from on-premises...


  • Washington, Washington, D.C., United States Zenius Full time

    Job OverviewWe are seeking a highly skilled Senior Health Data Migration Engineer to join our team at Zenius. As a key member of our team, you will be responsible for assessing and maintaining the Department of Veterans Affairs' (VA) data migration requirements, ensuring effective data handling between VA systems and Cerner.Key Responsibilities:Review and...


  • Washington, Washington, D.C., United States General Dynamics Information Technology Full time

    Job Summary:We are seeking a highly skilled Senior Software Engineer to join our team at General Dynamics Information Technology. As a PHP Migration Specialist, you will be responsible for leading the migration of legacy ColdFusion applications to modern platforms, utilizing your expertise in PHP, MySQL, and Apache.Key Responsibilities:Develop software...


  • Washington, Washington, D.C., United States Zachary Piper Full time

    Job Title: Data Integration SpecialistLocation: Hybrid, first three months remote.Company: Zachary Piper SolutionsDuration: 4 years left on contractClearance Required: TS/SCIJob Overview:Zachary Piper Solutions is seeking a highly skilled Data Integration Specialist to join our team in support of a government agency. This position will be 3 months remote,...


  • Washington, Washington, D.C., United States Goldman Edwards, Inc. Full time

    Job OverviewAs a Lead Cloud Migration Project Manager at Goldman Edwards, Inc., you will take charge of the strategic migration of applications to cloud environments, ensuring seamless transitions for various stakeholders. This role demands exceptional project management capabilities, comprehensive knowledge of cloud technologies, and recognized IT project...


  • Washington, Washington, D.C., United States U.S. Department of the Interior Full time

    Job SummaryThe U.S. Department of the Interior is seeking a highly skilled Natural Resources Specialist to join our team. As a key member of our organization, you will be responsible for managing and maintaining our official national AIM data repository.Key ResponsibilitiesCompile, edit, migrate, build, and maintain an official national AIM data repository...


  • Washington, Washington, D.C., United States Serigor Inc. Full time

    Job Title: Database Specialist MasterAt Serigor Inc., we are seeking a highly skilled Database Specialist Master to join our team. As a key member of our IT department, you will be responsible for designing, creating, and maintaining databases in a client/server environment.Key Responsibilities:Database Design and Development: Design, create, and maintain...


  • Washington, Washington, D.C., United States Pantheon Data Full time

    Job DescriptionCompany OverviewPantheon Data, a subsidiary of Kenific Holding, operates as a private small business located in the Washington, DC area. Established in 2011, Pantheon Data initially focused on acquisition and supply chain management services for the US Coast Guard. Over the past decade, our service offerings have expanded significantly, now...


  • Washington, Washington, D.C., United States Pantheon Data Full time

    Job DescriptionCompany OverviewPantheon Data, a subsidiary of Kenific Holding, is a privately-owned enterprise located in the Washington, DC, region. Established in 2011, Pantheon Data initially focused on acquisition and supply chain management services for the US Coast Guard. Over the past decade, our service portfolio has expanded significantly, now...


  • Washington, Washington, D.C., United States Vets Hired Full time

    Job DescriptionVets Hired is seeking a skilled Software Development Specialist to join our team.Key Responsibilities:Collaborate with development leads to implement solution designs and develop high-quality database solutions.Design and implement efficient database procedures and functions using T-SQL.Review and interpret ongoing business report requirements...


  • Washington, Washington, D.C., United States Educology Solutions Full time

    Job Title: ETL Professional Application DesignerAt Educology Solutions, we are seeking a highly skilled ETL Professional Application Designer to join our team. As a key member of our data integration team, you will be responsible for designing and developing processes that translate data from various sources to destinations and present findings to...


  • Washington, Washington, D.C., United States Apex Systems Full time

    Job Title: Salesforce Data AnalystApex Systems is seeking a highly skilled Salesforce Data Analyst to join our team. As a key member of our data integration team, you will be responsible for designing, configuring, testing, and deploying a new case management system and CRM.Key Responsibilities:Identify and understand source data systems and become an expert...


  • Washington, Washington, D.C., United States Penn Foster Inc Full time

    Job Title: Associate Economic Data EngineerWe are seeking a highly skilled Associate Economic Data Engineer to join our team at the IMF. As a key member of our Information Technology Department Data & Economics Economic Modeling Services Section, you will play a critical role in migrating existing macroeconomic models and frameworks into an innovative...


  • Washington, Washington, D.C., United States Pierce Technology Corp Full time

    Exciting Opportunity for a System Integration SpecialistWe are currently seeking a highly skilled System Integration Specialist to join our dynamic team at Pierce Technology Corp. As the System Integration Specialist, you will be responsible for leading and executing system integration and migration tasks for a variety of firmwide applications. If you have a...


  • Washington, Washington, D.C., United States Microsoft Corporation Full time

    Job SummaryWe are seeking a highly skilled Technology Specialist to join our team at Microsoft Federal. As a key member of our organization, you will play a critical role in helping us achieve our mission to empower every person and organization on the planet to achieve more.Key ResponsibilitiesOwn technical discussions with customers, leveraging processes...


  • Washington, Washington, D.C., United States EXCEL Management Systems Inc Full time

    Job SummaryThe Telecommunications Technician - Unified Communications Specialist will play a critical role in managing and supporting the full spectrum of analog, digital, and Unified Communications (UC) systems at our customers' sites.This position will be responsible for leading the deployment, configuration, and maintenance of UC systems, including...


  • Washington, Washington, D.C., United States Randstad Full time

    Job Title: Data Entry SpecialistAre you detail-oriented and organized? Do you have a passion for data management? We are seeking a skilled Data Entry Specialist to join our team at Randstad.Job Summary:We are looking for a highly motivated and detail-oriented individual to support our organizing and engagement systems. As a Data Entry Specialist, you will be...


  • Washington, Washington, D.C., United States Childrens Law Center Full time

    Job Title: Data Management SpecialistJoin Children's Law Center as a Data Management Specialist and play a critical role in fostering high-quality data collection across all teams. As a key member of the Evaluation and Learning team, you will be responsible for monitoring data entry, performing analyses, and facilitating data interpretation for continuous...