Data warehouse Developer_ ETL/Informatica/SQL/PL/SQL
Posted on Sep 25, 2021 by AARK TECH SOLUTIONS LTD
Remote Working: No (Due to current COVID situation, the client may ask for remote working from Switzerland itself).
Our client is urgently looking for an Data Warehouse Developer to join their team based in Zurich, Switzerland.
- In Data Warehousing, Decision support Systems and extensive experience in implementing Full Life cycle Data Warehousing Projects.
- Strong ETL experience using Informatica PowerCenter 8.x/7.x/6.x/5.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations.
- Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
- Developed complex mappings in Informatica & Datastage to load the data from various sources into the Data Warehouse, using different transformations/Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
- Thoroughly proficient in SQL and PL/SQL development in Oracle 8i/9i.
- Expertise in Data Modeling, Designing of Logical and Physical datamarts.
- Experienced in designing and writing on-demand UNIX Shell Scripts.
- Exceptional analytical and problem solving skills. Good team player with the ability to communicate effectively at all levels of the development process.