We are seeking a highly experienced Senior SSIS developer to join our team. The ideal candidate will have extensive expertise in developing, implementing & maintain SSIS packages for data integration ,
Transformation & migration tasks .
Responsibilities:
- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
- Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems
- Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
- Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
- Design, implement and maintain database objects (tables, views, indexes) and database security
- Analyse and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
- Test and prepare ETL processes for deployment to production and non-production environments
- Support system and acceptance testing including the development or refinement of test plans
Key Responsibilities :
- Develop and deploy changes to the SSIS packages to accommodate new business requirements.
- Validate all changes going into production and make sure of post deployment checks.
- Combine raw information from different sources and identify opportunities for data acquisition that can help with business insights.
- Manage service delivery and manage life cycle of incidents including communication, investigation, and resolution.
- Coordinate among Business Partners, IT Partners, Vendors and Support Team to provide a problem free production environment
Must Skills:
SSIS, SQL Server, SSRS
Nice to Have Skills:
SSAS, Power BI
Qualifications:
- Bachelor’s degree in computer science, Information Systems, or related field.
- Minimum of 3-7 years of experience in SSIS development, with a focus on developing SQL based ETL solutions.
- Proficiency in SQL
- Strong understanding of dimensional modeling concepts and methodologies.
- Experience with ETL tools and processes, particularly SSIS (SQL Server Integration Services).
- Excellent problem-solving skills and attention to detail.
- Ability to communicate effectively with technical and non-technical stakeholders.
Proven track record of delivering high-quality SSIS solutions on time and within budget
