ETL DATA Migration Lead Job at Cloud Analytics Technologies LLC, Manhattan, NY

Z0RWOWRzVXZPaU4zNXV3VlZyQlozUjFxdnc9PQ==
  • Cloud Analytics Technologies LLC
  • Manhattan, NY

Job Description

Job Details

Job Title: ETL DATA Migration Lead

Description

The Technical Data Lead provides technical leadership across all technical components of the data migration. This includes staging table design, ETL development, SQL/PLSQL scripting, environment support.

Key Responsibilities

  • Lead technical design of data migration architecture.
  • Build staging tables, ETL jobs, and transformation logic.
  • Write, execute, and optimize SQL/PLSQL scripts.
  • Support data extraction, cleansing, and reconciliation.
  • Review and validate SI's conversion logic and mapping specs.
  • Support conversion cycle testing and reconciliation cycles.
  • Develop bridging scripts for parallel and reverse-parallel processing.
  • Ensure data quality and adherence to security.
  • Produce required technical documentation and reports.

Primary Required Skills

  • Strong Oracle DB + SQL/PLSQL expertise.
  • ETL development using: Informatica, Talend, SSIS.
  • Experience building staging tables, migration scripts, data pipelines.
  • Experience validating SI-provided mapping specifications.
  • Experience with secure data transfer utilities.
  • Oracle Data Migration certification preferred .
  • Hands-on experience in complex conversion projects (multi-cycle).

Job Tags

Similar Jobs

Eagle Fire

Fire Sprinkler Inspector Job at Eagle Fire

 ...About Us: Since 1987, Eagle Fire Inc. has become a top-tier provider of comprehensive fire protection services, including fire sprinkler systems, life safety services, special hazards systems, fire alarm services, access control systems, fire protection systems management... 

HCRC Staffing

Neurologist New Brunswick NJ Job at HCRC Staffing

(Physician/MD qualifications required) Neurology - Neurologist New Brunswick NJ NO on call or weekend hours We are looking for Neurologist to join our growing medical team full time at our outpatient offices around the New Brunswick NJ area. We are interested in a... 

Hawkins County Board of Education

Transportation - Bus Monitor Job at Hawkins County Board of Education

 ...Supervisor Qualifications: Minimum of a High School Diploma or GED Purpose Statement: To assist the school bus driver in supervision of students and...  ...driver in maintaining discipline on school bus; monitor and assist students while bus is in operation stopping... 

Top Level Promotions

Office Support Assistant Work from Home Job at Top Level Promotions

 ...Work from Home Data Entry & Office Administration Flexible Online Role About the Job We are seeking organized and motivated...  ...opportunity is ideal for beginners looking to gain hands-on experience managing digital records, supporting administrative projects,... 

Commonpoint Queens

Worksite Monitor, Youth Employment Program Job at Commonpoint Queens

 ...The Part-Time Worksite Monitor will report to the SYEP/WLG Worksite Operations Coordinator, and will serve as a liaison between the Commonpoint...  ...who host SYEP interns every summer and WLG interns during the school year. RESPONSIBILITIES Visit each worksite in...