PROFESSIONAL EXPERIENCE

• IT Professional with 6 + years of experience on Informatica Power Center. Data Warehousing & Data Integration.
• Highly Proficient in data extraction, transformation and loading data using Informatica PowerCenter 9.5/9.1/8.6.1/8.1.1/7.1.4/7.1.3 (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Developed numerous power center mappings with variety of source \ target like Flat File, Oracle, DB2, XML etc.
• Experience with ETL, Data Mapping, Data warehousing, and Metadata management in OLTP and OLAP environments.
• Experienced in all the steps of Software Development Life Cycle (SDLC) such as gathering project requirements, analyzing system, developing, testing, migration and administration, security management and production support.
• Extensive knowledge of Informatica power center transforms like Aggregate, Router, SQL transform, lookup, XmL etc.
• Developed UNIX shell scripts to FTP, control and schedule Power Center workflows, emailing, archival for B2B.
• Strong Experience in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Experience in identifying and resolving ETL production root cause issues. Expertise in maintenance, enhancements, performance tuning of ETL code.
• Exposed to Micro strategy, reporting.
• Good exposure inInformatica MDMwhere data Cleansing, De - duping and Address correction were performed
• Troubleshooting on Master Data Management (MDM), Metadata management, data quality, data integration and Oracle database environment in various Verticals such as Health Care Insurance, Retail.
• Expert inanalyzing, designing, developing, installing, configuringanddeployingMS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• UsedSSIS Packagesfor extracting, cleaning, transforming and loading data intodata warehouse.
• Strong Experience in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in oracle database.
• Coordinated deployments & production implementations for the project.
• Strong problem solving, analytical and decision-making skills.
• Delivered projects end to end solution using Informatica Power Center, Unix& Maestro,Autosys.
• Excellent team player and self-starter with good communication and interpersonal abilities

TECHNICAL SKILLS /ABILITIES

Data Warehousing: Informatica Power Center 9.0.1/8.* /7.* SSIS,SSRS,VBA

B2B Tools: Informatica B2B DT, Informatica B2B DX

Databases: Oracle 9/10/11g, MySQL, SQL Server 2008/ 2012, DB2, MS Access,VBA, MS Excel.

Programming: UNIX Shell Scripting, SQL queries.

Environment: RH Linux 4.3,5.0, Windows 2000/2003/XP/7,TOAD, Citrix, FTP/ WINSCP,UNIX/putty, Networking .

PROFESSIONAL EXPERIENCE

Confidential

ETL /Data warehouse Analyst

Responsibilities:

• Interacted with the users, Business Analysts for collecting and understanding the business requirements.
• Designed ETL process as per the requirements and documented ETL process using MS VISIO. Demonstrated the ETL process Design with Technical Lead. Prepared the design guidelines for ETL process development using Informatica Power center, PL/SQL, SQL and Shell scripts.
• Extensively worked on Informatica Power Center Designer (Source Analyzer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Responsible for developing complex Informatica mappings using different types of transformations like Connected and unconnected LOOKUP, Router, Filter, Joiner, Aggregator, Expression and Update strategy transformations for large volumes of data.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Involved in production support and responsible for tuning the Informatica mappings to increase the performance.
• Responsible for code migration and scheduling jobs in Production.
• Involved in Data Cleansing, Data Profiling and created profile reports for business users to review.
• Resolved Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM.
• Developed transformation logic and designed various Complex mappings using the Designer.
• Troubleshooting database, workflows, mappings, source and target to find out the bottlenecks and improved performance.
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, and lookup, Sequence Generator, Router, Sorter and Stored Procedures. And used debugger to test the mappings and fixed the bugs.
• Created new database objects like Procedures, Functions, Triggers, and Views.
• Used HP Quality center to resolve and maintain the Test case, Test plan . Documented the Entity level mapping according to the new changes.

Environment: Informatica Power Center 8.6.1, Oracle 9i/11g, SQL Developer,Mainframes(VSAM Files), UNIX, Windows XP, PL/SQL, HP Quality Center, Micro strategy, FTP Autosys .

Confidential

ETL Developer

Responsibilities:

• Work with business to understand Business Requirements and prepare Technical Specification, Design document, implementation checklist, use cases and test approach documents.
• Create Informatica mappings using transformations such as the Source qualifier, Normalizer, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Create Informatica mappings to source data from denormalized OLTP database and continue through multiple cycles of cleansing, transforming, aggregation to be finally loaded to data warehouse.
• Create Informatica jobs to aggregate OLTP data to fulfill exact need of reporting \ OLAP application.
• Create Unix scripts to schedule Informatica jobs in Maestro .
• Day-to-day responsibilities include reviewing system documentation, identifying development objectives,developing/updating change requests, fixes, defects, and executing functional and regression Informatica batch testing scenarios.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
• Working along side Data modeling team in helping them set up a good OLAP system designing.

Environment: Informatica (PowerCenter 9.0.1/ 8.6/ 8.1), AIX, Oracle,DB2

Confidential, Greenville, SC

ETL Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Prepared ETL Design & Development approach document.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Used pmcmd command, for running of the sessions, inside the UNIX shell scripts.
• Created and scheduled workflows using Workflow Manager to load the data into the target Database.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
• Reviewed the code to maintain proper logic implementation/quality standard.
• Worked in Informatica 8.1 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Created unit test case documents and performed unit testing & resolved issues.
• Support the System Testing and Defect fixing.
• Implementation in the Production Rollout.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Oracle8i, Informatica Power Center, PL/SQL, Windows, UNIX, TOAD.

Confidential, Irving, TX

ETL Developer

Responsibilities:

• Actively involved in designing, developing, creating mappings, mapplets using Informatica source, warehouse and loading the data.
• Performance tuning of Informatica mappings and sessions and SQL queries written in Oracle.
• Transferred data from excel files to Oracle database using SQL Loader tool.
• Using parameters to handle the values of database connections, file path, data load history dynamically.
• Scheduled the jobs for night load to re-fresh the source data tables.
• Performing requirement gathering, Data Profiling, and unit testing of ETL jobs.
• Developing complex ETL jobs like SCD type 1 & Type2. The SCD Type 1, & 2 are used extensively to captures the changes in the from source data into data marts and data warehouse.
• Developer Power Center mapping using Web Service consumer transform and MQ target.
• Proposing modifications and enhancements to the interface for reducing production defects which in turn creates new enhancement projects
• Maintaining Informatica, BPEL and MQ servers
• Delivering minor enhancements.
• Preparing Design documents and unit test log.
• Participating in meetings, workshops to understand and document requirements
• Provide UAT support of the newly built interface.
• Provide production warranty support

Environment: Informatica Power Center 7.1, PL/SQL, Oracle 9i, TOAD, UNIX

Confidential, Kolkata, India

ETL Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.
• Worked with various relational sources and flat files to populate the data mart.
• Extract data from various source systems like flat files and Oracle databases and to schedule the workflows.
• Created stored procedures to extract data from flat files.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Used Debugger to test the mappings and fix the bugs.
• Involved in Performance Tuning of ETL jobs by tuning the SQL used in Transformations.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL and Server Integration Services (SSIS).
• UsedSSIS Packagesfor extracting, cleaning, transforming and loading data intodata warehouse.
• Experiencein Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery
• Worked extensively on SQL, PL/SQL and UNIX Shell Scripts.
• Involved in Unit Testing, Integration and User Acceptance Testing of mappings.
• Created high-level Technical Design Documents.
• Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion, Fuzzy Lookup, Fuzzy Grouping, Pivot etc).

Environment:Informatica Power Center 8.6.0 / 7.1.1, Informatica Power Connect / Power Exchange for web services & MQ, Oracle, PL/SQL, UNIX Shell Script, Toad, SSIS, SSRS, Sql Server Windows, MS Access,Excel, VBA.

Confidential

Developer /Oracle DBA

Responsibilities:

• The work involves overall maintenance of Oracle database, performance tuning, backup, recoveries and other database related activities.
• Management of table space growth, monitoring data files additions, extent growth
• Installation, Configuration of all instances, Upgrading.
• Create Database and user profiles, table space, indexes
• Back up Restore (Import/Export, Hot Backup, Cold Backup).
• User creation and granting roles, privileges.
• Expertise In Oracle performance testing using Performance center
• Data handling, executing database change requests as and when required, running export and import.
• Analyzing database schemas, tables and indexes for improving database performance.
• Monitoring database performance through OEM and Oracle Performance Manager tool
• Responsible of Day to day activities in DB performance and Space monitoring in production server as well as development and UAT environments.
• Identifying poor performing user queries and tuning.
• 24x7 Database Administration Support
• Provide support for Development and Testing Database .
• Extract data from various source systems like flat files and Oracle databases and to schedule the workflows.
• Monitoring all VMware Application and its performance
• Using Primavera to do project management of construction projects

Environment: Oracle 8i,9i, Standby Database, VMware 3.x,windows 2003/XP Primavera, Unix Sun Solaris 9,10, RH Linux 4.0, 4,OEM, SQL DBA, T-SQL,, Lode runner,T-SQL