ETL Developer - MSBI

Description :

Job Title : ETL Developer

Location : PAN indis

Experience : 5+ Years

Work Mode : Hybrid

Shift Timing : 11 AM to 9 PM

Responsibilities :

- Design, develop, and implement ETL processes using SSIS, Power BI, and SQL Server.

- Develop complex SQL/T-SQL queries, stored procedures, functions, triggers, indexes, cursors, and analyze execution plans.

- Build, integrate, and convert SSIS jobs to Azure Data Factory; schedule ADF pipelines using triggers.

- Work with CI/CD, Git, and deployment processes.

- Collaborate with business stakeholders to gather requirements and deliver scalable ETL solutions.

- Partner with DBAs, data analysts, and cross-functional teams to ensure data integrity and accuracy.

- Create and maintain documentation including technical specs, data mappings, and data lineage.

- Perform data profiling, cleansing, and validation for high-quality data outputs.

- Monitor and optimize ETL jobs for performance, reliability, and scalability.

- Troubleshoot issues related to data integration, transformation, and loading.

- Stay updated with industry trends and best practices in ETL and Azure Data Factory.

Required Qualifications & Skills :

- Bachelors degree in Computer Science, Information Systems, or related field.

- 5 - 7 years of proven experience as an MSBI ETL Developer (SSIS, SQL Server, Power BI).

- Strong command of SQL/T-SQL, DML/DDL, stored procedures, functions, triggers, indexes, cursors, and data import/export operations.

- Hands-on experience designing and managing ADF pipelines, linked services, datasets, activities, and Mapping Data Flows.

- Knowledge of Azure & self-hosted integration runtime and performance optimization.

- Experience with ADF triggers (schedule, tumbling window, event-based) and pipeline monitoring.

- Strong understanding of SDLC, data warehousing concepts, and best practices.

- Proficiency in SQL programming and query optimization.

- Experience with data modeling and dimensional modeling.

- Excellent analytical, problem-solving, and communication skills.

- Experience working in an Agile environment.