Required Skills

Data Warehouse Architect

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 :- 2nd Jun 2025

JOB DETAIL

Ability to lead a Data Mart development project including design, development, data modelling, implementation and documentation. 

Knowledge of Oracle databases and data warehouse database design. 

Ability to design data warehouse schema objects for various Data Marts. 

Ability to use data warehouse designing software tools like Erwin, Visio or others to document and communicate project goals effectively. 

Ability to build data warehouse fact tables and dimension tables applying slowing changing dimension concepts. Ability to design ETL jobs to integrate data from different sources into Oracle Exadata databases runing on Oracle Cloud Infrastructure. 

Ability to build data pipelines to process terabytes of data while maintaining performance and proactively scaling resources as needed. 

Ability for query, and Talend job optimization to ensure adequate performance. 

Ability to analyse visualization/reports requirements to design the corresponding database objects. 

Good communication skill to provide knowledge transfer sessions and the corresponding documentation. 

Ability to draft project documentation including diagrams and project management documentation requirements. 

Knowledge of the Talend administration console to help maintain and configure new projects and jobs.

Company Information