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

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

Machinify

Technical Lead - UI Engineering (Remote) Job at Machinify

 ...for all participants: patients, providers, and especially payers. Machinifys revolutionary AI-platform has enabled the company to develop and deploy, at light speed, industry-specific products that increase the speed and accuracy of claims processing by orders of magnitude... 

Theoria Medical

Physician Assistant Job at Theoria Medical

 ...0.00 SIGN ON BONUS**********RELOCATION ASSISTANCE AVAILABLE**********RELOCATION ASSISTANCE...  ...~ Supportive Community: Access to physician/provider network. ~ Effortless documentation...  ...multispecialty physician services, telemedicine, RPM, and more. We currently provide... 

Iowa Department of Administrative Services

Tax Compliance Internship Job at Iowa Department of Administrative Services

 ...Apply ? Tax Compliance Internship Salary $18.25 Hourly Location State of Iowa - Remote, IA Job Type...  ...Bureau, Operations Bureau, and Collections Bureau Hours: Part-time during semester approximately 12-16 hours per week. Full-time during... 

CornerStone Staffing

PRIOR AUTHORIZATION SPECIALIST Job at CornerStone Staffing

 ...PRIOR AUTHORIZATION SPECIALIST Make a real difference as a Prior Authorization Specialist in a high-volume healthcare or reimbursement hub setting. Use your expertise in benefit verification, insurance navigation, and medical insurance to accelerate access to critical... 

County Of York

Cyber Security Analyst Job at County Of York

 ...4:30 p.m. layers Information Technology domain Cyber Security Analyst commute - Job Summary POSITION SUMMARY The Cyber...  ...security operations addressing requests within service level agreements and defined uptime requirements. ~ Assist...