Country/Region:
IN
Requisition ID:
36290
Work Model:
Position Type:
Salary Range:
Location:
INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI
Title: SSIS Technical Lead-BI
Description:
Area(s) of responsibility
Job Title - Senior SSIS / SSRS Developer
Experience - 7–10 Years
Key Responsibilities
- Design, develop, and maintain complex SSIS packages for large‑scale ETL processes, including CDC implementation, incremental loads, and full loads with SQL Server and Oracle connectivity.
- Handle data extraction, transformation, and loading from multiple sources such as SQL Server, Oracle, Excel, flat files, and other external systems using SSIS.
- Implement error handling, logging, auditing, and performance optimization in SSIS packages to ensure reliable and efficient data loads.
- Create and maintain SQL Server Agent jobs for scheduling, monitoring, and maintaining ETL workflows across multiple environments.
- Develop and optimize T‑SQL stored procedures, functions, and queries to support ETL logic and improve data processing performance.
- Provide production support, resolve JIRA incidents and defects, and manage bug fixes while simultaneously working on new development activities.
- Coordinate deployments across multiple environments, support testing cycles, and ensure data consistency and process stability during releases.