Description
My client is looking for an experienced SQL Developer with experience of Informatica PowerCenter.
You will be part of a squad team that works in an agile framework (scrum) and all squad members sit physically together and work on Network & Customer Experience Analytics.
Your role
- You will work closely with your squad colleagues and be responsible for the analysis, development, testing and follow up of the implementation of project deliverables with a focus on quality:
- Load and integrate data from our multitude of applications, service platforms and networks in the Enterprise Data Warehouse/Data Lake via ETL solutions
- Creating datamarts and/or reports/dashboards
- The analyst/developer is a key contact person for internal clients and takes care of optimal communication and collaboration with them and all other teams needed, in and outside our domain.
- You have to make sure that solutions make optimal use of available computer capacity (CPU, I/O, storage, memory, ), available on our platforms (Teradata, Hadoop, Oracle, ) and guarantee optimal performance.
Your skills
- Profound knowledge of key concepts of Business Intelligence, Data Warehousing and entity-relationship (E-R)-, Third Normal Form (3NF)- and dimensional modelling (knowledge on RDA helps)
- Advanced knowledge of SQL (Teradata)
- Advanced knowledge of Informatica PowerCenter (ETL)
- Familiar with Shell Scripting in Unix/Linux environments
- Basic knowledge of software deployment/versioning tools (GIT, Jenkins) and of collaboration tools (Jira, Confluence)