JPC-22160 - 83557---Data/Analytics Consultant
Job Posted: May 14, 2024 | Total views: 1

Job Description:

• 83557-1

   

  Job Description:

  Project Overview: NCW – Northe
  Corporate Warehouse is a data warehousing initiative catering to end user needs for Financial, Regulatory reporting and also deep lea
  ing/analytics.

  Contractor’s Role: Contractor will be working as Data Analyst within an Agile scrum team to study the existing DWH system and work towards redesigning the system as per new architecture.

  Experience Level: Minimum 3 years experience working as Data Analyst and overall 6-7 years IT experience.

   

  Qualifications:

  • Good understanding of dimensional modeling, SCD (Slowly Changing Dimension) designs

  • How to capture source to target mappings

  • Good hands on knowledge of sql queries and analysis

  • How to do Data analysis/profiling, Good communication skills, Analytical thinking

  • Good in doing documentation, preparing flow diagrams.

   

  Nice to Haves:

  • Knowledge about ETL process design

  • Knowledge and experience of working in projects related to Financial Domain

   

  Tasks & Responsibilities:

  • Study the existing data load designs, Capture source to target mappings and rules, perform Data Analysis using sql queries

  • Redesign the process as per new process standards, design table structures (staging, middle layer, reporting layer),

  • Prepare source feed requirement document, ETL load design documents for various layers (staging, middle layer, reporting layer).

  • Perform data validations to verify the data load as per the design

  • Collaborate with multiple teams involved in the project.

   

  Reason for Request:

  Comments for Suppliers:

  Minimum 3 years experience working as Data Analyst and overall 6-7 years IT experience.

About Company :
Purview is a leading Digital Cloud & Data Engineering company headquartered in Edinburgh, United Kingdom having a presence in 14 countries India (Hyderabad, Bangalore, Chennai and Pune), Poland, Germany, Finland, Netherlands, Ireland, USA, UAE, Oman, Singapore, Hong Kong, Malaysia and Australia.

We have a strong presence in UK, Europe and APEC, providing services to Captive Clients (HSBC, NatWest, Northern Trust, IDFC First Bank, Nordia Bank etc) in fully managed solutions and co-managed capacity models. Also, we support various top IT tier 1 organisations (Capgemini, Deloitte, Wipro, Virtusa, L&T, CoForge, TechM and more) to deliver solutions and workforce/resources.

Company Info: