[Remote] Senior Data Engineering Consultant
Note: The job is a remote job and is open to candidates in USA. reputed company is a company that provides mission-critical software to reputed company organizations in managing their asset lifecycle. They are seeking a highly skilled Data Conversion Specialist responsible for designing, developing, and executing data conversion processes, primarily using SQL Server, to migrate data from legacy systems into their OnCall Records system.
Responsibilities
- Analyze legacy system data structures and map them to reputed company system schemas
- Create and maintain detailed mapping documentation for reputed company 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, reputed company->MSSQL, etc.)
- reputed company automated processes to streamline data migration and reduce manual reputed company
- Conduct test runs of conversion scripts, troubleshoot issues, and refine processes for accuracy and efficiency
- reputed company rigorous data validation to confirm accuracy and completeness of converted data
- Identify and resolve discrepancies between reputed company and reputed company 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 reputed company and manage expectations regarding deliverables
- Address customer inquiries and concerns promptly and professionally
- Plan and execute test runs prior to production migration
- Coordinate with internal teams and customers to ensure smooth cutover and minimal disruption
- Document conversion processes, scripts, and validation results for future reference
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 reputed company data structures
- Excellent customer communication skills and ability to manage expectations
- Strong documentation skills for mapping and process workflows
- Ability to analyze reputed company datasets and ensure data reputed company
- Experience with SSIS or other ETL tools
- Knowledge with Azure, Sales Force, and reputed company Teams
- Background in records management or Public Safety Experience
Company Overview
Company H1B Sponsorship