Lead Software Engineer

Over 8+ years of strong Business Analysis experience, analytical skills and Database experience

Knowledge in App onboarding ,Timelines setting ,SEBI compliance ,Milestone modification ,Project milestones creation

Advanced SQL: Proven ability to write complex queries (window functions, multi-table joins, aggregations,CTEs) to investigate multi-million row datasets, identify outliers, and diagnose root causes of datamismatches across databases (Snowflake, Oracle, PostgreSQL, BigQuery).Data Quality & Reconciliation Tools: Hands-on experience with DQ and reconciliation platforms (e.g., CollibraDQ, Informatica IDQ, Monte Carlo, Great Expectations, SmartStream TLM, Duco, Gresham, or bespoke recengines). Data Lineage & Mapping: Strong proficiency in Source-to-Target Mappings (STTM), Data Dictionarygeneration, schema validation, and data lineage tracing.

• BI & Data Visualization: Experience building data quality dashboards in Tableau, Power BI, or Looker to reportSLA adherence and break trends.
  
  

Responsibilities

End-to-End Exception Resolution & Break Management

• Lead the triage, investigation, and root cause analysis (RCA) for complex transaction and financial breaksacross front-to-back systems (e.g., trade capture failures, settlement fails, corporate action breaks, paymentSTP fallouts, and sub-ledger-to-GL out-of-balance exceptions).
• Design robust operational and technical remediation workflows for trade, cash, position, and intercompanyreconciliation breaks.
• Classify exceptions into systematic errors (logic/schema mismatches), upstream data errors (missing/corruptreference data), operational misbookings, and platform timing/latency discrepancies.
• Partner with Operations and Engineering to drive long-term structural fixes, eliminating recurring manualworkarounds and tactical journal adjustments.