Role 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 Skills Mandatory
Skills:
Azure Data Factory, Azure SQL, ETL Concepts, MS SQL Server, Oracle PL/SQL About LTM LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling current ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert
- https://www.ltm.com/careers/recruitment-fraud-alert
📌 Senior Specialist (Pune)
🏢 LTM
📍 Pune