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 and IDQ.
• 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 Microsoft Business Intelligence technologies like SQL Server Integration Services, SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Powercenter9.x/8.x, IDQ and Trillium.
• 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.
• Thorough knowledge in various tools and technologies like different versions of Informatica Data Quality (9.x, 10.x) and Data Analyst, Informatica Power Center (9.x, 10.X) and Informatica Cloud.
• Experienced in developing meta-data repositories.
• Worked on PROVIDER, CLAIMS, MEMBER subject areas.
• 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), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases
• Strong experience in Informatica Data Quality (IDQ), creating data profiles, custom filters, data cleansing and developing score cards.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server, DB2 8.0/7.0, UDB, No SQL Databases, Mongo DB, MS Access and Teradata.
• Create conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data Mart, Star/Snowflake schema implementations.
• Proficient in Informatica Developer, Web based Analyst tool, informatica cloud, PowerCenter repository manager, Designer, workflow manager, & monitor.
• 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 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), IDQ.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2/UDB, Mongo DB, Teradata.

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

Reporting Tools: Reporting services SSRS, SSIS Tableau, and Micro strategy.

Languages: Java, JavaScript, HTML, Perl, SQL, PL/SQL, UNIX, Shell scripts, C++, R.

Autosys, Control: M.

Tools: Selenium, QTP, Win Runner, Load Runner, Quality Center, Test Director, 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.
• Built Informatica Intelligent Cloud Services (IICS) Tasks, Mappings, and TaskFlows
• 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 on Informatica 9.6v and Informatica Cloud Designer to develop process for extracting, cleansing, transforming, integrating & loading data into staging area. Logical and physical star modeling.
• 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.
• Optimized the SQLs and Informatica mappings which handled millions of records.
• Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques.
• Developed re-usable components in Informatica, Oracle and UNIX
• Actively participated in Install/Deployment plan meetings.
• Proved accuracy in doing sanity checks, smoke tests after the install of new scripts used by ETL.
• Prepared Data Mapping documents, process documents, Re-startability Matrix to help on-call team reduce the turnaround time when there is an issue.
• Efficiently handled multiple projects during resource crunch.
• Provided Training to the team with the functional and technical knowledge.

Environment: Informatica PowerCenter 9.6, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, Toad, SQL Developer, Oracle 11g, SQL loader, PL/SQL, Erwin, Linux, Teradata, Micro Strategy and Tableau .

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.
• Failed data to be fixed thru UI by fixing the Policy data in live tables.
• 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 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Oracle 10g, SQL Server, Flat files, SQL, PL/SQL, UNIX Scripting, SOA Services, Web Service Transformation, XML Source and Target transformations.

Confidential, Austin, Texas.

Informatica/ IDQ Developer

Responsibilities:

• Worked in Agile development methodology environment and Interacted with the users, Business Analysts for collecting, understanding the business requirements.
• Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in the installation and configuration of Informatica Power Center 9.6 and evaluated Partition concepts in Power Center 9.6
• 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 stored procedures, views, user defined functions and common table expressions.
• Generated underlying data for the reports through SSIS exported cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in IDS Services like building Business logics, analyzing the structure and data quality, creating a single view of data etc.
• Worked on Informatica cloud for creating source and target objects, developed source to target mappings.
• Involved in importing the existing Power center workflows as Informatica Cloud Service tasks by utilizing Informatica Cloud Integration.
• Involved in Data integration, monitoring, auditing using Informatica Cloud Designer.
• Worked on Data Synchronization and Data Replication in Informatica cloud.
• Written PL/SQL scripts created stored procedures and functions and debugged them.
• Created Mapplets, reusable transformations and used them in different mappings. Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads and Developed reports based on issues related to the data warehouse.
• Used different Informatica Data Quality transformations in the Developer and Configured match properties match paths, fuzzy match key, fuzzy and exact match columns
• Created profiles, rules, scorecards for data profiling and quality using IDQ.
• Used Informatica Data Quality for addresses and names clean-ups and developed error handling & data quality checks to pull out the right data
• Used IDQ to cleanse and accuracy check the project data, check for duplicate or redundant records.
• Used debugger to test the mapping and fix the bugs and identified the bottlenecks in all levels to tune the performance and resolved the production support tickets using remedy.
• Developed monitoring scripts in UNIX and moved Data Files to another server by using SCP on UNIX platform.
• Extensively used Teradata Utilities like Fast-Load, Multi-Load, BTEQ & Fast-Export.
• Created Teradata External loader connections such as M Load, Upsert and Update, Fast load while loading data into the target tables in Teradata Database.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.

Environment: Informatica Power Center 9.6, Oracle12C, Informatica Cloud, IDS 9.6.1, IDQ 9.6.1 Teradata 14.0, SQL Server 2014, Teradata Data Mover, Autosys Scheduler Tool, Netezza, UNIX, Toad, PL/SQL, SSIS, Power Connect, DB2, Business Objects XI3.5

Confidential, New York.

Informatica/ MDM Developer

Responsibilities:

• Address Doctor Upgrade in Power Center and Developer.
• Configure AVOS with hub and made sure that default workflows are integrated.
• Configured BE workflows with IDD.
• Installed MDM in the windows development environment.
• Handled Address Cleansing before populating the data into landing tables.
• Worked on ETL process for bringing in the data into MDM landing tables.
• Worked on profiling the data using Developer tool/Analyst Tool for identifying the data integrity from different sources.
• Most of the data was cleansed in Power Center/Developer before the data is placed in MDM landing tables.
• Based on the data quality analysis and discussion with stakeholders the source data trusted scores are defined.
• Developed validation rules based on the profiled data quality and data analysis.
• Came to conclusion on key fields after discussing with people in the knowledge of data.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Configured match rule set filters for meeting the different data scenarios.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data and fine-tuned the match rules.
• Developed ad hoc queries like Execute Batch Delete SOAP requests for deleting the specific data from the concerned underlying tables using.
• Developed Unmerge user exist for reprocessing the some of the records which are supposed to be processed differently.
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director.
• Used ActiveVOS for configuring workflows like one step approval, merge and unmerge tasks.
• Configured static lookups, dynamic lookups, bulk uploads, extended search and Smart search in IDD.
• Configured JMS Message Queues and appropriate triggers for passing the data to the contributing systems.

Environment: Multi-Domain MDM 10.0, IDD, Oracle 11g, Oracle PL/SQL, Windows Application Server, Active VOS, Informatica PowerCenter 10.1, Informatica Developer, Address Doctor 5.1, PowerShell.

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 modelling 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.