Senior Specialist - Data Engineering

LTM

Pune District

On-site

INR 3,000,000 - 4,800,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

LTM is seeking a Technical Team Lead: Azure Data ETL Lead in Pune to guide a team of ETL/SQL and Azure developers. You will translate requirements into detailed designs, review solutions, and ensure adherence to standards, architecture, and timelines.

You will drive Azure Data Factory pipelines, SQL-based ETL, data transformation and reconciliation, plus governance and production support across distributed teams.

Qualifications

  • Must have experience in Azure Data Factory (ADF) and Azure SQL Managed Instance.
  • Strong T-SQL programming skills required.
  • Experience in ETL framework development and data warehousing concepts.
  • Knowledge of ADLS, Git and Azure DevOps.
  • Experience with data migration/conversion and insurance claims domain knowledge.

Responsibilities

  • Provide technical leadership for ETL/Azure developers.
  • Translate requirements into detailed designs and oversee code reviews.
  • Manage delivery of workstreams, risks, dependencies and blockers.
  • Oversee Azure Data Factory pipelines and SQL-based ETL frameworks.
  • Ensure data quality, performance tuning and compliance.

Skills

Azure Data Factory
ADF
Azure SQL Managed Instance
SQL Server
Snowflake
Advanced TSQL Programming
ETL Framework Development
Data Warehousing Concepts
Azure Data Lake Storage
ADLS
Git
Azure DevOps
Database Performance Tuning
Azure Functions
Azure Key Vault
Managed Identity
Logic Apps
REST API Integration
Insurance Claims Domain Knowledge

Tools

Azure Data Factory
ADF

Job description

Technical Team Lead: Azure Data ETL Lead

a team of developers responsible for designing developing and supporting the endtoend TPA Claims Processing platform Drive the implementation of Azurebased data ingestion transformation reconciliation stewardship and reporting solutions while ensuring adherence to architecture standards quality processes and project timelines The solution includes SFTPbased file ingestion PGP decryption Azure Data Factory pipelines Azure SQL processing claims conversion exception management and downstream integrations

Key Responsibilities
  • Technical Leadership Lead a team of ETL SQL and Azure developers Translate functional and technical requirements into detailed implementation designs Review technical solutions code database objects and ETL workflows Ensure adherence to architecture security and development standards Provide guidance on complex technical issues and production support activities
  • Delivery Management Own delivery of assigned workstreams and sprint commitments Track project progress risks dependencies and blockers Coordinate development testing deployment and production support activities Ensure timely delivery of project milestones and releases Support effort estimation planning and resource allocation activities
  • Azure ETL Solution Implementation Oversee development of Azure Data Factory pipelines and SQLbased ETL frameworks Ensure implementation of File ingestion and validation PGP decryption processes Data transformation and conversion logic Audit and reconciliation controls Exception handling frameworks Data archival and retention processes
  • Database Data Engineering Oversight Review and approve Stored Procedures Functions Views ETL Control Tables Audit Tables
  • Exception Management Tables
  • Ensure database performance optimization and data quality compliance
Stakeholder Coordination
  • Act as the primary technical contact for architects business analysts QA teams and business stakeholders
  • Participate in design reviews requirement clarification sessions and project governance meetings
  • Provide project status updates and technical risk assessments
  • Collaborate with offshore and onsite teams to ensure alignment
Quality Governance
  • Establish coding standards and review processes
  • Conduct code reviews and design walkthroughs
  • Ensure compliance with project documentation standards
  • Drive defect prevention and continuous improvement initiatives
Required Technical Skills
Must Have
  • Azure Data Factory ADF
  • Azure SQL Managed Instance SQL Server Snowflake
  • Advanced TSQL Programming
  • ETL Framework Development
  • Data Warehousing Concepts Azure Data Lake Storage ADLS Git Azure DevOps Database Performance Tuning Azure Functions Azure Key Vault Managed Identity Logic Apps REST API Integration Insurance Claims Domain Knowledge
Leadership Expectations
  • Mentor and coach development team members
  • Conduct technical knowledgesharing sessions
  • Review deliverables and ensure quality standards are met
  • Drive problem resolution and decisionmaking
  • Foster collaboration across development QA and business teams
  • Experience 8 years of IT experience
  • 3 years of technical team leadership experience
  • Strong experience delivering Azurebased data engineering or ETL projects
  • Experience managing distributed development teams
  • Experience with largescale data migration conversion or integration programs
  • Insurance Domain Knowledge
Preferred Key Deliverables
  • Technical Solution Designs Detailed Technical Specifications ETL Framework Components Azure Data Pipelines Database Objects Data Models Reconciliation Audit Reports Deployment Packages Production Support Documentation Team Delivery Metrics Success Measures Ontime sprint and release delivery ETL processing accuracy and data quality Reduction in production defects Compliance with architecture and security standards Successful mentoring and development of team members Effective stakeholder communication and project governance
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer – Azure & Snowflake
Senior Data Engineer – Azure & Snowflake

Phigital Care • Bengaluru

On-site
INR 3,000,000 - 5,000,000
Azure Data Engineer - CTR
Azure Data Engineer - CTR

Datavail • Mumbai

Remote
INR 3,500,000 - 5,500,000
 
Consultant-Domain
Consultant-Domain

HCLTech • Bengaluru

On-site
INR 1,800,000 - 3,200,000
Senior Software Engineer
Senior Software Engineer

Incedo • New Delhi, Faridabad District, Gurugram District

On-site
INR 150,000 - 280,000
Senior Technical Specialist
Senior Technical Specialist

Datavail Infotech • Mumbai

Remote
INR 3,000,000 - 5,400,000
Data and Analytics engineering lead
Data and Analytics engineering lead

Orbia Pune • Pune District

On-site
INR 4,000,000 - 7,000,000
Senior Data Engineer
Senior Data Engineer

DigitRell • Ernakulam

On-site
INR 1,500,000 - 2,100,000
Data Engineer Advisor
Data Engineer Advisor

Mployee.me • Hyderabad

On-site
INR 400,000 - 700,000
SENIOR DATA ENGINEER-AZURE AND SNOWFLAKE IMMEDIATE JOINERS
SENIOR DATA ENGINEER-AZURE AND SNOWFLAKE IMMEDIATE JOINERS

Phigital Care • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Data And Integration Engineer
Data And Integration Engineer

CirrusLabs, LLC • Hyderabad, Pune District, Bengaluru

On-site
INR 1,500,000 - 3,000,000