Data Transformation Analyst

Techvilla Solutions

Boca Raton, FL

Posted On: Nov 19, 2024

Posted On: Nov 19, 2024

Job Overview

Job Type

Contract - W2, Contract - Corp-to-Corp, Contract - Independent

Experience

3 - 8 Years

Salary

$40 - $45 Per Hour

Work Arrangement

Hybrid

Travel Requirement

0%

Required Skills

  • SQL
  • DBMS
  • Data security
  • data mapping
Job Description
Roles and Responsibilities
  • Analyze and interpret data structures from multiple sources. 
  • Maintain data mappings to ensure accurate data conversion. 
  • Create and execute scripts for data extraction, transformation, and loading (ETL) processes. 
  • Conduct thorough testing and validation of converted data to ensure accuracy and consistency. 
  • Identify and troubleshoot data inconsistencies and other data-related issues. 
  • Design, develop and optimize SQL queries for data retrieval and manipulation. 
  • Ensure SQL queries are efficient and adhere to best practices for performance and security. 
  • Create, maintain, and optimize stores procedures to support data migration processes and activities. 
  • Ensure stored procedures are well-documented and follow coding standards.
  • Troubleshoot and resolve issues related to stored procedures. 
  • Work closely with the development and migration teams to understand data requirements and provide solutions.

 

Qualifications
  • Bachelor's degree in computer science, Information Technology, or a related field 3-5 years proven experience in data conversion, SQL Development, and stored procedures 
  • Proficiency in SQL and experience with database management systems (PostgreSQL, Oracle, SQL)
  • Experience with data integration tools. Strong diligence and commitment to data accuracy and consistency
  • Ability to work with large datasets and complex data structures. Excellent communication and collaboration skills
  • Familiarity with cloud-based data services, AWS is a plus. Knowledge of data security and privacy best practices
  • Familiarity with data mapping tools and techniques
  • Strong organizational skills and ability to manage multiple tasks simultaneously.

Job ID: TS240478


Posted By

Vivek

Information Technology Recruiter