SUMMARY:

• 8 years of IT experience and extensive experience working with the clients Confidential, Confidential, AT& Confidential, Wal Mart Confidential, Well Care Health Plans and in the business domains BFSI ( Banking, Financial Services and Insurance), Mortgage, Retail and Healthcare.
• Expertise in handling various aspects of Business Intelligence viz. Data Warehouse Design, Development, Administration and Architecture, ETL Administration, Development and Production Support, Informatica PowerCenter / Data Quality / B2B / Master Data Management, Talend Data Integration / Data Quality / MDM, Abinitio, Oracle PL/SQL, Teradata PL/ SQL, Netezza PL /SQL and UNIX Shell Scripting.
• Good understanding end to end architecture on server and how ETL / Big data tools (Informatica / Talend / Abinitio / Apache Big data products) interact with it.
• Extensive experience in writing UNIX automation scripts using Informatica Command Line Interface (CLI) commands viz. pmcmd, pmrep, infacmd.sh, infasetup.sh and server monitoring commands viz. iostat, vmstat, mpstat, top.
• Extensive Experience working with Solaris, Suse Linux and AIX servers and Clustered File systems viz. VxCFS and GPFS and good understanding of their architecture.
• Good understanding of Data storage and Networking.
• Extensive experience in capacity planning and bench marking of server memory, C.P.U, Storage and Network.
• Expertise in handling multiple projects simultaneously and design / development of client - server and multi-tier applications and Decision Support systems and solutions.
• Expertise in working on administration of 11 different application servers at the same time.
• Expertise in working on server migration projects and doing end to end set up of Informatica / Talend application servers.
• Troubleshooting and Performance tuning of Informatica Server and ETL applications
• Experience in version upgrade projects of Informatica viz. version 8.6.1 to 9.1.0, version 9.1.0 to 9.5.1 HF2 and version 9.5.1 HF2 to 9.6.1 HF2 and setting up of Informatica MDM Multi-domain & Informatica Data Director (IDD)
• Expert in all phases of Software development life cycle - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Expertise in data warehousing, ETL architecture, Data Profiling.
• Experience in working with various versions of Informatica Powercenter 10.x, 9.x, 8.x, 7.x-Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, Confidential -SQL, DTS.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts and Perl scripts.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy.
• Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc.

TECHNICAL SKILLS:

Business Area: BFSI Domain(Banking, Financial Services and Insurance), Mortgage, Retail, Pharmacy Domain

Project Development Methodologies: Agile, Agile Scrum, Kanban, Waterfall

ETL / MDM Tools: Informatica on Grid, Informatica Power Center 10.1.0/ 9.6.1 / 9.5.1 / 9.1.0/8.6.1/7.1.3,, Informatica BDM 10.1 / 9.6.1,Informatica developer(Data Quality), Informatica B2B, Informatica Master Data Management (MDM) Multi-Domain, Informatica Metadata Manager, Informatica Test data Management (TDM), Informatica PMPC, Informatica Data Replication (IDR), Informatica Data Validation Option (DVO), Informatica Data Director(IDD), Teradata Decision Expert 12.1.2, TERADATA BTEQ, FLOAD, MLOAD,NZSQL, Talend, Abinitio

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte.NC

Informatica Developer

Responsibilities:

• Install and Configured Informatica 9.5.1,9.6.1 and 10.1.
• Upgraded Informatica 9.5.1 to 9.6.1,9.6.1 to 10.1.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Oracle 10g/11g, Teradata, DB2, Flat files, CSV files and Microsoft SQL Server.
• Extensively worked on Informatica Power Center Components - Power Center Designer, Workflow Manager to create workflows and sessions, Workflow Monitor and Repository Manager.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Worked on Teradata utilities like fastload, MultiLoad and FastExport.
• Experience in using Automation Scheduling tools like Autosys.
• Good expertise in Performance Tuning at Database and Informatica side like Source, Target, Mapping, Transformation and Session to make them more efficient in terms of session performance.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Experience in IDQ and Informatica Data Analyst tool for running profiles and score cards.
• Hands on experience in creating the End to End lineage for key business elements using the Informatica Metadata Manager.
• Well versed in creating the metadata reports using Informatica Data Analyzer.
• Experience in developing Business Glossary using Informatica Data Analyst Tool.
• Experience in developing and monitoring ETL Packages and DTS packages using SQL server Integration Services (SSIS).
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience in developing Deski and Web Intelligence Reports using Business Objects reporting tool
• Good experience in working with Onsite-Offshore model and having good leadership qualities
• Experience in all the phases of the Data Warehouse project life cycle involving design, development and Implementation of Data warehouses using ETL, Online Analytical Processing & reporting tools(BO)
• Good Understanding of Logical and Physical Data Modeling, Dimensional Data Modeling, Star Schema/Snow Flake Schema
• Good Understanding of Unix commands. Developed Shell scripts to transfer files from one server to other server.
• Preparation of HLD, LLD, Test Case etc. maintain the coding standard according to the Naming convention.
• Extensively involved in using Quality Center, Clear Quest to report bugs.
• Good knowledge on Python.
• Shown commitment and enthusiasm to achieve the dead lines by effective time management.

Project Title: Compliance Surveillance Data Repository (CSDR)

Confidential,New Tazewell,TN

Informatica Developer

Responsibilities:

• Created complex mappings using various Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, Transaction control, Sorter etc. as per the business requirements
• Extracted data from heterogeneous sources like Flat files, CSV Files and Oracle database and applied business logic to load them in to the Data warehouse
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager.
• Designed workflows with many sessions, tasks (Decision, Assignment task, Event wait) and used Informatica scheduler to schedule jobs.
• Created workflows and worklets for designed mappings.
• Involved in data cleansing and Performance Tuning of ETL Mappings and sessions (using Partitioning, Pushdown Optimization etc).
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Generated Email Notifications and status reports using Email Tasks in Workflow manager.
• 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.
• Performed Data integration techniques for data warehouse using Informatica power center.
• Working on creating SSIS packages using BIML script.
• Created the SSIS packages to load the Staging environment.
• Implemented Incremental load used Event Handlers to clean the data from different data sources.
• Created SSIS packages to extract/write data to Flat Files.
• Written command line scripts and embedded them into SSIS package to merge/zip files.

Confidential,Morristown, NJ

ETL Consultant

Responsibilities:

• Coordinate PowerCenter technical review/approval before on-boarding new projects to shared platform
• Prepared design documents, Technical Object documents, Business Scenario documents.
• Created Informatica mappings for initial load, daily updates and monthly loads.
• Involved in Code review, Functional and Integration testing for all the mappings and workflows.
• Developed standard document and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Extracted source data from different sources like SAP, Oracle, flat files from Legacy systems and load the same into business data warehouse after applying business rules.
• Performed objects deployment on versioned repositories from QA to Production
• Experienced with Installation, Configuration, and Administration of Informatica and patch installation in Unix environment.
• Involved in Migration process from development, Test and Production Environments

Confidential,Bentonville, Ark.

ETL Developer / Data Analyst.

Responsibilities:

• Used Informatica Designer to Create Mappings, Mapplets, Transformations, and Target tables. Extensively used Server Manager for creating and scheduling various sessions.
• Extensively worked on all phases of Software Test Life Cycle - requirement analysis, Estimation, Estimation approval from client, Design, Walkthroughs and approval of test artifacts from client team.
• Created data model after analysis of entities and relations among them, using Erwin.
• Highly analytical and process-oriented data analyst with in-depth knowledge of database types; research
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed using debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Selected as team lead to manage four analysts for major project to validate a brand new datawarehouse
• Provided technical support to programmers and data analyst teams
• Created Functions, Packages, Stored procedures, triggers using PL/SQL.
• Migrated code from QA to Prod Environment and provided Production Support.
• Helped QA team in creation of test cases for regression testing.
• Created universe in Business Objects for annual reports.
• Modified mappings and stored procedures in Powercenter for maintenance and enhancement activity.
• Interacted with Data Architect and Business Analysts to meet the deadlines.
• Develop reports and data to assist in evaluation in business performance and operation
• Performed Data analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata.

Confidential,Tampa, FL

Informatica Developer

Responsibilities:

• Initial analysis of Raw Data received from business Users. Data use to differs from County to county and State to state.
• Worked on SQL Loader to load the data from flat files obtained from various vendors.
• Wrote SQL and PL/SQL programs to retrieve required information from the database.
• Created Indexes on the table for faster retrieval of the data to improve database performance.
• Created database objects like tables, views, materialized views, procedures and packages using oracle tools like TOAD, SQL Developer and SQL*Plus.
• Handled errors using exception handing extensively for the ease of debugging and displaying the error message in the application.
• Involved in ETL in order to meet the requirements for extraction, transformation, cleansing, and loading from source to target.
• Involved in ETL process from development to testing and production environments.
• Extracted data from various sources and loaded it into target database using Informatica Power Center 7.1.
• Tuned mapping and SQL queries for better performance and efficiency.
• Performed unit testing and validated the Data.
• Provided Weekly status report to manager on the process and timeliness.
• Performed performance tuning of the process at the mapping level, session level, source level and the target level.