SUMMARY

• 7 years of Experience in Data Warehousing, Database Design, Development and Implementation of Data Warehouse & Data Marts using ETL Tools and ETL Processes in various business domains like finance, banking, insurance and services industries.
• Experience in designing and implementing data warehouse applications, mainly in ETL processes using Informatica Power Center v10.x/v9.x/v8.6.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Consultant), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large - scale Data warehouses using Informatica Power Center.
• Extensively used ETL methodologies for supporting Data Extraction, Transformation and Loading process, in a corporate-wide-ETL solution using Informatica Power Center.
• Extensively worked on developing Informatica Designer, Workflow manager and Workflow monitor for data loads.
• Extensive experience in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer.
• Extensive knowledge of data warehouse approaches - Top down (Inmon’s approach) and Bottom up (Kimball’s approach), methodologies - Star Schema, Snowflake.
• Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in IT, E-Commerce, Insurance and Finance industries.
• Experience in development and maintenance of SQL, PL/SQL, Stored procedures, functions, analytic functions, constraints, indexes and triggers.
• Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts and Normalization/De-normalization.
• Experience in using update strategies, incremental loads, and implementing Slowly Changing Dimensions of Type I and Type II
• Experienced in IDQ (9X, 9.5.1) handing LDO’s PDO’s & some of the transformation to cleanse and profile the incoming data by using Standardizer, Labeler, Parser, Address Validator Transformations of experience in using different versions of Oracle database like 12c/11g/10g.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Experience in ETL development process using Informatica for Data Warehousing, Data migration and Production support .
• Experience in both Waterfall and Agile SDLC methodologies.
• Data modeling experience in creating Conceptual, Logical and Physical Data Models using ERwin Data Modeler.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Experience in integration of various data sources like Oracle, DB2, Flat Files and XML Files into ODS and good knowledge on Teradata 12.0/13.0, SQL Server 2019/2017/2016 and MS Access.
• Hands on experience in MDM development Involved in the designing of Landing, Staging and Base tables in Informatica MDM.
• Created MDM mapping and configured match and merge rules to integrate the data received from different sources.
• Extensive knowledge in all areas of Project Life Cycle Development.
• Strong analytical, verbal, written and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g, SQL Server 2019/2017/2016 , MS-Access, Teradata.

Operating Systems: Windows, UNIX

Languages: PL/SQL, T-SQL, UNIX Shell Scripting

ETL Tools: Informatica Power center v10.x/v9.x/v8.6.1, Informatica IDQ, Power Center, Power Exchange, SQL Server Integration Services (SSIS), MDM (Master Data Management), Informatica Data Explorer (IDE)

Scheduling Tools: Autosys, Informatica Scheduler, control- M, Active Batch

Methodologies: Star Schema, Snow Flake Schema, Ralph Kimball Methodology, Data Mart, ERwin

Reporting Tools: SQL Server Reporting Services, MS Access Reports, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

Sr. Informatica Developer

Responsibilities:

• Analyzed and thoroughly studied various data sources and different development environments within the organization.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the oracle databases.
• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Used various informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the target systems using Informatica power center.
• Used Informatica Data Quality (IDQ) to profile the data and apply rules to Membership & Provider subject areas to get Master Data Management (MDM).
• Worked on multiple projects using Informatica developer tool IDQ
• Involved in migration of the maps from IDQ to power center.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Coded UNIX shell scripts, created command task, and email task for providing the pre-session post-session requirements for various informatica jobs.
• Provide database coding to support business applications using T-SQL
• 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.
• Worked with the Release Management Team, the DBA Team, and the UNIX team for smooth code productions.

Environment: Informatica PowerCenter 9.6.1, Informatica Data Quality (IDQ), Oracle 18c/12c, PLSQL Developer, Flat Files, MS Excel 2013, MS Visual Studio 2017, SQL Server 2019, UNIX, MS Access.

Confidential, Phoenix, AZ

Informatica Developer

Responsibilities:

• Interacted with the Data Analysis team to gather requirements and created Business Specification Documents. Analyzed the approach Documents/Templates and suggested a few fixes. Analyzed source to target mapping document.
• 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 Center to extract/transform and load data from different operational data sources like Oracle, Flat files, XML files, Cobol files, SQL server from which customers data is coming and is loaded into Teradata warehouse.
• Actively involved in implementing the land process of loading the customer/product Dataset into Informatica MDM from various source systems.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• 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 Center Designer.
• Implemented Type 2 Slowly Changing Dimension (SCD) to access the full history of accounts and transaction information.
• Implemented Change Data Capture (CDC) using the MD5 function.
• Worked on Informatica command line utilities like PMCMD, PMREP.
• Responsible for the performance tuning of the ETL process at source, target, mapping and session levels.
• Responsible for troubleshooting bottleneck problems by creating the indexes at database level.
• Created and configured workflows, worklets, and sessions using Informatica Workflow Manager.
• Made use of session log files and workflow log files to debug errors in mappings and sessions.
• Used Mapping Parameters and Variables for reusability of code snippets.
• Coded shell scrips in UNIX and used UNIX tools like WinSCP.
• Supported the testing team, UAT team and production support teams.

Environment: Informatica Power Center 9.1.1, Informatica MDM Multi-Domain, IDD, Oracle 12c, Teradata, UNIX, Teradata utilities.

Confidential

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment,
• Involved in Analysis of the current system and Design solutions to create a centralized data warehouse as well as planning migration solutions from the current system to the new system,
• Used Informatica to extract data from different Source systems DB2 and Flat files then into Oracle Target system,
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse,
• Involved in Development and Data Integration of the main components using Informatica Power Center,
• Used different Transformations like Expression, Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look ups etc.,
• Actively involved in the design and implementation of Physical and logical Data warehouses and Data marts, OLAP solutions, Multidimensional analysis,
• Developed logical models building hierarchies, attributes and facts extracting tables from warehouse,
• Actively involved in the scripting team for shell script to automate and migrate data from ODS to Data warehouse,
• Used the command line program PMCMD to communicate with the Informatica Server and for monitoring the workflow and tasks,
• Involved in performance tuning, monitoring and optimization of ETL loads.
• Involved in different team review meetings,
• Created the mapping and Functional Specifications,

Environment: Informatica Power Center 8.6, Oracle 11g, UNIX, XML, Teradata, MS Excel 2010, Flat files, SQL Server, PL/SQL.