SUMMARY

• 8+ years of extensive hands - on experience in the field of Data Warehousing, ETL Integration, Database development and Business Intelligence with industry exposure in Retail Marketing and Sales, Health Care, Insurance, Credit card Banking, etc.
• Around 6+ Years of extensive experience in ETL process using Informatica PowerCenter 9.1, 8.6, 8.5, 7.1/6.X.
• Experience in developing complex Mapplets, Worklets and re-usable Tasks.
• Good exposure inInformatica MDMwhere data Cleansing, De-duping and Address correction were performed
• Good knowledge on Ab Initio Design, Configuration in Ab Initio ETL and Data Mapping.
• Experience in implementing the complex business rules by creating re-usable transformations, mappings, workflows and PL/SQL stored procedures.
• Experience in using the Informatica command line utility pmcmd to schedule and control sessions and batches.
• Experience in web application design using open source MVC, Spring and Struts Frameworks.
• Created Schemas (Star and Snow Flake) to fit reporting, query and business requirements.
• Designed and developed complexmappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Worked in Service Oriented Architecture (SOA) and familiar with Transact Oriented Data Warehouse where Data is updated and fetched in real-time.
• Strong knowledge and expertise in agile and waterfall development methodologies.
• Experience in integration of various data sources like Oracle, Teradata, Sybase, SQL Server, DB2, MS Access, Flat files, XML and COBOL files.
• Expertise in PL/SQL in creating/maintaining database Stored Procedures, Functions, Packages, Triggers, Cursors and Indexes
• Expertise in Shell Scripting, AWK, SED and XML.
• Expertise in importing and integrating legacy system data to relational database systems.
• Strong leadership, excellent communication, analytical, design and development skills, good working experience with customers, end users and colleagues. Demonstrated ability to work in both individual and team environments.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Power Exchange) 9.1, 8.6/7.1/6.2/5.1, Data Stage 8.0.1/7.5.

Modeling Tools: Power Designer, Erwin 4.1.2/3.5

BI Reporting: Cognos 8.3/8.1, Cognos Reportnet 1.1 MR2, Framework Manager, Cognos Impromptu Administration 7.0, Business Objects XI R2/6.5/6.1b

Additional Tools: Autosys, CA-7, TOAD, MS Office, Clear Quest, Clear Case

Operating Systems: UNIX, Windows NT/2000/XP, Sun Solaris 8.0

Databases: Oracle 10g/9i, Teradata, DB2, SQL Server and MS Access.

Languages: C, C++, SQL, PL/SQL, JAVA, JSP, ASP, COBOL, FORTRAN, PERL, KORN, Shell Scripting, HTML, XML, JavaScript, and VBScript.

Messaging Tools: MQ SERIES, TIBCO

GUI: HTML, XML and ASP

PROFESSIONAL EXPERIENCE

Confidential, Milford, OH

Sr. Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehouse efforts.
• Developed ETL mappings, transformations using Informatica Power Center
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, MappingDesigner, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Created ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
• Worked on building UNIX Shell scripts to check and update the Teradata/Oracle tables and appending multiple CSV’S to a single CSV and used them in Datastage jobs.
• Implemented Type 1 and Type 2 Slowly changing dimensions.
• SAP provides the cost data in the form of flat files.Informatica is used to extract the data from SAP UNIX system and load it into the Oracle staging database.
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions.
• Extensively usedTeradata Utilities likeFast-Load, MultiLoad, BTEQ & Fast-Export
• Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting.
• Experienced in several facets of MDM implementations including Data Profiling, metadata acquisition and data migration.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and Users in development and staging environments.
• Worked closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.
• Documentation to describe program development, logic, coding, testing, changes and corrections.
• Implemented extreme programming by using fast paced Agile methodology, involving in task completion, user stories, and iterations
• Provided support in administration of the Informatica repository and assisted in the design and architecture of multiple repositories to support multiple application development and QA environments and involved in code reviews.
• Created and scheduled jobs in Autosys.
• Production support Written 24/6.

Environment: Informatica Power Center 9.1,IBM WebSphere Information Server(DataStage Designer), Power Connect, Teradata, Oracle 10g, Flatfile, OBIEE, SQL, TOAD, UNIX scripting, Autosys, Windows XP Professional, Hyperion.

Confidential, PA

Sr., Informatica Developer

Responsibilities:

• Gathered ETL Requirements from Data Architects, Interacted with the Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes.
• Defined and documented ETL requirements and leading the implementation of technology solutions to help the businesses achieve objectives and provided effective and responsive operational services/support for departments.
• Analyzed ongoing processes and mapped it to business requirements and proposed technical solutions to change or improve existing processes.
• Analyzed the change data capture (CDC) process for extract the data.
• Proposed Data model changes for building table structures for efficient load processing and co-ordinate with Data Architect & DBA
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Worked closely with team members and QC team for finalizing ETL Specification document test scenarios.
• Used Informatica DI to create ETL transformationsandexperienced in developing reports .
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
• Analysis of the source system to determine elements needed for ETL designs and did extensive data profiling for ETL maps.
• Used OBIEE Add-Ins to insert, deploy, and analyze Reports in Excel and PowerPoint and also OBIEE Objects such as table views and chart views (BI Publisher).
• Designed High Level ETL strategy for Data Architects and Detail level design documentation for development team.
• Developed Informatica Mappings and Workflows for Data Integration.
• Organized the Workflows and Sessions for the Initial and Incremental Data load runs.
• Prepared the Schedules for the Initial Load runs and Incremental Load runs.
• Designed test cases for initial and Incremental Load testing.
• Involved in Waterfall methodology.
• Worked on Talend to develop jobs and scheduled jobs in Talend integration suite. Extensively used the concepts of ETL to load data from flat files to Salesforce.
• Performance tuning and optimization of complex SQL queries using Teradata Explain. Created several custom tables, views and macros to support reporting and analytic requirements.

Environment: Informatica Power Center 9.1/8.6, Oracle 10g, TOAD, ERWIN, UNIX, TERADATA, SQL Server 2005, Control-M Scheduler, Putty.

Confidential, IL

ETL Developer

Responsibilities:

• Work performed includes requirements gathering, design overview, ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Creation and management of the solution proposal, Macro and Micro designs, and deployment plans.
• Provided in-depth technical consultation to ensure development of efficient application systems by utilizing standard methodologies and best practices.
• Responsible for writing program specifications for developing mappings.
• Created Complex Informatica Mappings to implement complex business rules by using maplets, reusable transformations and mapping parameters.
• Design and Development of Mapping specifications, Physical Flow diagrams and Build documents.
• Developed reusable mappings to process real time files/admin systems extracts, error handling and notification process.
• Designed and developed ETL load strategies, update strategies, error processing, mapping dependencies, batch processing and balance control approaches.
• Developed mappings, workflows and schedules that reflect ETL methodology standards.
• Designed and implemented schemas for reference data, Change Data Capture, process control and audit balancing.
• Developed mappings/maplets, used dynamic parameter files.
• Used transformations like Normalizer, Lookup, Aggregator, Expression, Sequence Generator, Router, Filter, Joiner and Union Transformations.
• Created data checks and implemented error strategies using the Database Logging.
• Used Informatica version control to maintain the changes to the code.
• Created partitions to improve the Session Performance.
• Involved in code reviews to facilitate the right coding practices.
• Automated hourly and daily transaction reports using Talend open studio.
• Extensively involved in developing shell scripts, Perl scripts for loading the data and for automating the ETL process.
• Responsible for migrating projects between multiple environments (Dev, QA, UAT and Prod).
• Involved in CA7 scheduler jobs.

Environment: Informatica Power Center 8.1,Oracle 10g, SQL Server 2005, Erwin, Windows, UNIX, HP Quality Center, TalenD, Netezza, Metadata manager.

Confidential, Irving, TX

Data warehouse Consultant

Responsibilities:

• Writing Oracle Stored Procedures, SQL scripts and calling them from Perl and shell scripts at pre and post session.
• Collection of data source information from all the legacy systems and existing data stores.
• Preparation of strategy for Data Conversion as per the business rules.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner, stored procedure.
• Developed ETL interfaces to integrate master data from Oracle, SQL Server, DB2, Teradata, MySQL and Flat file source systems into Oracle database.
• Applied performance tuning on targets, sources, mappings and sessions to improve system performance.
• New attributes/columns were introduced in the dimension tables by slowly changing dimensions.
• Used Workflow Manager to create worklets and workflows and Workflow Monitor to monitor the workflows.
• Developed PL/SQL stored procedures for pre and post session commands and used indicator files to run tasks in workflows.
• Created partitions for concurrent loading and processing of data.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Involved in the creation of new users and controlling and administering the access privileges to Informatica Power Analyzer.

Environment: Informatica Power Center 8.1, Oracle 9i/10g, PL/SQL, SQL*Loader, Teradata, Shell scripts, MS SQL Server 2000, DB2, Toad, Solaris, ODBC, Power Analyzer.

Confidential, NC

ETL Developer

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA)
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Created List, Crosstab, Chart type reports using Business Objects.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica PowerCenter, Oracle 10g, SQL Server 2008, MS Access, SQL*Loader, UNIX, Winscp, Putty, Erwin, SQL, PL/SQL

Confidential

ETL Developer

Responsibilities:

• Involved in complete system development life cycle study, analysis and Design for creating a robust MIS Reporting System. Involved in initial study, design of Data Warehouse for better Reporting for Inventory and Procurement Systems.
• Attended in-house Training in Informatica and Dimensional Modeling.
• Used Informatica Power Center 7.1 to create data mappings.
• Created various mapping like Joiner, Lookup, Update Strategy.
• Developed Application programs using Oracle PL/SQL.
• Created indexes, sequences, constraints.
• Wrote Packages, Procedures, Functions and Database Triggers.
• Created test plan, test scripts. Documented actual results and compared them with expected results.
• Tracked various defects and worked to resolve the production defects.
• Verified the source data and executed various SQL’s to verify data in TOAD.
• Involved in Unit Testing / System Integration Testing. Assisted QA Team members to create test scenarios.
• Used SQL*Loader to load flat files data to various tables.

Environment: Oracle 9i, SQL, PL/SQL,Windows NT, Toad, Test Director, Informatica Power Center.