About the company:
With over 2.5 crore customers, over 5,000 distribution points and nearly 2,000 branches, IndusInd Bank is a universal bank with a widespread banking footprint across the country. IndusInd offers a wide array of products and services for individuals and corporates including microfinance, personal loans, personal and commercial vehicles loans, credit cards, SME loans. Over the years, IndusInd has grown ceaselessly and dynamically, driven by zeal to offer our customers banking services at par with the highest quality standards in the industry. IndusInd is a pioneer in digital first solutions to bring together the power of next-gen digital product stack, customer excellence and trust of an established bank
.
Job Purpos
- e:To work on implementing data modeling solutio
- nsTo design data flow and structure to reduce data redundancy and improving data movement among systems defining a data linea
- geTo work in the Azure Data Warehou
- seTo work with large data volume of data integrati
on
Experie
nceWith overall experience between 10 to 15 years, applicant must have minimum 8 to 11 years of hard core professional experience in data modeling for large Data Warehouse with multiple Sourc
es.
Technical Sk
- illsExpertise in core skill of data modeling principles/methods including conceptual, logical & physical Data Mo
- delsAbility to utilize BI tools like Power BI, Tableau, etc to represent insi
- ghtsExperience in translating/mapping relational data models into XML and Sch
- emasExpert knowledge of metadata management, relational & data modeling tools like ER Studio, Erwin or oth
- ers.Hands-on experience in relational, dimensional and/or analytical experience (using RDBMS, dimensional, NoSQL, ETL and data ingestion protoco
- ls).Very strong in SQL que
- riesExpertise in performance tuning of SQL quer
- ies.Ability to analyse source system and create Source to Target mapp
- ing.Ability to understand the business use case and create data models or joined data in Datawareho
- use.Preferred experience in banking domain and experience in building data models/marts for various banking functi
- ons.Good to have knowledge
of -Azure powershell scripting or Python scripting for data transformation in
ADF- SSIS, SSAS, BI tools like Powe
r BI-Azure PaaS components like Azure Data Factory, Azure Data Bricks, Azure Data Lake, A
zureSynapse (DWH), Polybase, ExpressRoute tunneling,
etc.-API integra
tion
Responsib
- ilityUnderstanding the existing data model, existing data warehouse design, functional domain subject areas of data, documenting the same with as is architecture and proposed
- one.Understanding existing ETL process, various sources and analyzing, documenting the best approach to design logical data model where req
- uiredWork with development team to implement the proposed data model into physical data model, build data
- flowsWork with development team to optimize the database structure with best practices applying optimization met
- hods.Analyze, document and implement to re-use of data model for new initiat
- ives.Will interact with stakeholder, Users, other IT teams to understand the eco system and analyze for solu
- tionsWork on user requirements and create queries for creating consumption views for users from the existing DW
- data.Will train and lead a small team of data engin
eers.
Qualific
- ationsBachelors of Computer Science or Equi
- valentShould have certification done on Data Modeling and Data An
- alyst.Good to have a certification of Azure Fundamental and Azure Engineer courses (AZ900 or DP20
0/201)
Behavioral Compe
- tenciesShould have excellent problem-solving and time management
- skillsStrong analytical thinking
- skillsApplicant should have excellent communication skill and process oriented with flexible execution m
- indset.Strategic Thinking with Research and Development m
- indset.Clear and demonstrative commun
- icationEfficiently identify and solves
- issuesIdentify, track and escalate risks in a timely
manner
Selection
- Process:Interested Candidates are mandatorily required to apply through the listing on Jigya. Only applications received through Jigya will be evaluated
- further.Shortlisted candidates may need to appear in an Online Assessment and/or a Technical Screening interview administered by Jigya, on behalf on Indus
- Ind BankCandidates selected after the screening rounds will be processed further by Indus
Ind Bank
