Consultant - Forensics - National - ASU - Forensics - Discovery - New Delhi

About the role

Consultant-National-Forensics-ASU - Forensics - Discovery - New Delhi National comprises of sector agnostic teams working across industries for a well rounded experience. Successful organizations depend on their reputation for keeping promises, respecting laws and behaving ethically to maintain stakeholder trust.

What you'll do

• Extract and analyze large, complex datasets using advanced SQL across multiple databases and source systems
• Perform data profiling, cleansing, transformation, reconciliation, and quality validation to establish reliable datasets for investigations
• Develop sophisticated SQL queries using joins, CTEs, window functions, subqueries, aggregations, stored procedures, and query optimization
• Conduct forensic analytics to identify fraud indicators, unusual transactions, duplicate payments, conflicts, outliers, transaction splitting, unusual relationships
• Integrate and reconcile data from ERP systems, databases, flat files, and other structured or semi-structured sources

What you need

• Power BI
• Data analysis
• SQL
• ETL
• SQL Server
• PostgreSQL
• B.Tech or B.E. or B.Sc or BCA or M.Sc or MCA or M.Tech

Good to have

• Excel
• Python
• Snowflake
• Reconciliation
• Capital markets
• ERP