Data Analyst

Role: Data Engineer/ Analyst

Experience: 4+ Years

Domain: Exposure in Banking domain is required

Location: Gurgaon, Noida, Hyderabad, Pune, Bangalore

Work Mode: Hybrid

Summary: We are seeking a highly skilled Data Analyst / Data Engineer with strong expertise in SQL and hands-on experience in PySpark and big data environments. The ideal candidate will have US Banking domain experience and the ability to work directly with clients to deliver data-driven insights and solutions.

Roles and Responsibilities: Develop and optimize complex SQL queries for large-scale data analysis Establish Spark sessions and perform data processing using basic and intermediate PySpark commands Extract and process data from Hadoop ecosystems (Hive/Impala) and Oracle databases Perform complex data wrangling, transformation, merging, and analysis on large datasets Analyze business requirements and translate them into technical data solutions Collaborate directly with clients to gather requirements and present insights Ensure data accuracy, integrity, and performance optimization Support data validation, reconciliation, and reporting activities

Must Have: Advanced SQL (query optimization, joins, subqueries, performance tuning) Intermediate Python proficiency Strong hands-on experience with PySpark (Spark session creation, DataFrame operations, transformations, basic performance handling) Experience working with Hadoop (Hive/Impala) and Oracle databases Proven experience handling and analyzing large datasets Strong data wrangling and analytical skills Experience in US Banking domain (regulatory reporting, risk, finance, or related areas preferred) Excellent communication skills with the ability to interact directly with clients