ETL Developer & Data Warehouse Specialist

Tasks

• Build and optimize SQL queries
• Build reporting with SSRS
• Create SSIS package mappings and transformations
• Design data warehouse solutions
• Design dimensional data models
• Develop ETL workflows
• Develop SSAS cubes and partitions
• Develop stored procedures functions and views
• Implement high availability and disaster recovery
• Monitor and optimize ETL and database performance
• Perform SQL Server administration and maintenance
• Transform and validate data in ETL
• Troubleshoot production issues
• Write MDX calculations and queries

Perks/Benefits

• N/A

Skills/Tech-stack

Data Modeling | Data Warehousing | Database Administration | Disaster Recovery | ETL | High Availability | Integration Services SSIS | MDX | Oracle Database | Performance Tuning | Reporting Services (SSRS) | SQL Server | SQL Server Analysis | SQL Server Analysis Services | SQL Server Analysis Services SSAS | SQL Server Integration Services | SQL Server Integration Services (SSIS) | SQL Server Reporting | SQL Server Reporting Services | SQL Server Reporting Services (SSRS) | SQL Server integration | Snowflake Schema | Star Schema | T-SQL