SUMMARY:

• Over a span of 6 years of experience in providing ETL and Business Intelligence (Informatica PowerCenter/ PowerMart/ PowerExchange), OBIEE 11g, BI Publisher, Database Design, Data Modeling, Data Warehouse Testing PL/SQL, SQL Tuning.
• Extensive experience on Informatica PowerCenter 9.x/8.x with strong business understanding in power utility and different service sectors.
• Extensive Knowledge in architecture design of Extract, Transform, Load environment using Informatica PowerCenter.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica PowerCenter and PowerMart.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Experience in using the Informatica command line utility to schedule and control sessions and batches.
• Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Worked on integrating data from heterogeneous sources like Oracle, flat files, DB2, COBOL and XML files.
• Experience with pre - session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
• Strong experience in Understanding Logical and Physical Data Modeling, Dimensional Data Modeling - Star Schema/Snow Flake modeling, Fact and Dimension Tables.
• Strong knowledge in Informatica production support.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Knowledge of full life cycle development for building a Data Warehouse.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.6.1/9.5.1/8.6.1 , Informatica Power Connect, Informatica Designer, Workflow Manager, Work flow Monitor, Datamart, OLAP, OLTP, Mapplet, Transformations, Autosys, Control M, SQL*Plus, SQL*Loader, Netezza 6.0.

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

BI Tools: OBIEE 11g, BI Publisher 11g, Tableau10, MS Power BI.

Databases: Netezza 7.2.1, Oracle Exadata 11g, Oracle 11g, IBM DB2 UDB 8.0, MS SQL Server 2016/2014, Teradata V2R6, MS Access.

Programming GUI: SQL, PL/SQL, SQL Plus, UNIX Shell Scripting, Linux, PERL Programming

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

WORK EXPERIENCE:

Confidential

Informatica Developer

• Created PRE ETL scripts to validate the files and file format which we receive from the Source system.
• Administered Informatica by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.
• Extracted data from flat files applied business logic to load them in the staging database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.6.1.
• Executed Oracle packages and functions to implement business rules and transformations after staging is done.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented populate slowly changing dimension to maintain current information and history information in warehouse tables.
• Created a POC using Informatica on AWS Technologies like AWS S3 and AWS Redshift.
• Worked on different data sources such as Oracle, Teradata, Flat files etc.
• Created complex mappings in Power Center Designer using Normalizer, Aggregator, Router, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner.
• Automated database monitoring and reporting functions utilizing UNIX SHELL scripts, and PERL scripts.
• Good working experience in writing UNIX shell scripts to process Data Warehouse jobs.
• Performed periodic checking of databases for maintaining data consistency and integrity and rebuilt indexes.
• Involved in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling.
• Working knowledge on DataWareHouse Admin Console (DAC) to schedule jobs for Fact and Dimension tables.
• Wrote Oracle packages and functions to validate the Pre and Post Exceptions in the process of sending Exception files and Response files to Source System.
• Extensively used Java and CLOB files to Extract the files in the process of sending files to Source System.
• Created various Oracle database objects like Indexes, stored procedures, Materialized views, synonyms and functions for Data Import/Export.
• Created Load Status Report, Load Status Report - Detail, Load Distribution Report, Load Performance Report to find the status of jobs across all verticals using OBIEE.
• Experience in working with big data Hadoop stack tools like HDFS, HIVE, Hue, Pig, Sqoop.
• Implemented DataLevel Security and Purging in OBIEE using appropriate Hierarchy joins.
• Responsible for validated System Integration Testing for the code developed.
• Used HP Quality Center 9.2, prepared test case documents, test plans and validated the test cases in HP Quality Center 9.2
• Prepared Technical design documents, High Level Design documents and Low Level Design Documents.

Environment: Informatica Power Center/ Power Mart 9.6.1, OBIEE 11.1.1.7, Oracle Exadata 11g, Teradata, Oracle BI DAC, AWS S3, AWS Redshift, Toad, HP Quality Center 9.2, HDFS, HIVE, Hue, Pig, Sqoop. WinSCP, Filezella, Windows 10, UNIX, LINUX, Microsoft Visio.

Confidential

Informatica Developer

• Extracted data from flat files applied business logic to load them in the staging database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.5..1.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Created complex mappings in Power Center Designer using Normalizer, Aggregator, Rank, Router, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner and DB2 Stored procedure transformations to create Sequences.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 9.5.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Involved in Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Scheduling the workflows using Informatica command-line utilities.
• Implemented populate slowly changing dimension to maintain current information and history information in warehouse tables.
• Worked on different data sources such as Oracle, DB2, Flat files etc.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Wrote DB2 stored procedures for implementing business rules and transformations.
• Configured Users/Groups from Informatica domain configuration.
• Implemented Informatica recommendations, methodologies and best practices.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Prepared test cases and involved in unit testing of mappings, system testing and user acceptance testing.
• Prepared functional and technical documentation of the ETL's created for future references.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center/ Power Mart 9.5.1, UDB DB2 8.1, Oracle 11g, SQL, PL/SQL, XML, Cognos Series 8.3, MS Access, Windows 2007, UNIX

Confidential

VA ETL Developer

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.1.
• Knowledge in upgrading from Informatica version 8.6.0 to 8.6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.0 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations and trouble-shooting using UNIX, PL/SQL and shell scripting.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center/ Power Mart 8.6.1, Oracle 11g, UDB DB2 8.1, Windows, UNIX, PL/SQL, XML, JIRA

Confidential

Jr.ETL Developer

• Extensively used Informatica PowerCenter 8.6.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Developed Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Implemented Slowly Changing Dimension methodology.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Maintained Versions of Mappings, Mapplets, Sessions, Workflows etc using StarTeam/Accurev.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Involved in Unit testing and documentation.
• Provided production support for Business Users and documented problems and solutions for running the work flow.

Environment: Informatica 8.6.1, Teradata V2R6, Oracle 11g, SSIS, Cognos Series 8.3, Perl Wrapper Script, Unix HP-UX.