We provide IT Staff Augmentation Services!

Informatica Etl Developer/data Analyst Resume

2.00/5 (Submit Your Rating)

Overland Park, KS

PROFESSIONAL SUMMARY:

  • ETL Informatica/Data analyst expert with 6 years of strong experience in performing ETL (extraction, transformation and load) processes using Informatica Power Center 9.x, 8.x to load the data in to data warehousing or legacy to target systems.
  • Strong experience with SQL scripts to perform various data operation on the databases.
  • Experience in all phases of the project life cycle including Requirement Gathering, Design, and Development, Testing, go - live and post go-live enhancements and support.
  • Extensive knowledge of various kinds of Informatica Transformations such as Source Qualifier, Aggregate, Lookup, Rank, Joiner, Filter, Router, Sorter, Sequence, Union, Update Strategy, Stored Procedure, Normalizer, xml Transformation.
  • Experience in Repository Configuration, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems (Oracle, SQL server, Flat files) to targets.
  • Strong understanding of RDBMS Concepts, Dimensional Modeling (Star Schema, Snowflake Schema) and Slowly Changing Dimensions.
  • As a Data Analyst, have analyzed sources and source system profiles to create source-to-target mapping document.
  • Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • Hands on experience on database management tools and UNIX scripts.
  • Experience in maintenance and enhancement of existing system. Experience in debugging the failed mappings and developing error-handling methods as part of production support.
  • Ability to quickly grasp available technology, tools and existing client Architecture.
  • Excellent written and communication skills, analytical skills with the ability to perform independently as well as in a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x (Workflow Manager, Workflow Monitor, Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager).

Database & Related Tools: MS SQL Server 2005/2008, Oracle 11, 10g/9i/8i, MS Access, SQL* Plus, Toad for Oracle, SQL Server Management studio.

Languages: SQL, PL/SQL, Unix Shell Scripting

Operating Systems: Unix, Microsoft Windows 98/NT/2000/XP/2007/Vista/2010/7/10.

Others: Tableau, OBIEE, MS Office 2007/2010/2013- Word, Excel, Outlook, PowerPoint, Notepad ++, Notepad, MS Visio, OneNote, Adobe Acrobat.

PROFESSIONAL EXPERIENCE:

Confidential, Overland Park, KS

Informatica ETL Developer/Data Analyst

Responsibilities:

  • Worked with data modeler to derive high level and detailed level data model for Property & Casualty insurance data.
  • Worked as Data analyst for analyzing, data profiling and data cleansing of the source systems
  • As a Data Analyst determined and documented data mapping rules/ business rules from source data fields to their related target data fields
  • Developed extract, transform and load jobs to:
  • Extract data from source systems such as studio application in to staging area databases
  • Perform required mapping between source to target data
  • And load the data in to consolidated data warehouse system
  • Used UNIX scripts and Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Used Autosys scheduler to schedule ETL jobs per required batch scheduling timelines.
  • Worked with legacy system team to facilitate infrastructure requirements, connection details and getting the data for the ETL process.
  • Develop the technical specification documents and technical unit testing documents.
  • Recommended tweaks and changes to the data model design based on the challenges in implementing ETL code.
  • Worked closely with the testing teams to debug the defects and testing issues. Also, built scripts to create large volume of test data for testers.
  • Perform code migration activities to move the code form DEV to QA and then to PROD environment.
  • Involved in Performance tuning tasks for Informatica code and query optimization.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.1, Toad for Oracle, SQL Developer, PL/SQL, Oracle 10g/9i, Autosys, SQL Server 2008, UNIX, SQL Server Management Studio, Perl, SmartFTP, Putty.

Confidential

Informatica ETL Developer/Data Analyst

Responsibilities:

  • Involved in planning, building, and managing successful large-scale Data Warehouse and decision support systems
  • Worked as Data analyst for analyzing, data profiling and data cleansing of the source systems
  • Responsible for Informatica ETL development & Confidential Execution Plan creation. In order to develop OBIEE report, implemented star schemas.
  • Worked on Informatica Power Center 8.6 tools - Source Analyzer, Mapping Designer, Power Exchange and Transformations.
  • Extracted source data using power exchange from Siebel System.
  • Created complex mappings using Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner.
  • Created Transformations like Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, and Source Qualifier Transformations in the Informatica Designer.
  • Used SQL tools like SQL Plus to run SQL queries and validate the data pulled in OBIEE reports.
  • Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
  • Developed Informatica mappings, sessions and workflows for all mappings.
  • Implemented Type II slowly changing dimension to keep a full history of dimensional data in the tables.
  • Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
  • Extensively used debugger to trace errors in the mapping.
  • Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
  • Worked on creating and customizing Confidential (Data warehouse Administration Console) Tasks, Subject Areas and Execution plans to load data from Siebel CRM application to Siebel Relationship Management Warehouse (SRMW) using Informatica Power Center 8.6 pre-built vanilla mapping.
  • Created Confidential Execution plan to schedule the Informatica mappings to load the data incrementally on a daily basis.
  • Created BI Publishers in OBIEE Repositories. Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.

Environment: Informatica Power Center 8.6, Confidential 10.1.3.4, Siebel 8.1.1, OBIEE 10.1.3.4, Oracle 10g, SQL*Plus, TOAD, BI APPS 7.9.6

Confidential

Informatica ETL Developer

Responsibilities:

  • Team member of the Data Warehousing module. Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica.
  • Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.
  • Extracting and loading of data from flat file, Oracle sources to oracle database (target warehouse) using transformations in the mappings.
  • Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
  • Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
  • Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema
  • Created Pre and Post Session Scripts for checking file existence.
  • Worked on performance tuning of mappings, sessions, Target and Source.
  • Performed developer testing, functional testing, and unit testing for the Informatica mappings.
  • Provided extensive support in UAT (user acceptance testing) and deployment of mappings.
  • Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica Power Center 8.6, Oracle 10g (SQL Developer), Trackers, cube

Confidential

SQL, VBA developer

Responsibilities:

  • Extensively involved in Requirement Analysis, High level Design & Low level design
  • Involved in SQL database, Tables Design
  • Developed VBA and SQL programs to
  • Determine eligibility for several different types of the pension benefits.
  • Determine pension earnings based on numerous definitions, and calculate multiple sets of benefits, based on provisions of pension plan document.
  • Determine Social Security Benefits.
  • Produce summary displaying all calculations and prints detailed reports of calculations. Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results.
  • Responsible for Unit Testing, Functional Testing, and Regression Testing, Client Acceptance testing, Client Test Support Activities, Knowledge sharing.
  • Used SQL tools like TOAD to run SQL queries and validate the data pulled in Summary reports.

Environment: Visual Basic, SQL, MS excel, TOAD, Oracle

We'd love your feedback!