We provide IT Staff Augmentation Services!

Senior Etl Consultant Resume

Hyundai, CA

Professional Summary:

Over 10 years of IT experience with expertise in data warehousing. 7+ years of strong experience in designing and implementing Data Mart / Data Warehouse applications using ETL tools such as INFORMATICA PowerCenter 9.5.1,9.1,8.6.1,8.1.3,7.1.3 and PowerMart to transfer the data from legacy systems (Mainframes) to common/ different targets and experience with Oracle SQL and PL/SQL development.

  • Informatica: 7+ years of Data Warehousing experience using Informatica Power Center 9.5.1/9.1/8.6.1/8.1.3/7.1.3 , OLAP, OLTP, Autosys, IXP. Strong experience in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, and legacy system files.
  • Data Modeling: Strong Dimensional Data Modeling experience worked on Erwin 4.5 for designing the Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
  • Production Support – Done extensive 24x7 production support and issue resolutions.
  • Offshore Team Co-ordination – Onsite-offshore co-ordination experience and well versed with off-shore teams ensuring timely and quality results.
  • Strong Knowledge in Data Warehousing Concepts and experience in Quality Analysis.
  • Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to provide accurate software solutions.
  • Excellent team player with strong communication and Interpersonal skills.

Technical Skills:

ETL Tools: Informatica Power Center 9.5.1/9.1/8.6.1/8.1.3/7.1.3 (Repository Manager, Designer, Workflow Manager, Workflow Monitor)

Databases: Oracle 11g/10g, Oracle 9i/8i/7.3.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions) ER Diagrams, ERwin 4.0/3.5.2/2. x. OLAP, Star Schema.

Miscellaneous Tools: TOAD, SQL*Plus, iSQL*Plus, SQL*Loader, AutoSys, PL/SQL Developer

General Software & Prog: Excel, Word, PowerPoint, SQL, PL/SQL

Operating Systems: Windows 7/Vista/2000/98/XP/NT,

Professional experience:

Confidential, Hyundai, CA

Senior ETL Consultant

Confidential is expanding its Operations in Canada. For Canadian IT needs, the existing applications of USA will be rolled out for multi-organization structure.

As part of this transformation TDS ( Confidential ) is built. TDS holds financial data needed for Loan/Leasing processing and is a part of the decision support system. TDS is typically used by financial and risk analysis team through Dealer Portal.

Role and Responsibilities:

  • Working on requirement gathering, source system analysis and design Specifications.
  • Creating Technical design documents from the functional specifications and developing Informatica Mappings, Mapplets, Sessions and Workflow to implement the business rules and for data movement.
  • Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle, and to load the data into the target database.
  • Created Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, and Sequence generator, Sorter, Joiner and Update Strategy.
  • Worked on Optimizing / tuning mappings by following Informatica best practices to decrease the run time of workflows.
  • Designed the automation process of Sessions, Workflows and Worklets (command, email, assignment, control, event wait/raise, conditional flows)
  • Worked on Informatica Data Quality (IDQ) 9.5.1 Developer/Analyst Tools to Analyse, Standardize and Cleanse data which involves removing noise of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
  • Responsible for Production Support and first point of contact for any issue in production and QA issues.

Environment: Informatica Power Center 9.5.1, IDQ, Oracle 11g, PL/SQL developer, Flat Files, CSV and Delimited files, Unix Shell Scripts.

Confidential, Fremont, CA

Senior ETL Developer

Project Description:

Confidential , we’re building the product based on Text Analytics based on structured and unstructured data from various sources like Social Media, Blogs, and Forums etc. Companies looking to get an edge over their competitors through the creation of transformational marketing strategies need to have a deep understanding of customer experience. KloudData’s product will compile a list of positive and negative sentiments for a product or component feature at the click of a button. This product will provide easy graphs to highlight trends in changing consumer reaction to product concept and features

Responsibilities:

  • Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents to code ETL Mappings for new requirement changes.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
  • Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files and Relational Database.
  • Extensively used databases from Oracle, and MS Sql server.
  • Involved in daily scrum meeting to discuss the status of the project, facing any issues and blocking any of the jobs.
  • Creating Technical design documents from the functional specifications and developing Informatica Mappings, Mapplets, Sessions and Workflow to implement the business rules and for data movement.
  • Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle, and to load the data into the target database.
  • Design the ETL process to Extract transform and load data to Oracle
  • Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, and Sequence generator, Sorter, Joiner and Update Strategy.
  • Created Mapplets and reusable transformations to be re-used during the development life cycle.
  • Used Parameter files to define values for parameter and variable used in the mappings and sessions.
  • Create parameter and variables and called them whenever required.
  • Responsible for Production Support and Issue Resolutions using Session Logs and Workflow Logs.
  • Responsible for determining Incremental Loading mappings using Mapping Variables and Parameter Files.
  • Experience in Administrative activities such as creating folders, assigning security permissions to users and migrating the code to production in Informatica Repository Manager and admin console.
  • Monitoring performance of jobs, and making sure that they run successfully and responsible for reviewing the databases for the optimal results.
  • Worked on troubleshooting the Mappings to improving Performance by identifying bottlenecks.
  • Performance tuning of the process at the mapping level, session level, source level, and the target level.
  • Develop mappings and test data related to Text Analytics project
  • Responsible for determining Incremental Loading mappings using Mapping Variables and Parameter Files.

Environment: Informatica Power Center 9.5 Repository Manager, Designer, Source Analyzer, Workflow Manager, Workflow Monitor, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Task Developer, SQL Server 2005/2008, Oracle 10g, SQL Server Flat Files, CSV File, Delimiter, Unix Shell Scripts.

Confidential

Sr. ETL Developer

Project Description:

Confidential is one of the world’s largest providers of life insurance, pensions and long-term savings and investment products, located in Europe. IIK is data mart developed for data requirements of the marketing departments

Roles and Responsibility:

  • Involved in end to end development using ETL tool-Informatica for data flow from Source system to Target.
  • Involved in requirement gathering, source system analysis and design Specifications.
  • Worked on preparing functional specs and technical design documents.
  • Prepared low level design documents establishing mappings between sources and targets.
  • Involved in extracting data from flat file sources and load into the Oracle data base.
  • Developed several complex ETL Mappings using various transformations like Update strategy, Lookup, Filter, Router, Joiner, Stored procedure etc.,
  • Extensively used Informatica debugger to figure out the problems in mappings.
  • Worked on Optimizing / tuning mappings by following Informatica best practices to decrease the run time of workflows.
  • Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the financial calculations.
  • Created complex workflows and worklets using workflow manager.
  • Involved in QA. Worked on unit testing, regression testing, UAT and prepared test cases.
  • Worked on reviewing deliverables, system testing and user acceptance testing.
  • Involved in Initial loads and Incremental loads. Initially monitored daily loads to ensure that the data is loaded timely and in appropriate manner.
  • Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions.
  • Carried out Impact Analysis of the new changes included in the project and involved in regression testing.
  • Involved in training new heirs to work as production support and make sure all issues are fixed in the respective turn-around time.

Environment: Informatica 8.6.1, Oracle 11g-R2, Windows Server, Cognos, Erwin, Flat files.

Confidential

Sr. ETL Developer

Project: Confidential

Project Description:

The client is required to comply with Solvency II. Through Confidential data warehouse has been implemented to support reporting for the financial department and become Solvency II complaint.

Roles and Responsibility:

  • Was onsite (Netherland) coordinating with the clients, as a part of development team.
  • Used Informatica Power Center 8.1.3 to extraction, transformation and load (ETL) data in to the dataware house using transformations like Joiner, Filter, Router, Expression, Lookup, Aggregation etc...
  • Implemented slowly changing dimension to maintain current and historical data.
  • Implemented Informatica Best Practices including naming standards for mappings, workflows, and transformations.
  • Worked on cleansing, Standardizing and Transforming source data to implement business rules.
  • Used Parameter files for multiple DB connections for the sources and targets.
  • Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
  • Developed schedules to automate the Informatica sessions and batches.
  • Worked on performance tuning at the mapping level, session level, source level, and the target level.
  • Developed PL/SQL stored procedures & cursors for implementing business rules in Informatica.
  • Involved in Quality Analysis. Worked on Code Review, Unit testing, UAT, regression testing and migrated mappings from development environment to production.
  • Developed mapping specification document and Unit Test cases.
  • Involved in regression testing.

Environment: Informatica 8.1.3, Oracle 10g, Windows Server, Flat files.

Confidential - Confidential

ETL Developer

Project Name: Confidential

Project Description: Confidential Confidential is the largest brokerage in the world, with more than 20,000 Financial advisors and $2.5 trillion in client assets. Reg Ed is an external vendor who maintains the database of financial advisor Profiles as BOAML is not directly involved in fetching licenses for FAs from the regulatory authorities.

Roles and Responsibility:

  • Involved in Coordinating with the Onsite team in understanding the Business Requirements.
  • Responsible for monitoring the daily, weekly and quarterly warehouse load process.
  • Expertise in troubleshoot time sensitive job failure issues.
  • Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails.
  • Prepared daily load error report and solutions.
  • Involved data Analysis for the existing data warehouse to ensure that no data loss or rejections have occurred impacting the Business during the daily load process.
  • Extracted data from flat files and oracle database, applied business logic to load them in the Oracle database.
  • Worked on Joiner, Filter, Router, Expression, Lookup and Aggregation transformations.
  • Prepared estimations, design documents and Unit Test cases for mappings.
  • Creating solution documents for developed mappings.
  • Carry out Impact Analysis for any new changes being pushed to Production.

Environment: Informatica 7.1.3, SQL Server 2000, Windows 2000, Business Objects.

Confidential - Confidential

ETL Developer

Project Name: Confidential

Project Description:

Confidential has an internal portal called Confidential University to enable employees enhance their skills through self-learning. Confidential is a data mart build for Confidential University. Cognos is used for web based reporting.

Roles and Responsibility:

  • Understanding existing business model and customer requirements.
  • Analyzing the Production issues and timely fixing.
  • Developed mappings using informatica for data flows from Source to Target.
  • Used various transformations like the Joiner, filter, lookup, expression, aggregator, update strategy etc... In mappings to perform the ETL process
  • Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
  • Worked on mapping review, to find design flaws and optimize performance.
  • Created effective Unit Test cases to ensure successful execution of data loading processes.
  • Performed Informatica code migrations, testing, debugging and documentation.
  • Used AutoSys as scheduling tool.

Environment: Informatica 7.1, Oracle 9i, Windows 2000, Cognos.

Confidential

ETL Developer

Project Description: This project was to build a set of tables for identifying Expart details and maintain a log of their expenses. Exparts are the employees who are hired in at a specific region but physically work out of a different region, as per the business requirements.

Roles and Responsibility:

  • Monitoring daily and weekly loads.
  • Fixing production issues and closing Remedy tickets.
  • Understanding the customer requirements for project enhancement.
  • Worked on Informatica tool for developing mappings to extract and load the data from flat file sources to Oracle target tables.
  • Involved in error handling, debugging and troubleshooting Sessions using Session logs, Debugger and Workflow Monitor.
  • Used different tasks like Email and Command task.
  • Used Autosys to automate the Informatica Sessions.
  • Review existing mapping for performance optimization.
  • Prepared unit test cases.
  • Involving User Acceptance Test.

Environment: Informatica 8.1, Oracle 9i, Windows 2000, Cognos

Hire Now