SUMMARY

• 6+ years of experience in various Data Warehousing, ETL & BI projects.
• Expertise in developing end to end solution for Data Warehousing, Data Integration, Data Quality projects.
• Experienced in Informatica (9.6.1) as ETL tool and various BI tools like QlikView (v11.2), SSRS (2016) to develop ETL and BI solutions.
• Extensively worked with Basic Informatica transformations including Source Qualifier, Router, Lookup, Update Strategy, Expression, and Joiner as well as Complex Informatica transformations like XML, SQL, Web - Service etc.
• Strong experience in implementing Data warehousing solutions involving Dimension modeling with Star and Snow flake schema implementation.
• Configured Informatica mappings to run in full load mode as well as incremental mode.
• Expert at RCA of ETL errors using Informatica Session Logs and at resolving performance & data issues.
• Proficient in Performance Tuning for Informatica by optimizing the sources/targets mappings/sessions.
• Experience in managing Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3, Data Marts, OLAP, OLTP and Change Data Capture (CDC).
• Experienced in working with Oracle, MySQL and SQL Server databases.
• Experienced in writing complex SQL queries using operations like joins, rank, dense rank, group by, aggregations, inner queries, sub queries, co-related queries.
• Published technical papers on one of the most used Data Mining Algorithm, “Frequent Item Set”.
• Expert in Troubleshooting/Problem Solving skills.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Familiar with Agile and Waterfall development methodologies.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Shell Scripts, Java, C, C++.

Solution Design Concepts: Data Warehousing, Business Intelligence, Extract Transform Load (ETL)

ETL Tools: Informatica Power Center (9.6.1)

BI Tools: QlikView (v11.2), SSRS (2012)

Databases/Data Sources: Oracle 11g, MySQL, SQL Server, Flat Files

Other Tools: SQL Developer, ER Studio, MS Visio, MS Office, WINSCP

Operating Systems: Windows, Unix, Linux, Mac OS

PROFESSIONAL EXPERIENCE

ETL/BI Developer

Confidential - Dallas, TX

Environment: - Informatica 9.6.1 HF3, Shell Scripting, UNIX, SQL, PL/SQL, Oracle AND QlikView.

Responsibilities:

• Worked on data cleansing, data Extraction, Transformation and Loading design, development, source to target mappings, data warehouse transformations, performance tuning, testing and documentation.
• Used Informatica Power Centre to extract/transform and load data from different operational data sources like Oracle, Flat files like CSV files, XML files, SQL server from which customer’s data is coming and is loaded into warehouse.
• Worked on complex mappings using transformations like Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected and Unconnected Lookup, Dynamic Lookup, Filter, Router, Union, and Update Strategy using Informatica Power Centre Designer.
• Created and configured workflows, worklets, and sessions using Informatica Workflow Manager.
• Worked on session log files and workflow log files.
• Implemented Type 2 Slowly Changing Dimension (SCD) for accessing the full history of accounts and transaction information.
• Developed custom SQLs to daily to generate various performance-based ad-hoc reports for analysis.
• Constructed and implemented multiple-table links requiring join statements like self-joins and outer joins.
• Creating scheduled jobs for QVD extracts and report reloads in QlikView.
• Worked on Informatica scheduler as well as UNIX scripts to schedule ETL jobs.
• Preparation of Functional Requirements Specification (FRS) from given business requirements.
• Participated in code and design review sessions to make sure coding is done as per standard specifications and meeting business requirements.
• Preparation of High Level Design Document (HLD) and Low-Level Design Document (LLD).

ETL/bi Developer

Confidential - Dallas, TX

Environment: - Informatica 9.6.1 HF3, Shell Scripting, UNIX, SQL, PL/SQL, Oracle AND QlikView.

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica.
• 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.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created Reports according to user Requirement.
• Extracted data from Oracle and SQL Server tan used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Wrote Shell script running workflows in Unix environment.
• Optimizing performance tuning at source, target, mapping and session level

ETL Developer

Confidential

Environment: - Informatica 9.6.1 HF3, Shell Scripting, UNIX, SQL, PL/SQL and Oracle.

Responsibilities:

• Worked on analysis, design, development, testing, and debugging of complex reports, ETL scripts and dashboards.
• Agile delivery - worked on sprint scope, tasks assigned by lead.
• Create Star/Snowflake logical and physical Data Model to identify facts and dimensions from the source system and business requirements to be used for data warehouse.
• Implemented SCD to capture history changes for required dimensions.
• Reviewed and tested integration design in Development, QA & Production environment.
• Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
• Extensively involved in doing user acceptance testing (UAT).
• Write and modify SQL scripts to update tables, views and materialized views and used insert statements to move new data into the database.
• Worked on performance improvement to find bottle necks in report runtime.
• Created test Cases for each specification in Requirement Specification Document corresponding to each module and worked on test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Troubleshoot high level issues to identify and resolve problems caused by the database, source data, ETL, or the Business Intelligence software e.g. nulls in data causing joins to function incorrectly; ETLs running out of sequence; etc.
• Worked on unit test and system test for code developed for each module.

Project Intern

Confidential

Environment: - Eclipse, SQL, PL/SQL and Oracle.

Responsibilities:

• Worked on J2EE application to develop new modules.
• Used OracleJDeveloperto support JAVA, JSP and HTML codes used in modules.
• Worked on Oracledatabase to create procedures and views.
• Wrote Shell Scripts forData loadingandDDL Scripts.
• Developed and modified severalFormsand for various modules. Also, responsible for following up bugs reported by various users and suggesting possible patches to be applied.