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

YVpTWDQ1R3E1RDRqRTBpM3FPMFpqYWdIN1E9PQ==
  • 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

Vets Hired

Ultrasound Technician Job at Vets Hired

 ...Job Summary Ultrasound Technician This role involves performing high-quality obstetric and gynecologic ultrasound examinations while ensuring a professional, comforting, and patient-centered experience. The Ultrasound Technician is responsible for operating and maintaining... 

jobgether

Data Analyst - REMOTE Job at jobgether

 ...opportunity for someone looking to grow in a dynamic and innovative remote work environment. Accountabilities Collect, clean, and...  ...'s degree in Data Analytics, Statistics, Mathematics, Computer Science, or a related field. ~3-6+ years of experience in data analysis... 

Chipton‑Ross Inc

216524 - Structural Analysis Engineer Job at Chipton‑Ross Inc

 ...Experience in stress analysis of subsystems and subsystems installations desired. ~Experience with MRB stress analysis of metallic and composite structure desired.~Experience using Altair HyperMesh as a pre-processor and TMP Vision for post-processing desired. ~... 

Nesco Resource

Regional Recruiter Job at Nesco Resource

 ...Were looking for a Regional Recruiter to support multiple branches by delivering top talent across professional, engineering and...  ...and new client hiring needs. What You Bring ~35 years of staffing agency recruiting experience required. ~ Strong sourcing skills (Boolean... 

Cintas Corporation

Sales Representative - Facility Services Job at Cintas Corporation

 ...Requisition Number: 217203 Job Description Cintas is seeking a Sales Representative to focus on new business-to-business account development in our Facility ServicesDivision. Responsibilities include prospecting, cold calling, setting appointments with prospects...