SSIS Technical Lead-BI

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.