Data Analyst

EXL; Maharashtra; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

EXL is seeking a Data Analyst with 4+ years of experience to support data exploration, mapping, and quality validation in the banking domain (Credit & Lending). The role requires hands-on SQL/HQL or Spark SQL, PySpark, and Python, with exposure to Hadoop/Hive/Spark ecosystems.

Knowledge of data modeling, ER diagrams, and agile delivery will be advantageous. The candidate will collaborate with data asset teams to translate business requirements into data solutions, ensuring data mapping accuracy

Qualifications

• 4+ / 5+ years of professional experience as a Data Analyst with good decision-making, analytical and problem-solving skills.
• Hands-on experience in query languages like HQL or SQL (Spark SQL) for Data exploration.
• 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

SQL

PySpark

Python

Banking domain knowledge

Hadoop

Hive

Spark

Data mapping

Data quality validation

Data management

Data cleaning

Data schema analysis

ER diagrams

Agile

Credit risk frameworks (Basel II/III,/

Tools

Hadoop

Hive

Spark

Spark SQL

Job description

• 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.

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