SUMMARY

• Over 7+ years of experience in IT industry including 6 years of expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications.
• Strong DWH & ETL experience in Informatica Power Center 9.6.1/9.1/8.6.1 development, design, process and best practices experience as ETL Analyst and Developer in US.
• Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP).
• Well acquainted with Informatica client tools - Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager, Workflow Monitor and Informatica Developer.
• Extensive database experience with Oracle, DB2, SQL Server, Sybase and highly skilled in Oracle.
• Good Knowledge in Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables.
• Extensive experience in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected &Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in ETL performance tuning of sources, transformations, targets, mappings, work lets, workflows, and sessions.
• Optimized the Solution by using the performance tuning methods in the Oracle SQL queries like Indexing techniques, Hints, Partitioning and Parallel execution process.
• Extensively used Debugger in Informatica Designer tool to test the data and fix errors in the mapping.
• Experience with Informatica Metadata Manager, loading resource and generating Lineage.
• Implemented complex business rules in Informatica by creating Reusable transformations to reduce the development time and complexity of mappings.
• SCD Management including Type 1, 2, 3, Hybrid Type 3, De-normalization, Cleansing, Conversion, Aggregation, Performance Optimization etc.
• Expertise in Tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks. Query Rewrite, tuning Mappings and Sessions.
• Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures.
• Experienced in Implementing HP Quality Center for bug detection and fixing in testing.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work independently.
• Perform Release Management by undertaking Agile Methodology’s Sprints.
• Experience in writing shell scripting for various ETL needs.
• Used AutoSys for automatic job management, event driven scheduling and programmable error recovery.

TECHNICAL SKILLS

ETL Tools: Informatica 9.6.1/9.1/8.6.1 (Power Mart/ Power Center) 6.x, Informatica Power Exchange, Informatica Developer, Informatica Data Analyst, Informatica Power Connect, IDQ, IDE, Metadata Manager, MDM, IDD.

Reporting Tools: BusinessObjectsXIr2/r 1/6.5/6.1/5.1 , CognosReportnet,Cognos8,SSRS(SQL Reporting Services),SAS

Databases: Oracle 12c/11gr2/10.x, IBM DB2 UDB 10.1/9.7, HDFS, Hive, Server 2012/2008, Sybase, MS Access.

Database utilities: SQL *plus, Stored procedures, Functions, Exception handling.

Data Modeling tool/ Methodology: MSVisio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling.

Languages: C, C++, JAVA, Unix Scripting, Visual Basic, T-SQL, PL/SQL, XML

Operating Systems: Unix, Linux RHEL 6.6, IBM AIX 6.5/5.9, AWS EC2, Sun Solaris 10, Windows 2003/2000/NT, Autosys, Control-M.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Developed ETL procedures to ensure conformity with standards and lack of redundancy, translated business rules and functional requirements into ETL procedures.
• Designed and developed Informatica mappings to load data from source systems to Data Warehouse and then to Data Mart.
• Design and develop the data transformations for source system data extraction, staging, validation, quality handling, and aggregation.
• Implemented and populated slowly changing dimensions, confirmed dimensions, fact tables, and summary tables using Informatica.
• Extensively worked on performance tuning of the programs, ETL procedures and processes.
• Experienced with production support, debug failed jobs and report the status to manager.
• Worked with Hadoop Big data platform, integrating with Informatica, reading and writing data to HDFS, HIVE.
• Experience using Data analyst tool for data quality(IDQ).
• Experience using Informatica Developer for generating mapping(for IDQ).
• Converted existing applications written in PL/SQL to use Informatica ETL procedures.
• Designed and developed new data marts to answer specific business needs.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded in to the target tables.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Involved in Prod Support to research and resolve the daily load issues.
• Document the Prod job failures and provide the root cause analysis to the management.
• Created test cases for unit testing, Integration testing, UAT support and functional testing.
• Used Autosys for automating Batches and Session.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Informatica 9.6.1/ 9.5.0 , UNIX, Informatica Metadata Manager, IDQ 9.6.1, MDM, Oracle 12c/11gr2, Unix Shell Scripts, RHEL 6.6, SQL, PL/SQL, Flat files, DB2, Autosys. ServiceNow, Remedy, Horton works 2.2.

Confidentia

Sr. Informatica Developer

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used ETL (Informatica) to load data from source to Data Warehouse.
• Coordinated and supported the data modeling team for defining supply chain attributes for various drugs.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplets Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
• Hands on experience using data analyst for IDQ.
• Used Informatica repository manager to backup and migrate metadata in development, test and production environments.
• Worked with mapping wizards for slowly changing dimensions and slowly growing dimensions by using Informatica mapping designer.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance in the existing sessions.
• Used CDC for moving data from Source to Target.
• Identified the data in the source system that has changed since the last extraction with the help of CDC.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Designed and Developed Oracle PL/SQL procedures, performed Data Import/Export, Data Conversions and Data Cleansing operations.
• Analyzed failed jobs and provide root cause analysis to the management.
• Coordinated with the multiple teams to fix the failed ETL batch jobs and rerun them.
• Used Autosys for automating Batches and Session.
• Involved in writing shell scripts on Unix (AIX) for Informatica ETL tool to run the Sessions.
• Involved in generating reports from DM layer using Business Objects.
• Involved in tracking, reviewing and analyzing defects

Environment: Informatica 9.1/8.6.1, PL/SQL, XML, Toad, UNIX Shell Scripting, Autosys, SQL, Ms Excel,Oracle11g, MS SQL Server 2008/2005, Erwin7.3, Windows NT, IBM-AIX, Putty, MLOAD, DB2, Sybase.

Confidential - Milwaukee, WI

ETL Developer

Responsibilities:

• Performed business analysis, requirement analysis and converted them into technical specifications.
• Developed mappings to load the data from multiple sources form business units like mortgage servicing, Mortgage Insurance and Loan Origination.
• Worked with data modeling to come up with optimized model for accounting DataMart.
• Created the mappings to load the data for activity/balance details for Sub-ledger and GL accounts for accounting needs.
• Aggregated data from each balance terms and activities and SLS and GL account level.
• Created ETL solution specifications document explaining the entire process flow of ETL from source to stage to target and reviewed the same with architecture team.
• Developed mappings to Load the staging tables from flat files which are sent by message manager.
• Implemented ETL techniques like Update/Insert/Rollup while loading the data from staging to target.
• Optimized the performance of the Informatica mappings by analyzing the session logs and understanding various bottlenecks (source/target/transformations).
• Updated mappings and applied manual DB mods to add the new attributes to Aggregate tables as needed by Business Objects reporting needs.
• Created workflows and implemented session dependencies between detail table and aggregate table loads.
• Configured Sessions properties for better performance.
• Production support trouble shooting failed jobs and debug them.
• Supported various testing cycles during the SIT & UAT phases.
• Supported the daily/weekly ETL batches in the Production environment.
• Bug fixing/ defect fixing, re-unit testing and delivering the code.
• Prompt in responding to business user queries and resolving any ad hoc queries.

Environment: Informatica 9.1, Sybase, Oracle 11g/10g, Flat files, MM, DB2, SQL Server, Unix, RHEL, Autosys.

Confidential

ETL developer

Responsibilities:

• Defined the ETL process to extract the data from multiple sources to stage area to one denormalized table.
• Loaded customer information from CIS System (Customer Information System) into EDW as per the reporting needs.
• Routed the data from Staging area to appropriate target Fact and DIM tables as per the business dimensions.
• Updated the Billing payee/Customer information (SCD) when every customer is moved out/moved in the property.
• Received the flat files from IBM Mainframes where customer monthly power utilization is stored which in turn loaded into EDW for Billing and projection analysis.
• Supported BI team by creating the report specific tables to improve the report performance to meet the SLA's of highly used reports on daily basis.
• Created the mappings to roll up the data from level 0 to higher levels of aggregation which are used by BI team for reports.
• Defined workflows for Mappings and worked with autosys team to schedule them as needed and implement the job dependencies.
• Used task developer in the Workflow manager to define sessions.
• Ensured the Data Mart loads run on time and accurately.

Environment: Informatica 9.0/8.6, SQL Server, Oracle 10g/9i, Flat Files, SQL, SQL Server, PL/SQL, UNIX

Confidential, Memphis, TN

ETL Consultant

Responsibilities:

• Created ETL technical design and solution specification documents in a supply chain environment outlining the entire process flow and Development approach to load the DataMart.
• Created mappings to load the HR DataMart to keep update information about each employee's payroll data, sick leaves and total YTD hours worked and benefits.
• Update the target table with active employee details and flagged the retired employees as inactive.
• Analyze company and industry trends to recommend strategies and tactics to maintain the company's position in strategicsupplychain. Utilized various data sources for analysis of thesupply chainand performance.
• Supported BI team and addressed their need by adding the new fields as needed.
• Monitored the Daily and Monthly jobs to make sure there are no failures and verified the metadata table for record count loaded.
• Addressed the job failure notifications by fixing the issue and restated the job to ensure the successful completion of End to End ETL job.

Environment: Informatica 8.6.1, Oracle 10g, DB2 8.x, UNIX, RHEL 5.3, Autosys. TOAD, SQL Developer.

Confidential, Fairfield, CT

ETL Consultant

Responsibilities:

• Involved in the Analysis of Physical Data Model for ETL mapping and the process flow diagrams.
• Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings.
• Designed and wrote data extraction, transformation, clean and load and Informatica mappings for the enterprise Data Warehouse environment
• Used Informatica transformations such as the Source Qualifier, Aggregators, and Connected & Unconnected lookups, Filters, Sequence Generator and Stored Proc. etc.
• Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings.
• Created sessions to run the mappings.
• Created mapplets and reusable transformations to use across different mappings.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Created and maintained data governance strategies that reduced data redundancy wherever possible.
• Developed and executed test plans and played an active role in project rollouts.
• Investigated and assisted users in the resolution of any day-to-day data warehouse issues.

Environment: Informatica Power Center 8.1 (Repository Manager, Designer, Server Manager), Oracle 10g/9i, Windows 2000, SQL, PL/SQL.