Lead Data & Integration Engineer

Responsibilities:
1. System Analysis & Design

• Analyse business/technical requirements and translate them into data flows and integration designs
• Work with upstream and downstream teams to define data contracts and interfaces
• Identify gaps, inefficiencies and risks in current data movement processes
• Propose pragmatic solutions balancing speed, quality and maintainability

2. Integration & Data Movement

• Design and implement data movement across systems using:
• APIs
• SFTP and file based transfers
• Batch pipelines
• Coordinate integrations across systems in the Data Lake ecosystem (Informatica, Cloudera, etc.)
• Ensure data is correctly transformed, mapped and delivered to target systems
• Troubleshoot integration issues across environments

3. Data Preparation for GenAI

• Support data ingestion and preparation for GenAI use cases:
• document ingestion
• data aggregation
• enrichment and transformation
• Work with structured and unstructured data
• Ensure data is usable for downstream AI workflows (RAG, search, investigation flows)

4. Delivery & Coordination

• Work across multiple teams:
• data platforms
• application teams
• infrastructure
• security
• Support SIT, UAT and production rollouts
• Ensure integration reliability, error handling and monitoring
• Document flows, mappings and interfaces clearly

Requirements

Below are the key skillsets that will be required for all relevant tasks mentioned:

·   10 years of experience in system analysis, integration engineering, data engineering or technical delivery roles.

·   Strong ability to translate requirements into system flows, data flows, interface specifications and implementation plans.

·   Experience working with upstream and downstream teams to define and deliver enterprise integrations.

·   Practical experience with REST APIs, SFTP, batch processing, file based integration and data pipeline orchestration.

· Good understanding of data mapping, transformation, aggregation, reconciliation and data quality controls.

·   Good SQL skills and basic to moderate Python skills for data handling, scripting, automation and troubleshooting.

·  Exposure to Java

·   Exposure to Informatica, Cloudera or similar enterprise data platforms.

·  Working knowledge of Git, branching, pull requests, code reviews and controlled release practices.

·   Familiarity with CI/CD, Jira, Confluence and enterprise deployment processes.

·  Experience with Control M or equivalent scheduling tools.

·   Familiarity with logging (OTEL) and monitoring tools such as Splunk  Elastic Stack.

·  Exposure to GenAI concepts such as document ingestion, RAG, embeddings and data preparation for AI workflows.

Key Domain/ Technical Skills:

·       Data Engineering,

·      System Integrations,

·      Python, SQL