SUMMARY

• 7 years of Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 10.1.1/9.10/9.6/9.
• Experience in various stages of System Development Life Cycle (SDLC) and its approaches like Waterfall, Agile Model.
• 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 9.10/9.6.1/9.5.1/9.1/8.6/7.1 , PowerExchange 9.1.
• Experience in OLTP Modeling (2NF,3NF) andOLAP Dimensional modeling (Star and Snow Flake) using ERwin Standard Edition/r7.3/4/3.5 (conceptual, logical and physical data models).
• Experienced in Oracle database development using PL/SQL, Stored Procedures, Functions and Packages.
• 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 transformation.
• Managing and updating database as per the business requirements.
• Developmental experience on Windows platform.
• Experience in scheduling Workflows or jobs to run at specified time intervals.
• Good hands-on Source Code Management(Version Control System) tools like Git and Subversion to maintain Informatica code.
• Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer, Workflow Manager, Repository Manager and Workflow Monitor.
• Experienced In working with various Scheduling tools like Autosys, Control-M,Informatica Scheduler.
• Experience with automation/integration tools like Jenkins.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1.1/9.10/9.6/9. 1

Database: Oracle 11g/10g/9i/ 8i, SQL Server, DB2

Languages: SQL, PL/SQL, UNIX

Operating Systems: Windows, UNIX

Software / Applications: MS XP/NT, MS office Suite

Tools: TOAD

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL Informatica developer

Responsibilities:

• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Write Teradata SQL, BTEQ, MLoad, OLELoad, FastLoad, and FastExport for Ad-hoc queries, and build UNIX shell script to perform ETL interfaces BTEQ, FastLoad or FastExport, via Hummingbird and Control-M software.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Worked with Data mapping team to understand the source to target mapping rules.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Analyzed, identified, fixed bad data and imported data from SalesForce - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Involved in creating the Unix Scripts and jobs to handle Informatica workflows and Teradata utilities like Bteq, Mload, Fast Export and TPT scripts.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• Handful experience on Windows 32 bit commands, Quoting, Escaping.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• Scheduled the Talend jobs using AWS Cloud watch.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 10/9.10, Informatics Repository Manager, OBIEE Oracle10g/9i, and DB2 6.1, Erwin, TOAD, and SAP Version: 3.1.H, Unix- SunOS, PL/SQL, and SQL Developer, Java/J2EE, Struts, JDBC, PL/SQL, JUNIT, ANT, HTML, DHTML, JSP, JavaScript, XML, Oracle, Apache Tomcat, MS Excel,AWS.

Confidential, Bentonville, AR

ETL Informatica developer

Responsibilities:

• Understood ETL process and business rules that need to be implemented
• Worked on Informatica Power Center 9.6 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets and Transformations.
• Developed mappings in Informatica to load the data from various data sources into the Data Marts, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• 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).
• Created and configured Workflows, Worklets and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in extraction, cleansing and loading of data into Oracle database from flat files and DB2 tables.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Performed Unit testing and Functional Testing of Informatica mappings and Workflows.
• Performed ETL & database code migrations across environments.
• Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL*Loader.
• Documentation of technical specification, business requirements, functional specifications for the development of Informatica mappings to load data into various tables and defining ETL standards.

Environment: Informatica Power Center 9.6 Oracle 8.1.7.4, SQL*Plus, PL/SQL, TOAD 7.1, UNIX, Windows XP.

Confidential, Brentwood, TN

ETL/ SQL Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on business rules.
• Used Informatica Power Centre 9.0.1.for extraction, loading and transformation (ETL) of data in the DataMart.
• Participated in the review meetings with functional team to signoff the Technical Design document.
• Involved in Design, Analysis, Implementation, Testing and support of ETL processes.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica Power Center.
• Developed IDQ mappings using various transformations like Labeler, Standardization, Case Converter, Match and Address validation Transformation .
• Used Talend Admin Console Job conductor to schedule ETL Jobs on daily, weekly, monthly and yearly basis (Cron Trigger).
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Coded PL/SQL stored procedures and successfully used them in the mappings.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process and also to schedule the automatic execution of workflows.
• Scheduled the Jobs by using Informatica scheduler& Jobtrac
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Worked on Exporting and Importing of Talend jobs using Talend Admin Console.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning at various levels like mapping level, session level, and database level.
• Provided production support by monitoring the processes running daily.
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Coordinating with the Offshore team and directly interacting with the client for clarifications & resolutions
• Introduced and created many project related documents for future use/reference.
• Designed and developed ETL Mappings to extract data from Flat files and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of Power enter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Built complex reports using SQL scripts.
• Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using workflow monitor.

Environment: Informatica 9.0.1, PL/SQL, Informatica Data Quality IDQ 9, Oracle 9i, UNIX, SQL, PL/SQL, Informatica Scheduler, SQL*loader, SQL Developer, Transformer, Oracle 11g, TOAD, Windows Server 2008, UNIX.