Description

Manage and optimize data integration and warehouse components to ensure data integrity and performance.

This role is on-site.

Responsibilities

• Develop and maintain integration solutions using SQL Server SSIS and BIDS to connect legacy data stores to the data warehouse.
• Build and optimize data warehouse components, including stored procedures, views, and ETL processes.
• Perform data conversions from OLTP to DW using SSIS and Data Factory.
• Identify and analyze data quality issues to ensure consistency and integrity across all layers.
• Troubleshoot complex data issues, provide production support, and deploy ETL workflows with error handling and rollback capabilities.

Required Skills

• 5+ years of experience in data warehousing and ETL development.
• Expertise in SQL Server SSIS.
• Hands-on experience with BIDS.
• Proficiency in SSRS.
• Experience developing and optimizing stored procedures and views.
• Ability to perform manual testing on data processes.

Preferred Skills

• Experience with Power BI.
• Experience with Crystal Reports.
• API development experience.

Key Skills

Education

Not specified