Fraud Technical Specialist-SQL

Firstsource; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Firstsource Solutions Limited is seeking a Fraud Technical Specialist in BPM to strengthen our fraud controls. The role focuses on crafting advanced SQL queries, designing fraud detection rules, and translating data patterns into actionable insights for the business.

Ideal candidates have 2–4 years of SQL experience in fraud analytics, exposure to enterprise data warehouses, and a proactive, collaborative mindset to work with internal teams and external vendors.

Qualifications

• 2–4 years of experience in SQL for fraud deduction and anomaly detection.
• Experience with large datasets in an enterprise data warehouse.
• Strong analytical mindset to translate business problems into data-driven insights.
• Ability to design and test fraud detection logic from behavioral and transactional data.
• Numerate and capable of handling multiple priorities with resilience.

Responsibilities

• Collaborate with Fraud Technical Lead to design and optimize fraud detection rules.
• Investigate emerging fraud trends by querying data across systems and identifying patterns.
• Develop advanced SQL queries and customised reports for stakeholders.
• Support QA and testing of fraud platform upgrades and enhancements.
• Coordinate with internal teams and external vendors to resolve incidents with priority.

Skills

SQL proficiency

Large datasets

Analytical mindset

Fraud detection logic

Numeracy

Adaptability

Tools

Oracle

Google Cloud Platform

Job description

“Firstsource Solutions Limited, an RP-Sanjiv Goenka Group company is a global leader providing business process solutions and services spanning the customer lifecycle across Healthcare, Banking and Financial Services, Communications, Media and Technology, Retail, and other diverse industries. With a global footprint across US, UK, India, Philippines, Mexico, Romania, Turkey, Trinidad & Tobago, South Africa, and Australia, they ‘make it happen’ for their clients, solving their biggest challenges with hyper-focused, domain-centered teams and cutting-edge tech, data, and analytics. Firstsource’s inch-wide, mile-deep practitioners work collaboratively, leveraging UnBPO - their differentiated approach to reimagining traditional outsourcing - to deliver real-world, future-focused solutions that drive speed, scale, and smarter decision, turning transformation into tangible results for clients.”

Position :Fraud Technical Specialist

Division : BPM

Experience : Preferred min 2-4 years of experience in strong SQL queries writing on fraud deduction and finding the anomalies.

As part of Fraud team, you’ll play a key role in delivering our Technical Fraud strategy, ensuring the business is protected through intelligent, data-driven fraud controls.

• Collaborate with the Fraud Technical Lead to design and optimize fraud detection rules using insights derived from large-scale data analysis.
• Investigate emerging fraud trends by interrogating data across multiple systems, identifying patterns and proposing actionable countermeasures.
• Respond to business-critical questions by developing advanced SQL queries and customised reports. You’ll go beyond the numbers to deliver clear, meaningful insights to stakeholders across the business.
• Support system quality assurance through user acceptance testing of fraud platform upgrades and enhancements, ensuring all changes meet functional requirements and are free of defects.
• Work with internal support teams and external vendors to resolve system incidents, applying commercial judgement to prioritize and elevate issues appropriately.

Key Skills & Experience

• Advanced SQL proficiency — confident writing complex queries involving joins, subqueries, CTEs, and aggregate functions.
• Experience working with large datasets in an enterprise data warehouse environment (e.g., Oracle, Goggle Cloud Platform).
• Strong analytical mindset with the ability to translate business problems into data-driven solutions.
• Comfortable designing and testing fraud detection logic based on behavioural and transactional data.
• Highly numerate, ideally with experience in a data analysis or fraud analytics role.
• Previous fraud experience is advantageous but not essential — technical and analytical capability is key.
• Demonstrates resilience and adaptability when faced with competing priorities.

Disclaimer:

Firstsource follows a fair, transparent, and merit-based hiring process. We never ask for money at any stage. Beware of fraudulent offers and always verify through our official channels or @firstsource.com email addresses.

Padmapriya