SWETHA REDDY

Sr. ETL Consultant/MDM Developer

Email: adl1w8@r.postjobfree.com

Phone: 760-***-****

SUMMARY

9+ Years of Professional experience in Informatica MDM, Informatica PowerCenter, IDQ, Oracle as an Informatica MDM and as Developer different areas of Data warehousing, RDBMS, Cycle (SDLC) analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in MDM and Data warehousing and various business applications in different platforms.

Informatica Power Center 10.01/9.6/9.1/8.6/8.5/8.1/7.1 Oracle 11g/10g/9i (SQL/PL/SQL), Extensive experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in Pharmaceutical, Finance and Insurance industries.

Experienced in implementing multiple end-to-end MDM solutions using- Informatica master data management MDM, IDQ, IDE, IDD, Power Center

Worked in Data Conversion of various data sources like Oracle, MS SQL Server, Oracle Apps, MS Access, Fixed Width and Delimited Flat Files, COBOL files and XML Files

Strong experience in Extraction, Transformation, 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.

Configured landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups.

Worked on Mappings from landing to staging tables and Imported new ORS into MDM hub console.

Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.

Performed all kinds of MDM Hub jobs - Stage Jobs, Load Jobs, Match and Merge Jobs using the Batch Viewer and Automation Processes.

Experience in MDM Informatica Tool and given proven solution to generate the golden records on Customer/Product/Employee data.

Developed Teradata BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements

Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling

Implementing large projects to include effective data integration & data virtualization solutions

Good communication and interpersonal skills and Strong understanding of ETL best practices.

TECHNICAL SKILLS

ETL Tools

Informatica Power Center 10.01/9.6.1/9.5/8.6/8.5/8.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server) Power Exchange, Omni Data Quality server, Information Builders, MDM console

Databases

Oracle 11g/10g/9i/8i, MS SQL Server 2012/7.0/6.5, Teradata, MS Access 7.0/2000, Netezza, SQL Server (DTS/SSIS/SSRS) EBS 12.1.3

Data Modeling tools

ERWIN 4.x and Concepts like Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Development Tools

SQL *PLUS, TOAD, SQL Navigator. Teradata, SQL DEVELOPER

Programming Languages

Unix Shell Scripting and Perl Scripting, Batch Scripting, VB.NET 05/08, XML, Tableau, C++, UML (Rational Rose), Java, Oracle PL/SQL OBIEE, (Stored Procedures, triggers, Indexes)

Packages

MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint

Scheduling Tools

AUTOSYS, Tivoli, Control-M, ESP, MASTERO, DAC

Operating Systems

Windows 2008/2007/2005/NT/XP, UNIX, MS-DOS, IBM /ESA

Education Details:

Bachelors: Engineering in –Biotechnology 2008 (JNTU UNIVERSITY)

Master’s: Master’s in science & Technology -2011(International Technological University)

EXPERIENCE

Advance America Cash Advance, SC Sep2019-Present

Sr. Informatica MDM Developer

Project: Data Migration

Advance America has provided short-term financial services to millions of customers across the United States. including Payday Loans, Installment Loans, Title Loans, and Personal Lines of Credit.One of the largest Latin American providers of banking services, consumer finance and specialty retailing, and a founding member of the Community Financial Services Association, which encourages fair and fully disclosed lending practices. We abide by all state and federal laws, and transparency is at the core of our business practices

Responsibilities:

Analyzing, designing and developing ETL strategies and processes, writing ETL specifications, Informatica development, and administration and mentoring other team members.

Created Source Data Quality reports profiling data for critical attributes presenting it to Data stewardship teams

Executed MDM Data Migration including planning and execution from Informatica 9.6.1 to Informatica 10.1.

Worked in an Agile environment with sprint standups, offshore and onshore delivery model

Analyzed and Participated in cleanup of data and developed new functions to be used in mapping.

Prepared detailed documentation for the Existing MDM Infrastructure.

Involved in gathering and analyzing the requirements and preparing business rules.

Parsing high-level design spec to simple ETL coding and mapping standards. Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

Creation of Informatica Workflows, sessions and Run that Sessions to load into Target and Debugging, Unit Testing of Mappings.

Actively participated in designing the Logical Data Model and Physical Data Model for Staging Area.

Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer Perform Informatica

Designed and developed Informatica Mappings to load data from Source systems to ODS.

Created a new manual match rule and Oracle script for a Business scenario where records were added to IDD merge queue on a certain condition.

Implemented new child and grandchild to existing IDD applications and implemented SIF API’s in IDD User Exits for various business scenarios.

Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.

Ensure that all steps in implementation checklist have been verified.

Perform checkouts of the components after the production implementation.

Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.

Involved in Unit, Integration, System, and Performance testing levels.

Involved in loading the data from Source Tables to ODS (Operational Data Source) Tables using Transformation and Cleansing Logic using Informatica.

Provided on-going maintenance and support of production ETL processes. Monitor production processes and respond to errors and emergency issues.

Created the Validation rules for the staging and Source tables to validate the counts on the Loads.

Environment: Informatica Power center 10.01, Data Quality, Informatica Multi domain MDM 10.1 HF1 Sql server 2012, Oracle 11g, PostgreSQL, CA Central Agile. Snowflake Cloud.

Verizon Wireless, CA-Folsom September 2017 –Dec2018

Sr. MDM Developer /ETL Developer

Project Description: Revenue Recognition

Responsibilities:

Working with business users and business analyst for requirements gathering and business analysis. Converted business requirement into high level and low-level design.

Designing and customizing data models for Data warehouse-supporting data from multiple sources on real time.

Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ.

Designed and configured MDM hub and IDD. Created Staging, Landing tables, Mappings and data flow to the Base object tables, Match& Merge, Trust settings, Complex hierarchies & workflow for Informatica MDM.

Hands on experience in configuration, customization, master data maintenance, process testing & trouble shooting in SAP and MDM tools.

Configured ActiveVOS for workflow management.

Used IDQ for profiling the data and used different transformations before moving the data into landing layer.

Worked on MDM Hub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD)

Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.

Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

Design, document and configure the Informatica MDM Hub to support loading, matching, merging, and publication of MDM data.

Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.

Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.

Reviewed high-level design specification, ETL coding and mapping standards.

Used ETL to extract files for the external vendors and coordinated that effort.

Responsible for creating dashboards and overall creation of data visualizations.

Created primary Database storage structures (Table Spaces, Segment, Extent, Data files, Data blocks) and objects (Tables, Views, and Indexes).

Data quality assessment/analysis for new incoming data set.

Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions).

Helped in viewing records and explained manual merge/unmerge process in IDD to data stewards.

Worked independently and completed assigned project responsibilities under limited supervision and aggressive deadlines.

Environment: Informatica 9.6.1/10.0.1, Informatica MDM 10.2, IDD, Informatica Data Quality 10.1.1, UNIX Shell Scripting PL/SQL Oracle, HP Quality Centre, OBIEE.

Toyota Financial Services, CA Aug 2016 –Sept 17

Sr. MDM Developer / ETL Developer

Project Description: Incentives Plus

Toyota Financial Services Corporation TFS, which has overall responsibility for the financial, services subsidiaries globally. TFS offers its customers financial services that include auto sales financing credit cards retail sales of corporate bonds and investment trusts and insurance. The team is primarily working on building business across several application team across finance group in handling the Lease, Retail and receivables and maintain the data warehousing for the financial services along with real time services to the customers.

Responsibilities:

Work closely with Data Stewards to identify data anomalies by performing data profiling and analysis of the data quality reports to resolve the data quality/ integrity issues.

Involved in Normalization and De-Normalization of existing tables for faster query retrieval

Responsible for Business Analysis and Requirements Collection

Parsed high-level design specification to simple ETL coding and mapping standards

Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables

Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems.

Worked Data Profiling Team in analyzing the source systems data for duplicative and quality issues.

Provided support to develop the entire warehouse architecture and plan the ETL process.

Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD

Designed and configured MDM hub and IDD. Created Staging, Landing tables, Mappings and data flow to the Base object tables, Match& Merge, Trust settings, Complex hierarchies & workflow for Informatica MDM.

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Created test plans, test strategies setup the test environment, co-ordinate with the business analysts and business users for creating test data to perform extensive testing.

Involved in production support and resolving the production issues promptly by attending the high priority issues immediately providing best customer support.

Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data for crops, materials and breeders in IDD data tab.

Involved in the UAT testing of the Items Data Mart price files tool automation project

Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

Environment: Informatica MDM/IDD/IDQ, Data Warehouse, DataMart, Informatica9.6/9, Informatica Power Exchanger, UNIX Shell Scripting PL/SQL Oracle, HP Quality Centre, Tubule, OBIEE, Teradata.

Verizon Telematics, GA Aug 15– June 2016

Sr. MDM Developer/Production Support

Project Description (MDM):

Verizon Telematics is a leader in implementing the next generation of connected services for the automobile. Centered on a core platform of safety and security offerings, the company develops and manages vehicle- and driver-centric solutions to enhance the driving and ownership experience is the largest domain provider in USA. Joined their existing Enterprise Data System (BI) team as Data Analyst ETL Architect and successfully designed, developed and enhanced there marketing data mart (MDM). Suggested key enhancements to their existing Marketing data mart which resulted in building more efficient marketing strategies, Analyzed, identified, fixed bad data and Imported data from Siebel – CRM, Oracle, MDM on near real time basis and integrated that data to one single place to provide users the capability to report on near real time/live data warehouse.

Responsibilities:

Involved in the design of ETL structures for ETL processes, particularly to load bridge and helper tables to maintain the hierarchical nature of Slowly Changing Dimensions (SCD)

Understanding the existing subject areas, source systems, target system, operational data, deployment processes and Production Support activities

Design queries for marketing data marts and then figure out how to make these queries yield comparable data.

Proactively resolved open defects against MDM and other subject areas.

Carried out the testing strategy/validations against MDM subject area by implementing key test cases

Extracted/loaded data from/into diverse source/target systems like Teradata, Oracle, SIEBEL CRM XML and Flat Files.

Execution of SQL queries to extract data from DB2 tables for running test scripts.

Raise tickets/issues with respective teams in the event of production failures and get in touch the respective teams to get the issues fixed as earliest as possible.

Worked on Informatica Data Quality to resolve customers address related issues.

Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems

Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.

Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.

Involved in defining the source to target data mappings, business rules and data definitions

Designed database & UNIX Scripts needed to meet the system requirements.

Designing the documents and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data. Optimizing SQL queries for better performance using Hints, Indexes and Explain Plan

Extensive experience working in an Agile development environment

Created new tables, stored procedures for Application Developers and some user defined functions Created SQL scripts for tuning and scheduling

Good understanding in entity relationship and Data Models

Implemented partitioning and bulk loads for loading large volume of data.

Performed Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like parameter files, variables, partitioning techniques and pushdown optimization, and identifying performance bottlenecks

Performed data conversions from flat files into a normalized database structure

Environment: Informatica Power Centre 9.6/9.5, Informatica Multi-domain MDM 10.1, IDD, Erwin, Address Doctor, Oracle 11g, PL/SQL, Teradata, MDM HUB 10.6V, UNIX OBIEE, DAC, Teradata, IDQ

Nationwide, Iowa Aug 13 - July 14

Sr. ETL Developer/Production support

Responsibilities:

Source data analysis, table design using ESP, improved cube designs for ease of loading on straight move.

Changed Design and mappings as needed to improve performance. Business analysis and data model design for new tables related to ETL. Design and create database tables needed for application

Implemented upgrade plan including testing of all production mappings, sessions, workflows, Modified mappings, sessions, workflows as needed to get them to work as designed in upgraded environment

Started working on Delta File Creation (Pre-Stage) in Hadoop using Informatica

Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center

Extensive experience working in an Agile development environment

Worked on all phases of data warehouse development lifecycle, ETL design and implementation, and support of new and existing applications

Loaded the dataset into Hive for ETL (Extract, Transfer and Load) operation

Maintaining Tableau reports & analysis and work on enhancements to existing reports or creating new reports based on business needs.

Design, develop, unit test, and support ETL mappings and scripts for data marts using Talend Checking & fixing delimiter in ASCII Files.

Responsible for security, backup, recovery, modifications, and new DB2 databases

Created mappings using pushdown optimization to achieve good performance in loading data into Netezza

Involved in the performance tuning of Informatica mappings by using Informatica Push Down optimization (PDO), which provides the same performance impact as a BTEQ script but also provide a good data lineage

Environment: Informatica Power Center 9.6, Power Exchange, COBOL, Oracle11g, ESP, Tableau, Sales Force, PL/SQL, UNIX, Teradata, Hadoop, Netezza, Talend, Quality center

COX Communications, Atlanta, GA Jan 12 - July 13

BI Developer/Production support:

Responsibilities:

Parsed high-level design specification to simple ETL coding and mapping standards

Designed and customized data models for Data warehouse supporting data from multiple sources on real time Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients

Remain calm under pressure and ensure IT management and business stakeholders are kept fully updated on progress of critical issues

Escalate issues and remediation steps effectively and in a timely manner.

Perform troubleshooting analysis and resolution of critical applications and batch processes.

Support the Client Reporting Production Environment as a first priority.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions

Experience in using Automation Scheduling tools like Autosys and Control-M

Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading

Participated in the full development lifecycle within the reporting framework, from developing business intelligence requirements to QA and production deployment

Written SQL Scripts and PL/SQL Scripts to extract data from Databases Power Exchange Change Data Capture has been done for data updates

Worked on Informatica Data Quality to resolve customers address related issues. Worked on Informatica On Demand to mainly import data from Sales Force

Maintained documents for Design reviews, Engineering Reviews, ETL Technical specifications, Unit test plans, Migration checklists and Schedule plans

Developed data models according to company standards Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and 24*7 Production support for data warehousing

Analyzing the logs if any of the Informatica servers goes down

Resolving Issues/Disputes

Environment: Informatica Power Center 9.6, Power Exchange, Seibel OBIEE, DB2 Exchange, Oracle 11g, Control-M, Salesforce, PL/SQL, UNIX.

SHIRE PHARMACEUTICALS, Wayne, PA Apr 10- Dec 11

Sr. ETL Developer/MDM Developer

Project Description: MDM (Master Data Management) has the objective of providing processes for collecting, aggregating, matching, consolidating, and quality assuring, persisting and distributing such data throughout an organization to ensure consistency and control in the ongoing maintenance and application use of this information.

The main objective of the project is to implement Financial Data Warehouse (FBI). As a Sr. Lead Informatica developer, I was responsible for Business Requirement gathering, Coding, Performance Tuning, Error Handling, Job scheduling and Implementation of Best Practices as per the Client Standards.

Responsibilities:

Participated in design sessions where decisions are made involving the transformation from source to target

Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (pl/sql), packages, triggers

Managed and compile documentation for all ETL processes.

Created detailed process flow designs and drafts high-level Standard Operation Procedures.

Performed Informatica Administration tasks

Performed tuning for PL and SQL procedures, Views, and Informatica objects

Designed and implements the error handling strategy for ETL team.

Monitored data warehouse month-end loads to ensure successful completion

Mappings, Mapplets and Sessions for data loads and data cleansing, Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center

Performed match/merge and ran match rules to check the effectiveness of MDM process on data. Created Unit Test Case document

Design logical and physical data models and data processing infrastructure.

Provide production database support, enhance existing system and design and develop new systems.

Monitor the usage of database space and performance.

Performance optimization of the database and applications

Involved in ETL process from development to testing and production environments

Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.

Environment: Informatica Power Center 8.6.1, Power Exchange, Erwin, Business Objects 6.5, Cognos, Tivoli, Oracle 9i, DB2, XML, TSQL, MS SQL Server 2005, UNIX (AIX), UNIX Shell scripting, Salesforce.

Contact this candidate