Data Scientist

IndusInd Bank


Date: 2 weeks ago
City: Mumbai, Maharashtra
Contract type: Full time

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 Purpose:

  • To work on implementing data modeling solutions
  • To design data flow and structure to reduce data redundancy and improving data movement among systems defining a data lineage
  • To work in the Azure Data Warehouse
  • To work with large data volume of data integration


Experience

With 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 Sources.


Technical Skills

  • Expertise in core skill of data modeling principles/methods including conceptual, logical & physical Data Models
  • Ability to utilize BI tools like Power BI, Tableau, etc to represent insights
  • Experience in translating/mapping relational data models into XML and Schemas
  • Expert knowledge of metadata management, relational & data modeling tools like ER Studio, Erwin or others.
  • Hands-on experience in relational, dimensional and/or analytical experience (using RDBMS, dimensional, NoSQL, ETL and data ingestion protocols).
  • Very strong in SQL queries
  • Expertise in performance tuning of SQL queries.
  • Ability to analyse source system and create Source to Target mapping.
  • Ability to understand the business use case and create data models or joined data in Datawarehouse.
  • Preferred experience in banking domain and experience in building data models/marts for various banking functions.
  • Good to have knowledge of –

-Azure powershell scripting or Python scripting for data transformation in ADF

- SSIS, SSAS, BI tools like Power BI

-Azure PaaS components like Azure Data Factory, Azure Data Bricks, Azure Data Lake, Azure

Synapse (DWH), Polybase, ExpressRoute tunneling, etc.

-API integration


Responsibility

  • Understanding 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 required
  • Work with development team to implement the proposed data model into physical data model, build data flows
  • Work with development team to optimize the database structure with best practices applying optimization methods.
  • Analyze, document and implement to re-use of data model for new initiatives.
  • Will interact with stakeholder, Users, other IT teams to understand the eco system and analyze for solutions
  • Work 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 engineers.


Qualifications

  • Bachelors of Computer Science or Equivalent
  • Should have certification done on Data Modeling and Data Analyst.
  • Good to have a certification of Azure Fundamental and Azure Engineer courses (AZ900 or DP200/201)


Behavioral Competencies

  • Should have excellent problem-solving and time management skills
  • Strong analytical thinking skills
  • Applicant should have excellent communication skill and process oriented with flexible execution mindset.
  • Strategic Thinking with Research and Development mindset.
  • Clear and demonstrative communication
  • Efficiently identify and solves issues
  • Identify, track and escalate risks in a timely manner


Selection Process:

  1. Interested Candidates are mandatorily required to apply through the listing on Jigya. Only applications received through Jigya will be evaluated further.
  2. Shortlisted candidates may need to appear in an Online Assessment and/or a Technical Screening interview administered by Jigya, on behalf on IndusInd Bank
  3. Candidates selected after the screening rounds will be processed further by IndusInd Bank

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Manager

Aon, Mumbai, Maharashtra
1 day ago
About OrganisationAon plc (NYSE: AON) is a leading global professional services firm providing a broad range of risk, retirement and health solutions.Our 50,000 colleagues in 120 countries empower results for clients by using proprietary data and analytics to deliver insights that reduce volatility and improve performance.Aon India Insurance Brokers Private Limited, licensed since 2017, is a composite insurance broker delivering...

Research Scientist

Abbott, Mumbai, Maharashtra
4 days ago
Key Accountabilities And Responsibilities Analytical Method Development of various pharmaceutical dosage forms like oral solid, oral liquid, Injectables, Nasal Spray. Analytical Method Validation of various pharmaceutical dosage forms like oral solid, oral liquid, Injectables, Nasal Spray. Analytical Method Transfer of various pharmaceutical dosage forms like oral solid, oral liquid, Injectables, Nasal Spray.JOB SPECIFICATIONAnalytical method development and validation for pharmaceutical dosage...

Senior Creative

The Lubrizol Corporation, Mumbai, Maharashtra
5 days ago
Role AccountabilityThe Senior Creative has a high level of competency in several creative disciplines and supports Lubrizol and its customers by providing creative expertise and delivering the very best in business communications. The role should have a high level of experience in in Graphic Design and Design for Digital applications.The role supports Lubrizol and by extension its customers internally and...