Data Engineer – DWH Solutions

Introduction
In this role you’ll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers) where we deliver deep technical and industry expertise to a wide range of private and public sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.
A career in IBM Consulting is rooted by long-term relationships and close collaboration with clients across the globe.
You’ll work with visionaries across multiple industries for the most innovative and valuable companies in the world. Your ability to accelerate impact and make meaningful change for your clients is enabled by our strategic partner ecosystem and our robust technology platforms across the IBM portfolio; including Software and Red Hat.
Curiosity and a constant quest for knowledge serve as the foundation to success in IBM Consulting. In your role you’ll be encouraged to challenge the norm investigate ideas outside of your role and come up with creative solutions resulting in groundbreaking impact for a wide network of clients. Our culture of evolution and empathy centers on long-term career growth and development opportunities in an environment that embraces your unique skills and experience.

Your Role and Responsibilities
You will join an experience team (who is open to share its knowledge) of DWH Data Engineers who are on daily basis developing maintaining and operating several large EDW solutions for large clients based in Czech Republic. Based on the various projects needs you will be responsible (in cooperation with the team) for design and development of full data lifecycle streams. In general the team further supports the delivery on Production environment and ensures daily operation of EDW solutions.

Your main responsibilities may include:

• Design and implement data acquisition stream based on the source systems possibilities including Change Data Capture solutions
• Design and implement ETLs from Landing Layer through all layers of EDW solutions
• Work with Data modelling software (Power Designer IBM Data Architect) update code generators (when needed) as majority of solutions are fully or partially model-driven
• Deploy DDLs definitions in RDMBS
• Prepare configuration for DWH Scheduler
• Design and Develop outputs for external systems/DataMart for Reporting Layers
• Cooperate with the remaining team on daily basis
• Work closely with the project manager and provide support in project planning work estimations
• Cooperate with relevant client team members in order to discuss details of Interface agreements and/or Reporting requirements
• Work with code repository tools
• Stay up-to-date with modern trends in DWH area especially cloud-based solution and PySPARK data processing frameworks
• Provide functional and technical leadership and guidance to junior team members.
• Ensure adherence to project standards and best practices.

Required Technical and Professional Expertise

• Minimum of 1 years of experience in IT.
• Knowledge of RDBMS solutions
• Knowledge of SQL
• Basic understanding data processing
• Communication and collaboration skills – team player
• Strong analytical and problem-solving skills.
• Fluent Czech or Slovak languages.
• Good command of English language.

Beneficial Technical and Professional Expertise

• Understanding of data processing in three-layer DWH solutions
• Working knowledge of a RDBMS – Oracle DB2 Teradata PostgreSQL RDBMS
• Linux shell scripting crontab
• Working knowledge of an ETL tool – IPWC IBM DataStage
• Working knowledge of a Reporting system – IBM Cognos Analytics MS Power BI
• Working knowledge of a Change Data Capture solutions – Oracle Golden Gate IBM IIDR
• Database administration skillset
• Working knowledge of code repository solutions (github gitlab etc.)
• Basic understanding of Agile delivery concepts and terminology

Preferred Technical and Professional Expertise
listed above