PROFESSIONAL SUMMARY:

• Having 5+ years of experience in Information Technology including Data Warehouse development using ETL/Informatica Power Center.
• Extensive experience in developing ETL mappings, scripts and data integration using Informatica Power Centre 9.x/8.x/7.x.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.
• Experienced in data profiling and data analysis.
• Attended data model review sessions with Data Modeler.
• Expertise in understanding Business Model Identifying Dimensions and Facts.
• Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Experience in creating Reusable Transformations ( Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank ) for better usability.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Expertise in implementing Slowly Changing Dimensions - SCD Type 1 & SCD Type 2.
• Experienced with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, SQL Assistant.
• Experience in doing Tuning of Teradata Queries using Explain plan .
• Experience in converting SSIS packages & Hadoop Hive QL to Informatica .
• Extensively worked with SQL and PL/SQL.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in UNIX environment, file transfers and job scheduling .
• Worked on Informatica Performance Tuning identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experienced in ETL Informatica & Database Upgrade Testing .
• Experience working in Agile methodology and ability to manage change effectively.
• Excellent communication, interpersonal skills, enthusiastic, self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Languages: SQL, PL/SQL, UNIX, Python.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata. Data Modeling tools Erwin, MS Visio

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/, Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3

Autosys, Control: M

Testing Tools: QTP, WinRunner, LoadRunner, Quality Center, Test Director

PROFESSIONAL EXPERIENCE:

Confidential, Oklahoma City, OK

ETL Developer.

Responsibilities:

• Worked with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model .
• Extracted data from different source systems - Oracle, DB2, My SQL, Flat Files and XML Files.
• Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements.
• Involved in enhancements and maintenance activities of the Enterprise Data Warehouse .
• Communicated with business customers to discuss the issues and requirements .
• Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression, Update Strategy, Transaction Control and Sequence Generator .
• Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables.
• Worked with Huge data sets to load Fact Tables .
• Implemented Change Data Capture (CDC) for handling delta loads .
• Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment.
• Experienced in doing performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating the with tuning methods .
• Used Informatica file watch events to pole the FTP sites for the external files.
• Involved in Enhancing existing Production Informatica objects for change or additional requirements and pushing it back to production after successful QA testing .
• Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load in to Teradata Ware House.
• Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata SQL .
• Involved in Teradata upgrade process from TD 12/TD 14 .
• Production Support has been done to resolve the on-going issues and troubleshoot the problems.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks .
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Worked with ETL Admin team for code migration activities and deployments.
• Worked with QA team for better understanding of code development.
• Implemented & followed organization level Informatica best Standards & Procedures .
• Involved in Solving Trouble tickets raised by Business users as part of application support team.

Environment: Informatica Power Center 9.6.1/9.1.1, Oracle 11g, DB2, Teradata 14/12, Flat Files, XML, TOAD, SQL Assistant, UNIX, Facets 4.7, Windows.

Confidential Milwaukee, WI

ETL Developer.

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Responsible for Impact Analysis, upstream/downstream impacts.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Developed mappings to load Fact, Dimension tables ( SCD Type 1 and SCD Type 2 dimensions ) and Incremental loading and unit tested the mappings.
• Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Developed and maintained Python ETL programs for analyzing and correcting record shipment barcode scanner raw data.
• Involved in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance .
• Loaded data in to the Teradata tables using Teradata Utilities BTEQ, Fast Load, Multi Load, and Fast Export, TPT.
• Also developed a Python program that cross checks the corrected scanner Data Flat Files and VFP DB tables via ADO after importation against the Informix DB via ODBC for upfront identification of case file folders that should be added or removed.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• Scheduling Informatica jobs and implementing dependencies if necessary using Autosys.
• Managed postproduction issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 9.5.1/9.1.1, Oracle 11g, MY SQL, Teradata, Python, Flat Files, Erwin 4.1.2, SQL Assistant, Toad, Putty, Autosys, Windows, UNIX.

Confidential, Richardson, TX

ETL Developer.

Responsibilities:

• Involved in requirement gathering, data Analysis, and user meetings, discussing the issues to resolve and translated the user inputs into ETL design documents.
• Worked with Informatica power center 8.6 tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplets designer and Transformation developer.
• Developed Informatica mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Involved in making the changes to the existing data models to accommodate the new requirements.
• Responsible for Optimizing the ETL loads and also redesigning ETL Interfaces which were not providing the accurate data for the business.
• Worked with mapping parameters and variables, session parameters , PMCMD commands, email tasks.
• Worked with SQL override, Lookup override, Lookup caches, Index and Data caches while designing the mappings also Worked with TOAD SQL*Loader for loading the data from external files into RDBMS tables and Fine-tuned the SQL queries using Explain Plan and TKProf to speed up the session runs.
• Handled Informatica administration work like migrating the code, creation of users, creating folders, worked with Shortcuts across shared, non-shared folders and wrote Autosys scripts for scheduling the workflows.
• Responsible for fixing PLSQL procedures for getting the accurate data.
• Created and executed unit test plans based on system and validation requirements. Worked closely with Business during the testing phase and fixed bugs that were reported.
• Developed reports which used Conditional blocks/Variables and associated them with queries to show data only when the conditions were fulfilled.

Environment: Informatica Power Center 8.6, Oracle, KProf, TOAD, SQL*Loader PL/SQL Toad, Autosys, UNIX, Windows.

Confidential, Trenton, NJ

Informatica Developer

Responsibilities:

• Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used heterogeneous files from Oracle, Flat files and SQL server as source and imported stored procedures from oracle for transformations.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
• Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make Event based scheduling.
• Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 7.1.2, DB2 v8.0, SQL, Windows 2000, UNIX, SQL Server 2000, Oracle 8i, Flat files, SQL, Business Objects 5.1.6, Windows.