Summary
Overview
Work History
Education
Skills
Technical Skill Set
Timeline
Generic

Kartheek G

Charlotte,NC

Summary

  • Eight plus (8+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
  • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools � Informatica Server, Repository Server manager.
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
  • Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
  • Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
  • Strong experience in Extraction, Transformation and 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.
  • Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
  • Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
  • Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
  • Experience in using Automation Scheduling tools like Autosys and Control-M.
  • Worked extensively with slowly changing dimensions.
  • Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

Overview

9
9
years of professional experience

Work History

Sr. ETL Developer

Charles Schwab
02.2021 - Current
  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Designed ETL specification documents for all the projects.
  • Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
  • Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
  • Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
  • Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
  • Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
  • Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
  • Extensively used workflow variables, mapping parameters and mapping variables.
  • Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Implemented Informatica recommendations, methodologies and best practices.
  • Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Involved in Unit, Integration, System, and Performance testing levels.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Migrated the code into QA (Testing) and supported QA team and UAT (User).
  • Created detailed Unit Test Document with all possible Test cases/Scripts.
  • Conducted code reviews developed by my team mates before moving the code into QA.
  • Provided support to develop the entire warehouse architecture and plan the ETL process.
  • Modified existing mappings for enhancements of new business requirements.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Involved in production support.
  • Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

ETL Developer

US Bank
08.2019 - 01.2021
  • Modified existing / developed new complex Informatica Power Center Mappings to extract and pull the data according to the guidelines provided by the business users and populate the data into Target Systems.
  • Interact with BusinessAnalyst to assist him in understanding the Source and Target System.
  • Responsible to pull the data from XMLfiles, Flatfiles Fixed width Delimited and COBOL files by using complex transformations like Normalizer, XMLSourceQualifieretc.
  • Extracted and transformed data from various sources like Teradataand relational databases Oracle, SQLServer .
  • Involved in generating MLOADand TPUMPscripts to load the data into Teradata tables.
  • Created Mappings using Mapping Designer to load the data from various sources, using different transformations like SourceQualifier, Expression, Lookup Connected and Unconnected , Aggregator, UpdateStrategy, Joiner, Filter, and Sorter transformations.
  • Developed complex mappings using transformations such as Aggregator, Connected and UnconnectedLookup, Filter, Joiner, Expression, Filter, Sorter, Router, Normalizer, SourceQualifier and UpdateStrategy.
  • Worked extensively to create views using Composite queries and publish them as web link.
  • Sourced data using WEBSERVICES transformation.
  • Extensively worked on MappingVariables, MappingParameters, WorkflowVariables and SessionParameters.
  • Worked on different tasks in Workflows like sessions, eventsraise, eventwait, decisionmail, command, Worklets, assignment, timer and scheduling of the workflow.
  • Worked on Power Center Designer tools like SourceAnalyzer, TargetDesigner, MappingDesigner, MappletDesigner and TransformationDeveloper.
  • Used Debuggerwithin the Mapping Designer to test the data flow between source and target and to troubleshoot the invalidmappings.
  • Designed and developed UNIXShellscripts to report job failurealerts.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel initial Incremental Load.
  • Worked on SQL tools like TOADand SQLDeveloperto run SQLQueries and validate the data.
  • Scheduled Informatica Jobs through Autosysscheduling tool.

ETL Developer

Verizon
05.2018 - 08.2019
  • Translated requirements into business rules made recommendations for innovative IT solution
  • Involved in analyzing scope of application defining relationship within between groups of data star schema etc.
  • Analysis of star schema in dimensional modeling and Identifying suitable dimensions and facts for schema.
  • Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
  • Documented data conversion integration load and verification specifications.
  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Maintained warehouse metadata naming standards and warehouse standards for future application development.
  • Extensively used ETL to load data from wide range of sources such as flat files and Oracle to XML Documents.
  • Worked with the various enterprise groups to document user requirements translate requirements into system solutions and produce development testing and implementation plan and schedule.
  • Used transformations like Joiner Expression Connected and Unconnected lookups Filter Aggregator Store Procedure Rank Update Strategy Java Transformation Router and Sequence generator.
  • Developed documented and executed unit test plans for the components
  • Involved in Informatica administrative work such as creating Informatica folders repositories and managing folder permissions.
  • Worked with ETL Developers and SQL Server DBA Team
  • Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
  • Used XML schema to extract data from Oracle Teradata into XML using Export Option in Informatica.
  • Created pre-session and post-session shell scripts and mail-notifications.
  • Developed Shell scripts using UNIX to drop and recreate indexes and key constraints.
  • Used TOAD to develop oracle PL/SQL Stored Procedures.
  • Extensively worked on the Informatica Designer Repository Manager Repository Server Workflow Manager/Server Manager and Workflow Monitor.
  • Created Workflows containing command email session decision and a wide variety of tasks to load the data into Target database.
  • Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
  • Employed performance tuning to improve the performance of the entire system.
  • Performed Pipeline partitioning to speed up mapping execution time.
  • Creating the design and technical specifications for the ETL process of the project.
  • Used Informatica as an ETL tool to create source/target definitions mappings and sessions to extract transform and load data into staging tables from various sources.
  • Maintain Development Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.

Informatica Developer

Old National Bank
01.2017 - 04.2018
  • Old National Bank is a multi-billion dollars, multi-state Financial Services company Headquartered in Evansville, Indiana
  • As the largest independent banking company Based in Indiana, it is providing to customers with a comprehensive range of financial Products and services, including Commercial and Retail Banking, Credit Card Services, Electronic Banking, Trust and Asset Management, Brokerage, and Insurance Services
  • This bank involved in amounts for various purposes like Personal Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc
  • The company requires different level of analysis regarding loan amount, type of customers’ type of payment schedules, interest rates, defaulters list and the penal interest calculations, etc
  • The data warehouse, basically it is a Data Mart as it covers only one domain of the business and captures data from their Historical Database.

ETL Developer

Hewlett and Packard
01.2015 - 07.2016
  • Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
  • Involved in creating Logical and Physical Data Models and creating Star Schema models.
  • Assisted in designing Star Schema to design dimension and fact tables.
  • Involved in developing star schema model for target database using ERWIN Data modeling.
  • Worked on Informatica PowerCenter - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer .
  • Created Complex mappings using Unconnected and connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
  • Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files
  • Created Mapplet and used them in different Mappings.
  • Used sorter transformation and newly changed dynamic lookup.
  • Created events and tasks in the work flows using workflow manager.
  • Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
  • Created Schema objects like Indexes, Views and Sequences.
  • Daily production supports for the scheduled job and provide the resolution related to failed job and fixed them.
  • Created Stored Procedures, Functions and Indexes Using Oracle.
  • Worked on batch processing and file transfer protocols.
  • Performance tuning of the workflow which are taking time.
  • Analyzed the enhancements coming from the individual Client for application and implemented the same.
  • Creation of technical documents.
  • Developed mappings for policy, claims dimension tables.
  • Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.

Education

Skills

  • Data Warehousing Management
  • ETL Modeling
  • SQL Programming
  • Object-Oriented Programming
  • Agile/Scrum Methodology
  • Source and Version Control: Git, Github
  • RDMS Development and SQL
  • Amazon Web Services
  • SDLC Compliance
  • ETL Processes
  • Design Development
  • Data Evaluation
  • Standards Development
  • Performance Tuning
  • Debugging and Troubleshooting
  • JIRA

Technical Skill Set

Informatica Power Center 10.x/9.x/ 8.x, Informatica Data Quality 10.x(IDQ), Informatica Power Exchange 9.x, IICS (Informatica Intelligent Cloud Services), Dimensional Modeling (Star Schema, Snowflake, Fact, Dimensions), Erwin, Waterfall model, Agile, Visual source safe, Oracle, DB2, SQL Server, Teradata, IICS, AWS, Windows 7/2003/2013/, Unix, Mac, Cron, Autosys, Control-M, Business Objects, MicroStrategy

Timeline

Sr. ETL Developer

Charles Schwab
02.2021 - Current

ETL Developer

US Bank
08.2019 - 01.2021

ETL Developer

Verizon
05.2018 - 08.2019

Informatica Developer

Old National Bank
01.2017 - 04.2018

ETL Developer

Hewlett and Packard
01.2015 - 07.2016

Similar Profiles

  • Jacob Bridges

    Jacob BridgesJacob Bridges

    Financial Services Representative at Charles SchwabFinancial Services Representative at Charles Schwab

  • Miranda Withers

    Miranda WithersMiranda Withers

    Onboarding and Educational Development at Charles Schwab & CoOnboarding and Educational Development at Charles Schwab & Co

  • Sterling K. Smith

    Sterling K. SmithSterling K. Smith

    Senior Specialist, Client Services & Support Operational Support Account Solutions at Charles Schwab & Co.Senior Specialist, Client Services & Support Operational Support Account Solutions at Charles Schwab & Co.

  • Brady Humbert

    Brady HumbertBrady Humbert

    Stock Plan Services Operations and Support Specialist at Charles Schwab & Co., Inc.Stock Plan Services Operations and Support Specialist at Charles Schwab & Co., Inc.

  • Samantha Cotton

    Samantha CottonSamantha Cotton

    Manager at Mellow MushroomManager at Mellow Mushroom

CREATE PROFILE
Kartheek G