Informatica and IDQ developer
Over 9 years of experience in software development and extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 9.1, IDQ 9.1, SQL, PL/SQL, Oracle and Unix.
Expertise in Data extraction, cleansing, parsing, standardization, consolidation, validation and migration
Experience in writing PL/SQL stored procedures, functions, packages and triggers using PL/SQL developer.
Expertise in fine performance tuning of SQL statements and PL/SQL modules using Explain Plan, SQL Trace for optimizing the cost and evaluating the performance.
• Operating Systems:
Windows XP/VISTA/7, UNIX, IBM OS/390.
• ETL Tools:
Informatica Power Center (Designer/workflow manager/workflow monitor)9.1/8.x, IDQ 9.1.
• Data Bases:
Oracle11g/10g/9i, MS Access 2000, MySQL, DB2.
• Software Tools:
SQL*plus, SQL developer, Excel and Power point, MS ACCESS, Toad.
• Programming Languages:
UNIX, SQL, PL/SQL, COBOL, JCL
• Scheduling Tool:
AUTOSYS, BMC Control-M
• Scripting Languages:
UNIX Shell Scripting