Data Migration Analyst

US Tech Solutions; Sunnyvale (CA); On-site; USD 80,000 - 100,000; Full time

Job summary

A staffing solutions firm in California is seeking a data migration expert with over 5 years of IT experience. The role involves building SQL queries, executing data migrations, and ensuring quality assurance processes are met. Candidates must possess excellent communication skills, be adept at team collaboration, and have a proven track record in data analysis and management. The position offers opportunities for professional growth in a dynamic environment.

Qualifications

• At least 5 years of IT-related experience.
• 3-5 years of experience with databases focusing on SQL and ETL tools.
• Ability to build SQL data queries.
• Experience in leading data migration processes and methodologies.
• Solid understanding of software quality assurance best practices.

Responsibilities

• Assist in the design, planning, and management of data migration.
• Perform source system data analysis for mapping.
• Conduct migration and testing of data between systems.
• Create and execute test plans and cases for various scenarios.
• Regularly report on the execution of system testing.

Skills

SQL

PL/SQL

Data Migration methodologies

Data Cleansing methodologies

Data analysis

Test Plans creation

Interpersonal skills

Organizational skills

Job description

US Tech Solutions is a global staff augmentation firm providing a wide-range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit our website www.ustechsolutions.com.

We are constantly on the lookout for professionals to fulfill the staffing needs of our clients, sets the correct expectation and thus becomes an accelerator in the mutual growth of the individual and the organization as well.

Keeping the same intent in mind, we would like you to consider the job opening with US Tech Solutions that fits your expertise and skillset.

Qualifications

Required qualifications:

• At least 5 years of IT related experience
• 3-5 years working with databases with demonstrated expertise in SQL, PL/SQL, Oracle 11, ETL tools, Data conversion, Data De-duplication, Data Cleansing methodologies
• Be able to build SQL data queries
• Demonstrated experience in analyzing data sets and Effective at understanding a problem and developing one or many approaches to solving the problem.
• Assist in designing, planning and managing the data migration process.
• Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.
• Experience in Data Migration methodologies
• Highly effective working in a team, as well as working independently.
• Perform source system data analysis in order to manage source to target data mapping.
• Perform migration and testing of static data and transaction data from one core system to another.
• Perform data migration audit, reconciliation and exception reporting.
• Assist with the identification of trends or patterns in complex data sets
• Filter and “clean” data, and review reports, printouts, and performance indicators
• Create Test Plans and Test Cases for all scenario types and execute. (i.e. positive, negative testing, boundary)
• Verify requirement traceability from System Requirements through test cases and defects
• Ensure that testing activities will allow applications to meet business requirements and systems goals, fulfil end-user requirements, and identify and resolve systems issues
• Work with the developers to understand the technical requirement/design being built in a project
• Validate Test Preparation of environments and verify all teams are aligned with what needs to occur to build/prepare the test environments
• Coordinate, track and report regularly on execution of system testing
• Verify defects are effectively recorded, communicated and understood
• Analyze and ensure test results and changes/defect are reflected in the test case and test cases are updated appropriately based on resolution
• Identify and recommend process improvements as necessary
• Excellent written and oral communication skills
• Excellent listening and interpersonal skills (includes but not limited to peers, managers, and the business)
• Excellent organizational skills to manage a wide array of testing information
• Strong knowledge of system testing and software quality assurance best practices and methodologies