Key Responsibilities:

- Design, develop, test, deploy, and maintain ETL workflows and SSIS packages.

- Develop data extraction, transformation, and loading processes from multiple data sources.

- Create and optimize stored procedures, functions, triggers, and views using T-SQL and PL/SQL.

- Work on SQL Server Analysis Services (SSAS), including multidimensional cube design, deployment, and MDX query development.

- Develop and maintain reports using SSRS

- Perform data migration, data integration, and transformation activities using SSIS and DTS.

- Design and implement data warehouse solutions including fact tables, dimension tables, star schema, and snowflake schema.

- Troubleshoot and resolve production support issues related to ETL and database systems.

- Identify and resolve performance bottlenecks in SQL queries, ETL processes, and application code.

- Collaborate with business analysts, developers, and stakeholders to understand business requirements and deliver scalable solutions.

- Follow SDLC processes including analysis, design, development, testing, deployment, and documentation.

- Ensure adherence to coding standards, best practices, and data quality standards.

Required Qualifications:

- 5 to 10 years of experience as an ETL/SSIS Developer.

- Strong analytical, debugging, and troubleshooting skills.

- Experience handling production support and issue resolution.

- Ability to work in a fast-paced, high-pressure customer-facing environment.

- Excellent verbal and written communication skills.

- Strong organizational and multitasking abilities.