Data Migration Engineer Atlanta GA
Data Migration Engineer
Location: Atlanta, GA (Hybrid)
Duration: 5 months
Day-to-day Responsibilities:
- Extract data from an Appian-based solution to a client-specified format for legacy database integration.
- Design, develop, and execute data migration processes, ensuring compliance with federal regulations.
- Work with federal acquisition data sources to ensure secure and high-integrity migrations.
Key Responsibilities:
- Data Migration Design & Execution - Build migration solutions for federal acquisition data, mapping complex data structures.
- ETL Process Development - Develop and deploy robust Extract and Transform processes for structured and unstructured data.
- Source-to-Target Mapping - Document mapping between legacy systems and target environments, focusing on data quality and transformation.
- Compliance & Security - Ensure migration processes adhere to federal data privacy and security standards.
- Data Quality Assurance - Resolve data quality issues and support acceptance testing with business users.
- Collaboration & Documentation - Work with federal acquisition SMEs and technical teams, maintaining comprehensive documentation.
- Performance Monitoring & Tuning - Optimize data migration jobs for efficient execution and troubleshoot technical issues.
Required Skills:
- API Design: Intermediate
- Data Migration: Advanced
- Data Modeling: Advanced
- ETL Architecture & Development: Advanced
- SQL: Advanced
Preferred Skills:
- Agile Software Development Methodology: Intermediate
- Federal Acquisition Regulation (FAR): Foundation
- Oracle Database: Advanced
- Requirements Collection and Management: Intermediate
- Verbal Communication/Presenting: Advanced
Expected Deliverables:
- Input into prime's status reporting processes; weekly timecards
Education: BS or equivalent
