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.

SSIS Technical Lead-BI