The Junior SSIS Developer is responsible for developing, testing, and maintaining ETL processes under the guidance of senior developers and architects.
Key Responsibilities
- Develop and modify SSIS packages based on design specifications.
- Create source-to-target mappings and ETL workflows.
- Develop SQL queries, stored procedures, and scripts.
- Perform unit testing and defect resolution.
- Monitor ETL jobs and support production operations.
- Participate in code reviews and documentation activities.
- Troubleshoot data load failures and data quality issues.
- Support deployment and migration activities.
Required Skills
- 4-5 years of IT experience.
- 3+ years of SSIS development experience.
- Good knowledge of SQL Server and T-SQL.
- Experience with data extraction, transformation, and loading processes.
- Understanding of data warehouse concepts.
- Experience with SQL Server Agent jobs.
- Ability to debug and troubleshoot SSIS package failures.
Preferred Skills
- SSIS
- SQL Server
- Data Warehousing
- SQl/PLSQL ,T-SQL
- Vibe coding with AI Assistance (Nice to have but not mandatory)
- Agile/Scrum delivery model
Deliverables
- SSIS package development
- Unit testing execution
- ETL documentation
- Defect fixes and enhancements
- Production support assistance
