Data Analyst
On-siteChennai, Tamil Nadu, India
Job Summary
Manage metadata-driven financial reporting data integration for 80+ source applications processing 200M+ rows daily on Oracle PL/SQL. Execute dynamic SQL, partitioned table maintenance, and performance tuning while ensuring rerun safety and parity validation. Debug transformation issues and validate data results effectively. Support the migration strategy to AWS Databricks using PySpark and Python, translating complex dynamic SQL logic. Apply banking domain fluency including average daily balancing math, general ledger structures, and COBOL legacy deconstruction to ensure accurate month-to-date accumulation and interest accruals.
Required Qualifications
- Oracle PL/SQL engineering: dynamic SQL, partitioned tables, performance tuning, restartable processes
- Production discipline: rerun safety, parity validation, ops handoff documentation
- Problem Solving: Ability to validate data results and debug transformation issues effectively
- COBOL literacy — framework replicates legacy mainframe X7IC2x and X9AVGxx programs exactly
- Banking product knowledge — Average daily balancing, interest accruals, split record behavior, etc.
- Dynamic SQL → Python translation skill (critical for Databricks migration)
Desired Qualifications
- Modern data engineering: Databricks, PySpark, AWS S3
- Banking domain fluency: Average Daily Balancing math, General Ledger structure, managerial ledger, Month to date accumulation, COBOL legacy deconstruction
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.