Data Analyst

EXL Talent Acquisition Team; Pune District; On-site; INR 1,000,000 - 1,600,000; Full time

Job summary

EXL Talent Acquisition Team in Pune, India seeks an experienced Data Analyst to transform data into actionable insights. You will work with SQL, PySpark and Python in a banking domain context, enabling risk and credit decisioning.

The role requires 4+ to 5+ years of experience, strong data mapping, data quality validation, and familiarity with Hadoop, Hive and Spark. Knowledge of Basel II/III, IFRS 9 and stress testing is a plus. You will collaborate in an Agile environment.

Qualifications

• 4+ / 5+ years of professional experience as a Data Analyst with good decision-making, analytical and problem-solving skills.
• SQL, Pyspark, Python with Banking Domain knowledge - Credit & Lending.
• Working knowledge / experience of Big Data frameworks like Hadoop, Hive and Spark.
• Hands-on experience in query languages like HQL or SQL (Spark SQL) for Data exploration.
• Data mapping: Determine the data mapping required to join multiple data sets together across multiple sources.
• Documentation - Data Mapping, Subsystem Design, Technical Design, Business Requirements.
• Exposure to Logical to Physical Mapping, Data Processing Flow to measure the consistency, etc.
• Data Asset design / build: Working with the data model / asset generation team to identify critical data elements and determine the mapping for reusable data assets.
• Understanding of ER Diagram and Data Modelling concepts
• Exposure to Data quality validation
• Exposure to Data Management, Data Cleaning and Data Preparation
• Exposure to Data Schema analysis.
• Exposure to working in Agile framework.
• Knowledge of Credit Risk Frameworks such as Basel II, III, IFRS 9 and Stress Testing and understanding their drivers - advantageous

Skills

Data analysis

SQL

PySpark

Python

Banking domain knowledge (Credit & L**

Tools

Hadoop

Hive

Spark

Spark SQL

HQL

Job description

Must-Have:

• 4+ / 5+ years of professional experience as a Data Analyst with good decision-making, analytical and problem-solving skills.
• SQL,Pyspark, Python with Banking Domain knowledge - Credit & Lending.
• Working knowledge / experience of Big Data frameworks like Hadoop, Hive and Spark.
• Hands-on experience in query languages like HQL or SQL (Spark SQL) for Data exploration.
• Data mapping: Determine the data mapping required to join multiple data sets together across multiple sources.
• Documentation - Data Mapping, Subsystem Design, Technical Design, Business Requirements.
• Exposure to Logical to Physical Mapping, Data Processing Flow to measure the consistency, etc.
• Data Asset design / build: Working with the data model / asset generation team to identify critical data elements and determine the mapping for reusable data assets.
• Understanding of ER Diagram and Data Modelling concepts
• Exposure to Data quality validation
• Exposure to Data Management, Data Cleaning and Data Preparation
• Exposure to Data Schema analysis.
• Exposure to working in Agile framework.
• Knowledge of Credit Risk Frameworks such as Basel II, III, IFRS 9 and Stress Testing and understanding their drivers - advantageous