Data warehouse Developer_ ETL/Informatica/SQL/PL/SQL

Company: AARK TECH SOLUTIONS LTD
Job type: Other

    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.

    Your role

    • 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.

    Apply for this job