Summary
Overview
Work History
Education
Skills
Certification
Career Accomplishments
Timeline
Generic

Mallikarjuna Amedela

Bengaluru

Summary

  • 14 years of strong experience in the Analysis, Design, Development, Testing and Implementation of Business Application Systems for Data Warehousing industry vertical like banking & insurance Sector using Informatica Platforms (Informatica PowerCenter 8.6/9.1/9.5).
  • Having 5+ years of experience in developing large scale Data Warehouse Application on Big Data Platforms using Informatica BDM/Informatica Data Engineering Integration (DEI) 10.1.0, 10.2.2 and 10.4.1, 10.5.4.
  • Strong Data warehousing experience specializing in Hive RDBMS, ETL Concepts, Strategy, Design, Development & Testing. Good knowledge of Performance Tuning of Informatica 7.x, 8.x, 9.x and Informatica BDM/DEI 10.5.5.
  • Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
  • Having experience in using Native, Non-native engines - Blaze, spark.
  • Extensively involved in code migration to UAT and Production, support and incident management, troubleshooting.
  • Having knowledge on Azure Data Factory and Databricks.
  • Onsite exposure – client site at Singapore, London and Dubai.

Overview

16
16
years of professional experience
5
5
years of post-secondary education
3
3
Certifications

Work History

Lead software Engineer

Virtusa Consulting services Ltd
04.2024 - Current
  • Involved in analysis, Solution design, Development, code review, Testing and deployment of Informatica BDM objects
  • Informatica BDM Mapping Creation, Workflow Creation and Application Creation
  • Involved data load from source system to RDV, TDV and Hadoop data ingestion layers using spark ddi framework & Informatica
  • Involved Oozie files generation jobs scheduling and data loads
  • Created various mappings using Non-native using spark and Native
  • Actively participated in testing of BDM mappings, bug fixing and troubleshooting the issues
  • Involved in code deployment, execution, big fixes during UAT testing and production deployment
  • Involved in Production support, identifying issues and updated daily status

L4-Lead

HTC Global Services
05.2022 - 03.2024
  • Involved in analysis, Solution design, Development, code review, Testing and deployment of Informatica BDM objects
  • Informatica BDM Mapping Creation, Workflow Creation and Application Creation
  • Creating data flow for various stages of the using Informatica BDM tool
  • Developed BDM mappings and workflows to extract data from Hive to Staging and Staging to EDW
  • Created Stage, Scd1, Scd2 and Incremental load mappings
  • Involved in performance tuning of Informatica BDM mappings
  • Actively participated in testing of BDM mappings, bug fixing and troubleshooting the issues
  • Involved in code deployment, execution, big fixes during UAT testing and responsible for daily status updates
  • Involved in Team coordination on various issues and represented in daily agile standup meeting board

Assistant Consultant

TCS
06.2012 - 02.2022
  • Involved in analysis, Solution design, Development, code review, Testing and deployment of Informatica BDM objects
  • Informatica BDM Mapping Creation, Workflow Creation and Application Creation
  • Creating data flow for various stages of the ELT (Extract Load Transform) in and out of the Big Data environment
  • Developed BDM mappings and workflows to extract data from HIVE to Oracle and HIVE, Aws S3 files
  • Involved in creating Hive tables and queries and UNIX scripts
  • Involved in performance tuning of Informatica BDM mappings
  • Actively participated in testing of BDM mappings, bug fixing and defect tracking till closure
  • Involved in deployment activities creating labels in RMS, UKDT’s tracked deployment till SIT
  • Involved in Team coordination on various issues and represented in daily agile standup meeting board

Senior Software Engineer

iGATE Global Solutions
03.2010 - 06.2012
  • Prepared Request for Proposal for the project as well as estimates and SLA's to the client
  • Prepared design document sand test case result documents
  • Established the technical infrastructure.
  • Extensively used Informatica client tools–SourceAnalyzer, WarehouseDesigner, MappingDesigner, WorkflowManager,and WorkflowMonitor
  • Maintained Project status reports for audit purpose.
  • Developed several reusable transformations and maplets that were used in other mappings.
  • Interacting with the technical support team in establishing required connections for the team and assisting team in resolving any kind of connection issues
  • Perform technical reviews of code and testplans created by team members.

ETL Developer

Magna Infotech Pvt Ltd
07.2009 - 01.2010

Education

MBA -

Sri Venkateswara University
Tirupati, India
04.2001 - 01.2006

Skills

InformaticaBDM /Informaitca PC,Impala,Hive

Azure Data Factory

Airflow

RDS

Zeena

Hadoop-HDFS

SQL

Oracle

Unix

DB2

Issue resolution

Code reviews

Technical documentation

Technical requirements

Troubleshooting and resolution

Code development

Team collaboration

Code debugging

JIRA

Performance tuning

Agile

Incident Management

Hive

Impala

Certification

ITIL Foundation, 2011

Career Accomplishments

  • Received Award of excellence TCS for outstanding delivery in meeting customer expectations and for completing regulatory critical project within defined time and at highest quality.
  • On the spot and Best team awards in TCS.
  • Appreciations from the Client and Project Manager in many scenarios like performance tuning, production support and team coordination.

Timeline

Lead software Engineer

Virtusa Consulting services Ltd
04.2024 - Current

L4-Lead

HTC Global Services
05.2022 - 03.2024

Assistant Consultant

TCS
06.2012 - 02.2022

Senior Software Engineer

iGATE Global Solutions
03.2010 - 06.2012

ETL Developer

Magna Infotech Pvt Ltd
07.2009 - 01.2010

MBA -

Sri Venkateswara University
04.2001 - 01.2006

Similar Profiles

CREATE PROFILE
Mallikarjuna Amedela