Solution Architect

Pune, Maharashtra

Job Summary

Offer SR for Ravi Das

Key Responsibilities

The successful candidate will be a key player in the design and growth of the data integration platform which supports our global Wealth businesses. The platform integrates data from a range of sources and makes them available to consuming systems servicing day-to-day operations, reporting to regulators, and management information and business intelligence stakeholders. The platform is undergoing expansion and growth through 2021 and beyond, with many new data sources to be onboarded; therefore, we require a senior data warehouse and data integration consultant who would work closely with our Data Architect and with analysis and development teams to:

- assist stakeholders with their data requirements
- gather and manage in-depth knowledge of our data platform’s data models
- create and maintain data models and metadata
- design (but not build) changes and extensions to the platform’s data models and data flows
- perform impact assessment for required changes and
- define requirements and lead problem solving in the data architecture space bringing together people of different business and technical disciplines.

Skill Requirements

Essential Skills/Basic Qualifications:

- Data modelling (definition of data schemata)



and data analysis skills in a data warehouse type environment, including both star schema and third normal form. Using ER Studio or similar tool
- Robust SQL skills. Comfortable at the SQL command prompt
- Experience of working in Financial domain with understanding of key data entities in Investments and Client domain
- Understand types of data schema and when to use them (3NF, star, flat, etc); mapping/translation between these
- Express key structural points of complex data model in accessible terms
- Experience understanding source data models with limited documentation and access to experts
- Understanding of the principles of data quality and data governance

Desirable skills/Preferred Qualifications:

- Strong analytical skills
- Experience of inferring a data model and lineage from an existing database with limited documentation
- Python and Pandas for data manipulation
- Data warehouse background
- Experience of data science and machine learning principles and techniques
- ETL tools; ability to use and enhance new tooling
- Amazon Web Services (AWS) – AWS Glue, Athena, S3
- Data catalogue e.g. Alation
- Working in agile mode
- Graduate preferably with a technology based degree

Other Requirements

📌 Solution Architect (India)
🏢 HCLTech
📍 India