Job Title : ETL Developer (MSBI + ADF)
Experience : 5–7 Years
Location : Remote—India
Work Timings : 11 : 00 AM – 9 : 00 PM IST
Role Overview
We are seeking an experienced MSBI ETL Developer with strong expertise in SSIS, SQL Server, Power BI, and Azure Data Factory (ADF) . The role involves designing, building, and supporting enterprise ETL pipelines, data integration workflows, and cloud-based data engineering solutions. You will collaborate closely with technical stakeholders to ensure high-quality, scalable, and optimized data processes.
Key Responsibilities
🔹 ETL Design & Development
- Develop robust ETL workflows using SSIS, SQL Server, and Power BI .
- Build end-to-end ETL / ELT pipelines based on business and architectural requirements.
- Perform data profiling, cleansing, transformation, and validation to ensure data accuracy.
🔹 SQL Development
Strong hands-on expertise in :
T-SQL development (DML / DDL)Stored procedures, functions, triggersQuery optimization & indexingExecution plans & performance tuningBulk data operations & import / export🔹 Azure Data Factory (ADF)
Develop complex ADF pipelines , mapping data flows, datasets, and linked services.Migrate SSIS packages into ADF and manage SHIR (Self-hosted Integration Runtime).Configure pipeline triggers (schedule, event-based, tumbling window).Optimize performance for high-volume cloud data pipelines.🔹 Collaboration & Processes
Work with data architects, DBAs, business analysts, and data consumers.Maintain technical documents including data mapping sheets, lineage, and pipeline logic.Implement CI / CD pipelines and version control using Git.Monitor, debug, and troubleshoot ETL / ADF processes.Required Qualifications
Bachelor’s degree in Computer Science or related field.5–7 years of strong MSBI ETL development experience.Expertise in SSIS, SQL Server, Power BI .Strong T-SQL experience with stored procedures, triggers, indexing, execution plans.Hands-on Azure Data Factory experience—pipelines, data flows, linked services.Solid understanding of data warehouse concepts, dimensional modeling, star schema .Strong debugging, optimization, and analytical skills.Experience working in Agile / Scrum environments.Preferred Skills / Good to Have
Experience in US Healthcare domain.Knowledge of Tableau, Cognos Reporting .Experience with Salesforce data integrations.Exposure to additional BI / Analytics tools.