Candidates About

 

Shivanvitha

Sr. Informatica Developer with IDQ/MDM/Teradata/PL/SQL/Oracle               

Summary:

·         8+ years of experience in IT in the areas of analysis, design, development and testing in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Business Objects with Oracle, SQL Server databases, SSIS, MDM etc.

·         Involved in complete software development life cycle (SDLC) of project with Agile Methodologies.

·         Extensive Database experience using Oracle 11g/10g/9i, Teradata, DB2, MS SQL Server 2010/ 2005, SQL, PL/SQL. 

·         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 and Address Validator Transformations.

·         Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data cleansing and data validation by using IDQ.

·         Extensively worked on Informatica Power Center Designer components like Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer.

·         Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.

·         Experience in developing Enterprise level Data warehouse, Data marts and Operational databases.

·         Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.1/8.6/7.x/6.x/5.x.

·         Strong experience in using Informatica Data Quality 9.6.1 (IDQ) tool. Complex quality rule development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL and Real-Time consideration.

·         Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.

·         Worked with Informatica cloud for creating source and target objects, developed source to target mappings.

·         Proficient with RDBMS systems, SQL, Oracle PL/SQL, database design and optimizations

·         Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 11g/10g/9i/8i, DB2 UDB.

·         Worked on scheduler tool Autosys, Tidal and Control-M to create job for ETL workflows.

·         Extensive experience using tools and technologies such as Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008, DB2 UDB, Sybase, Teradata 13/12/ V2R5/V2R4, Netezza MS Access, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x, Erwin 4.0/3.5, SQL* Loader, TOAD, Stored procedures, triggers.

·         Experience in Performance Tuning. Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.

·         Strong data modeling experience using Star/Snowflake schemas, Re-engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling.

·         Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).

·         Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre session and post session commands.

·         Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, flat files, XML files, DB2 UDB, Main Frames and COBOL files.

·         Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches

·         Expertise in using GUI tolls like Erwin, Toad, SQL Developer, SQL Navigator and SQL *Loader. 

·         Excellent communication skills, team player, ability to work individually and meet tight deadlines.

·         Experience in Installation, Configuration, and Administration of Informatica Power Center 9.x/8.x/7.x/6.x, power exchange8.1 and Power Mart 5.x/6.x Client, Server.

·         Experienced in Databases like Oracle, SQL Server, DB2 and Teradata. Done backend application coding using TOAD utilizing SQL, PL/SQL, T-SQL.

·         A very good team player and lead with excellent problem solving and technical skills.

Technical Skills:

ETL Tools:	Informatica Power Center, Power Exchange 9.5/8.6/8.1 7.1, Metadata Manager, IDQ, IDE, IDD, MDM, SSIS, DataStage, Salesforce, etc.
Reporting Tools:	Business Objects XIR2/6.1/5.0, Qlikview, OBIEE, Microstrategy, Oracle       Analytics, etc.
Databases:	Oracle 11g/10g, MS SQL Server 2008/2005/2000, MS Access, IBM, DB2, Teradata 14.0, Netezaa 4.0, Siebel CRM, PeopleSoft
Data Modeling:	Data Modeling, Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
Operating Systems:	UNIX, Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS
Web Services	SOAP, REST, WSDL, UDDI

 

Professional Experience

 

Client: United Health Group, Colonia, NJ                                                                             Jan 2016 to Current

Role: Senior Informatica Developer

Responsibilities:

 

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

·         Worked on Exception Handling Mappings for Data Quality, Data Profiling, Data cleansing and data validation by using IDQ.

·         Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV, QA, and testing and production environment.

·         Worked on MLOAD, FLOAD, FEXPORT and TPUMP to load data to DWH system.

·         Prepared SQL Queries to validate the data in both source and target databases

·         Involved in preparing ETL and Reporting Design Documents.

·         Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.

·         Used Teradata utilities Fast Load, MultiLoad, Tpump to load data and building, testing, implementing Teradata Fast Load, MultiLoad and BTEQ scripts, DML and DDL. 

·         Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.

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

·         Created complex functions, stored procedures, triggers, packages and DBMS Scheduler jobs using PL/SQL Developer.

·         Involved in designing MDM data model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications. 

·         Perform error handling as part of production support on Informatica as well as UNIX.

·         Used Data stage to manage the Metadata repository and for import /export for jobs.

·         Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.

·         Worked with Connected and Unconnected Stored Procedure for pre & post load sessions

·         Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.

·         Created customer hub (MDM) – by consolidating and integrating various sources and storing the golden record as individual identity in the hub.

·         Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.

·         Worked on production tickets to resolve the issues in a timely manner.

·         Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.

 

Environment: Informatica Power Center 9.5, AWS, Informatica IDQ, Informatica MDM, SIF, API, Oracle 10g, Teradata, SQL Server 2008, Toad, SQL Plus, SQL Query Analyzer, SQL Developer, MS Access, Windows NT, Shell Scripting, Clear Quest, Tivoli Job Scheduler, Windows Azure.

 

Client: Citrix System, Fort Lauderdale, FL                                                                        Sept 2014 to Dec 2016

Role: Senior ETL Developer

Responsibilities:

·         Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.

• Developed the Informatica Mappings with Aggregator transformation, SQL overrides in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from Oracle to Teradata target database.
• Created PL/SQL Stored procedures which were used in Informatica mappings.

·         Involved in the data modeling and designed the Data Warehouse using Star Schema methodology. Also, responsible for all the ongoing data model design decisions and database implementation strategies.

·         Performed Profiling, Score carding, Creating Rules, Reference data tables, Mapplets and Mappings as part of the development process.

·         Fine-tuned existing Informatica mappings for performance optimization.

·         Extracted data from different source systems such as Oracle, SQLServer, MS Access, DB2, Mainframes, XML and Flat Files.

·         Created customer hub (MDM) – by consolidating and integrating various sources and storing the golden record as individual identity in the hub.

·         Developed Complex transformations, Mapplets using Informatica to Extract, Transform and Load Data into DataMart, Enterprise Data warehouse (EDW) and Operational data store (ODS).

·         Used Metadata Manager to manage the Metadata associated with the ETL processes.

·         Used error handling mapplets to capture error data into PMERR tables for handling nulls, analysis and error remediation process.

·         Defined the test strategy, created unit test plans and supported UAT and regression testing using HP Quality Center.

·         Used IDQ to do data profiling of the master data. Used Informatica Analyst to get an overview of the accuracy of the data and percentage populated.

·         Used Informatica Developer client to set up Address validation, name matching using Match transformation, etc.

·         Worked with MDM principle and SIF service with ability to debug SIF related issues.

·         Identified slowly running ETL jobs and reduced the run time drastically by applying performance tuning techniques.

·         Advocated best practices for ETL Processes and conducted Data Integration COP meetings.

Environment: Informatica Power Center 9.5/9.1.1/8.6, Informatica MDM, SIF, API, Informatica Developer client, Power Exchange CDC, Oracle 11g, Erwin, Informatica IDQ, Quality Center, SQL SERVER 2005/2008, MS Access, XML, T-SQL, Shell Scripts, Control-M, Teradata.

 

Client: BMO HARRIS BANK, Dallas, TX                                                                               Mar 2013 – Aug 2014

Role:  Senior ETL Developer

Responsibilities:

·         Analyzed the functional specifications provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.

·         Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.

·         Performed Source System Data Profiling using Informatica Data Explorer.

·         Involved in designing Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model using Erwin.

·         Extracted data from SAP using Power Exchange and loaded data into SAP systems.

·         Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from Oracle to Teradata target database.

·         Worked on Teradata BTEQs.

·         Basic Informatica administration such as creating folders, users, privileges, server setting optimization, and deployment groups, etc.

·         Designed Audit table for ETL and developed Error Handling Processes for Bureau Submission.

·         Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.

·         Used Informatica IDQ to do data profiling of the source and check for the accuracy of data using dashboard.

·         Managed Change Control Implementation and coordinating daily, monthly releases and reruns.

·         Responsible for Code Migration, Code Review, Test Plans, Test Scenarios, Test Cases as part of Unit/Integrations testing, UAT testing.

·         Used Teradata Utilities such as Mload, Fload and Tpump.

·         Used UNIX scripts for automating processes.

 

Client: Kaiser Foundation Health Plan, Colorado, CA                                                      Sept 2011 – Feb 2013

Role: Senior ETL Developer

Project Description:

MIA-IDR is one of the Data Warehouse projects in Kaiser Foundation Health Plan, Inc. MIA stand for Management Information & Analysis and IDR stands for Information Delivery and Reporting.

·         The scope of this project is to get all the Kaisers Inpatient and Outpatient data from a single uniform data repository known as CLARITY (Teradata). The clarity data base is a standard EPIC system which is used by many Health care organizations.

·         For some regions, we get flat files as input and for others we hit the Clarity data base (Teradata) directly for sourcing needs.

·         The Data warehouse follows a star schema. There are 2 stages of the data warehouse staging area and the final warehouse. The data from the files is loaded to the staging area incrementally, from the staging area the data is loaded to the final warehouse.

·         The target is Oracle 10g (RAC). ETL tool Informatica is on UNIX. The inpatient data is loaded every day via a daily cycle and the Outpatient data is loaded on a weekly basis. Other feeds like Ambulatory, SNF etc. are also loaded on a weekly basis. The size of the data and the warehouse is what makes this project challenging and interesting.

  

Responsibilities:

·         Translated the business processes/SAS code into Informatica mappings for building the data mart.

·         Used Informatica power center to load data from different sources like flat files and Oracle, Teradata into the Oracle Data Warehouse.

·         Implemented pushdown, pipeline partition, persistence cache for better performance.

·         Developed reusable transformations and mapplets to use in multiple mappings.

·         Implementing Slowly Changing Dimensions (SCD) methodology to keep track of historical data.

·         Assisted the QC team in carrying out its QC process of testing the ETL components.

·         Created pre-session and post-session shell scripts and email notifications.

·         Involved in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.  

·         Created mappings using Data Services to load data into SAP HANA.

·         Involved in data quality checks by interacting with the business analysts.

·         Performing Unit Testing and tuned the mappings for the better performance.

·         Maintained documentation of ETL processes to support knowledge transfer to other team members.

·         Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.

• Involved as a part of Production support.

Environment: Informatica Power Center 9.1, Oracle11g, Teradata, SAP HANA, UNIX Shell Scripts.

 

Client: Axis Bank, India                                                                                                                      Aug 2009 – July 2011

Role: Informatica Developer 

Project Description:                                                                             

This project deals with building a real time view of enterprise level data. A decision support system is built to compare and analyze product prices, their quantities and patient profiles. This Enterprise Data Warehouse (EDW) is used to deliver reports and information to sales and marketing management.

 

Responsibilities:

·         Responsible for requirement definition and analysis in support of Data Warehousing efforts.

·         Developed ETL mappings, transformations using Informatica PowerCenter 8.6.

·         Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL Server, Teradata etc.

·         Developed data Mappings between source systems and target system using Mapping Designer.

·         Responsible for Test and Production issue resolutions.

·         Developed shared folder architecture with reusable Mapplets and Transformations. 

·         Extensively worked with the Debugger for handling the data errors in the mapping designer.

·         Created events and various tasks in the work flows using workflow manager.

·         Responsible for tuning ETL procedures to optimize load and query Performance.

·         Setting up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler.

·         sExtensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.

·         Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.

·         Taken part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.

·         Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.

·         Migrating Informatica Objects using Deployment groups.

·         Trouble issues in TEST and PROD. Do impact analysis and fix the issues.

·         Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.

·         Developed Unit test cases and Unit test plans to verify the data loading process and Used UNIX scripts for automating processes.

Environment: Informatica – PowerCenter 8.6, Power Exchange, Teradata, Oracle 10G, MS Access, UNIX, Windows NT/2000/XP, SQL Server 2008, SSIS, OBIEE, Qlikview, Teradata, SQL Assistant, Netezza, DB2.

 

EDUCATIONAL QUALIFICATIONS:

·         Bachelor of Technology in Computer Science from JNTU– Graduated.