Database ETL Senior/ Solution Architect Senior – Roche
•100% remote, remote
•1 interview + assessment center
Must have:
•At least 4 years of DB/ETL development experience and 5+ years of experience as a Solution Architect
Requirements:
•Knowledge of integration concepts & supporting tools;
•Very good command of ETL processing tools (e.g. Informatica PC, Nifi, SSIS, Talend, etc.)
•Very good command of SQL & PL/SQL
•Good command of data storage solutions (e.g. Oracle, PostgreSQL, MySQL, etc,)
•Basic knowledge of UNIX systems
•Date warehousing concepts & patterns familiarity
•Knowledge of cloud data integration tools e.g. GCP DataFlow, Cloud (AWS/Azure/Google)
•Knowledge of BI reporting systems
•Agile frameworks/methodologies (e.g., Scrum, SAFe).
•Experience with one or more diagramming, mockuping, and UI design tools (eg. Balsamiq, Draw.io, MS Visio, LucidChart, Enterprise Architect, Adobe XD, etc.).
•Knowledge of Pharma industry standards and solutions, as well as the overall drug development process and business processes related to it, will be an advantage
•Familiarity with coding languages, operating systems, and databases.
•Understanding of process optimisation and deployment.
•Experience working with various infrastructure platforms.
•Ability to organize and prioritise critical projects.
•Excellent analytical skills.
•Proven track record of finding creative solutions.
•Solid understanding of IT topics.
•Past experience of working in a manufacturing environment is a plus.
•English at least at C1 level (B2 exceptionally)
•Proficiency in German language, both written and verbal is a plus
PostgreSQL Draw.io Analytical skills Microsoft Visio Databases Enterprise architecture (EA) apache-nifi Talend integration PL/SQL Oracle Solutions Architect diagramming SQL Server Integration Services (SSIS) Balsamiq SQL ETL Scrum deployment MySQL Lucidchart adobe-xd SAFe operating-systems