30 Jul
|
Anicalls (Pty
|
Hyderabad
30 Jul
Anicalls (Pty
Hyderabad
• Over 9+ Years of Experience in IT and Data warehousing, ETL (Extract, Transform and Load)
• Experience in Informatica (Power center/Power Mart/Power Exchange).
• Experience in SQL Server with CUBE
• Extensively experience on ETL Informatica Transformations using Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator and created complex mappings.
• Experience in implementing the entire life cycle of the project
• Experience in Unix Shell Scripts for automation of the ETL process.
• Should be able to provide the end to end architecture of the ETL process for loading staging/landing zone and audit control process.
• Experience in creating detailed technical design documents, including the Source to target mapping docs.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins, and hash indexes in Oracle/Teradata and Postgre SQL databases.
• Expertise in Data modeling techniques like Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Experienced in the Performance of Mapping Optimizations in Informatica.
📌 Lead Informatica Developer Hyderabad
🏢 Anicalls (Pty
📍 Hyderabad