SUMMARY

• Over 9 years of IT experience in Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment
• Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter 10.2.0/9.6.1/9.5.1/9.1/8.6/ , PowerExchange 9.6.1, Data Integration Hub 9.6.2,Cloud Integration Hub.
• Experience in using Webservices and security configuration in Informatica server (end - to-end), Power exchange, Power Connect, SAP BW
• Experience in OLTP Modeling (2NF,3NF) and OLAP Dimensional modeling (Star and Snow Flake) using ERwin Standard Edition/r7.3/4/3.5 (conceptual, logical and physical data models)
• Experience in integration of various data sources definitions like SQL Server, Oracle, MySQL AB, COBOL Files, Flat Files, VSAM,XML and XSDs
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads
• Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un-connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router transformations
• Expertise in Installing and Managing Informatica Power center, Metadata Manager, Data Explorer and Data Quality
• Experience with relational databases such as Oracle 12c/11g/10g/9i, Netezza, SQL SERVER 2012/2008/2005 , Teradata 13/12/V2R5/V2R6 and AS400.
• Knowledge on Big Data technologies like Hadoop/Map Reduce, Pig, HBASE, Hive, Sqoop, Hbase, Dynamodb, Elastic Search and Spark SQL.
• Experience with Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, TPUMP, MULTILOAD, Teradata Administrator, SQL Assistant, PMON, Visual Explain)
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementation the reconcile process accordingly.
• Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Experience with Database SQL tuning and query optimization tools like Explain Plan
• Experience in SQL*Loader, UTL File Concepts, Import and SQL*Plus, DBMS Packages
• Experience in moving the Program Files (FTP) to the server by using the Tools like WINSCP, Putty and Telnet
• Experience in evaluating data profiling, cleansing, integration and extraction tools(Informatica, Kalido, and Composite Software)
• Strong experience in implementing CDC using Informatica Power Exchange 8.6
• Experience with Unix Shell Scripting (KSH - Korn Shell Scripting)
• Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and pmcmd commands
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Experience in identifying and resolve ETL production root cause issues. Experience in maintenance, enhancements, performance tuning of ETL code
• Knowledge of Informatica administration in windows and Linux environment
• Experienced In working with various Scheduling tools like Autosys, Skybot,Control-M, Informatica Scheduler
• Developed test case’s for business and user requirements to perform System/ Integration / Performance testing
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Strong analytical and problem solving skills
• Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually.

TECHNICAL SKILLS

Operating Systems: Windows 8,Windows(NT,2000/03/XP/Vista/7), Mac (10.4/10.5/10.6 ), Linux(Red Hat), UNIX (Solaris, AIXv5.2,SunOS 5.10,)

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripts, Perl Scripting,Java, XML

ETL Tools: Informatica PowerCenter 10.2.0/ 9.6.1/9.5.1/9.1/8. x/, Informatica Developer (Data Quality,Analyst) Informatica Administration,PowerExchange,SSIS, Data Integration Hub 9.6.2

Data Modeling: ERWin StandardEdition/r7.3/4/3.5, MS-Visio 2010/2007

Databases: Oracle 12c(Exadata)/11g/10g/9i/, MS SQL Server 2012/2008 R2/2008/2005, Netezza,IBM DB2, Teradata 13/12/V2R5/V2R6,AS400

Scheduling Tools: Autosys, Control-M,Skybot, Informatica Scheduler, Active Batch.

Reporting Tool: Tableau,Microstrategy

Others: Web Services, MS Office, MS Visio, TOAD, FTP, SFTP, SCP,GIS, MKS, ALM,TortoiseSVN 1.7.9,GitHub,SQL Developer,PAC2000 v7.6.JIRA,Confluence, Artifactory,Jenkins

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL Developer/Lead

Responsibilities:

• Experience in working on the various domains of health care industry.
• Experience in requirements gathering, analysis, requirements documentation and ETL flow designs.
• Collaborated with vendors and partners to structure and integrate outside data sources.
• Design and lead the development of ER models and Database Schema such as Star and Snowflake Schema.
• Design and lead the implementation of application database architecture using various RDBMS platform (Oracle,MS SQL, Netezza).
• Experience in installing and configuring Informatica Powercenter client 9.6.1/9.5.1 in windows environment
• Created mappings, mapplets, sessions, workflows, worklets in Informatica Powercenter 10.2/ 9.6.1/9.5.1.
• Created generic worklets for session logging of each workflow process.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Created UNIX Shell Scripts and scheduled through Conrol-M for triggering the workflows as part of the batch data load.
• Experience in usage of Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Worked with appropriate Business Analysts to create Software Requirement Specifications(SRS), Functional Requiremen Document(FSD) and Mapping document.(Source to Target document)
• Provided weekly production support in a rotation shift basis and addressed the Incident tickets during the oncall support.
• Proposed solutions for various ETL design requirements and formulated them into ETL technical documents.

Environment: Informatica Power Center 10.2/9.6.1, Power Exchange 9.1, Netezza, Aginit Workbench, SQLDeveloperOracle 12C/11g,MicroSoft SQL Server 2010, Putty, WinScp, SQL, PL/SQL, Shell Scripts, Microsoft Visio 2010, Active Batch(Scheduler),Windows, UNIX, Confluence, BitBucket, SourceTree, JIRA, Jabber, ServiceNow, Sharepoint.

Confidential

Sr ETL Informatica Developer

Responsibilities:

• Experience in working on the various domains of Automobile industry.such as sales, services and parts.
• Lead the offshore team and coordinated with business clarifications and code reviews .
• Designed high level ETL process and data flow from source system to target databases.
• Strong understanding of MDM/ODS architecture and best practices using Informatica Power Center 10.2/9.6.1.
• Created mappings, mapplets, sessions, workflows, worklets in Informatica Powercenter 10.2/9.6.1.
• Created generic worklets for session logging of each workflow process.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Created UNIX Shell Scripts and scheduled through Active Batch for triggering the workflows as part of the batch data load.
• Experience in usage of Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Worked with appropriate BSAs to create Business requirement documents(BRD), Functional Requiremen Document(FSD) and Mapping document.(Source to Target document).
• Experiene with Web Service Module or the REST Web Service Module to send response to the web service client (KIA portal) using Infomatica 9.6.1.
• Worked on the migration/testing/configureation of Informatica PowerCenter 9.6.1 to 10.2.0
• Worket on registering the SAP mappings and configuring the SAP connectivity to pull the data using Informatica.

Environment: Informatica Power Center 10.2/9.6.1, Power Exchange 9.1, Oracle 12C/11g,MicroSoft SQL Server 2010, Putty, WinScp, SQL, PL/SQL, TOAD, Shell Scripts, Microsoft Visio 2010, Control-M(Scheduler),Windows, UNIX

Confidential, Chandler, AZ

Sr. ETL/ Informatica Consultant

Responsibilities:

• Experience in identifying the source data elements from the leveraged commerical banking and relating the profitability metrics.
• Created database materialized views to consume data from different source using DB Links.
• Experience in installing and configuring Informatica Powercenter client 9.6.1/9.5.1 in windows environment
• Created mappings, mapplets, sessions, workflows, worklets in Informatica Powercenter 9.6.1/9.5.1.
• Created generic worklets for session logging of each workflow process.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Created control files and used SQL*Loader to load the delimited flat files into the relational oracle database.
• Created UNIX Shell Scripts and scheduled through Autosys for triggering the workflows as part of the batch data load.
• Experience in usage of Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created new and modified existing perl scripts to refresh the materialized views from the source systems driven by meta-data approach.
• Provided analysis report for the better optimization data loads using Cloud Data Integration (CDI) tool.
• Worked on the Proof of Concept for IICS(Informatica Intelligent Cloud Services) to redefine the business processes.
• Configured NDM directories and created scripts for consuming and producing large files across the nodes.
• Provided weekly production support in a rotation shift basis and addressed the problem tickets during the oncall support.
• Developed Functional requirement Document and batch data load architecture using Microsoft visio and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis
• Led and worked with the Devops and ETL team by providing appropriate guidelines, assigning tasks, reviewing the code, providing review comments. Suggesting solutions by creating Function Specification document, ETL mapping documents.
• Worked on the Oracle Exadata Migration from Oracle 11g to 12c.
• Configured Wallet authentication and modified all the scripts to accept the wallet changes.

Environment: Informatica Power Center 9.6.1 /9.5.1 , Power Exchange 9.1, Oracle 11g,MicroSoft SQL Server 2010, Putty, WinScp, SQL, PL/SQL, TOAD,SQL Loader, Shell Scripts, Microsoft Visio 2010, TortoiseSVN,Autosys CA Workload Control Center(Scheduler), Windows, UNIX, PAC2000,GitHub, JIRA,Confulence, Artifactory,Jenkins

Confidential, Merriam, KS

Informatica/Integration Developer

Responsibilities:

• Experience in creating publications,subscriptions,topics using Informatica Data Integration Hub 9.6.2.
• Created custom publications and subscriptions to create XML target files to feed Mercury Gate(Transportation Management system)
• Optimzed the OMS(Order Management System) by using the AS400 source to new Mercury Gate Solution.
• Analyze business requirements and coordinate with the business analyst’s to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Parse high-level design specs to simple ETL coding and mapping standards.
• Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems.
• Discuss strategies for handling various concepts like Error Handling and Slowly changing dimension
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor, using debugger in Mapping Designer to debug complex mappings.
• Performance tuning the workflows by identifying and eliminating the bottlenecks in targets, sources, mappings, sessions and workflows.
• Knowledge and understanding on Informatica Data Services(IDS).
• Experience in installing and configuring Informatica Powercenter client 9.6.1/9.5.1 in windows environment
• Created mappings, mapplets, sessions, workflows, worklets in Informatica Powercenter 9.6.1/9.5.1.
• Created generic worklets for session logging of each workflow process.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Created Windows batch Scripts for SFTP process and XML file handling.
• Experience in usage of Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Developed migration plan documents and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis

Environment: Informatica Data Integration Hub 9.6.2,Informatica Power Center 9.6.1 /9.5.1 , Power Exchange 9.1, MicroSoft SQL Server 2012,WinScp, SQL, PL/SQL, Windows Batch Scripts, Skybot(Scheduler), Windows 8