• Taking the TDS and extracting it regularly to a warehouse
• Taking batch files (Experian, Cabot, etc), and importing them to a warehouse
• Creating marts based on shards of the warehouse
• Exposing these marts to the various teams that need their own (analytics, finance, etc)
• Good ETL skills specifically:
• SQL
• SSIS
Wymagania
REQUIREMENTS:• Design and develop ETL processes using SSIS, T-SQL and stored procedures
• Resolve data issues, perform unit testing and system documentation for ETL processes
• Support the software development team with deep, database-related knowledge
• Improve functionality (in terms of speed, performance and usability) of existing databases
• Support maintenance of local database servers
• Collaborate with development team to perform root cause analysis
• Experience in SQL Server / T-SQL database development (data modelling, stored procedures, functions and query optimization)
• Experience in SSIS and ETL development
• Excellent troubleshooting skills
• Ability to translate complex business requirements into technical solutions
• Ability to create complex, high performance stored procedures/views in SQL Server 2012/2014 APART FROM WHAT EVERYONE ELSE OFFERS, WE OFFER:
• Attractive salary
• Continuous professional development
• Stable work among professionals
• Good atmosphere at work