Role: Business Analyst
Required Skills: Business analyst
Experience: 8 - 10 Years
Function: TECHNOLOGY
Apply By: 2026-12-26
Business Analyst with AML expertise
Must Have Technical/Functional Skills
- Strong hands on expertise in SQL for complex data validation and reconciliation.
- Deep understanding of DWH architecture - Staging, ODS, DWH, Data Marts.
- Strong Banking domain knowledge (Retail, Corporate, Loans, Payments, Risk).
- Perform cross system data reconciliation between core and downstream systems.
- Perform defect analysis and root cause investigations with development teams.
- Automate data validation and reconciliation using scripts or frameworks.
- Work effectively in Agile/Scrum environments using JIRA/ALM tools.
- Strong hands-on SQL skills for data profiling, validation and analysis across large datasets.
- Good understanding of relational database structures, including tables, keys, joins, views and data relationships.
- Experience in data governance and metadata management, including defining business names and definitions for data elements.
- Hands-on experience with a metadata repository / data catalog tool
- Ability to identify and document Critical Data Elements (CDEs) used in business and regulatory reports.
- Proven experience in end-to-end data lineage, tracing data from reports back to the originating system.
- Ability to build data lineage manually and with automated lineage tools where available.
- Strong knowledge of Data Quality dimensions: completeness, accuracy, validity, consistency, timeliness and uniqueness.
- Experience defining, documenting and implementing Data Quality rules at the element level against business requirements.
- Hands-on experience with Data Quality tools.
- Ability to create Data Quality metrics, scorecards and dashboards for monthly executive reporting.
- Experience working with Authorized Data Sources (ADS) and enterprise data domains.
- Understanding of ETL / data integration processes and how data moves across source, staging, warehouse and reporting layers.
- Knowledge of Data Warehouse concepts: staging, ODS, data marts, and fact and dimension tables.
- Ability to perform source-to-target mapping (STM) analysis and data reconciliation.
- Experience with data profiling to find anomalies, gaps and the root causes of data issues.
- Ability to run data issue management: logging, tracking, remediating and escalating DQ exceptions.
- Working knowledge of reporting / BI tools ( e.g., Tableau, Power BI) to visualize DQ metrics.
- Familiarity with banking regulatory and data management frameworks
- Strong skills in gathering requirements and documenting findings with business and technology teams, analysts and developers.
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternaccl & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range- $90,000-$105,000 a year