SUMMARY:

• 9+ years of experience in Data Warehouse Business Intelligence domain with projects involving Informatica as ETL tool and QlikView.
• Extensive experience working with Data Warehouses and Data Marts using Informatica Power Center 8.x, 9.x and 10.x(Designer, Repository Manager, Workflow Manager and Workflow Monitor).
• Extensively worked on various Informatica Designer tools like Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Extensive experience in developing complex ETL mappings using transformations like Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, Stored procedure in Informatica Power Center.
• Worked extensively in creating ETL sessions, worklets and workflow, capturing dependencies and scheduling in workflow manager.
• Extensive knowledge in handling Slowly Changing Dimensions (SCD) Type 1/2/3).
• Experience working with different OLAP BI Reporting tools like QlikView.
• Worked extensively on performance tuning long running ETL jobs and fixing any failed jobs.
• Worked very closely in performing root cause analysis, Debugging and fixing data issues in a timely manner.
• Extensive experience in monitoring ETL batch jobs using workflow monitor.
• Knowledge in designing Dimensional models for Data Mart and Staging Database.
• Extensive knowledge in designing functional and detailed design documents for data warehouse development.
• Extensive knowledge of a variety of Relational DBMS products, with experience in designing and programming for relational databases, including Oracle and SQL Server.
• Extensive experience on creating command tasks, email task for data file movement and sending emails alerts to desired audience using UNIX Shell scripting.
• Worked on performance tuning using Oracle partitioning, creating various indexes.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Extensively worked on creating test plans, Unit testing, Integration testing and worked closely with business for UAT support.
• Extensively worked with release management for code migration across the platforms using Repository Manager.
• Extensively worked on documenting and implementing GO LIVE plans.
• Experience working with SDLC, SCRUM, Waterfall and Agile methodologies.
• Responsible for interacting with different Business Partners, Vendors & Customers to identify information needs and business requirements for reports.
• Responsible as a Mentor in training newly hired contractors with the Business knowledge and the Data flow concepts.

TECHNICAL SKILLS:

ETL: Informatica Power Center 10.1.0/9.x/8.x Repository Manager, Mapping Designer, Workflow Monitor, Workflow Manager

Databases Scheduling tools: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2003 and Autosys.

Environment: Windows 95/98/2000/NT/2003/XP/7, UNIX, MS-DOS.

Languages: SQL, PL/SQL, C, C++, UNIX Shell scripts.

PROFESSIONAL EXPERIENCE:

Confidential, San Rafael, CA

Sr. Informatica Developer

Responsibilities:

• Analyzed and thoroughly studied various data sources/CRM system and different environments (DEV, STG and PRD) within the organization.
• Thoroughly studied the different databases and schema(Dimensions/Facts) within the organization.
• Extensively worked on replicating data from Salesforce to Confidential data ware house i.e. ODSG and GDW.
• Extracted data from various source systems (SFDC, CSV files, MDS) applied business transformations and loaded to target databases using Informatica Power Center.
• Developed and build complex Informatica mapping using different transformation like Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Sorter and Router.
• Extensively worked on designing session/worklets/workflows capturing all dependencies using informatica workflow manager.
• Extensively worked on data replication from Siebel to ODSG using IBM CDC replication.
• Closely worked with Operations team on monitoring the informatica job runs, troubleshooting failed jobs and performance tuning for long running jobs.
• Extensively worked with release management and operations team for preparing GO LIVE plans and code migration.
• Worked on a POC on AWS S3 for replicating data from Salesforce to S3 buckets.
• Worked closely with QA team for writing different test cases and extensively involved in QA/UAT efforts.
• Closely worked with business stake holders/BSA’s to understand business requirements and solution them to meet business expectations.
• Extensively worked on creating mapping documents, test plans and wiki documents.
• Worked on enhancing and developing Qlikview QVDs for data provisioning for business reporting.
• Extensively worked on SQL server for basic DDL, DML commands as well as creating indexes.
• Worked on creating Unix/Linux/DOS shell scripts as per the project needs.

Environment: Informatica Power Center 10.1.0/9.x, SQL Server 2008 R2, Oracle 11g, PLSQL Developer, MS Excel 2016, MS Visual Studio 2016, WinSCP and Windows 7.

Confidential, Tampa, FL

Sr. Informatica Developer

Responsibilities:

• Extensively worked on extracting the data from various heterogeneous source systems like flat files (fixed width, delimited) and relational databases applied business logic and loaded into Data Warehouse.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex informatica mappings to load the Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Worked closely with business for requirement gathering and to understand the project needs.
• Created different move-it jobs to have inbound/outbound transition of files between Confidential and different vendors.
• Developed UNIX shell scripting, created command task, and email task for providing the pre-session post-session requirements for various informatica jobs.
• Worked on automation of informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Worked with different teams as Release Management, DBA, and UNIX team for smooth code promotions.

Environment: Informatica Power Center 9.1.0/8.6, Oracle 11g, PLSQL Developer, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access, Autosys and Windows 7.

Confidential, Tampa, FL

Senior ETL/Informatica Developer

Responsibilities:

• Studied the design of the data warehouse model using Star Schema.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Involved in the designing of ETL process using Informatica in order to populate the BI Data Mart using the Flat Files, SQL server and Oracle databases.
• Extracted data from sources like SQL server, and Fixed width and Delimited Flat files. Transformed the data according to the business requirement and then Loaded into Oracle databases.
• Designed and developed complex mappings to load the Historical and Weekly data from the Legacy Systems to Oracle database.
• Created Reusable Transformations and Mapplets, used them in Mappings to develop the business logic for transforming source data into target.
• Implemented Type II S lowly Changing Dimension methodology for accessing the full history of customers.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup, Filter, Update Strategy, and Router transformations.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created and Monitored Workflows to run Session tasks using Informatica Server.

Environment: Informatica Power Center 9.1.1/8.6.1, Oracle 11g/10g, SQL Server 2008, Flat files, MS Excel, MS Visual Studio, UNIX, WinSCP and Windows 7.

Confidential, San Ramon, CA

DW ETL Informatica Developer

Responsibilities:

• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.
• Worked with source teams to resolve data quality issues raised by end users.
• Mappings were developed in Informatica employing transformations like Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router.
• Applied Slowly Changing Dimension and Dynamic lookup techniques.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed post-session and pre-session shell scripts and scheduled Event based sessions using Informatica workflow manager.
• Used Informatica Power center workflow manager to create sessions, batches to run with the logic embedded in the mappings
• Implemented performance-tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.
• Responsible for data reconciliation between source and target and resolving the issue.
• Used parameters and variables (sessions/mappings) extensively for incremental loads.
• Analyzed Session Log files in case of session failures to resolve errors in mapping or session configurations.
• Setting up tasks to schedule the loads at required frequency using Power Center workflow manager.

Environment: Informatica PowerCenter8.6.1/8.1, Oracle 10g/9i, SQL Server 2005, MS Excel, MS Visual Studio, UNIX, WinSCP and Windows 7.

Confidential, San Jose, CA

ETL Consultant

Responsibilities:

• Imported various Sources, Targets , and developed Transformations using Informatica Power Center Designer.
• Developed various Informatica Mappings with the collection of all Sources, Targets, and Transformations.
• Created Mapplets using Mapplet Designer.
• Used Type2 mapping to update a slowly changing dimension table to keep full history.
• Created and maintained metadata and ETL documentation that support business roles and detailed source to target data mappings.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Testing and validation of the developed Informatica mappings.
• Monitored sessions using Informatica Server Manager.
• Applied performance-tuning logic to optimize session performance.
• Involved in Unit Testing, Integration, and User Acceptance Testing of Mappings.
• Worked with Senior Developer in Documenting the ER Diagrams, Logical and Physical models, business process diagrams and process flow diagrams.

Environment: Informatica Power center 8.1/7.1, Oracle 9i/8i, MS Excel, MS Visual Studio, UNIX, WinSCP and Windows 2003.