SUMMARY:

• Dedicated and talented professional with 10 years of visible achievements in both customer - driven and technological industries, Facilitated development of Business Intelligence (BI)/Data Warehouse systems, provided BI expertise, designed and developed data models by translating user requirements into data flows and data mapping.
• Extensive experience in the areas of Systems Analysis, Fit-Gap Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & Reports, conducting testing and validations, conducting user training, documentation and Production Support.
• Very strong analytical, technical and business skills in architecting and designing using ETL applications.
• Technical leadership, mentoring and managing senior designers, developers and development teams.
• Good knowledge of Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables.
• Experience in integration of various relational and non-relational data sources like Oracle, SQL Server and Flat Files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Event Wait, Event Raise, Timer etc).
• Expert knowledge in Performance Tuning, identifying and resolving performance bottlenecks in various levels such as source, mapping, target and sessions to provide maximum efficiency and performance.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Good understanding of Relational Database Management Systems (RDBMS) like Oracle 11g/10g and DB2
• Involved in Unit testing, Integration testing to check whether the data loads into target are accurate.
• Proficient in interaction with the business users by attending meetings with the clients in Requirements gathering phase.
• Excellent analytical/ communication skills and good team player.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

TECHNICAL SKILLS:

Environment: s Windows, UNIX, Linux

ETL Tools: Informatica Power Center 9.6/9.1/8.6/7.1.2 Power Exchange CDC 9.1.0 and 9.0.1, Informatica MDM.

Reporting Tools: QlikView

Databases: Oracle 10g/11g, SQL server 2008

Client Tools/Utilities: SQL developer, TOAD 9.x

Automation Tool: Windows PowerShell

Programming Languages: PL/SQL, UNIX Shell Scripting

EXPERIENCE:

Confidential, Milwaukee, WI

ETL Architect

Responsibilities:

• Installed and configured PowerCenter 9.1.0 on UNIX platform.
• Installed and configured Informatica PowerExchange CDC 9.1.0 and 9.0.1 for Oracle on UNIX platform.
• Performed Informatica upgrade from V8.6.1 to 9.0.1 and 9.1.0.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Installed and configured the following IDQ 9.0 components on AIX UNIX Servers.
• DQ Content Basic.
• DQ Content Accelerator
• DQ Content IMO
• Configured OS Profiles and LDAP Authentication.
• Installed and configured Informatica Support Console 1.5 to proactively monitor the environment.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Ensure that all support requests are properly approved, documented, and communicated using the MQC tool. Documenting common issues and resolution procedures.

Environment: - Informatica PowerCenter, 9.1.0, 9.0.1, PWX 9.1.0, Informatica DataQuality 9.1.0, Oracle 11G, and Autosys.

Continental, Chicago, IL

ETL Architect

Responsibilities:

• Installed and configured Power Center 8.6.1 on UNIX platform.
• Upgraded to Informatica Power Center 8.6.1 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Informatica Corporation.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Configured OS Profiles and LDAP Authentication.
• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and vice versa.
• Worked on Push Down Optimization to optimize Oracle loads.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Creation and maintenance of Informatica users and privileges.
• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Worked on Informatica Templates to standardize the CISCO process and maintain consistency across different teams.
• Worked on UNIX shell scripts to handle Job Control Process.
• Testing the Informatica Objects in QA before moving them into Production.
• Designed and documented ETL standards document.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.

Environment: Informatica Powercenter 9.1, Oracle 10g, PL/SQL, TOAD, SQL server 2008 and UNIX shell Scripting.

Confidential, Bloomington, IL

ETL Architect

Responsibilities:

• Installed and configured Power Center 8.6.1 on UNIX platform.
• Installation and configuration of Power Center 8.6.1 hot fixes, patches and version upgrade from Power Center 8.5.1 to Power Center 8.6.1.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Deployment of Informatica Mappings/Sessions/Workflows into Production environment. Testing the Informatica Objects in QA before moving them into Production.
• Designed and documented ETL standards document.
• Worked on shell scripts to sftp (Secured FTP) the file to and from TumbleWeed Server Directory.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Worked on Object Queries, resolving conflicts delete and purge objects.
• Ensure that all support requests are properly approved, documented, and communicated using the Remedy tool. Documenting common issues and resolution procedures

Environment: - Informatica Power Center 8.6.1, Oracle 10g, PL/SQL, SQL Navigator, Teradata and UNIX Shell Scripting.

Confidential, Confidential, IL

ETL Architect

Responsibilities:

• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Creation and maintenance of Informatica users and privileges.
• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extracted data from various sources like IMS Data Flat Files and Oracle.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance, as the volume of the data was heavy.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Created Stored Procedures for data transformation purpose.
• Monitored the sessions using Workflow Monitor.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets.
• Removed bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Created Mappings, Mapplets and Transformations, which remove any duplicate records in source.
• Implemented efficient and effective performance tuning procedures, Performed benchmarking, and these sessions were used to set a baseline to measure improvements against.
• Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.
• 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.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.

Environment: - Informatica Power Center 8.6, QlikView, Oracle 10g/11g, PL/SQL, SQL Navigator, UNIX shell scripting.

Confidential

Informatica Developer

Responsibilities:

• Prepared ETL specification documents to move data from Source to Target as per the High level design document.
• Mappings/sessions/Params/jobs creations/validation/Verifications according to the ETL Design specifications.
• Extensively worked on Command task, Email task and Event wait task,
• Defect fixing if any issue persists in coding after the code deployment to production as part of business readiness testing and analyzing the impact of the solution.
• Understanding High level Design & Mapping design document for DWH and OLTP systems.
• Participate in the meetings with client & onsite team to ensure valid business requirements, discussion on issues, to achieve quality deliverables with in timelines.
• Developed Informatica objects like mappings, using active and passive transformation are, mapping parameters, session parameters, reusable and non-reusable objects, short cuts.
• Maintain the version control for all ETL objects using Subversion.
• Extensively worked on XML sources.
• Experience in creating reusable objects and used Expression, Lookup, XML Source qualifier and Union Transformations.
• Carry out the Unit test for the mappings developed.
• Delivering the quality deliverables within the deadlines according client standards
• Reviews and Peer Code reviews for quality of deliverables.
• Keep tracking the defects and analyzing the defects and fixing those in timely manner.
• Moving code to different environments once the code changes happens as per the BRD (Business Research Document).

Environment: Informatica Power Center 7.1.2, Oracle 10g, PL/SQL, SQL Developer and UNIX Shell Scripting.