Lead Data Engineer (ID: CREQ263224)

Informatica, Oracle PL/SQL, any Cicd tool experience

Secondary: ADF, AZURE

Location & Shift
Location: Bangalore
Shift: 11:00 AM 08:00 PM

KNOWLEDGE OF ETL PIPELINES & good SQL experience.

We are seeking a Lead Data Engineer with 5+ years of experience to architect and
scale modern data platforms, lead cloud data engineering initiatives, and deliver robust,
secure, and high-performance data solutions. We use data and analytics to personalize
incredible customer experiences and develop solutions that help our customers live the
lives they want. As part of our digital transformation, we have made significant
investments to build cloud data lake platforms. We are looking for a hands-on data
engineer who can help us design and develop our next generation Cloud Data Lake and
Analytics Platform for Workplace Solutions.
The Expertise You Have
5+ years in Data Engineering / Big Data / Platform Engineering with endtoend
delivery of large enterprise programs.
Multitenant database and data modeling expertise-designing tenantaware
schemas and delivering productive, robust database code and designs for websites
and products.
Advanced SQL across Oracle, Azure SQL Managed Instance (SQL MI),
MySQL, and Snowflake; strong performance tuning and query optimization.
Handson with cloud data platforms: Azure (preferred), including big data
services and integrations.
Deep experience building ETL/ELT pipelines using Informatica, SnapLogic,
Azure Functions, Python targeting Snowflake and other cloud data
warehouses.
Proven track record designing, developing, and deploying batch data
processing pipelines and feature generation platforms using Azure, Python,
and SQL.
Strong DataOps/CI/CD for data and code: GitHubbased workflows, automated
database releases, and source control best practices across the SDLC.
Experience with event/streaming: Azure Event Hubs, Kafka, or Amazon




Kinesis.
Data architecture design & documentation using Confluence and draw.io;
metadata management and lineage.
Production excellence in financial services / benefits administration-triaging
incidents, root cause analysis (logs/reports), and minimizing business impact.

Fidelity Internal
Information

Experience leading or mentoring teams on businesscritical data platform
solutions; strong stakeholder communication.

The Skills That Are Key to This Role
Translate complex business and analytical needs into scalable, resilient data
architectures and pipelines.
Design and implement highperformance distributed pipelines (batch &
streaming) with strong SLAs, monitoring, and cost efficiency.
Build lakehouse and warehouse solutions (e.g., Delta/Iceberg/Hudi +
Snowflake) with robust semantic/data models.
Endtoend ownership: requirements architecture build deploy
monitor optimize.
ETL/ELT excellence with Informatica, SnapLogic, Azure Data Factory, Azure
Functions, Python, and Databricks/Spark.
Azure platform proficiency, including:
o Azure Data Factory, Azure Databricks, AKS, Azure Service Bus
(ASB), API Management, Storage Accounts, Event Hub/Event Grid,
Redis Cache.

Strong RDBMS/NoSQL experience: Oracle, SQL Server/SQL MI, MySQL,
Postgres, Cosmos DB, MongoDB.
DataOps/DevOps: CI/CD pipelines (GitHub Actions/Azure DevOps),
unit/integration tests, automated data quality, and infrastructureascode
(Bicep/ARM/Terraform).
Data quality & observability (e.g., Great Expectations/Deequ/Monte Carlo),
schema evolution, partitioning, and performance tuning.
Build tools and frameworks that turn pipelines into actionable insights for key
business KPIs; partner with BI/analytics teams.
Strong Agile delivery-driving epics, stories, and tasks using Agile/Scrum and
Jira; excellent written and verbal communication.

Good to Have Skills for This Role
dbt for modular SQL development, testing, and documentation.

📌 Informatica Data Engineer - Virtusa (Bengaluru)
🏢 TRIGENT SOFTWARE PRIVATE
📍 Bengaluru