Professional Summary
Jessica Claire Over 7+ years of professional IT experience in Analysis, Design, Development, Testing, and Implementation of various Data warehouse. Extensively involved in ETL Development using IICS and Informatica Power Center 9.x/10.X Having experience working with Informatica IICS tool effectively using it for data integration (On- premises and cloud-based) and data migration from multiple source systems. Experience with IICS (Data Integration, Administrator, Monitor) Services. Experience in Building Service connectors for Real Time integration with Third party applications like Google Cloud Storage, BigQuery. Strong technical experience building data integration processes by constructing mappings, tasks, task flows, schedules, and parameters. Used informatica designer components - source analyzer, transformation developer, mapplet and mapping designer. Worked extensively with complex mappings using multiple transformations like source qualifiers, expressions, filters, joiners, routers, union, unconnected / connected lookups and aggregators, hierarchy builder and hierarchy parser, stored procedures, rank and normalizer, sequence and SQL. Experienced in performance tuning of jobs. Strong in finding out the bottlenecks and fixing them using various tuning methods like session partitioning, reducing the lookup sizes, using persistent caches and pushdown optimization etc. Experience in Implementation of CDC and SCD1/SCD2. High Experience in RDMBS (Oracle), including complex SQL constructs and DDL generation, fine tuning the SQL queries that are used at different places like source override, pre SQL and post SQL at source and target and at the lookup override. Experience in UNIX shell scripting for creating list files, cleansing the input files, and archiving the source files Performed Unit testing at various levels of the ETL and actively involved in team code reviews. Experience in working with Agile methodology and Involved in Agile Meetings, Feature Backlog Grooming Refinements, Daily Stand-ups, Retrospection, SOS (Scrum of Scrum), Sprint Planning, Sprint Internal Demo's, Sprint External Demo's. Hands on Experience in Jira/Confluence Tools for Project Management, Sprint Management, Defects. Ability to learn new technology and quickly adapt to technology changes, have willing to work attitude. IICS, PowerCenter 9.x, 10.x Oracle, PostgreSQL, Big Query, Google Cloud