We provide IT Staff Augmentation Services!

Sr. Informatica Developer And Obiee Developer Resume

2.00/5 (Submit Your Rating)

Middleton, NJ

SUMMARY:

  • 9 years of experience in Data Architecture, Server Migration, Data Integration, Data Warehousing using ETL tool INFORMATICA Power Center 9.X/8.6/8.1/7.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets/Workflow Manager)
  • Excellent knowledge in data warehouse development life cycle including Software Development Life Cycle (SDLC) on various platforms like WINDOWS /XP/2000, UNIX.
  • Extensive knowledge in dimensional data modeling, star schema, snowflake schema, fact and dimension tables and process mapping using the top - down and bottom-up approach.
  • Extensively worked in the Performance tuning of the SQL and ETL processes.
  • Experience in Designing and developing mappings from various transformation logics like, Source Qualifier, Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Union, Joiner, Transaction Control and Update Strategy.
  • Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
  • Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions
  • Developed slowly changing dimension mappings of Type1, Type2 and Type3 (version, flag and time stamp)
  • Worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files
  • Scheduling the sessions to extract, transform and load data into warehouse database depending on the business requirements.
  • Wrote SQL for implementing business rules for adhoc data.
  • Performed data analysis using complex SQL on various sources systems including Oracle and Teradata.
  • Experience on using Teradata SQL Assistant, Teradata and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to Tpump on UNIX/Windows environments and running the batch process for Terradata.
  • Modified the existing BTEQ script to enhance performance by using Volatile tables, incorporating parallelism, collect stats when needed.
  • Provided assistance during user testing (interaction with the users)
  • Responsible for Unit testing of mappings and workflows.
  • Provided support ILM (Informatica Lifecycle Management) solutions by design, development and implementation.
  • Understand client business needs and provide Informatica ILM technical capabilities.
  • Extensively worked on Code Migration from Development, UAT, and Production.
  • Strong Experience in creating drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008
  • Ability to prioritize and execute tasks in a high pressure environment.
  • Reliable, proactive, adaptable, responsible, hardworking, ethical and good team player.

WORK EXPERIENCE:

Sr. Informatica Developer and OBIEE Developer

Confidential, WI

Responsibilities:

  • Worked on the requirements gathering and analysis for loading data into ODS.
  • Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information for implementing the Data warehouses.
  • Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
  • Parsed high-level design spec to simple ETL coding and mapping standards
  • Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
  • Developed and tested all the backend programs, Informatica mappings and update processes
  • Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Relational Tables (Teradata and Oracle)
  • Extracted data from Flat files and Oracle and loaded them into Teradata. Designed the ETL processes using Informatica to load data from Oracle to target Teradata Database.
  • Created mappings using various Transformations such as Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Look up, Sequence Generator, and Update Strategy.
  • Created and used the Normalizer Transformation to normalize the flat files in the source data.
  • Extensively built mappings with SCD1, SCD2 implementations as per requirement of the project to load Dimension and Fact tables.
  • Used Evaluate expression options to validate and fix the code using Debugger tool while testing Informatica code.
  • Handled initial (i.e. history) and incremental loads in target database using mapping variables.
  • Used Debugger to debug mappings and created breakpoints for better analysis of mappings.
  • Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
  • Created Bonus summary reports using SQL Server reporting tool (SSRS)
  • Worked on ILM to execute enterprise wide data archival end-to-end implementation.
  • Facilitated various solutions in ILM and TDM to manage data in packaged or custom business applications that run on various backend applications such as oracle.
  • Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.
  • Performed Unit testing and created unit test plan of the code developed and involved in System testing and Integration testing as well. Coordinated with the testers and helped in the process of integration testing.
  • Knowledge of OBIEE as a Business Intelligence tool and Data Extraction using Informatica as an ETL tool.
  • Experience in loading the data from OLTP database to OLAP such as OBIEE database.

Environment: Informatica PowerCenter 9x, Sybase, UNIX, Toad, Terradata 12

Senior Informatica Developer

Confidential, Middleton, NJ

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Involved in Designing Logical and Physical Data model using Erwin Tool.
  • Creating the design and technical specifications for the ETL process of the project.
  • Maintained offshore team with 4 resources for development in Informatica.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
  • Developed complex mappings using Informatica Power Center Designer to transform and load data.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
  • Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Implemented complex mappings such as Slowly Changing Dimensions.

Environment: Informatica Power Center 8.6 (Power Center Designer, workflow manager, workflow monitor), UNIX, Oracle, Teradata 12.

Informatica developer

Confidential - Boston, MA

Responsibilities:

  • Extensively used ETL to load data from Oracle database, Flat files to Data Warehouse.
  • Involved in production support for the Data Warehouse Informatica jobs.
  • Modified the existing mappings and workflows as per requirement changes and migrated them back to production environment.
  • Created robust and complex workflow and Worklets using Informatica Workflow Manager and troubleshot data load problems
  • Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
  • Translated business requirements into Informatica mappings/workflows
  • Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Used Informatica Designer to create complex mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts.
  • Developed Mappings to extract data from ODS to Data Mart, and monitored Daily, Weekly and Monthly Loads.
  • Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database
  • Worked with mapping variables, Mapping parameters and variable functions like Set variable, Count variable, Set invariable and Setmaxvariable.

Environment: Informatica Power Center 8.6.1, Sql Server 2005, Oracle 10g, PL/SQL, Business Objects XI R2, Toad, Unix Shell Scripts.

Senior Informatica Developer

Confidential

Responsibilities

  • Involved in Business Analysis and requirement gathering.
  • Used Power Center for data Extraction from various sources such as databases and flat files.
  • Extensively used transformations Expression, Aggragator, Joiner, Filter, lookup.
  • Created mappings using different Transformations like filter, Router, Aggregator, Joiner, Lookup, Expression, Sequence Generator, and normalizer, update strategy etc
  • Develop/Migrate/Customize ETLs for Data Extraction, Transformation and Loading using Informatica Power Center 8.6.1.

Environment: Informatica PowerCenter 9x, Sybase, UNIX

Informatica Developer/ETL Developer

Confidential

Responsibilities

  • Understanding database design schemas for different sources.
  • Understanding end user requirements.
  • Designed the ETL processes using Informatica tool to load data from File system and Oracle into the target.
  • Created aggregate tables, Materialized views to improve query performance.
  • Created Mapplets and reusable transformations.
  • Done the error validation of the data moving from source system to the target.
  • Used Informatica as an ETL Tool to extract data from source systems to Target systems. Have good experience in understanding & creating source and target definitions, Mappings, Transformations and working with workflows.
  • Used the Informatica Workflow Manager create and run the sessions for loading the data using the earlier created mappings.
  • Involved in extracting data from different data sources, flat files, excel sheets and loaded into Oracle 9i and target flat files using Informatica.
  • Test the mappings and check the quality of the deliverables.
  • Used Informatica Workflow Manager & Monitor to create, schedule, Monitor Workflows.
  • Performed the Tasks of Validating, Executing and scheduling the workflows.

Environment: Informatica Power Center 8x, Oracle 9i, Windows XP.

Informatica Developer

Confidential

Responsibilities:

  • Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica Power Center 7x.
  • Was involved in Identifying slowly changing dimensions (SCD) and creating mapping using wizards in Designer.
  • Transformation is done using Informatica tool from MS-Access, Oracle database To Oracle database.
  • Sophisticated transformations rules are implemented using Informatica features like Filter, Aggregation, Joiner, Expression, Lookup, Update Strategy, Stored Procedure and Source Qualifier. Wrote PL/SQL packages, Stored Procedures to invoke several ETL functionalities for aggregation and summation.
  • Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
  • Responsible for documenting the entire process.

Environment: Informatica 8x, ORACLE 9i, Windows XP.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.X/8.X

Programming Languages: Scripting SQL, PL/SQL, ASP.NET, VC++, HTML, XML.

Tools: Toad, Erwin3.x, SQL Server Reporting Services (SSRS), MS Excel Word, Excel, SQL*PLUS, PowerPoint, SSIS (SQL Server Integration Services), Erwin, MS Visio

Databases: ORACLE 11g/10G, MSSQL Server 2005, 2008 and Teradata 12.

Reporting Tools: MS Excel, OBIEE 10g

Operating Systems: Windows/2008/2000/XP, Unix, Linux

We'd love your feedback!