KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
L #3126
Applications open Full-Time Job

FSRC-R and CT-RCT-PYTHON and SQL-STAFF

EY

  • Chennai, India
  • Competitive Package
  • 2–4 Years
  • Posted Yesterday
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

EY GDS – RCT

Staff – Python & Advanced SQL

Staff – Software Engineering

Experience: Strictly 2+ years

Eligibility requirement

  • Candidates must have 2–4 years of relevant professional experience, including hands-on cloud experience.
  • Freshers, candidates with less than 2 years of experience, and candidates without cloud experience are not eligible for this role.

The opportunity

Join a financial crime technology team building data-driven solutions for global financial services clients. This role combines hands-on Python engineering, advanced SQL development, and practical exposure to Financial Crime Compliance processes. You will work with business, compliance, data, and engineering stakeholders to deliver reliable solutions across KYC, AML, Transaction Monitoring, Sanctions, and Fraud.

Role Overview

We are seeking a hands-on software engineer with strong Python and advanced SQL skills and relevant Financial Crime Compliance domain experience. The successful candidate will develop and support data-intensive applications, analytical workflows, and rule-based solutions used in customer due diligence, transaction monitoring, sanctions screening, fraud detection, investigations, and regulatory reporting.

Key Responsibilities

  • Design, develop, test, and maintain Python applications, services, utilities, and data-processing workflows.
  • Write complex, optimized SQL for data extraction, transformation, reconciliation, profiling, and investigation use cases.
  • Work with large financial datasets, including customer, account, transaction, alert, case, and screening data.
  • Translate Financial Crime Compliance requirements into technical designs, data rules, scenarios, and reusable components.
  • Support KYC and AML workflows such as customer onboarding, customer risk rating, customer due diligence, enhanced due diligence, and periodic review.
  • Contribute to Transaction Monitoring, Sanctions, and Fraud solutions, including rule implementation, threshold logic, alert generation, data validation, and issue analysis.
  • Develop APIs, batch jobs, automation scripts, and integration components using Python.
  • Perform unit testing, code reviews, debugging, root-cause analysis, and production support.
  • Collaborate with compliance SMEs, business analysts, data engineers, QA teams, and client stakeholders in Agile delivery teams.
  • Follow secure coding, version-control, documentation, and deployment practices.

Primary Skills – Must Have

  • Python: Strong hands-on programming experience, including data structures, functions, object-oriented programming, exception handling, modules, logging, testing, and performance-conscious coding.
  • Advanced SQL: Strong command of complex joins, subqueries, common table expressions, window functions, aggregations, query optimization, stored procedures, and data reconciliation.
  • Databases: Practical experience with at least one relational database such as PostgreSQL, Oracle, Microsoft SQL Server, or MySQL.
  • Data engineering: Experience processing structured data using Python libraries such as pandas and integrating with databases, files, or APIs.
  • APIs and services: Working knowledge of REST APIs and Python frameworks such as FastAPI, Flask, or Django.
  • Engineering practices: Git, unit testing, code review, debugging, documentation, and CI/CD fundamentals.
  • Cloud: Mandatory hands-on experience with at least one cloud platform: Microsoft Azure, AWS, or GCP. Candidates should have practical experience developing, deploying, or supporting data-driven applications or services in a cloud environment.

Good to have

  • Experience with PySpark or distributed data processing.
  • Familiarity with orchestration or ETL tools such as Airflow, Azure Data Factory, or equivalent.
  • Experience with data visualization or reporting tools such as Power BI or Tableau.
  • Understanding of model or rule performance measures, threshold tuning, false-positive reduction, and data lineage.
  • Exposure to Agile delivery tools and practices, including Jira or Azure DevOps.

Financial Crime domain knowledge

  • KYC / CDD / EDD: Customer onboarding, identity and document checks, customer risk rating, beneficial ownership, periodic review, and remediation.
  • AML: Financial crime risk indicators, typologies, alert and case workflows, investigations, escalation, and regulatory reporting concepts.
  • Transaction Monitoring (TM): Scenario or rule logic, thresholds, segmentation, alert generation, tuning support, back-testing, and data-quality controls.
  • Sanctions: Customer and payment screening, watchlist concepts, potential-match handling, disposition workflows, and screening data quality.
  • Fraud: Fraud indicators, rules or models, event and transaction analysis, alert triage, investigations, and case outcomes.

Experience And Education

  • Experience: Strictly 2–4 years of relevant professional experience in software engineering, data engineering, analytics engineering, or technology delivery.
  • Eligibility: Freshers and candidates with less than 2 years of relevant experience will not be considered.
  • Cloud experience: Hands-on experience with Microsoft Azure, AWS, or GCP is mandatory.
  • Domain experience: Relevant delivery experience in KYC, AML, Transaction Monitoring, Sanctions, or Fraud is good to have.
  • Education: Bachelor’s or Master’s degree in Computer Science, Engineering, Information Technology, Data Science, or a related field.

What Success Looks Like

  • Production-quality Python and SQL that is accurate, maintainable, secure, and efficient.
  • Clear understanding of the business purpose and regulatory context behind the solution being built.
  • Strong ownership of assigned deliverables, defects, documentation, and stakeholder communication.
  • Ability to explain technical findings and data issues clearly to both engineering and compliance stakeholders.

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

Eligibility & process

Who can apply

Seniority: Mid-Senior level. Employment type: Full-time

Skills & stack

Python SQL Django FastAPI Flask REST APIs PostgreSQL MySQL

Selection process

Details are shared by the recruiter after shortlisting.

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Python, SQL, Django, FastAPI, Flask, REST APIs, PostgreSQL, MySQL) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion EY Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join EY as a FSRC-R and CT-RCT-PYTHON and SQL-STAFF?
Highlight EY's market reputation, recent tech innovations, and how your skills in Python directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
EY Competitive Package
Recruiter Resume Apply
Chat Chat with Kashii