Job Description:

We are seeking an extraordinary and exceptional candidate for the position of ETL/BI Architect with expertise in SSIS and SQL Server. The ideal candidate will have extensive hands-on experience in designing, developing, and managing SSIS/SQL ETL processes and database objects. You will be responsible for leading the design and development of robust ETL solutions, optimizing performance, and working with distributed teams on critical business systems. The role requires proficiency with Microsoft SSIS ETL tools, strong SQL skills, and the ability to work efficiently in high- pressure environments.

Key Responsibilities:

1. ETL Design and Development: Design, develop, and implement SQL Server stored procedures, functions, views, and triggers used in the ETL process. Design and develop SSIS/SQL ETL solutions for acquiring, transforming, and preparing data from upstream systems. Develop data transformations, including importing data from files and migrating data across different database platforms.

2. Debugging and Tuning:



Debug and optimize SSIS or other ETL processes to ensure accurate and effective data movement. Continuously improve the performance of ETL processes.

3. Database Design and Maintenance: Design, implement, and maintain database objects, including tables, views, and indexes. Ensure proper database security is implemented and maintained.

4. Data Transfer and Integration: Analyze and develop strategies for importing and transferring data between source systems, staging, and ODS/Data Warehouse destinations.

5. Testing and Documentation: Test and prepare ETL processes for deployment to production and non-production environments. Support system and acceptance testing, including refining test plans. Document work processes, including data flows (DFD, ERD) and end-user resources.

6. Collaboration and System Enhancements: Work as part of a team to manage and deliver quality system enhancements as required by business needs. Coordinate wit

📌 Architect – ETL/BI (Gandhinagar)
🏢 POST A RESUME
📍 Gandhinagar