Title : Technical Analyst
Location : New York, NY- 10279
Duration : 2 years
Job Description :
We are seeking a Technical Analyst to support the migration of critical pension data into Vitech V3Locity version 10 on Oracle 19C . The Technical Analyst will perform hands-on analysis, data cleansing, and conversion activities, ensuring integrity and alignment with business requirements.
Key Responsibilities
- Conduct data profiling, mapping, and transformation from legacy systems into V3Locity / Oracle 19C.
- Write and optimize SQL / PL-SQL scripts for data extraction, transformation, and staging.
- ssist with data validation, reconciliation, and audit reporting .
- Document business rules embedded in legacy system code and translate them into migration logic.
- Support testing cycles, defect resolution, and quality assurance during conversion.
Required Qualifications
3-5 years of data analysis and migration experience .Hands-on skills with Oracle 19C, SQL, PL / SQL, and data staging environments .Familiarity with reconciliation and data cleansing best practices.Strong analytical and problem-solving skills with attention to detail.Oracle or related data management certifications preferred.