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

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

MMS

Senior Medical Writer (Project-Based) - Remote Job at MMS

 ...About MMS MMS is an innovative, data-focused CRO that supports the pharmaceutical, biotech, and medical device industries with a proven, scientific approach to complex trial data and regulatory submission challenges. With a global footprint across four continents,... 

Roman & Associates

Claims Investigator Job at Roman & Associates

Claims Investigator - New YorkRoman is seeking a full time or part time claims investigator for the five boroughs and Buffalo, NY. The investigators will be responsible for handling insurance related claims. This is a unique opportunity to work for a fast growing, innovative... 

Elizabeth Glaser Pediatric AIDS Foundation

Director, Development Job at Elizabeth Glaser Pediatric AIDS Foundation

 ...free generation. Job Description Title: Director, Development Location: Washington, DC / Remote Reports To: Vice...  ...determined by factors such as qualifications , experience and training, education and certifications, internal equity, external... 

ExecutivePlacements.com

Software Tester Job at ExecutivePlacements.com

Staffmark Workforce Solutions offers this exciting contract opportunity at a global leader in electronics, mobile devices, and appliances, located in Plano, TX. Software Tester Top Skills Mobile Testing Detail Oriented Data driven Responsibilities Collect... 

Allen County Job and Family Services

Security Officer/Guard Job at Allen County Job and Family Services

 ...: 12 Hour Shift Are you interested in being part of our Security Team? Apply quickly and efficiently online? Weekly...  ...Driver's License required Computer skills, access control experience, ability to walk distances We are driven by a clear...