We provide IT Staff Augmentation Services!

Sr.etl Developer(informatica) Resume

0/5 (Submit Your Rating)

Pittsburgh, PA

SUMMARY

  • 8+ years of strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 9.x, 8.x,7.x,6.x
  • Experience in all the phases of the Data Warehouse project life cycle involving design, development and Implementation of Data warehouses using ETL, Online Analytical Processing & reporting tools
  • 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 on Informatica designer tools like transformations, reusable transformations, mappings, mapplets, and workflows. Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III).
  • Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources (Oracle, SQL server, Flat files) to targets persistent data stores.
  • Strong knowledge in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling.
  • SQL/Database developer experience in writing efficient SQL queries, PL/SQL Scripts, fine tuning queries and wrote several SQL queries for adhoc reporting.
  • Created Workflows with event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor
  • Experience in maintenance and enhancement of existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
  • Experience in UNIX Shell Scripting in order to fetch the input files and archive them for the Power center usage
  • Worked on Parameter files in order to pass the parameter and connection string in case of oracle table as the source or target
  • Extensive experience in performance tuning, identified and fixed bottlenecks, and tuned the complex Informatica mappings for better performance.
  • Strong knowledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation. Provided End User Training and Support.
  • Experienced in administrative work by creating users, user groups, folders, configure security and giving permissions in folders and to users in Repository manager.
  • Extensively worked for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error handling methods.
  • Ability to quickly grasp available technology, tools and existing designs.
  • 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/7.x, Informatica Data Quality (IDQ)9.x/8.x, Information Data Explorer, Informatica Power Exchange, Informatica Power Connect, Informatica B2B,MDM, SQL Server Integration Service (SSIS)

Languages: C, C++, .Net, Mainframes, XML

RDBMS: Oracle 8i/ 9i/ 10g/ 11g, SQL Server 2005/2008,Teradata 13/v2r6, Netezza 6.0

Tools: & Utilities: SQL Navigator, SQL Assistant, TOAD, SQL* Loader, SQL DeveloperSQL PLUS

BI Tools: Business Objects(SAP BO XI R3.1/R2), Cognos, Crystal Reports

Testing Tools: Quality Center, QTP, IBM Rational ClearQuest

Data Modeling tool: Erwin, MS Visio

Operating Systems: Windows 7,Vista, XP, 2000, NT, UNIX, LINUX

Versioning Tools: Rational ClearCase

Scheduling Tools: CA Autosys, Tidal Enterprise Scheduler 5.3.1, Tivoli’s Maestro

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh,PA

Sr.ETL Developer(Informatica)

Responsibilities:

  • Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse
  • Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files and loading into Staging and Data Ware House Star Schema.
  • Involved in massive data cleansing prior to data staging.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Designed Type1 and Type2 mappings
  • Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
  • Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done. complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
  • Implemented Incremantal load logic.
  • Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
  • Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
  • Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL
  • Created Script to meet business logic.
  • Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
  • Worked with UNIX shell scripts extensively for job execution and automation.
  • Scheduled Informatica workflows to run at regular intervals.
  • Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
  • Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
  • Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
  • Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 9.1 Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor, Oracle 11g, MS SQL Server 2005/2008, SQL,PL/SQL,T-SQL, Windows XP, Unix, Cognos, Tidal.

Confidential, Dallas, Texas

Sr.ETL Developer (Informatica)

Responsibilities:

  • Responsible for Requirement Gathering Analysis and End user Meetings.
  • Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse
  • Used all the Inormatica client components like Designer, Workflow Manger & Monitor, Repository Manger, and Admin Console
  • Worked extensively with various Passive transformations in Informatica Power Center like Expression, Sequence Generator, and Lookup Transformation
  • Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented
  • Extensively worked with SCDs slowly changing dimension Type 2
  • Responsible for performance tuning at various levels like mapping level, session level, and database level
  • Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager
  • Worked on Designer Tools: Source Analyzer, Warehouse, Transformation Developer, Mapplet and Mapping Designer.
  • Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
  • Extensively used Source Qualifier Transformation, and used most of its features like router, sorter, and SQL Override.
  • Extensively performed complex SQL queries on Source tables in Oracle 11g.
  • Used Router transformation whenever multiple filters are there in the mapping design
  • Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
  • Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning
  • Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
  • Creating source and target table definitions using Informatica Designer.
  • Wrote pre-session shell scripts to check session mode (enable/ disable) before running/scheduling batches.
  • Wrote post-session shell scripts to check status (failure/success) after completion of all batches
  • Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
  • Responsible for Unit Testing and Integration Testing of mappings and workflows.
  • Worked with third party CA Autosys scheduling Team for scheduling the Informatica PowerCenter Workflows

Environment: Informatica Power Center 9.0.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 11g, SQL Server, Sybase, Access, Flat Files, SAP Business Objects, AIX UNIX, Windows XP, CA Autosys Scheduler.

Confidential, Richmond, VA

Sr. ETL Developer

Responsibilities:

  • Involved in planning, building, and managing successful large-scale Data Warehouse and decision support systems
  • Responsible for Informatica ETL development & DAC Execution Plan creation. In order to develop OBIEE report, implemented star schemas.
  • Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
  • 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.
  • 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.
  • Used SQL tools like SQL Plus to run SQL queries and validate the data pulled in OBIEE reports.
  • 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 DAC (Datawarehouse Administration Console) Tasks, Subject Areas and Execution plans to load data from Siebel CRM application to Siebel Relationship Management Warehouse (SRMW) using Informatica PowerCenter 8.6 pre-built vanilla mapping.
  • Created DAC 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 Powercenter 8.6, DAC 10.1.3.4, Siebel 8.1.1, OBIEE 10.1.3.4, Oracle 10g, SQL*Plus, TOAD, BI APPS 7.9.6

Confidential, New York, NY

Sr. ETL Developer(Informatica)

Responsibilities:

  • 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, PL/SQL scripts
  • Designed and developed complex mappings in Informatica to load the data from various sources such as SQL server, Flat files, Oracle using different transformations such as, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
  • Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
  • Extensively worked with database and Informatica for performance tuning.
  • Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
  • Created Mapping Parameters and Variables.
  • Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.
  • Developed PL/SQL stored procedures and UNIX commands shell scripts for pre and post session commands and batch jobs.
  • Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
  • Worked with PMCMD command line program to talk with the Informatica server, 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 PowerCenter 8.6, (Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor), Oracle 10g, SQL, PL/SQL, SQL Server, Windows 2000 and UNIX, Cognos

Confidential, Memphis, TN

Sr. 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, PL/SQL scripts
  • Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as Java, SQL, Transaction control, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
  • Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
  • Extensively worked with database and Informatica Partitioning for performance tuning.
  • Extensively designed and developed reusable transformations & aggregations and created target mappings that contain business rules.
  • Extensively used Informatica Power Exchange.
  • Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
  • Implemented Change Data Capture (CDC) to extract information and Partitioned sessions for concurrent loading of data into the target tables.
  • Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
  • Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.
  • Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands and batch jobs.
  • Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
  • Wrote shell scripts and control files to load data into staging area and then into database tables.
  • 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.1.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Power Exchange, UNIX, Oracle 10g.

Confidential

Informatica Developer

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection.
  • Populated the business rules using jobs into the Repository for Metadata management.
  • Creating the Entity relationship diagrams and maintaining the corresponding documentation for corporate data dictionary with all the attributes, table names and constraints.
  • Defining entities, attribute and relationships. Worked on data granularity and cardinality.
  • Worked on Daily atomic, monthly atomic and monthly aggregations of the reporting data mart.
  • Worked Extensively on Informatica modules - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails
  • Development of major reports on weekly, monthly & quarterly basis for multidimensional analysis.
  • Reports were built using impromptu and PowerPlay & the model was built using Cognos Transformer.
  • Involved in creating periodic backup of the repository based on the requirement
  • Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
  • Power Cubes used to create Multidimensional Reports using Cognos PowerPlay.
  • Developed and fine-tuned PowerPlay Reports.
  • Unix Shell Scripts were written for Automation.
  • Performance tuning of Databases

Environment: Informatica Power Center 7.1.4, Oracle, Access, Flat Files, Cognos, AIX UNIXWindows XP, Autosys

Confidential

Oracle Developer

Responsibilities:

  • Responsible for SQL coding using SQL/PLUS
  • Responsible for PL/SQL programming
  • Developed Stored Procedures, functions, triggers, and packages
  • Worked with DBA in installing Oracle 7.3 and Oracle 8i on Solaris UNIX Box.
  • Involved in designing the database schema for the Metadata for storing the informative queries that are generated dynamically
  • Reviewed application requirements and recommended Database configuration.
  • Designed various data entry forms, Query screen and Output Reports
  • Implemented security features.
  • Created primary Database storage structures (Table Spaces) and objects (Tables, Views, and Indexes).
  • Managed the Table Spaces, rollback segments and indexes for applications.
  • Coded the scripts for loading the data into Oracle Database from flat files using SQL Loader

Environment: Oracle 8i, UNIX, Windows

We'd love your feedback!