P99Soft - Senior ETL/Data Engineer - Microsoft Stack

Job Title : ETL Engineer

Experience : 8+ Years

Location : Pune, Hyderabad, Bangalore (Hybrid)

Looking for strong experience in DTS packages, VS Scripting, SSIS, Microsoft Data Factory. The goal is to replace all DTS packages and VB Scripting with SSIS and Stored Procedures and C#.

Ideal Candidate Will Have :

- 8+ years in data/ETL engineering with hands-on Microsoft stack experience.

- Proven experience migrating DTS/VBScript ETL to SSIS, stored procedures and C#.

- Strong SSIS skills (SSDT/Visual Studio, control/data flow, logging, error handling).

- Expert T-SQL : stored procs, set-based logic, indexing and query tuning.

- Solid C# for Script Tasks/Components and ETL tooling.

- Experience with Azure Data Factory (pipelines, mapping data flows, linked services) and Azure-SSIS.

- CI/CD and deployment experience (Git, Azure DevOps, SSISDB/SSIS IR).

- Good understanding of incremental loads, CDC, SCDs, performance tuning and monitoring.

- Strong troubleshooting, documentation and stakeholder communication skills.

- Bonus : Azure data certifications, MicroStrategy, SSRS, Synapse/Databricks exposure.

In This Role You Will :

- Lead replacement of legacy DTS/VBScript pipelines with SSIS, T-SQL and C#.

- Re-design flows for reliability and performance (incremental and bulk loads).

- Coordinate with DBAs, application teams and product owners to execute low-risk migrations.

- Create reusable ETL patterns, templates and best practices.

- Deliver measurable improvements in run-time, reliability and data quality.

- Opportunity to work on Azure data services and support cloud migration initiatives.