Roles and Responsibilities

• Develop and maintain ETL processes using SSIS to extract, transform, and load data from various sources into the data warehouse.
• Design and optimize SQL queries to handle large data sets efficiently.
• Collaborate with stakeholders to gather requirements and ensure solutions meet business needs.
• Troubleshoot and resolve ETL process issues.
• Ensure data quality and consistency across all processes.
• Maintain and optimize the data warehouse environment to support reporting and analytics.

Required Skills

• Data Warehousing experience (architecture, schema design, performance tuning).
• Proficiency in SSIS (SQL Server Integration Services).
• Advanced skills in SQL (queries, joins, data manipulation).
• Experience building, maintaining, and optimizing ETL pipelines.
• Strong analytical and problem-solving skills.

Preferred

• Financial Services experience (not required, but a plus).
• Experience with cloud-based data platforms or other ETL tools.
• Familiarity with other data integration tools and technologies.

Posted By