Professional Summary
SKILLS O Jessica Claire Informatica Administrator with 6+ years of IT experience in Development, Administration, Design and Maintenance of Data warehouse applications as an Informatica Administrator and ETL Developer. 5+ years of experience in INFORMATICA tools ADMINISTRATION. Install, Configure and Upgrade Informatica Power center 9.x/8.x on IBM AIX, SUN-SOLARIS and LINUX. Hands on experience on migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production. Experience in Informatica Data Quality, Data Explorer and Power Exchange. Experience in Applying Informatica Hot fixes/EBF Installed & configured Informatica 9.x B2B Data Transformation. Provide 24/7 Support related to Administration tasks (Emergency Deployments, FATAL ERRORS on the Informatica Server, unexpected Informatica services failures, Repository issues etc.) Good knowledge on Teradata utilities like Multi load, Fast load, Fast Export & TPUMP. Experience in Extraction, Transformation and Loading of data from different source systems like Flat files, Excel, VSAM, DB2, Oracle, SQL Server and Teradata. Worked extensively on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Maplet and Mapping Designer Hands on experience with Complex mappings from varied transformation logics like, Aggregator, Router, Joiner, Connected and Unconnected Lookups and Update Strategy. And also developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the execution of the data loading process Complete monitoring of scheduled jobs and UNIX servers over 24/7 rotations.Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools. Technical skills: ETL: Informatica Power Center 9.6.1, B2B DT & Informatica Data Quality Databases: Oracle 12g/11g, MS SQL Server2005/2008, Teradata 14 Languages: SQL, PL/SQL, Unix Shell Scripting. Operating System: UNIX (AIX, Solaris, LINUX), Windows NT/XP