Technical Data Lead C2C requirements // NY (Onsite)

Title: Technical Data Lead

Location: NY (Onsite)

Need 10+ years consultant

Passport number mandatory

References:

We need to provide at least three (3) relevant references.

References should be of similar types of services within the last three years

Job Description: Technical Data Lead

Key Responsibilities

Responsible for executing the full data migration lifecycle.

Deliverables:

·         data mapping (three business areas, ~2 weeks each), conversion logic reviews weekly, cycle testing (two business areas and six all-data cycles), and six reconciliation cycles, Data validation at record level.

·         Data analysis, cleansing, conversion, and reconciliation.

·         Data Analysis Plan, Data Cleansing Approach, Data Conversion Plan, DCCARs, reconciliation reports, and knowledge transfer documentation.

· Weekly reports,

·         Development of PL/SQL packages, Procedures, and ETL scripts

·         Setting up staging tables and data pipelines

Reports:

·         Data Analysis Plan

·         Data Conversion Plan

·         Data Services plan

·         Data Security Plan

·         Data Services Project Staffing Plan

·         Status Reports

Application platform: COPS 1.0 is an Oracle Forms system, while COPS 2.0 (V3) is a Java-based application. COPS 2.0 will entirely replace COPS 1.0.

DB: Both applications will be on Oracle 19c with clustered architecture.

Responsibilities:

·         The work involves querying legacy data, building staging tables and ETL scripts, validating conversions, and managing data quality and governance.

·         Provides analysis, validation, and review support of mapping or conversion deliverables.

·         Expected to execute actual cleansing scripts within test and staging environments.

·         Expected to perform hands-on data conversion activities (e.g.. writing and running SQL scripts), as well as provide oversight, validation, and quality assurance for the System Integrator's conversion work.

·         Bridging scripts between parallel and reverse-parallel processing environments will need to be newly developed.

·         Will be taking on the external data source conversion responsibilities of the Fund.

·         Total estimated data volume to be migrated – 500GB that includes both historical & active records.

·         Coordinate with other teams, like QA, IV&V, Cybersecurity and System Coordinator apart Business teams.

· Performs technical and quality reviews, documents findings, and formally recommends acceptance or remediation to the Fund’s Project Manager

Key tools include Oracle DB, SQL/PLSQL, TOAD, Informatica, Talend, SSIS, Excel, and secure data transfer utilities.

Certifications: Only for Technical Data Lead – Any Oracle-recognized certification in data migration, integration, or database management (e.g., Oracle Database 19c, ODI, or OCI Data Integration) will satisfy the preference and be considered relevant.

Experience and Technical Qualifications

·         Bachelor’s or master’s degree in computer science, Information Systems, or a related field.

·         7+ years of experience in enterprise data migration, preferably in public sector, pension, or financial systems. Proficiency in Oracle 19C, PL/SQL, ETL frameworks, and data modeling.

·         Proven leadership in data analysis, cleansing, and conversion in large-scale transformation projects.

·         Strong understanding of data quality frameworks, reconciliation techniques, and data validation methodologies.

·         Proficient in SQL, data integration tools (e.g., Informatica, Talend, SSIS), and data profiling tools.

·         Proven experience developing and executing data conversion routines for legacy-to-modern systems.

·         Experience with scripting (Python, PowerShell, or Bash) for automation is preferred.

Thanks & Regards,

Priya, Sr. Resource Management Executive
A:  4080 McGinnis Ferry Road, Suite # 1302
      Alpharetta, GA-30005.
W: www.gallegasoft.com