We provide IT Staff Augmentation Services!

Senior Informatica Etl Consultant Resume

San Ramon, CA

PROFESSIONAL SUMMARY:

  • Having 11+ years of extensive experience in Analysis, Requirement gathering, Design, Development, Testing and Implementation of Business application systems for Banking & Financial, Health Care, Retail and Automotive Sectors.
  • Strong Experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence solutions in Data Warehouse / Data Mart Design, ETL, BI, Client/Server Applications.
  • Hands on experience inworking with ETL tools like Informatica Power center 9.6/9.1, IBM Infosphere Data stage 8.x/9.x
  • Strong experience in working with Informatica Power Center 9.1.x & 8.x client tools - Mapping designer, Workflow manager, Workflow monitor, Mapplet designer and Transformations.
  • Experience in various Databases such as Teradata V2R5, Teradata R12/R14, Oracle 11g/10gand DB2.
  • Experience in working with Teradata utilities, Fast Export, Fast Load, Multi Loadand B-TEQ.
  • Worked extensively in creating Teradata Database objects.
  • Good experience in programming languages like PL/SQL, SQL, UNIX.
  • Hands on experience in working different industries like Banking, Health Care, Retail and Manufacturing.
  • Very good understanding and experience in working Logical, physical and Dimensional Modeling techniques like Star/Snow flake schemas.
  • Experience in working data Migration from Oracle 10g to Teradata R14.
  • Have strong experience in writing SQL, PL/SQL packages and UNIX scripts.
  • Experience on working with different data loading techniques such as SQL Loader, Oracle UTL FILE utility and External Tables.
  • Have experience in conducting user acceptance testing and documenting the key test documents like Test Plan, Test cases, Test scripts.
  • Have experience in Datacenter Migration and ETL conversion project.
  • Worked in implementing project in agile methodology.
  • Worked on performance tuning of mappings, transformations and sessions to optimize session performance.
  • Have very good experience in working with third party scheduling tools like Autosys, CA ESP.
  • Have good experience in working with production support and on resolving production issues.
  • Good knowledge and understanding big data concepts and Architectural knowledge on Hadoop HDFS concepts and their eco systems like Map Reduce, Hive, Sqoop and HBase.
  • Effectively interacted with other members of the Business Engineering, Quality Assurance, Users and other teams involved with the System Development Life cycle.
  • Have good communication skill and ability to work effectively as a team member and as individual.

TECHNICAL SKILLS:

ETL Technologies: Informatica Power Center 9.x/8.x,IBM Info sphere Data stage 9.x/8.x

Data Base: Oracle, Teradata, DB2, SQL Server

Reporting: Business Objects, OBIEE

Operating Systems: UNIX, Sun Solaris, Linux, MS Windows Servers and Clients

Data Modeling: Logical and Physical data modeling, Star-Schema, Snowflake and Hierarchical

Big Data: HDFS Architecture, MapReduce, Hive, Scoop, Flume, HBase.

Languages: PL/ SQL, XML, UNIX Shell Script, Python

Tools: & Utilities: ESP,Share Point, Visio, Toad, M Load, Fast Export

WORK EXPERIENCE:

Confidential, San Ramon, CA

Senior Informatica ETL Consultant

Responsibilities:

  • Developed ETL Informatica Mappingsfor different sources Commercial Real Estate, Corp, USO, USSB of Automated Financial Systems (AFS) for commercial Loans and Address Matching, First Lien, Home Equity of Advanced Loan systems (ALS) for consumer loans.
  • Prepared Technical specification documents AM, First Lien Home Equity, Corp, CRE.
  • Worked on complex queries and procedures based on the business requirements.
  • Developed UNIX scripts for automation of triggering workflows and on for purging log files in UNIX file system.
  • Worked on developing Informatica Mappings based on business logics and used different transformations like Source Qualifier, Lookup, union, Router, Aggregator, Expression, Filter, update strategy and Joiner.
  • Worked in creating test case, test scripts documents and coordinated with Business for User Acceptance test.
  • Analyzing KDE document and data mapping documents for CCAR.
  • Worked on troubleshooting and performance tuning of ETL mappings, SQL queries and resolving the issues.

Confidential

Senior Informatica ETL Developer

Responsibilities:

  • Analysis, systems design and responsibility over ETL development.
  • Business requirements analysis and determining of project scope.
  • Interaction with senior management and other workers in IT and user Departments.
  • Involving in the ETL architecture construction and Source to Target mapping to load data into Data warehouse.
  • Extracting the data from RDBMS databases into staging area and populated onto Data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings in Informatica designer.

Confidential

Senior Informatica ETL Developer

Responsibilities:

  • Worked on Analysis, ETL design and development for the portfolios Securities, Consumer Loans.
  • Developing Informatica Mappings based on business logics and used different transformations like Source Qualifier, Lookup, union, Router, Aggregator, Expression, Filter, update strategy and Joiner.
  • Worked in creating test case, test scripts documents.
  • Worked on troubleshooting and performance tuning of ETL mappings, SQL queries and resolving the issues.

Environment: Informatica Power Center 9.6.1, Oracle 12c/11g, Windows XP, UNIX, Tidal

Confidential, Middleton, WI

Senior Informatica ETL Developer

POS Conversion

Responsibilities:

  • Worked in analyzing the existing PL/SQL program, preparing understanding documents and on gathering business requirements.
  • Prepared the Functional and Technical Mapping documents for Point of Sales (POS) interface conversion to Informatica ETL program.
  • Worked in Design and Development of Informatica ETL Jobs for the Mattel Retail POS systems from extracting flat file data with comma and CSV from Epicor, Café & Ticketing systems and processing the Retail data.
  • Created complex Informatica mappings based on the business logics and used Transformations like Source Qualifier, Lookup, union, Router, Aggregator, Expression, Filter, update strategy and Joiner.
  • Worked in creating test case, test scripts documents and coordinated with Business for User Acceptance test.
  • Developed UNIX scripts for automation of triggering workflows and on for purging log files in UNIX file system.
  • Prepared ETL document guide for prod ops team and helped them to understand the ETL job process flow to do the production support activities.
  • Worked with multiple teams like DBA’s, QA Teams, Business for UAT testing and Prod Ops team in all phases during the Implementation.

Environment: Informatica Power Center 9.1, Oracle 11g, Windows XP, LINUX, Autosys

Confidential, Bloomfield, CT

Senior ETL Consultant

Responsibilities:

  • Requirement gathering and analysisto understand the process flow of CCDR.
  • Worked extensively on database migration for CCDR from Oracle to Teradata.
  • Designed, Developed and implemented Informatica ETL workflows process for Provider /Individual, Biometrics and Program Activity modules of Confidential healthcare and insurance.
  • Extensively used Transformations like Source qualifier, Aggregator, Lookups, Filter, Update strategy, Router, Expression.
  • Worked on extracting different source data like Flat files with delimiter, XML and relational data from oracle tables.
  • Involved in monitoring the data loads (Daily/Weekly/Monthly) from various sources for the subject areas by workflow monitor and on running the workflows.
  • Extensively worked on analyzing the errors in the data loads and taking corrective actions.
  • Utilized Informatica debugger for debugging Informatica mappings.
  • Worked on troubleshooting and performance tuning of ETL mappings and SQL queries and resolving the issues.
  • Worked on addressing P1 and P2 Production issues with the standard process and providing the Business solutions with in the SLA period.
  • Created Unit test, Test case and Test script documents and worked with business for User Acceptance testing.
  • Developed PL/SQL stored procedures for loading the data in to Health View data mart system.
  • Worked on creating UNIX scripts for automation and invoking Informatica workflows.
  • Developed B-TEQ, Multi load scripts for different business scenarios for loading the data in to Claims data mart.
  • Troubleshooting in Teradata query performance issues and stored procedures. Fine-tune the existing scripts and process to achieve increased performance and reduced load times for faster user query performance.
  • Worked on code migration/conversion from PL/SQL to ETL Informatica for some of the existing components used in Provider module.
  • Worked with multiple teams like Data Architect, DBA, QA and with Business for UAT testing on all the phases of deployment.

Environment: Informatica Power Center 9.5, Oracle 10g,Teradata R14,Teradata Utilities, SQL Server 2008, LINUX, CA ESP.

Confidential

Senior ETL Consultant

Responsibilities:

  • Prepared Technical mapping documents for Loans and Deposit modules for Citi EMEA region.
  • Designed and Developed ETL Jobs for loading the customer base data extracting from different source systems to interim tables and loading in to target tables.
  • Involved in Analysis, Design and Development of Data stage ETL jobs for raw data loading and for building star schema using Informatica Power center, Oracle 10g.
  • Developed complex mapping to implement the business logics using the transformations like lookup, Union, router, aggregator, expression, update strategy, Filter and joiner.
  • Created customized Multi load scripts on UNIX platform for Teradata loads.
  • Worked on Teradata utilities and Teradata Database objects for data loads.
  • Developed ETL mappings for SCD1 and SCD2 implementation process.
  • Designed and developed the ETL mappings for different loading techniques like Full/Delta process.
  • Worked on troubleshooting and preparing impact analysis for the production issues and resolving the issues.
  • Worked on tuning of ETL mappings.
  • Created UNIX scripts for automation of the ETL programs.
  • Prepared operational support documents Performance for deployed programs and provided to production support.
  • Worked for the major datacenter migration activity from Singapore to Frankfurt. Conducted end to end testing of the data warehouse system.

Environment: Informatica Power Center 8.6, Teradata V12,Oracle 10g, Windows XP, TOAD, HP-UNIX, LINUX

Confidential

Senior ETL Developer

Responsibilities:

  • Extensively worked in design and development of ETL Mappings for building the DIH (Data Integration Hub) using IBM Web sphere Data stage 8.1, Oracle 10g.
  • Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner confirming to the business rules and documented.
  • Worked in production support on Monitoring batch runs for weekly and Monthly extracts from various data sources across all platforms to the target database.
  • Developed mappings for extracting the Global consumer banking data from different source systems.
  • Created UNIX Scripts for ETL automation processes.
  • Produced a Unit test Document, test case and test scripts documents.
  • Created SCD Type 2 mappings for the Customer mart implementing logic.

Environment: IBM Web sphere Data stage 8.1, Oracle 10g, Windows XP, UNIX, Autosys

Confidential

ETL Developer

Responsibilities:

  • Involved in analysis and requirement gathering for F@ST CPM & CVF project.
  • Developed ETL Mappings for the extracting the data from different source system and used various transformations to implement the business logic for Fast.
  • Developed B-TEQ and Multi load scripts to load data from Oracle to Teradata.
  • Created PL/SQL stored procedure for processing the CPM data and UNIX scripts for program automation.
  • Extensively utilized Teradata utilities Fast Load, Multi Load for loading the data in to CPM DWH system.
  • Created SCD Type 2 mappings for the Customer mart implementing logic.
  • Performed unit testing and worked with business on user acceptance testing (UAT).
  • Prepared functional specification and technical mapping specification documents.
  • Performed testing on the developed ETL mappings on using Debugger.
  • Worked on performance tuning for various ETL mappings.

Environment: Ascential Data Stage 7.5, Oracle 10g, Teradata V2R5.1/V2R6.1,Autosys, UNIX.

Hire Now