Job Requirements

JOB TITLE: Pharmacy Inbound ETL Developer DEPARTMENT: Information Technology

SUMMARY

ETL Developer and technology lead with hands-on experience designing, developing, implementing, testing, and supporting enterprise data integration solutions using Microsoft SQL Server, SSIS, and Microsoft Azure. Experienced with Azure Data Factory, Azure SQL, Azure Blob Storage, and Azure DevOps for building scalable ETL pipelines, orchestrating data workflows, managing cloud-based data storage, and supporting CI/CD processes. Strong background in inbound pharmacy data integration, requirements analysis, data mapping, data transformation, secure file transfers, process automation, quality assurance collaboration, application modernization, troubleshooting, and production support.

Proven ability to collaborate with business stakeholders, QA teams, technical teams, and external vendors to deliver reliable and scalable pharmacy data solutions.

DUTIES AND RESPONSIBILITIES

- Support day-to-day operations with a hands-on approach and passion for delivering best-in-class services to internal and external stakeholders.
- Work with internal and external clients to gather, analyze, document, and translate business requirements into technical solutions.
- Design, develop, test, implement, and maintain ETL and data integration solutions using SSIS, Microsoft SQL Server, and Azure.
- Design and develop Azure Data Factory (ADF) pipelines to orchestrate inbound pharmacy data ingestion, transformation, movement, scheduling, and processing.
- Build and maintain inbound pharmacy data interfaces based on business, client, and vendor requirements.
- Develop and support inbound pharmacy feeds.
- Utilize Azure Blob Storage for secure and scalable storage and processing of inbound pharmacy data files.
- Develop and maintain Azure SQL databases, tables, views, stored procedures, and other database objects supporting cloud-based pharmacy data processing.
- Integrate Azure Data Factory pipelines with Azure SQL, Azure Blob Storage, and other data sources to support end-to-end inbound pharmacy data workflows.
- Analyze inbound pharmacy data to troubleshoot errors, identify root causes, implement corrections, and improve data quality.
- Work closely with the QA team to develop test scenarios, validate ETL processes, verify data mappings and transformations, investigate defects, and ensure solutions meet functional and technical requirements.
- Collaborate with QA resources during system testing,



integration testing, regression testing, and production validation.
- Investigate and resolve defects identified during QA testing and provide technical support to ensure timely resolution.
- Work with multiple FTP/SFTP protocols and applications to securely receive and process inbound pharmacy data from external vendors and data partners.
- Develop and maintain scheduling, tracking, logging, monitoring, and error-handling solutions for pharmacy ETL and data processing workflows.
- Support production environments, including analysis, troubleshooting, performance optimization, and resolution of inbound pharmacy data processing issues.
- Utilize Azure DevOps for source control, work-item tracking, code management, build/release processes, defect tracking, and CI/CD deployments.
- Develop and maintain automated deployment processes for ETL and database components using Azure DevOps.
- Collaborate with QA, development, business, infrastructure, and external vendor teams throughout the development, testing, and implementation lifecycle.
- Develop technical design and architecture documentation and provide estimates for programming, testing, deployment, and implementation efforts.
- Identify risks, failure points, and opportunities for process improvement, automation, scalability, and reliability.
- Support pharmacy data migration and modernization initiatives involving Azure Data Factory, Azure SQL, and Azure Blob Storage.
- Other duties as assigned.

REQUIRED EXPERIENCE AND EDUCATION

- Required: 3 years of relevant experience in ETL development, data integration, or related technology roles.
- Required: Experience in the Healthcare Industry.
- Required: Hands-on experience working with inbound pharmacy data.
- Required: Experience with Microsoft SQL Server and SSIS.
- Required: Hands-on experience with Microsoft Azure, including Azure Data Factory, Azure SQL, and Azure Blob Storage.
- Required: Experience with Azure DevOps, including source control, CI/CD, build/release management, defect tracking, and deployment processes.
- Required:



Experience collaborating with QA teams throughout the software development and testing lifecycle.
- Bachelor's degree/diploma in Computer Science, Software Engineering, or equivalent combination of education and experience.
- Experience designing, developing, testing, implementing, and supporting enterprise ETL and data integration solutions.
- Experience with cloud-based data integration, data migration, workflow orchestration, testing, and CI/CD practices.

SKILLS AND ABILITIES

- Azure Data Factory (ADF) — pipeline development, inbound pharmacy data integration, orchestration, scheduling, and workflow automation.
- Azure SQL — database development, stored procedures, views, tables, data processing, and troubleshooting.
- Azure Blob Storage — cloud-based file storage, inbound pharmacy data ingestion, and file processing.
- Azure DevOps — Git/source control, work-item and defect tracking, CI/CD, build and release management, and deployment automation.
- Solid understanding of ETL architecture, data integration, data mapping, data transformation, and pharmacy file specifications.
- Strong Microsoft SQL Server development skills, including stored procedures, views, tables, and performance troubleshooting.
- Experience developing and supporting SSIS packages, ETL workflows, scheduling, error handling, testing, and production processes.
- Experience working with QA teams on test planning, test execution, defect analysis, data validation, and regression testing.
- Experience working with inbound pharmacy claims.
- Experience working with FTP/SFTP and other secure methods of receiving healthcare and pharmacy data; experience with MOVEit is preferred.
- Ability to design and implement scalable cloud-based data integration solutions using Microsoft Azure.
- Ability to understand complex business requirements and translate them into effective technical solutions.
- Strong analytical and problem-solving skills with attention to detail and accuracy.
- Ability to communicate technical concepts effectively to business stakeholders, QA teams, technical resources, and external vendors.
- Ability to work independently and collaboratively with remote teams.
- Strong organizational, time management, communication, and follow-up skills.
- Ability to identify opportunities for automation, process improvement, application modernization, and operational efficiency.
- Knowledge of healthcare and pharmacy industry processes.

📌 Pharmacy Inbound ETL Developer (Pune)
🏢 Xoriant
📍 Pune