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

AccuWeather Careers

Graphic Designer Intern Job at AccuWeather Careers

 ...We are seeking a creative, detail-oriented Intern Graphic Designer to support our design and marketing team. This internship offers hands-on experience working on real-world projects while learning industry-standard tools, workflows, and creative best practices. The ideal... 

Zetrick LLC

Mail Carrier Job at Zetrick LLC

 ...industry looks forward to continued growth and job security. We invite you to join our team and work independently at your local post office for your local community! What We Offer Healthcare benefits available for most employees 401k Bi-weekly Pay Vehicle... 

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... 

University of Maryland Medical System

Registered Nurse (RN), New Grad, Shock Trauma, Multi Trauma IMC, Rotating Job at University of Maryland Medical System

 ...stipulated in the Nursing Documentation policy. # The nurse graduate may administer medications under the DIRECT supervision of an RN. The nurse graduate may NOT administer medications independently. # Performs CPR as needed. # Follows institutional infection... 

Hertz

CAD Design Manager Job at Hertz

CAD Design Manager Location Estero, FL : A Day in the Life: The Design and Planning CAD Manager is responsible for developing schematic...  ...& more The Hertz Corporation operates the Hertz, Dollar Car Rental, Thrifty Car Rental brands in approximately 9,700 corporate...