ETL Developer

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, triggers Query optimization & indexing Execution plans & performance tuning Bulk 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.