sr informatica iics developer resume example with 17+ years of experience

Jessica Claire
Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000 - Cell: - - - -
Professional Summary

Highly skilled professional with 17+ years of hands-on experience in analyzing, architecting, developing and designing solutions (ETL,Data Warehouse, Data Mart, ODS) in OLTP technologies using star and snowflake dimensional modeling. Hands-on exposure with Informatica Cloud(IICS)/ETL and Hadoop technologies. Self-motivated team performer with experience as Informatica Lead/Informatica cloud(IICS)Developer/DW Architect/Hadoop/Sr. Teradata Developer.

Areas of Expertise
  • ETL Team Leader.
  • Informatica Power Center 10.x/9.x/8.x.
  • IICS (Informatica Cloud) Data Integration, App & API Integration.
  • API/Web Services using application integration REST End point connecter.
  • Informatica Cloud Data Integration (IICS – CDI Service) For Google Analytics.
  • Application integration with EATON/Rockwell Suppliers /Delighted Survey(End point) using JWT and REST Connectors.
  • Experience with Informatica MFT.
  • XML generator , XML parser, Java and HTTP transformation within Informatica for realtime transfer of ActiveMQ messages
  • Scope and Roadmap for DW ,ETL and BI.
  • Data Modelling,ETL High Level and Low Level Design.
  • Teradata, SQL Server and Oracle(PL/SQL).
  • Strong knowledge on Teradata Architecture.
  • KPIs and Reporting specific calculations.
  • Developing/Designing ETL Informatica processes/mappings .
  • Tuning ETL/Informatica mappings/processes.
  • Best practices for developing ETL jobs .
  • UNIX Shell Scripting and ETL automation.
  • Tuning of complex SQL Queries/Processes.
  • SCD 1, 2 ,3 and Change Data Capture (CDC).
  • Resolving production ETL failures.
  • Optimal performance strategy in Teradata using indexes,joins indexes,partitioning,statistics etc.
  • Teradata Utilities (BTEQ,Mload , FLoad & TPT)
  • Root cause analysis of business driven issues.
  • Experience on TWS,Cisco Tidal Enterprise and Ctrl M Schedulers.
  • Big Data,Hadoop, Hive,Sqoop, Oozie and Spark
  • Strong knowledge in Python Programming and Cloud(GCP)
  • Good team player, constant learner, excellent analytical & logical skills.
Work History
04/2019 to Current
Sr. Informatica/IICS Developer Rexel Holdings USA City, STATE,

  • Interacted with Business partners to identify/understand requirements, design specifications, expectations, and vision in key projects like supplier integration, TNT (Track and Trace), item golden record creation.
  • Identify ETL specifications based on business requirements and creating ETL Mapping Documents, high level documentation for product owners and data managers.
  • Handled end-to-end Development and Implementation of Product (Item) Master Data and Supplier Marts by taking into consideration business cases, objectives, optimization, and requirements. Which reduces loading timings 25 %.
  • Re-architected and developed product Golden Master Record project. This project was saving $100k/year licensing recurring costs to company
  • Managed code reviews and ensure that all solutions and processes are aligned to architectural/requirement specifications, SLAs and standards.
  • App & API Integration of Informatica Intelligent Cloud Services.
  • Extensively Worked on XML Parser/generator, HTTP (Post) and JAVA transformation as part of inventory synch and sharing between Micron, Eclipse systems through Realtime ActiveMQ messing.
  • Developing integrations using Informatica Cloud Data Integration (IICS – CDI Service) For Google Analytics.
  • Developing Informatica Cloud Mappings, Ds task, Data replication and task creation.
  • Worked with API/Web Services using application integration for EATON Supplier (End point) using JWT.
  • Worked with API/Web Services using application integration for Rockwell Supplier through REST End point connecter.
  • Worked on Delighted survey integration using REST API and pagination to pull survey messages.
  • Worked on Informatica MFT (Managed File Transfer) for to exchange the files with external systems.
  • Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface.
08/2008 to Current
Informatica ETL Lead|Architect|Hadoop Developer Verizon City, STATE,

FIOS Sales and compensation Mart:

  • Reviewed BRD (Business Requirement Document) and create aligned technical interface design specifications for analytics, reporting and ETL.
  • Handled data profiling, source analysis and data quality analysis.
  • Prepared high level solution architecture Design and review with top management.
  • Performed project management on several business enhancements and work requests.
  • Managed team and assign tasks, review /validate code and help them to fix critical issues in testing and development.
  • Mentoring junior developers , providing technical ,domain assistance, troubleshooting and alternative development solutions
  • Coordinated with team to prepare design docs and flow specs.
  • Interacted with business, cross functional team,SMEs and BI team on day to day basis for critical time lines requirements and any system issues.
  • Developed and enhanced complex Informatica mappings, sessions , worklets and workflows with optimization.
  • Prepared high level test strategies ,plans and scenarios for ETL processes.
  • Provided solutions to production failures and ETL/DB performance enhancement.
  • Engineered analysis to identify data and count issues between source systems and final BI reports.
  • Developed UNIX shell scripts for pmcmd, parameter file and file transfer automation.
  • Built data feeds and extracts with complex business rules sourcing from warehouse to different IT and Business Teams.
  • Developed various Adhoc reports quickly to find data-driven answers.
  • Developed processes for data extractions and loading into Teradata using BTEQ, Fast Load, Multi-Load and TPT.
  • Worked on ETL process migration for various data marts from Oracle to Teradata.
  • Tunned Teradata Queries by using PIs,PPIs, Indexes,joins indexes and statistics for FIOS Sales ETL and BI reporting .
  • Worked on Hadoop loading data into HDFS using Sqoop, created Hive tables for customer journey analytics.
  • Worked on Audit process to report enterprise dashboard metrics accurately and efficiently.
  • Implemented optimal ETL performance strategies which resulted in 30 % improvement in over all sales and real time data mart process times.
  • Helped manager to find out right resources by conducting interviews and filtering profiles.
  • Supported numerous escalations from business community regarding critical key rep compensation reporting .
  • Implemented processes for data lake solutions using Oozie and Hive for call metrics.
  • Coordinated with Operations team to resolve critical emergency incident reports (IR) related to data issues and load failures.

HSI/FIOS Broadband Rate Changes (Price up):

  • Collaborated with business, SMEs and cross functional teams to finalize eligibility requirements, design strategies and implementation approaches.
  • Reviewed project documents to identify potential impacts.
  • Prepared high level design, development and flow preparation for end to end ETL processes which resulted estimated annual revenue growth $10M to Company.
  • Built complex Informatica mappings and DB/ETL processes for leads list and MOG process.
  • Created various forecasting, eligibility, actually priced up, and fallout reports to estimate revenue and profitability to company.
08/2004 to 08/2008
ETL Consultant At Verizon Advansoft Consulting City, STATE,

HSI (High Speed Internet) Sales Mart :

  • Interacted with manager to understand enhancements, and modifications.
  • Designed data model and table structures, keys and indexes.
  • Build dimensions, fact and aggregate tables as per requirements and standards ,identify slowly changing dimensions and determine hierarchies.
  • Created Complex mappings, sessions, and workflows for real-time migration of data from different sources like Legacy Systems, flat files and other Relational Sources.
  • Implemented Informatica transformations like Joiner, aggregators, Connected & unconnected lookups, caches, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter etc.
  • Prepared CA (Change Activity), SRR (Software Release Request) documentation to migrate code.
  • Extensively tuned SQL queries by using hints and other tuning techniques.
  • Analysed data to make sure to match expected counts between source system and target system ,fix issues raised by Business
  • Involved in Informatica Administration to create users ,access and server restarts.
05/2004 to 08/2004
Data Warehouse/ Interfaces Developer At William Sonoma Advansoft Consulting Inc City, STATE,
  • Worked with business analysts, data architects and team leads to build infra structure of data flow.
  • Participated in integration test, system test, user acceptance and prepared test plans.
  • Documented entire DW process.
  • Developed/Enhanced UNIX shell scripts to load sales, inventory, and promotions rejections.
  • Handled production support for entire RDW batch processes.
  • Scheduled, and monitored all batch jobs using control-M scheduler.
  • Fixed and re-run failed jobs to complete batch jobs.
  • Identified and fixed FTP and merging failures in RDW batch process.
  • Worked on customized PL/SQL aggregations scripts to generate reports to business.
  • Fixed and raised TDR/PDR (Test/Production Defect Report) issues.
  • Involved in data validations of DW data against RCOM, RMS, and Legacy flat file system.
Expected in 2018 to to
: Graduate Business Analytics Certificate
Southern Methodist University - Dallas,
Expected in to to
Master of Science: Electrical Engineering
Tennessee Technological University - Cookeville, TN

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Southern Methodist University
  • Tennessee Technological University

Job Titles Held:

  • Sr. Informatica/IICS Developer
  • Informatica ETL Lead|Architect|Hadoop Developer
  • ETL Consultant At Verizon
  • Data Warehouse/ Interfaces Developer At William Sonoma


  • Master of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: