SQL Developer - Data Conversion

Our Insurance industry client seeks a SQL Engineer for a FT remote role with infrequent travel. This is a salaried role offering salary plus bonus and benefits. This role is direcct hire only and not open to 3rd parry or consulting candidates.

Should have expertise in:SQL Scripting and data mapping, strong SSIS Scripts and Data migration and transformation experience, mapping and writing scripts, improving data processes(doing some manual process and how can we insert through script or program), ability to give ideas on how to do better with existing scripts and great communications to manage multiple project deadlines,

As a Data Conversion Engineer, you will be responsible for designing, implementing, and executing data conversion processes to ensure the smooth transition of data from legacy systems to modern platforms. Your expertise in data manipulation, transformation, and migration will be crucial in maintaining data integrity and enabling accurate and efficient data conversion. Your ability to collaborate with cross-functional teams and troubleshoot complex data issues will contribute to the success of our data conversion initiatives.

As a Data Conversion Engineer, you will play a crucial role in ensuring the successful conversion of data from legacy systems to modern platforms. Your contributions will enable our organization to leverage accurate and reliable data, improve operational efficiency, and make informed business decisions. Join our team and make a significant impact on our data management and conversion initiatives.

Primary Responsibilities and Duties: Analyze legacy data systems and understand the data structure, relationships, and dependencies to design effective data conversion strategies.Collaborate with stakeholders to define data conversion requirements, objectives, and success criteria.Develop and implement data conversion plans, including data extraction, cleansing, mapping, transformation, and migration processes.Perform data profiling and analysis to identify data quality issues, anomalies, and inconsistencies in the legacy data.Write scripts, queries, or programs to extract, transform, and load (ETL) data from various sources into the target systems.Ensure data integrity and accuracy during the conversion process by validating and reconciling data across multiple systems.Collaborate with database administrators, software developers, and system administrators to ensure compatibility and smooth integration of converted data into the target systems.Develop and maintain documentation related to data conversion processes, including data mapping, transformation rules, and validation procedures.Monitor and troubleshoot data conversion issues, identify root causes, and implement corrective actions in a timely manner.Conduct performance tuning and optimization of data conversion processes to enhance efficiency and minimize processing time.Collaborate with testing teams to develop and execute data validation tests to ensure the accuracy and completeness of the converted data.Stay updated with industry best practices, emerging technologies, and data management trends related to data conversion.

Requirements and Qualifications:Relevant certifications or training in data management or ETL processes are desirable.Proven experience as a Data Conversion Engineer or similar role, with a focus on data migration and transformation.Proficiency in data manipulation, transformation, and migration using ETL tools, scripting languages, or programming languages (e.g., SQL, Python, R, etc.).Strong understanding of database concepts, data structures, and data modeling principles.Experience with data profiling, data quality assessment, and data cleansing techniques.Familiarity with database management systems and knowledge of SQL for data extraction, manipulation, and analysis.Knowledge of data integration methodologies and techniques, including data mapping and transformation rules.Understanding of data governance, data security, and privacy considerations in data conversion processes.Strong analytical and problem-solving skills to troubleshoot and resolve data conversion issues.Excellent collaboration and communication skills to work effectively with cross-functional teams and stakeholders.Detail-oriented mindset with a focus on data accuracy and integrity.Ability to manage multiple priorities and meet project deadlines.

Vertex Solutions Inc. is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, national origin, ancestry, religion, age, citizenship, sex, marital or veteran status, disability or handicap, sexual orientation or any other basis prohibited by applicable law.

Key Skills

• Python
• SQL