Required Skills

Data Warehouse Analyst

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 12th Aug 2025

JOB DETAIL

  1. Knowledge Transfer & Documentation:
  • Gain a thorough understanding of the existing data model, scripts, and workflows.
  • Document current functionality and business rules.
  • Work with Team to develop best path forward in their migration
  1. Production Support:
  • Monitor and troubleshoot batch processes using Control-M, maybe some off-hours support during weekdays and weekends.
  • Re-run or restart failed jobs, collaborating with the offshore team as needed.
  1. Development & Enhancements:
  • Write and enhance PL/SQL scripts.
  • Migrate existing scripts from local systems to Informatica workflows and automate processes.
  • Assist in migrating data between on-prem Oracle servers.
  1. Collaboration:
  • Work closely with the Architect and Sr. Developer on the data warehouse team.
  • Partner with business users and stakeholders to refine processes and clean up data models.
  1. Data Cleansing & Optimization:
  • Assist in streamlining the database, removing unnecessary columns, and improving performance.
  • Maintain updated documentation to reflect changes.

 

Company Information