7+ years of total experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
Extensive experience in Banking, Insurance, Financial, Telecommunications and Healthcare domains.
Good exposure in overall SDLC including requirement gathering, development, testing, debugging, Deployment, documentation and production support.
Experience with ETL process using Informatica Power Center 9.x/8.x Power Exchange, Designer (Source Analyzer, Mapping designer, Mapplets Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.
Experience in integration of various data sources with Multiple Relational Databases like Oracle, DB2,Teradata, MS SQL Server and Worked on integrating data from XML files, flat files like fixed width and
Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
Experience in the successful implementation of ETL solution between an OLTP and OLAP database in Support of Decision Support Systems/Business Intelligence with expertise in all phases of SDLC.
Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors.
Extensively created Mapplets, common functions, reusable transformations, look-ups for better usability.
Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk-load.
Experienced with Teradata utilities FastLoad, Multi-Load, BTEQ scripting, FastExport, SQL Assistant.
Involved in Understanding and translating the business requirements and to High Level and Low-level design for ETL processes in Teradata, Data stage and Informatica.
Experience in Performance Tuning of mappings, ETL procedures and process and involved in complete life cycle implementation of data warehouse.
Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using Erwin, Visio.
Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization.
Extensive experience in implementing CDC using Informatica Power Exchange 9.x/8.x
Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with Databases like Oracle 11x/10g, SQL Server 2005, Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL files and XML files.
Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed
Effectively communicate with business, project manager and team members.
Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.
Databases/Databases Tools : Oracle 8i/9i/10g, SQL Server 2007, MS Access, DB2,
Teradata 13.0, TOAD 8.6, SQL plus, ERwin 4.0, Query
Analyzer, SQL Assistant, SQL, SAP Data Services,
ETL/Reporting Tools : Informatica Power Center 9.6.1, Power Mart 6.2/5.1.
Power Exchange9.0, IDQ 9.6.1, DVO.
Methodologies : Star Schema, Snowflake Schema, Fact and Dimension
Operating Systems : UNIX, LINUX, MS- DOS.
Languages/Utilities : SQL, PL/SQL, Unix shell scripts, HTML, XML.
Query/Reporting : SQL, TOAD 6.5, SQL*Plus, Business Objects 5.1/5.0.
UNION BANK, Irvine, CA Jul 16 - Present
Informatica ETL Developer
Description: This project is developed for maintaining a catalogue of all the products that are offered online to the customers. It involved extraction of data from multiple Source systems and loading them through an ETL process in to staging tables and then in to Target tables.
Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
Extensively involved in writing ETL Specifications for Development and conversion projects.
Created shortcuts for reusable source/target definitions, Reusable Transformations, Mapplets in Shared folder.
Involved in requirement definition and analysis in support of Data Warehouse.
Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
Worked with XSD and XML files generation through ETL process.
Defined and worked with mapping parameters and variables.
Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
Performed the performance evaluation of the ETL for full load cycle.
Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
Worked on Parameterize of all variables, connections at all levels in UNIX.
Created test cases for unit testing and functional testing.
Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.
Used Teradata as a source system.
Environment: Informatica:-Power center 9.5.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.
Kaiser Permanente, Irvine, CA Feb 15 – May 16
Informatica ETL Developer
Worked with business analysts and the DBA for requirements gathering, business analysis and designing and participated document review meetings.
Worked on Informatica Power Center tools - Source analyzer, Target designer, Mapping designer, Workflow manager, Mapplets designer and Transformation developer.
Designed and created mappings, sessions and workflows and schedule the workflow as per the functional & technical specifications.
Extracted the data from Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse.
Developed Complex SQL queries using SQL Server, T-SQL and Oracle PL/SQL.
Designed mappings using Connected/Unconnected Lookups, Filter, Expression, Aggregator and Router transformations for populating target tables.
Coordinated with Informatica Admin to setup the environment and to move objects to different repositories and folders.
Created and executed workflows and worklets using Workflow Manager to load the data into the target database.
Extracted and loaded data from XML documents by using XML Parser and Generator transformations.
Worked on repository manager to manage & assigned permissions to folders.
Defined Target Load Order Plan for loading data into different target tables.
Implemented slowly changing dimensions methodology to keep track of historical data.
Analyzed session log files to resolve errors in mapping and managed session configuration.
Created, configured, scheduled and monitored the sessions and workflows based on demand, run on time using Informatica Power Center Workflow Manager.
Involved in performance tuning at various levels including Target, Source, Mapping and Session for large data files.
Created and scheduled jobs in Control-M.
Worked extensively with PL/SQL, DB2 procedures to load the data.
Involved in unit and system testing of developed mappings.
Maintained naming standards and warehouse standards for future application development and created functional and technical specification documents.
Environment: Informatica PowerCenter 9.1, Power Exchange(PWX), Oracle 11g/10g, DB2, SQL, T-SQL Server, PL/SQL, Flat files, XML, Control-M.
T-MOBILE, Atlanta, GA Oct 13 – Jan 15
Description: T-Mobile is the third largest wireless career in US with 73 million customers, provides wireless voice and data services to their customers. The scope of the project includes producing customer data warehouse for data analysis purpose.
Developed Informatica conversion mappings according to the business rules and imported it through Mapping Architect Visio.
Involved in documenting technical specifications and the business data flow from source to targets.
Developed various complex Informatica mappings, mapplets and reusable transformations for loading data into data warehouse.
Implemented SCD Type1 and Type2 method in ETL mapping to load data into EDW.
Created different transformations like B2B Data transformation, Expression, Sorter, Aggregator, Router, Filter, Lookup, Sequence Generator, XML Generator, XML Parser, Web services, HTTP, SQL, Joiner and Update Strategy transformations for loading the data into the targets.
Created web services request-response mappings by importing source and target definition using WSDL file.
Created conversion scripts using Oracle SQL queries, functions and stored procedures, test cases and plans before ETL migrations.
Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
Worked in migrating mappings, sessions, workflows and common objects from development to acceptance and to production.
Created dashboard design and development in Tableau and use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions
Blended data from multiple databases into one report from each database for data validation.
Preparing Dashboards using calculations, parameters in Tableau.
Building SSIS packages to create ETL process and load data into SQL Server database for some of the SSRS Reporting requirements.
Created SQL Jobs to execute SSIS packages and publish data on the web server.
Deploying, Scheduling and Monitoring SSIS Packages in the development, acceptance and production environments.
Debugging, Troubleshooting, Optimization and performance tuning for SSIS packages.
Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2008/2012.
Responsible in handling on-call production support to fix the incidents on timely manner.
Used debugger tool to fix bugs and defects.
Environment: Informatica 9.5.1, Informatica B2B Data Exchange, Oracle 9i, DB2, MS SQL Server 2016, T-SQL, Microsoft Visual Studio 2008/2010, Tableau Desktop
Enterprise software solutions, Hyderabad Jan 12 – Aug 13
Description: Mercedes Benz Financial Services (MBFS) NEXUS program originated as a result of Mercedes Benz separation from Daimler Chrysler. The core project involves in development of Data Warehouse and different Data Mart components. Here we integrate data from 70+ heterogeneous IT systems and load it into 200+ tables which forms the data warehouse. Data marts are developed from this data warehouse based on different subject areas.
Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.
Developed mappings to extract data from SQL Server, Oracle, Flat files, and load into Data warehouse using the Mapping Designer.
Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
Written Queries, procedures, created Indexes, primary keys and data bases testing.
Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
Defects were tracked, reviewed and analyzed.
Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
Environment: Informatica PowerCenter 9, SQL Server 2012, Flat files
Triad techno services, Hyderabad Nov 10 - Dec 11
Description: This project involves building of a Data Warehouse solution to meet the various requirements of Valeant Pharmaceuticals Sales depots, which are located across the country. The basic requirements for Valeant Pharmaceuticals with respect to sales and distribution are
Stock availability across location and products
Extracting data from sources like Oracle and Flat Files. And transforming them using the business logic and loading the data to the target warehouses.
Analyzing Source Database Objects as per the warehouse Database requirements.
Designed mapping Requirement Diagrams based on Source and Target Databases.
Developed mappings as per the Requirement, Using the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.,
Developed User defined Transformation and Mapplets for Reusability of code.
Handled Multiple Database Connectivity including oracle, SQL Server, Teradata.
Extensively used Dynamic and Static Lookup to improve the performance of mapping rather than Joiner Transformations.
Tested Mappings using Debugger and Workflow Manager using Test Scripts for Accuracy of Data as well as for Performance.
Environment: ETL: Informatica 8.6, Oracle 9i, Flat Files.