Key ResponsibilitiesQuery Optimization: Tune complex queries, views, and indexing strategies for high-frequency financial transactions.Architecture Design: Build scalable relational database schemas, tables, and partitions to handle historical financial data.Data Pipelines: Develop secure ETL/ELT processes to ingest data from banking APIs, trading platforms, and market feeds.Financial Logic Implementation: Code stored procedures and triggers for interest calculations, ledger balancing, and risk analytics.Compliance & Security: Implement strict data masking, auditing, and encryption to comply with financial regulations (e.g., PCI-DSS, SOX).Required Technical SkillsSQL Dialects: Advanced proficiency in T-SQL (SQL Server), PL/SQL (Oracle), or PostgreSQL.Performance Tuning: Deep understanding of execution plans, query hints, index fragmentation, and locks/deadlocks.Data Integration: Hands-on experience with ETL tools (e.g., SSIS, Informatica, or Talend).Reporting: Experience building data models for financial reporting tools (e.g., PowerBI, SSRS, or Tableau).Domain Expertise NeededFinancial Workflows: Strong understanding of general ledgers, transaction processing, and reconciliation.Data Standards: Experience handling financial data structures like ISO 20022, FIX protocol, or credit bureau layouts.
Pay: ₹500,000.00 - ₹1,000,000.00 per year
Benefits:
- Health insurance
- Leave encashment
- Provident Fund
Work Location: In person
