Responsible for all activities related to the development, implementation, administration, and support of ETL processes for large scale data warehouses using Informatica Power Centre.
Skills:
Good SQL knowledge.
Basic UNIX shell scripting knowledge.
In-depth understanding of fundamental Data-Warehousing concepts such as Dimensional Modelling, Star and Snowflake Schemas, Data marts, Security and deployment, FACT and Dimensional tables, Logical and Physical data modelling.
Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL processes.
Hands-on experience in tuning mappings and identifying/resolving performance bottlenecks at various levels such as sources, targets, mappings, and sessions.
Well-versed in developing complex SQL queries, unions, multiple table joins, and experience with Views.
Well-versed in UNIX shell scripting.
Experience:
Experience with Netezza & Yellowbrick.
Extensive experience in ETL design, development, and maintenance using SQL Server SQL, PL/SQL, SQL Loader.
Experience in database programming in PL/SQL (Stored Procedures, Triggers, and Packages).
Tools/Software:
Informatica Power Centre
SQL Server SQL
PL/SQL
SQL Loader
Netezza
Yellowbrick
UNIX