Informatica Tech Lead

Job Title: Informatica Tech Lead

Experience: 7+ Years
Domain: Capital Markets / Investment Banking / Trading & Risk
Location: Mumbai
Employment Type: Full-Time

Job Summary

We are seeking an experienced Informatica Tech Lead to lead data integration initiatives across Financial Markets platforms. The role involves designing and delivering high-performance ETL solutions that support front-office, middle-office, and back-office systems, including trading, risk, P&L, and regulatory reporting. The ideal candidate has strong Informatica ETL expertise combined with solid understanding of capital markets data and regulatory requirements.

Key Responsibilities

Technical Leadership

• Lead end-to-end design and development of Informatica PowerCenter solutions for financial markets data
• Define ETL architecture, frameworks, and best practices for high-volume, time-sensitive trading data
• Perform technical design reviews, code reviews, and performance tuning
• Troubleshoot complex data issues across market data, trades, positions, and risk feeds

Financial Markets Data Integration

• Design ETL pipelines for:
• Trade lifecycle data (orders, executions, allocations)
• Market data (prices, rates, curves, benchmarks)
• Positions, P&L, and risk metrics (VaR, Greeks)
• Reference and static data (instruments, counterparties, legal entities)
• Handle data ingestion from front-office trading systems, vendor feeds (Bloomberg, Reuters), and internal risk engines
• Implement data reconciliation, controls, and auditability to meet regulatory and business needs

Development & Delivery

• Develop complex mappings, transformations, workflows, and sessions
• Implement data quality rules, validations, and exception handling
• Ensure compliance with SDLC, change management, and release processes
• Support batch, near-real-time, and intraday processing requirements

Performance, Controls & Compliance

• Optimize ETL performance for low latency and high throughput
• Implement controls for regulatory reporting (BCBS 239, MiFID II, Dodd-Frank, EMIR as applicable)
• Monitor and resolve SLA and data availability issues critical to trading and risk reporting

Team & Stakeholder Collaboration

• Lead and mentor Informatica developers across onshore and offshore teams
• Work closely with Business Analysts, Quant/Risk teams, and Operations
• Communicate effectively with front-office and risk stakeholders
• Participate in Agile ceremonies and production support rotations

Required Skills & Qualifications

Technical Skills

• 7+ years of hands-on experience with Informatica PowerCenter
• Strong SQL and experience with large-scale databases (Oracle, SQL Server, Teradata, Snowflake, etc.)
• Deep understanding of Data Warehousing concepts (facts, dimensions, SCDs)
• Experience with high-volume batch and intraday ETL processing
• UNIX/Linux scripting
• Job scheduling tools (Control-M, Autosys, etc.)

Financial Markets Domain Knowledge

• Solid understanding of Capital Markets concepts, including:
• Asset classes: Equities, Fixed Income, FX, Derivatives
• Trade lifecycle and settlement
• Market data and pricing
• Risk and P&L reporting
• Experience working in investment banking or financial services environments

Leadership & Soft Skills

• Proven experience as a Tech Lead or Senior ETL Lead
• Strong analytical and problem-solving skills
• Excellent communication and stakeholder management abilities
• Ability to work under tight deadlines in production-critical environments

Preferred / Nice to Have

• Experience with Cloud data platforms (AWS, Azure, GCP)
• Exposure to Big Data / Streaming (Kafka, Spark) in financial systems
• Knowledge of BCBS 239, FRTB, MiFID II, or similar regulations
• Informatica or Cloud certifications
• Experience with CI/CD and DevOps for data pipelines

Education

• Bachelor’s or Master’s degree in Computer Science, Engineering, Finance, or a related field