Quality Assurance Sql Server

Swetha Nimmala

Sr. ETL Cloud Developer / MDM Developer

Email: *************@*****.***

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

LinkedIn: https://www.linkedin.com/in/swetha-reddy-50a605a8/

SUMMARY

11+ 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.

Performed requirement gathering, analysis, design, development, and testing, implementation, support and maintenance phases of both MDM and Data Integration Projects.

Excellent Domain/Business knowledge in Healthcare, Banking, Finance, Payroll and Insurance Industries with a strong technical background in Informatica Power center/IICS and Cloud Platforms.

Informatica PowerCenter 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, PowerCenter.

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, and 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.

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

Experience working on Java User Exits (Pre-stage and post-load) and knowledge on Installation and configuration of ActiveVOS.

Implementing large projects to include effective data integration and data virtualization solutions.

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

TECHNICAL SKILLS

ETL Tools

Informatica PowerCenter 10.6/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, SQL Server 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

Operating Systems

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

Education:

Bachelor of Engineering in Biotechnology from JNTUH, India in 2008

Master’s in Science & Technology from International Technological University, San Jose, CA, USA in 2011

PROFESSIONAL EXPERIENCE:

Flagstar Bank, MI Nov 2023 – Present

Sr. ETL Developer / Cloud Developer

Project: Data Migration

Project Description:

Flagstar Bank on a comprehensive data migration project to consolidate and modernize its data infrastructure. The project aimed to migrate sensitive customer data, loan information, and transactional records from legacy system to a new cloud-based data warehouse.

Responsibilities:

Translates data access, transformation, and movement requirements into functional requirements and mapping designs.

Designs automation processes to control data access, transformation, and movement.

Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling.

Leads Technical staff and clients to investigate, analyze and resolve complex technical problems related to system functions, environment, and procedures.

Understands existing Informatica ETL environment, translates into new environment requirements and plans tasks to meet those requirements.

Monitors and maintains compliance with Enterprise Architecture, Technology Standards, and Disaster Recovery/Business Continuity Planning.

Excellent in Data Warehouse Concepts and work experience.

Worked on Troubleshooting existing SQL statements and Scripts to provide efficient performance solutions as a part of Performance Tuning activity.

Wrote complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.

Designed, Implemented, and developed ETL processes using IICS Data Integration and developed cloud integration mapping templates for SCD1, SCD2 applications.

Experienced in designing and developing ETL processes to read and write data to cloud application like Salesforce.com

Work on enhancements and maintenance activities of the data including mining, profiling, tuning and modifying existing solutions and re-engineered Existing ETL for better performance.

Design and develop various automatize processes and schedule them to execute in a timely manner to meet downstream SLA’s.

Responsible for maintaining quality reference data in oracle by performing operations such as cleaning, transformation and ensuring Integrity in a relational environment.

Introduced and implemented design standards for ETL processes to enhance performance and audit capability.

Using Salesforce Data Loader, manual data operations are performed like insert and updates to Salesforce Objects on test sandbox.

Experience in Creating GUIDES In IICS for receiving input from users and displaying required information to Users in Salesforce based on input.

Experienced with converting the Legacy code to Informatica PowerCenter /IICS mappings and Workflows to make sure give the same resultExperienced with converting the Legacy code to Informatica PowerCenter /IICS IDMC mappings and workflows to make sure gives the same results.

Experience in identifying Bottlenecks in IICS ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning and Pushdown Optimization

Demonstrated strong analytical skills by reverse engineering legacy ETL processes, meticulously documenting them, and writing detailed test cases for validation.

Developed new ETLs, re-engineered existing ETL’s for better performance and efficient data pipelines.

Develop, Test, and document working custom development, integrations, and data migration elements of a Salesforce.com implementation.

Environment: Informatica Intelligent Cloud Services (IICS), Salesforce, Salesforce.com, Data Loader, Oracle 11g, GitHub, SQL, PL/SQL, SQL Server 2008

Cigna Healthcare, MA Jan 2023 – Nov 2023

Project: Claims/Proclaims

Sr. MDM Developer / ETL Developer

Project Description:

As a global health service company, Cigna's mission is to improve the health well-being and peace of mind of those we serve by making health. More than a health insurance company, total health and wellness.

Responsibilities:

Conducted weekly sessions with the functional team to finalize the client requirements and the Data Steward’s Team to understand the roles in their hierarchy.

Configured source systems collaboratively and performed batch group with stage and load jobs.

Creating external batches to execute mappings, Mapplets using Informatica workflow designer to integrate Shire’s data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.

Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.

Implemented Land Process for loading the customer Data Set into Informatica MDM from various source systems.

Design and develop MDM data model and defining logical relationships between the objects.

Configure IDD and Hierarchy Manager. Configured Trust scores.

Multiple customizations using MDM user exits, Java, SIF and Oracle.

Address standardization using Address Doctor and Informatica Data Quality Tools.

I worked on XPath, XQuery, and SoapUI and WSDL files.

Configured Human Tasks in the workflow to assign roles to Data Stewards and configured Email/Messaging/Identity Services.

Supporting MDM applications in Pre-Prod and Production environments Performed Admin Tasks.

Successfully implemented IDD using hierarchy configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries.

On-premises MDM offers enormous control, as you handle the configuration, upgrades, and system changes.

Involved in analyzing the source data coming from different data sources such as Oracle, flat files.

Importing source and target tables from their respective databases.

Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner and Union.

Used workflow manager to create workflows, sessions, and used various tasks like command.

Worked with various active transformations in Informatica PowerCenter like Normalizer Transformation, Aggregator Transformations.

Implemented change data capture (CDC) mechanisms within IICS to handle real-time data updates and

Synchronization.

Build IICS components like mappings, map lets, mapping tasks, task flows, Business services, Data Replication, Data synchronization tasks, file listener, Business Services,Hierarchical schema etc.

Created Data Validation Document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Ensure timely delivery and quality of delivery by adhering to quality 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.

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.

Created data mapping workflows in IICS to ensure data is correctly formatted and transformed according to business requirements before being loaded into Snowflake.

Successfully mapped source system data to target data warehouse schemas using IICS.

Involved in loading data from different sources to staging areas by cleansing data to do this we are using Trillium services and Duns Numbers from Duns and Bradstreet (DNB). After getting data as per business requirement from DNB

Environment: Informatica PowerCenter 10.2, Informatica Intelligent Cloud Services (IICS), Flat Files, Oracle11g, Teradata, UNIX Scripting, Putty, Visio, and MDM 10.4, IDD

Ford Motors, Dearborn, MI July 2021 – Oct 2022

Sr. MDM Developer / Operations

Project: Ford Credit – Counter Party Cross Reference

Project Description:

Data Receiving from 13 source systems. Data as new source to MDM and associated MDM process to ingest data into MDM platform, maps incoming source data with data ingested from ODS layer and keep it in IDQ and use in MDM process and create golden record in MDM. Publishing consolidated Counterparty’s into Teradata Informatica Solution would enhance both data available to sales as well as improving the efficacy support team in preparing and loading data into Teradata.

Responsibilities:

Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration.

Bringing Golder Record in MDM. Getting the data directly from ODS layer (sources) from Teradata.

Configured the Trust validation rules and involved in the match rule testing.

Build out the best practices regarding data staging data cleansing and data transformation routine within the Informatica MDM solution.

Define and build best practices regarding creating business rules within the Informatica MDM solution.

Involved in implementing the land process of loading the customer data set into Informatica MDM from various source systems.

Gathered requirements from business users by conducting brainstorming sessions.

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

Created Mappings to get the data loaded into the Staging Tables during the stage process.

Involved in the monthly deployments, upgrades testing and validations. Month end prod issues reported in high priority.

Testing the changes publishing the golden record to Z4200, Z4201, Z4203 and Z4204 Golden Record Tables.

Debugging the user exit code. Enhanced the HDD delta detection changes where java programming is involved.

Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, IICS ETL Design, IICS development, IICS System testing, Implementation, and production support.

Making enhancement fixes on data issues HDD and delta issues.

Provide the design and solution on the MDM issues and enhancements.

Designed the solution to ranking the field based on balance sheet date. It helped the business to get more insight of data to take better decisions.

Worked on the Autosys problem identification and failed process of the jobs troubleshooting with Autosys job status on daily. Debugging the logs and error issues.

Improvised the Sanity Query to find the daily issues in MDM daily flow data. Before business reports on the issues. Rejections, Missing data Lookups can be identified by the sanity query invoked with the IDQ mapping automated with Autosys job with daily schedule generate the report.

Worked on different data rejections and added fixes.

Debugging on the data issues. Enhancing the existing source queries Teradata and Oracle.

Involved in design and development of data validation checks, load process and error control routines.

Worked on UI-C360 interface, provisioning changes new data for reporting purpose.

Worked on the IDQ mapping changes any code modification or enriching the data before loading into MDM layer.

Bought a new data set for the new field in WK for DPF reporting purpose for multiple sources and systems. Changes were made to all related mappings of IDQ and MDM, new landings, staging tables were created.

Testing the all the functionality end to end in all the environments and communicating with business agreeing on the changes delivered. Coordinating with Business to get the Signoff for the Prod Deployments.

Execute data quality measurement and monitoring process utilizing techniques to provide insights into the quality of data.

Experience in developing data quality initiatives to evaluate new and existing data attributes.

Good Exposure to development, testing, debugging, implementation, documentation and production support.

Extensive experience in implementation of Data Cleanup Procedures, Transformations, Scripts and Execution of Test Plans for loading the data into the targets.

Performed unit testing at various levels of the ETL.

Involved in design and development of data validation, load process and error control routines.

Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.

Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident.

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.

Extensive experience in Master Data Management (MDM) HUB Console Configurations such as Staging Process Configurations, Landing Process Configurations, Match and Merge Process, Cleansing Functions, User Exits.

Environment: Informatica IDQ 10.5, Data Quality, Informatica Multi Domain MDM 10.4 HF3, Oracle 11g, Ralley, Teradata 16.20V

Advance America Cash Advance, Spartanburg, SC Sep 2019 – June 2021

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

I 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 PowerCenter Tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

Creation of Informatica Workflows, sessions and run those sessions to load into Target and Debugging, Unit Testing of Mappings.

Configured and managed connections to various data sources including SQL Server, Oracle, and flat files in both PowerCenter and IICS.

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.

Migrated ETL workflows from on-premises PowerCenter to cloud-based IICS environments, ensuring minimal downtime.

Integrated SQL and PL/SQL scripts with IICS mappings and workflows to streamline ETL processes and ensure consistent data flows.

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 APIs 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 PowerCenter 10.01, Data Quality, Informatica Multi Domain MDM 10.4 HF1 SQL server 2012, Oracle 11g, PostgreSQL, CA Central Agile. Snowflake Cloud

Verizon Wireless, Folsom, CA Sep 2017 – Oct 2018

Sr. MDM Developer / ETL Developer

Project: Revenue Recognition

Responsibilities:

Working with business users and business analysts 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 in 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 and workflow for Informatica MDM

Hands on experience in configuration, customization, master data maintenance, process testing and 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 Center, OBIEE

Toyota Financial Services, Torrance, CA Aug 2016 – Sept 2017

Sr. MDM Developer / ETL Developer

Project Description: Incentives Plus

Toyota Financial Services Corporation TFS, which has overall responsibility for the financial and 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 teams across finance groups in handling the Lease, Retail and receivables and maintains 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 with the 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 and 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 set up 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 to 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, Atlanta, GA Aug 2015 – 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 their 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 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 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 with the respective teams to get the issues fixed as early as possible.

Worked on Informatica Data Quality to resolve customer’s 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, and dynamic lookups, queries, packages and query groups.

Involved in

Contact this candidate