PROFESSIONAL SUMMARY:

• 11 years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling and Data Quality, Data Profiling, Development, testing, documentation, Implementation of Warehousing and Database Business systems for Finance, Insurance & Logistics sectors.
• Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 10.x/9.x/8.x, Metadata Manager,SSIS.
• Extensive knowledge of various kinds of Transformations ( Source Qualifier, Expression, SQL, Transaction Control, Aggregate, Lookup, Rank, Joiner, Filter, Router, Sorter, Sequence, Normalizer, Union, Update Strategy, Stored Procedure,HTTP,WebServices Consumer, Application Source Qualifier, XML, MQ, Salesforce lookup).
• Experience on Informatica tools like transformations, reusable transformations, mappings, mapplets, workflows and worklets. 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, DB2, Salesforce, SQL server, Informix, Sybase, VSAM, Sequential Files, XML files) to targets.
• Strong experience in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling.
• Experience in Creating Tables, Views, Triggers, and Stored Procedures, PL/SQL statements, clustered, non-clustered indexes and indexed views for various applications.
• Excellent knowledge of OLTP System Study, Analysis and E-R modeling
• Experience in scripting & maintaining windows servers.
• Experience with Control-M/Autosys schedulers for scheduling nightly jobs. Proficient in performing Production support activities.
• Experience in developing Unix Shell Scripts for automation of ETL process, SFTP connectivity, and file manipulation.
• Extensive experience in performance tuning, identified and fixed bottlenecks, and tuned the complex ETL mappings for better performance.
• Skilled in developing unit test plans, unit test cases, UAT (user acceptance testing) and documented them properly.
• Strong knowledge of Software Development Life Cycle (SDLC) and AGILE Methodologies. Including requirement analysis, design, development, testing, and implementation. Provided End User Training and Support.
• Reporting experience with Essbase, I dashboards, Cognos, Business Objects.
• Exposure to Informatica Developer/cloud tools for ETL operations like Data Extraction, Data Transformation and Data Loading
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process with excellent analytical/communication skills and good team spirit.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2.0, 9.6.5, 9.1.1, 9.0.1, 8.6.1, 8.1.1(Repository Manager, Mapping Designer, Workflow Designer and Workflow Monitor),SSIS,Informatica Metadata Manager, Informatica Developer/CloudDatabase & Related Tools: Oracle 12C,10g/9i/8i, MS SQL Server 2005/2008, Sybase, Informix, DB2, SQL*Plus, Toad for oracle, Sql Navigator,Salesforce.

Scheduling Tools: Control-M.

BI & Reporting Tools: Cognos 8.0, Idashboards, Essbase, Business Objects.

Languages: SQL, PL/SQL, T-SQL, C, Unix Shell Scripting, Perl 5.10, JCL.

Operating Systems: Window XP/10, Unix, Solaris 5, Unix-AIX 5.5, Z/OS.

Web: HTML,CSS

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, TX

ETL Lead Developer

Responsibilities:

• Involved in SSP (Servicing Systems Projects) business analysis and technical design sessions with business, technical staff and fisglobal (Source Systems) to Develop Entity Relationship/data models, requirements document, and ETL specifications and using FIS (AF & DM) applications.
• Proficient in Development of ETL code in Data Vault Methodology, using SDV, RDV, BDV, PIXL, EXCHANGE LAYER, CORE Layers of data as per requirements
• Expertize in Developed ETL architecture in accordance with business requirements.
• Development of Hubs, Links, Satellite tables using Data Vault Methodology
• Lead the Design/Development initiative on Projects like Inspections/Pricing/EOT/Invoices/Credit Bureau Reporting (Bankruptcy CH 13 & 7) /SCRA/Dealer Portal/ BL, WEL Letters (SSP i094) Projects.
• Worked on Informatica tools like Source Analyzer, Mapping Designer, Maplet Designer and Transformation Developer. Developed various Mappings, Mapplets and Transformations for Migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Involved in Performance improvement techniques of ETL Batch & Transformation of ETL code from Phase 1 to Phase2 to improve the efficiency of ETL jobs
• Experience in Preparing/handling tasks and providing directions to Offshore team as a project coordinator
• Developed mappings between multiple sources such as flat files, XSD’s, XML’s, Fixed width files, salesforce, oracle and MQ Series.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical Business functionality to load data.
• Created Database view in PIXL Layer by using RDV & BDV layers using business logic
• Designed/Developed Informatica mappings for Type 2 Slowly Changing Dimensions.
• Involved in writing the complex DML’s, DDL’s, SQL Queries for creating reports
• Created UNIX shell script to transport flat files from different ordering systems to the ETL server.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Proactively involved in Production support schedule and fixed the Incidents, Tickets, Issues and Change tasks
• Experience in Salesforce Integration by connecting 3rd party systems using webservices/HTTP
• Worked on Pushdown Optimization, Key-Range, Round-Robin, and Pass-through and Hash Auto-Keys partitions at Power Center session level.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL Procedures.
• Wrote test plans and implemented Unit testing. Created Control-M scripts for Scheduling the ETL jobs and Informatica Scheduler
• Created Control-M scripts for Scheduling the ETL jobs and Informatica Scheduler

Environment: Informatica - Power Center 10.2.0/9.6.5, Oracle 12C/11g, Erwin 4.0,Oracle, SQL, PL/SQL, UNIX, TOAD 12.6,Salesforce,DB2

Confidential, Lewisville, TX

Sr. ETL Consultant

Responsibilities:

• As an active team member Data Warehousing module, involved in the initial phases of the design and was taken part in the analysis of the product.
• Interaction with the Business Partners to understand the business of the application, gather requirements, analyzed and put into technical design documents (HLD & LLD).
• 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 SQL, Transaction control, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations, Created and configured mappings, defined workflows, tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery
• Extensively worked with database and Informatica Partitioning for performance tuning.
• Secure ftp the files to vendors & extensively worked on I dashboards.
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Actively involved Informatica forklift upgrade migration from 8.6.1 to 9.0.1
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Prepared test scenarios for against source data and target data
• Implemented Slowly Changing Dimensions (SCD) Type -2 to update the dimensional schema.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands and batch jobs.
• Generating the SQL queries for Cognos reporting and validating the reports.
• Experience with different database systems like Informix, Sybase, DB2, Oracle, SQL Server
• Experience in pulling the files from windows server and installed Reflection software for sftp process
• Wrote shell scripts and control files to load data into staging area and then into database tables.
• Configured sessions in a batch and scheduled them through Control-M job scheduler.
• Working closely with the testers in order to help with overall-testing completion of the committed Iteration capacity (points).
• Involved in converting long running manual ETL process into automated process.
• 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 9.1/9.0/8.6 - (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 10.6.1, SQL Server 2008, WINSQL, TOAD, SQL Developer, AQT, UNIX Shell Scripts.

Confidential, Memphis, TN

Informatica Consultant

Responsibilities:

• Worked on complete SDLC (Software Development Life Cycle) from Extraction, Transformation and Loading of data using Informatica.
• Responsible for Creating business solutions for Incremental and Full loads
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy and Stored Procedure
• Extensively worked with the Informatica server that runs on UNIX platform and used workflow monitor to monitor the Informatica server and reviewed error logs that it generates for each session it runs.
• Involved in designing STAR schema for business processes and studied existing OLTP system(s) to created Dimension and Fact Tables in physical model.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow
• 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.
• Extensively used TOAD to test debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions and for better performance created partitions, SQL Over ride in source qualifier.
• Used session partitions, dynamic cache memory and index caches for improving performance of Informatica server.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports using Business Objects.
• Involved in Integration and User Acceptance Testing and Generated reports for end client.

Environment: Informatica Power Center 8.6(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Power Perl 5.10, Unix, Oracle 10g, VSAM Files, Sequential Files, Control-M.

Confidential

Application/Program Developer

Responsibilities:

• Created Workflows, Tasks, database connections, FTP connections using Workflow Manager. Creating the Mappings using Informatica Designer to create the input feed according to the standard format work file to process for accounting engine.
• Create various mappings and Mapplet, transformations, lookups etc to validate the fields and derive the fields based on the input and converting raw input data into standard accounting data format.
• Extracted data from sources like DB2, Oracle and Fixed width and Delimited Flat files Transformed the data according the business requirement and then Loaded into the Oracle Database
• Wrote several stored procedures for recycling and other extraction purposes.
• Optimized Query Performance, Session Performance and Reliability.
• Extensively used Transformations for heterogeneous data joins, complex aggregations and external procedure calls.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created Mapping Parameters and Variables.
• Developed Mapplet using corresponding Source, Targets and Transformations.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Developed Business Objects Universes with classes, Objects and condition Objects and developed hierarchies to support drill down reports
• Analyzed existing Informatica mappings, which were producing errors and modifying them to produce correct results.
• Highly involved in trouble shooting production issues at Informatica as well as Database levels.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Monitored and improved the performance of Sources, Targets and Mappings Documented the Sources, Targets and Mappings.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.

Environment: Informatica Power Center 8.1(Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor), Oracle 9i, Erwin, Business Objects, Control-M, SQL, PL/SQL, Windows 2000 and UNIX.