Informatica Etl Developer

TECHNOALLY PTE. LTD.-Singapore, Singapura

Negociável

Tempo Inteiro

1 vaga

Role: ETL Developer

Design and develop any/all necessary ETL processes
Responsible for loading and validating data into the data warehouse
Knowledge in Dimensions and Facts tables.
Translated the business processes into Informatica mappings for building the Dimension tables.
Worked on different tasks such as Event wait, Event Raise and Command.
Created mappings to build business rules to load data.
Implemented slowly changing strategy to manage the data in the dimension tables.
Involved in Code review and manual testing such as Unit testing
Involved in creating mapping variable, mapping parameter to make the mapping more flexible
Knowledge in performance tuning to optimize session performance by eliminating performance bottlenecks.
Prepared Functional spec, Migration document, Unit test case document and support manual.
Hands on experience in writing UNIX commands and writing, editing Shell Scripts.
Hands on experience in creating procedures and functions.
Hands on working experience in SQL Server and Vertica Databases.
Strong experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger). Experience in SQL, PL/SQL and UNIX shell scripting.

Primary Skills

Secondary Skills

Detalhes