Required Skills

Fact Dimension tables Dimensional Modelling Netezza

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 10th Mar 2021

JOB DETAIL

•                 Should have extensive knowledge in Unix shell scripting.

•                 Thorough Understanding of DW principles (Fact, Dimension tables, Dimensional Modelling and Data warehousing concepts).

•                 Research, development, document and modification of ETL processes as per data architecture and modeling requirements.

•                 Ensure appropriate documentation for all new development and modifications of the ETL processes and jobs.

•                 Should have worked at least 1 year in either Insurance or Banking domain.

•                 Should have extensive working experience with different Data Sources like Netezza, Oracle Databases.

•                 Should be very good in writing complex SQL queries.

•                 Experience in translating functional or non-functional requirements to system requirements.

•                 Exposure to scheduling tools like BMC Control-M.

•                 Experience in agile methodologies is desirable.

•                 Exposure to Big Data technologies will be an added advantage.

•                 End to end understanding of source->ETL->Application layer->Reporting.

•                 Must have good Oral, written & presentation skills to interact with business & technical teams on day to day basis as its a client facing role.

•                 Should be self-driven and able to run the show with minimal or no assistance.

•                 Should have minimum 2 years US experience.

Company Information