SUMMARY:

• Overall 8 Years of strong IT experience in analysis, design, development and testing client server environment with focus on Data Warehousing application using tools like Informatica Power Center 10.x/9.x/8.x, Business Objects with Oracle, SQL Server databases.
• Involved in Software Development Life Cycle (SDLC) involving Application Development, Data Modeling, Business Data Analysis and ETL/OLAP Processes.
• Strong Data Warehousing ETL experience of using Informatica 10.1/9.6.1/9.1/8.6.1/8.5/ Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Powercenter 10.x/9.x/8. x.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Experience working on Informatica transformations like normalizer, Lookup, Source Qualifier, Expression, Aggregator, Sorter, Rank and Joiner.
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin and ER Studio Data modeling tools.
• Experienced in developing meta-data repositories.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger) as ETL tool on Oracle, DB2 and SQL Server Databases
• Create conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data Mart, Star/Snowflake schema implementations.
• Implemented Data Vault Modeling Concept solved the problem of dealing with change in the environment by separating the business keys and the associations between those business keys, from the descriptive attributes of those keys using HUB, LINKS tables and Satellites.
• Utilized knowledge on PL/SQL and Data Vault for transforming operational data into data warehouse cloud in Snowflake.
• Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Strong experience in writing complex SQL Queries, Stored Procedures and Triggers.
• Experience in Agile/Scrum, TDD and BDD methodologies
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.

TECHNICAL SKILLS:

Operating Systems: Linux, Unix, Windows 2010/2008/2007/2005/ NT/XP.

ETL Tools: Informatica Power Center 10.1/9.x/8.x

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005.

Data Modelling Tools: Erwin, MS Visio, E/R Studio.

Languages: MS SQL, PL/SQL, UNIX, Shell scripts.

Autosys, Control: M.

Tools: Selenium, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL.

Informatica ETL Developer

Responsibilities:

• Designing and developing data integration solutions using Informatica PowerCenter 10.1.1.
• Analyze variously formatted public records and vendor data for value and integration into the product platform.
• Developed Informatica mappings by using various transformations to suit the business user requirements and business rules to load and eliminate unrequired data from SQL server.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Written Oracle and SQL Server scripts to create materialized views for use in data vault reports.
• Implemented the Data Vault techniques in designing the enterprise data warehouse.
• Participate during System/Integration/UAT testing and provide timely and accurate defect resolution.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Deploy Informatica objects (sessions, mappings, workflows etc) from lower to higher environment (QA/production) using deployment groups through repository manager.
• Coordinated and worked with cross functional business teams and testing teams to plan and execute the releases as per the timelines.
• Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Managed Scheduling of Tasks to run any time without any operator intervention.
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Created Mapplets, common functions, reusable transformations, look-ups for better usability.
• Created conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data Mart, Star/Snowflake schema implementations.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Enterprise Data Vault.
• Worked closely with administrators for identifying root cause of ETL slowdown and then performing the fix accordingly.
• Drive n the technical direction for projects and ensure technical quality of the code delivered.

Environment: Informatica Power Center 10.1.1, SQL Server 2016, SQL Server management studio, Unix, Autosys.

Confidential, San Antonio, Texas.

Informatica ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements gathering.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Worked with heterogeneous source to Extracted data from Oracle database, XML and flat files and loading to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Performed tuning of SQL queries and Stored Procedures for speedy extraction of data, to resolve and troubleshoot issues in OLTP environment.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Developed mapping parameters and variables to support SQL override.
• Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
• Worked with Services and Portal teams on various occasion for data issues in OLTP system.
• Worked with the testing team to resolve bugs in ETL mappings before migrating to production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.
• Designed Informatica Mappings and Workflows be able to restart after a failure.
• Designed tables required for the execution of the ETL processes using ERwin.
• Extracted data stored in a multi-level hierarchy using Oracle Stored Procedures.
• Loaded Customer data in multiple levels (rows) using Oracle Stored Procedures and Cursors.
• Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
• Loaded Dimension, Fact and Exception tables and automated email generation when exceptions occurred.
• Provided excellent support during QA/UAT/Beta testing by working with multiple groups.

Environment: Informatica Power Center 9.6,Data Analyzer 8.1, Toad, SQL Developer, Oracle 11g, SQL loader, PL/SQL, Erwin, Linux,

Confidential, Dover, NH.

Informatica ETL Developer

Responsibilities:

• Loaded data from different Sources to Profile the data for Business.
• Participating with the Business team in meetings to prepare the BRD.
• Experience in understanding Business Requirement Documents (BRD), developing test plans, defining test cases.
• Preparing the Design documents for the BRD and having good knowledge in DMD (Data Mapping Document).
• Experience in designing/developing complex mappings, from varied transformations logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Normalizer Transformations.
• Well versed in writing the complex SQL queries, unions and multiple table joins and experience with Materialized Views.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while developing Informatica mappings understanding the Technical design documents.
• Extensively used SQL scripts/queries for data verification at the backend after ETL Jobs load in development.
• Implemented SCD Type I/II/III slowly changing dimensions.
• Developed and updated Test plans, Test Scenarios and Test Cases for all products.
• Involved in preparing the Technical design documents.
• Writing Stored Procedures to load data to tables to show in UI.
• Extracted data from various source systems like flat files, database tables.
• Monitoring the ETL Workflows in Production and Enhancing existing production ETL scripts

Environment: Informatica PowerCenter, Oracle 10g, SQL Server, Flat files, SQL, PL/SQL, UNIX .

Confidential, Austin, Texas.

Informatica Developer

Responsibilities:

• Involved in project planning, development, assign tasks to various team members and tracking their activities.
• Used Informatica to extract, load and transform operations. This role participates in the design and the movement of data from the operational and external environments to the business intelligence environment.
• Designed and developed Informatica mappings to build business rules to load data.
• Extensively worked on Informatica Lookup, Aggregator, Expression, Stored Procedure and Update Transformations to implement complex rules and business logic.
• Developed complex Informatica ETL jobs to migrate the data from flat files to the database.
• Performed thorough data profiling to understand the quality of source data and to find data issues using Informatica Data Quality.
• Involved in massive data profiling using Informatica IDQ prior to data staging.
• Created IDQ Mapplet for address cleansing, telephone cleansing and SSN cleansing and used them as Informatica Mapplet in Power Center.
• Involved in supporting the application until it is completely stable in Production.
• Co-ordinating with offshore teams for the deliverables.
• Conducting reviews with Business SME's for the design, Code, Unit Test Plan, and cases.
• Extracted source definitions from databases like Oracle and Flat files into the Power center repository.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Toolset of Informatica.
• Involved in the Performance Tuning & Preparation of unit test cases
• Resolving if there are any issues in transformations and mappings.
• Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings for enhancement releases.
• Coding Oracle PL/SQL Stored Procedures, Functions, and Packages
• Analyzing the Defect Resolution document for implementation of the requirements.
• Developing database scripts for each release and deploying them using Work Bench.
• Involvement in code deployment and postproduction deployment activities.
• Carrying impact Analysis for the changes made in source system and implementing the required changes in target DW environment

Environment: Informatica Power Center 9.6, Informatica Data Quality 9.6 .1, Oracle 11g, Teradata, Flat Files, Unix.

Confidential, New York.

Informatica ETL Developer

Responsibilities:

• Analysed the Business Requirement Documents (BRD) & Source to Target Mapping Document (STM) for better ETL Process before the development.
• Used Informatica Power Centre to pull data from different 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.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, java, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Used command task extensively to execute the Unix scripts from informatica.
• Developed mappings for SCD Type 1 and SCD Type 2 dimensions.
• Created process to handle Change Data Capture (CDC).
• Involved in source data Profiling and Tuning of queries for Source Data Extraction
• 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.
• Involved in Enhancing existing Production Objects for additional reporting requirements.
• Tuned the performance of mappings by following Informatica best practices and 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 partitioned the tables in Teradata for optimal performance.
• Loaded data into the Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.
• Extensively worked in the performance tuning of Teradata BTEQ.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Involved in analysis for future migration of Informatica to SSIS and knowledge on SSIS tool.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Involved in doing DWH data Analysis for reporting& also written SQL for ADHOC reporting purpose.
• Written Unix Wrappers for different purposes - PMCMD in Built, Archiving Logs, purging data, FTP the Files.
• Co-ordinate with reporting team for better understanding of DWH data.
• Involved in writing technical design documentation along with deployment activities.
• Scheduling Informatica jobs and implementing dependencies if necessary, using Maestro.
• Involved in Heavy Production Support on rotational basis.

Environment: Informatica Power Center 10.1/9.6.1/9.5.1 , SSIS 2017, Teradata 15/14, Oracle 11g, Sql Server, Flat Files, SQL, PL/SQL, UNIX.

Confidential

Informatica ETL Developer

Responsibilities:

• Actively involved in gathering business requirements and performing GAP analysis.
• Translated Functional requirements into Technical specification documents.
• Developed ETL mapping spreadsheet and Fact-Dimension matrix prior to performing the ETL process.
• Involved in Data modeling for GL Data Mart to bring in various set of books assets and balances into the warehouse
• Used complex transformations such as Connected and Unconnected Lookups, Joiner, Router, Filter and Stored Procedure transformations for data loads.
• Worked with Memory management for the best throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning.
• Debugged and implemented the best practices in mappings, sessions and workflows for data extraction and loading into Slowly Changing Dimensions type 1 and type 2.
• Created test plan cases and performed Unit, Volume and Performance tests.
• Created and scheduled Informatica workflows using Crontab application.
• Imported physical tables and created the required aliases, views, joins in the Physical layer of Siebel Analytics Admin tool.
• Developed the facts, dimensions, necessary hierarchies and the joins between the logical tables, added aggregates in the BMM layer.
• Implemented various performance tuning mechanisms by performing Query Optimization, Hints, running advice plans and explain queries on indexes and creating Materialized Views to execute the prompts on the Dashboards faster.

Environment: Informatica power center, IDQ, Microsoft Visio 2003, Oracle 8i/9i, PL/SQL, UNIX, Windows NT/2000 and Siebel.