SSIS Developer - SQL Server

Role Summary :

Seeking an experienced SSIS/SSRS Developer with strong SQL Server and data warehousing skills to build and maintain ETL processes and reporting solutions.

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.

Required Skills :

- Strong experience in SQL Server

- Hands-on expertise with SSIS and SSRS

- Solid understanding of Data Warehousing concepts

- Excellent T-SQL skills

- Experience in production support and troubleshooting

Good to Have :

- SSAS / Power BI

- Azure Data stack exposure

(ref:hirist.tech)