ETL Developer & Data Warehouse Specialist

Tasks

• Archive and purge historical data
• Collect data mart requirements
• Conduct access reviews
• Design data models
• Develop data warehouse solutions
• Develop stored procedures
• Document data lineage workflows and dependencies
• Identify data loading bottlenecks
• Implement backups and disaster recovery
• Implement data quality checks
• Implement error handling monitoring auditing
• Integrate data from multiple sources
• Maintain metadata repositories
• Manage partitioning strategies
• Manage version control and change management
• Monitor ETL jobs and packages
• Monitor server performance
• Optimize ETL performance
• Optimize ETL processes
• Perform data extraction transformation cleansing aggregation validation
• Provide technical documentation
• Rebuild and reorganize indexes
• Schedule ETL jobs
• Standardize reporting calculations
• Support SQL Server services
• Troubleshoot ETL failures
• Validate backups
• Write and optimize SQL queries

Perks/Benefits

• N/A

Skills/Tech-stack

Analysis Services | Backup and Recovery | Business Intelligence | Change Management | Data Governance | Data Mart | Data Mart Design | Data Quality | Data Quality Management | Data Warehousing | Database performance | Database performance tuning | Dimensional Modeling | Disaster Recovery | ETL | High Availability | Indexing | Integration Services | Microsoft SQL | Microsoft SQL Server | Oracle Database | Partitioning | Performance Tuning | Quality management | Reporting services | SQL Server | SQL Server Analysis | SQL Server Analysis Services | SQL Server Integration Services | SQL Server Reporting | SQL Server Reporting Services | SQL Server integration | SSAS | SSIS | SSRS | Server Integration Services | Server Reporting Services | T-SQL | Version control