Добавено на 1 week ago

Data Warehouse Solution Architect

Населено мястоSofia grad, Sofia, Bulgaria PP Adecco

ПозицияSpecialist

Дата2020-05-20

КатегорияIT and Telecommunications




Data Warehouse Solution Architect



On behalf of our client - a world leading banking institution - we are looking to hire a Data Warehouse Solution Architect.
Position Overview:
The selected candidate is responsible for the data architecture and data management activities within the ITS Data & Analytics Work Program. He/she should have a strong foundation and hands-on experience in Data and Analytics data management design and development, debugging Business Intelligence (BI) existing applications as well as performance tuning.
The selected candidate will work closely with the team to provide technical leadership to facilitate development projects that involve the computing environment which may include the coordination of software upgrades and the installation of new products. He/she will design and validate data solutions that are practical, flexible, scalable, reusable, and strategic. He/She will ensure data is ready for use by consuming application, analyst and scientist using frameworks and microservices to serve data. These efforts enhance data quality, enrich access and provide business decision makers with information upon which they can make more accurate and effective decisions across multiple domains.
      
Requirements:
- At least 7 years of hands-on experience in coding complex SQL queries, transform-load (ETL) design and development, performing tasks such developing strategies for data acquisitions as well as developing data structures, archive recovery and associated data policies
- At Least 5 years of hands-on experience in data integration, data virtualization, data federation and database design techniques
- Experience with performance tuning for complex SQL queries
- Experience in data modeling for relational databases – both for logical and physical data models with exposure to designing and developing for large-scale multidimensional databases and data warehouses
- Experience with managing and maintaining quality data by performing operations such as cleaning, transformation, and ensuring integrity in both on-prem and a cloud-based relational database environment
- Ability to build and interact with very large data processing pipelines, distributed data stores, and distributed file systems
- Experience designing and deploying high performance production services with robust monitoring and logging practices
- Familiarity with various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams, etc.)
- Thorough knowledge of complex ETL mappings, data pipelines and workflows in a Cloud-based ETL tool such as IICS and Azure Data Factory/SSIS
- Database: Oracle 12c/18c/19c, Azure SQL DW, SQL Server 2016/2014/2012/2008
- Cloud Technologies: Azure Microsoft Technologies, Unix, Linux, Windows
- Design Language: UML, Visio, Erwin 9.x and above
- Tools: Informatica Cloud Services (IICS), Informatica PowerCenter 10.x, Tibco Data Virtualization 8.x
If you recognize yourself in the description above, send us your CV today! Only short-listed candidates will be contacted. All applications will be treated in strict confidentiality. Recruitment license from National Agency of Employment #1814 from 08.12.2014
 

Последно преглеждани позиции