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

Leadership Triangle

HR Recruiter Job at Leadership Triangle

 ...Description We are looking for a HR Recruiter to join our team in Durham, NC! At the...  ...recruiting of regular, temporary (internal and agency), and intern positions; researching and...  ...as a recruiter (in-house recruiter or staffing agency recruiter)~ PHR or C/SPHR... 

Lincoln Healthcare

Temporary Human Resources Assistant Job at Lincoln Healthcare

 ...employee onboarding and offboarding processes. Maintain accurate and compliant personnel records. Support I-9 documentation, credentialing, and employee file audits. Assist with training logistics, payroll preparation, and benefits tracking. Support recruitment... 

Consolidated Edison Company of New York, Inc.

Sr Specialist - CBS Permit Management & Support Job at Consolidated Edison Company of New York, Inc.

Required Education/Experience Bachelor's Degree and 5 years Relevant experience or Master's Degree and 3 years Relevant experience Relevant Work Experience Must possess strong oral and written communication skills and can effectively interact...

Insight Enterprises, Inc.

Senior Change Management Consultant SADA Job at Insight Enterprises, Inc.

 ...Requisition Number: 103609 Sr Change Management Consultant Location: The role will be a remote position located in the United States. Insight at a Glance ~14,000+ engaged teammate s globally ~#20on Fortunes World'sBest Workplaces list ~$9.2 billion... 

SunPower

Solar installer Job at SunPower

 ...Solar Installer Join Our Growing Team! Are you looking for a hands-on career with unlimited earning potential and the chance to make a real impact? We're seeking motivated Solar Installers to help us bring clean, reliable energy to homes and businesses in our community...