Fraud Technical Specialist-SQL

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

Job summary

Firstsource Solutions Limited is seeking a Fraud Technical Specialist in Bengaluru to drive data-driven fraud controls. You will design and optimize fraud detection rules, investigate trends, and develop complex SQL queries for actionable insights.

Join a team in BPM division with exposure to large-scale data warehouses and cloud platforms. Strong analytical skills and experience in fraud analytics are preferred.

Qualifications

• Candidates should have strong SQL skills and be able to write complex queries with joins, CTEs, and aggregates.
• Experience with large datasets in a data warehouse environment is required.
• Ability to translate business problems into data-driven fraud controls.

Responsibilities

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

Skills

Advanced SQL

Fraud analytics

Fraud detection logic

Data warehouse

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 escape 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