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

Northeast Healthcare Recruitment, Inc. (NEHCR)

Remote Dementia Neurologist - Part-Time Telemedicine Job at Northeast Healthcare Recruitment, Inc. (NEHCR)

A healthcare recruitment company is seeking a Board-Certified Neurologist with expertise in dementia, cognitive neurology, or behavioral neurology for a part-time remote role. This position involves conducting clinical assessments and collaborating with care teams to enhance...

AFIMAC Canada

Private Investigator Job at AFIMAC Canada

 ...global leader in providing elite security, crisis management, and investigative solutions to a wide range of industries. We specialize in...  ...-effective services, and we are currently seeking experienced Private Investigators to join our dynamic team in Ontario. As a private... 

Hilton

Bartender (Part Time), Parkview Kitchen and Spirits - Juniper Hotel Cupertino, Curio Collection by Hilton Job at Hilton

 ...hospitality career, then this is the job for you!The incredibleJuniper Hotel Cupertinois looking to add abartenderto their amazing food...  ...What are we looking for? Since being founded in 1919, Hilton has been a leader in the hospitality industry. Today, Hilton remains... 

Personal Touch Home Aides of New York

RN Pediatric Home Care (Registered Nurse) Job at Personal Touch Home Aides of New York

RN Pediatric Home Care (Registered Nurse) Location Brooklyn, NY : RN Pediatric Home Care (Registered Nurse) Brooklyn, NY In order...  ...Reimbursement: We make sure you're compensated for your business travel. Opportunities for Professional Growth and Development:... 

Option Care Health Inc.

Clinical Pharmacist Job at Option Care Health Inc.

 ...Possibilities. With the nations largest home infusion provider, there is no limit to...  ...members including 5,000 clinicians, we work compassionately to elevate standards of care...  ...Job Description Summary: The Clinical Pharmacist is a licensed professional who is...