SUMMARY

• Around 5 years of Total IT Experience in ETL, Informatica, Data Warehousing using Informatica Power center 8.6/8.1.1/8.0/7.1.2/7.1.1/7.0/6.1 , Informatica Designer
• Experience in dealing with various Data sources like Oracle 10g/9i/8i, Oracle PL/SQL, SQL Server 2000 /2005, DB2, MS - Access, MS - Excel and Flat files.
• Experience in Dimensional Data Modeling experience on Data modeling, Dimensional Modeling, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Developed the required data warehouse model using Star schema for the generalized model
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Involved in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages and complex SQL queries for extracting the data to system.
• Transformations: Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update Strategy transformations.
• Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
• Worked exclusively on implementing the types of Slowly changing dimensions (SCDs)- Type I II and III in different mappings as per the requirements.
• Data Cleansing experience using UNIX Shell Scripting and SQL coding.
• Designed and developed ETL workflows to work with various sources and targets like MS SQL Server, DB2, Oracle, My SQL and Flat files.
• Performance tuning: Expertise in session partitioning, session tuning by optimizing Source, target, mappings and transformations.
• Expertise in preparing the ETL Design Documents like High Level and low-level Design documents.
• Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
• Involved in the Unit testing, System integration testing and UAT using Quality Center.
• Have worked on Business Analytical Reporting using BI Tools like Business Objects and Cognos 7.0.
• Interaction with different teams from Clients, BI teams, to end users for further enhancements.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical skills and high compliance to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.x, 9.x, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server

Databases: Teradata, Oracle11g/10g/9i/8i MS SQL Server 2012/2008/2005/ 2000 , MS Access 2010/2003/2000 , IBM DB2, Cassandra, Greenplum

Programming: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl

Scheduling Tools: ESP, Autosys, Batch IR

Operating System: Windows, Linux, HP-UX

Methodologies: Rational Unified Process (RUP), Waterfall, Spiral, Agile

BI Tools: Business Objects 6.5/6.0/5.x, Oracle Reports 9i, Cognos Series 7.0/6.0, Oracle Business Intelligence (OBIEE) 10.1.3

Database tools: Datastax Studio, PgAdmin III

Open API: Swagger

IT Service Management Tool: HP service Manager, ServiceNOW

Deployment Tool: Cross-Vista

Automation Tool: Red Hat Process Automation Manager

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

ETL/Informatica Developer

Responsibilities:

• Involved in complete understanding of business requirement and involved in analyzing the sources to load into multiple data warehouses.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle, PostgreSQL using Informatica Power Centre.
• Integrate with multiple teams to analyze the requirement for the source systems
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Involved in discussions with clients/users to determine the Dimensions, Hierarchies and Levels, Basic Measures, Key Metrics for Relational, Multidimensional Data Model for the system and understanding report requirements.
• Involved in daily deployments, closing tickets, incidents in hp service manager and service NOW
• Develop the Perl and Shell scripts to automate the finance billing file.
• Responsible for Detail design of each interface with technical documents specifying at each stage of the data load.
• Responsible for developing complex Informatica mappings using different types of transformations like Union transformation, Connected and Unconnected Lookup transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Assisted with implementation/upgrade of AutoSys and M-control troubleshoot errors, and documentation/procedures.
• Developed SDE mappings to load large amount of data from different sources to staging area, SID mappings for load the data from staging area to target system.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Follow up with BI teams to analyze and visualize the data loaded into the target systems using tableau and Power BI.
• Data Warehouse Data modeling based on the client requirement using ER win (Conceptual, Logical and Physical Data Modeling).
• Wrote test plans and executed it at UNIT testing and supported for system testing, volume testing and User testing.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Simultaneously worked with MuleSoft integrations, TOAD implementations, Red hat process automation manager for automating business rules and processes for designing the mobile application.

Environment: Informatica Power Center 9.5.x, MS SQL server 2012, Informatica IDQ, Data quality, Toad, PL/SQL (Stored Procedures, Triggers, Packages), Autosys, CSV files, Flat files, Unix Shell scripting, MS Visio, Windows XP, Putty, Cassandra, Greenplum, HP Service Manager, ServiceNow.

Confidential, Pittsburg, PA

ETL Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Involved in Agile environment participating in two-week sprint with regular updates from the team and off-shore.
• Developed the required data warehouse model using Star schema for the generalized model
• Determine and Communicate with business and customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one-time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database. Interacted with the business community and database administrators to identify the business requirements and data realties.
• Created Design Document and Informatica mappings based on business requirement.
• Created dimensions and fact tables for the project.
• Used update strategy and implemented SCD type-3 to effectively migrate data from source to target.
• Moved the mappings from development environment to test environment and then to production environments.
• Worked on lookup, aggregator and joiner caches for performance enhancements.
• Involved in designing of Testing plan (Unit Testing and system testing)
• Played a vital role in moving the project to Production and prepared the documentation at every level.
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Used persistent caches whenever data from workflows were to be retained.
• Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
• Involved in the Release Management team and verify the Production checklist documents necessary for the Production Activities
• Used PMCMD to start and abort sessions and tasks. Also used INFACMD to track the status of the applications and automate the service notification emails.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Troubleshoot issues in production with continuous monitoring of jobs after scheduling through Autosys.

Environment: Informatica Power Center 7.x, PowerBuilder, Oracle 9i/10g, Sybase, Oracle SQL Developer, Cognos, Quest-Toad, Siebel, Shell Scripts, SQL*Loader, Control-M, UNIX (IBM AIX, Solaris), DB2 UDB, and Windows 2000, HP Service Manager, AutoSys.

Confidential, Greater Chicago Area, IL

ETL/Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica Power Center 9.x / 8.6.1, MDM 9.5, IDQ, IDE, Power Exchange, MS SQL Server, Oracle 10g, Teradata, SQL Server 2000, SVN, Control-M, SQL, PL/SQL, SQL* Loader, Erwin, Toad, Star Schema, UNIX Shell Scripts, CSV files, Windows server 2003, and MS-Office tools, HP Service Manager, AutoSys.