Octave
Posted 75 days agoVerified live 1d ago
Data Conversion Specialist
Brief overview
Remote
3 H-1B approvalsDept. of Labor
SQL ServerT-SQL scriptingStored proceduresPerformance tuningData conversionData migrationETL processesRecords Management systemsData analysisData validationSSISAzureSalesforceMicrosoft Teams
Visa sponsorship history
2 years sponsoring, last filed FY2025
Data powered by U.S. Department of Labor. This does not guarantee sponsorship for this specific role.3H-1B approved
100%approval rate
H-1B Petition ApprovalsVisas USCIS actually granted: the strongest sign the company sponsors.
20242
20251
Job description
Summary
Octave is seeking a highly skilled Data Conversion Specialist to join their team. This role focuses on designing, developing, and executing data conversion processes to migrate information from legacy systems into Octave's OnCall Records system, requiring strong SQL scripting skills and data validation expertise.
Responsibilities
- Analyze legacy system data structures and map them to target system schemas
- Create and maintain detailed mapping documentation for all conversion processes
- Collaborate with business analysts and product teams to ensure accurate data transformation
- Write, optimize, and maintain SQL Server scripts for data extraction, transformation, and loading (ETL)
- Experience with cross-platform data manipulation/migration (i.e. XML-> MSSQL, Oracle->MSSQL, etc.)
- Develop automated processes to streamline data migration and reduce manual intervention
- Conduct test runs of conversion scripts, troubleshoot issues, and refine processes for accuracy and efficiency
- Perform rigorous data validation to confirm accuracy and completeness of converted data
- Identify and resolve discrepancies between source and target systems
- Document testing results and maintain audit trails for compliance
- Communicate effectively with customers and stakeholders to clarify requirements and timelines
- Provide regular updates on conversion progress and manage expectations regarding deliverables
- Address customer inquiries and concerns promptly and professionally
Skills
- Proven experience with SQL Server (T-SQL scripting, stored procedures, performance tuning)
- Strong understanding of data conversion, migration, and ETL processes
- Familiarity with Records Management systems and related data structures
- Excellent customer communication skills and ability to manage expectations
- Strong documentation skills for mapping and process workflows
- Ability to analyze complex datasets and ensure data integrity
- Experience with SSIS or other ETL tools
- Knowledge with Azure, Sales Force, and Microsoft Teams
- Background in records management or Public Safety Experience
Qualifications
Must Haves
- Proven experience with SQL Server (T-SQL scripting, stored procedures, performance tuning)
- Strong understanding of data conversion, migration, and ETL processes
- Familiarity with Records Management systems and related data structures
- Excellent customer communication skills and ability to manage expectations
- Strong documentation skills for mapping and process workflows
- Ability to analyze complex datasets and ensure data integrity
Nice to Haves
- Experience with SSIS or other ETL tools
- Knowledge with Azure, Sales Force, and Microsoft Teams
- Background in records management or Public Safety Experience
