ETL Developer

Job Description :

Roles and Responsibility :

Designing and coding the data warehousing system to desired company specifications

Conducting preliminary testing of the warehousing environment before data is extracted

Extracting company data and transferring it into the new warehousing environment

Testing the new storage system once all the data has been transferred

Troubleshooting any issues that may arise

Providing maintenance support

Consulting with data management teams to get a big-picture idea of the company’s data storage needs

Presenting the company with warehousing options based on their storage needs

Requirements :

Experience of 1-3 years in Informatica Power Center

Excellent knowledge in Oracle database and Pl-SQL such - Stored Procs, Functions, User Defined Functions, table partition, Index, views etc.

Knowledge of SQL Server database

Hands on experience in Informatica Power Center and Database performance tuning, optimization including complex Query optimization techniques  Understanding of ETL Control Framework

Experience in UNIX shell/Perl Scripting

Good communication skills, including the ability to write clearly

Able to function effectively as a member of a team

Proactive with respect to personal and technical development