Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vamsi M

Summary

Had 12 Years of IT Experience in IICS, Big data, ETL Design, Development, Support, Enhancement and Maintaining Data warehousing applications. Extensive knowledge in Python, SQL, PLSQL, T-SQL and Linux. Proactive & goal-oriented professional with established record of success in leading corporate technology initiatives; Adaptability to changing business environments. Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling and Slowly Changing Dimensions. Expertise in OLTP/OLAP Systems and analysis. Extracted the data from various sources like SFDC, Salesforce CRM, Siebel CRM, flat files, and other RDBMS databases into staging area and populated onto Data warehouse. Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Lookup, SQL, Stored Procedure and Union to develop robust mappings, mapping tasks and task flows in the Informatica Designer and IICS. Developed complex informatica cloud task flows (parallel) with multiple mapping tasks and Task flows. Developed mass ingestion tasks to ingest large datasets from on-prem to AWS cloud -file ingestion. Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow. Used Type 2 SCD mappings to update slowly Changing Dimension Tables. Modified existing mappings for enhancements of new business requirements. Involved in Performance tuning at source, target, mappings, sessions, and source systems. Prepared migration document to move the Informatica objects from development to testing and then to production repositories. Hand on experience UNIX, power shell Scripting skills with any of the following languages (Ksh, Bash). Knowledge of Microsoft Azure, Snowflake and IICS. Knowledge of Tableau visualization tool. Proactive ETL Developer with [8] years carefully handling and transforming data loads to suit customer needs. Versed in all dominant information modeling designs and mapping technologies. Dedicated to flawless ETL integrity and impeccable data security during all database maintenance and modification tasks.

Overview

12
12
years of professional experience

Work History

Data Governance /Senior ETL Developer

AltaMed
03.2023 - Current
  • Coordinating with Business users analyzing the business requirements and translating them into technical requirements
  • Worked on ETL packages to pull members, Enrollment data and associated claims data from FACETS into Data warehouse
  • Generated CMS and State regulatory mandated compliance reports by working with business users
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
  • Parsed high-level design specification to simple ETL coding and mapping standards
  • Designed and customized data models for Data warehouse supporting data from multiple sources in real time
  • Involved in building the ETL architecture and Source to Target mapping to load data into Datawarehouse
  • Created mapping documents to outline data flow from sources to targets
  • Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions, and measured facts
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
  • Developed mapping parameters and variables to support SQL override
  • Created mapplets to use them in different mappings
  • Developed mappings to load into staging tables and then to Dimensions and Facts
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, and scheduling of the workflow
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loaded it into data warehouse
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
  • Extensively used SQL
  • Loader to load data from flat files to the database tables in Oracle
  • Extensively worked on SFDC Salesforce, Salesforce CRM as source systems
  • Modified existing mappings for enhancements of new business requirements
  • Used Debugger to test the mappings and fixed the bugs
  • Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Senior ETL Developer

Apple
09.2022 - 02.2023
  • Developed ETL processes and objects such as jobs, transformations, mappings, sessions using Informatica PowerCenter 9.6.
  • Designed and developed complex mappings with multiple sources and targets to extract data from multiple systems.
  • Created error handling logic for all the mappings to capture any errors during the ETL process.
  • Developed PL and SQL stored procedures to perform various tasks like validation of data in staging area before loading into target tables.
  • Optimized existing ETL processes by applying different techniques like partitioning, indexing.
  • Configured workflow tasks such as event wait, email task for scheduling purposes.
  • Identified bottlenecks in ETL process and resolved them by analyzing the session log files.
  • Performed unit testing on the developed code to identify any bugs or issues prior to deployment.
  • Assisted business analysts with gathering requirements needed for successful completion of projects involving Data Warehouse development activities based on client's needs.
  • Implemented performance tuning techniques on mappings, sessions and workflows to improve throughput rate of ETL process.
  • Worked closely with database administrators team while developing database objects such as triggers, cursors, required for ETL development activities.
  • Created technical documents including high-level design document, low-level design document and user manual documents related to the development activities done in Informatica PowerCenter 9.6 environment.
  • Provided production support for troubleshooting issues related to Informatica PowerCenter components like source qualifier transformation, lookup transformation .
  • Developed shell scripts used for executing batch jobs and monitoring their progress through automated alerts system setup using crontab utility in Linux environment.
  • Monitored daily load status of all the Informatica workflows running in production environment using command line interface.
  • Involved in debugging source code written in SQL language used by Informatica PowerCenter components while extracting data from Oracle databases into flat files or vice versa.
  • Collaborated with other teams such as QA team members for bug fixing activities during UAT phase of project life cycle.
  • Participated actively in weekly meetings held between IT team members discussing about new initiatives taken up by organization concerning Data Warehousing technologies like Hadoop MapReduce framework.
  • Managed end-to-end operations of ETL data pipelines, maintaining uptime of 95%.
  • Applied Conceptual, Logical and Physical & Dimensional/Relational model designs to ETL tasks.
  • Analyzed code and corrected errors to optimize output.
  • Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.
  • Reviewed project requirements to identify customer expectations and resources needed to meet goals.
  • Recommended improvements to facilitate team and project workflow.
  • Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
  • Analyzed user needs and software requirements to determine design feasibility.
  • Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.
  • Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
  • Improved and corrected existing software and system applications.
  • Coordinated system installations, testing and code corrections.
  • Integrated object-oriented design and development techniques into projects to support usability goals.
  • Assessed code during testing stage to determine potential glitches and bugs.
  • Coordinated installation of software systems and collaborated with user experience team on design and implementation of new features.
  • Coordinated testing and validation procedures through software development lifecycle.
  • Modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.
  • Utilized established design patterns to expedite novel software creation and support consistent performance results.

Senior ETL Developer

Wipro Technologies
Bangalore
02.2021 - 08.2022
  • Developed ETL processes and objects such as jobs, transformations, mappings, sessions using Informatica PowerCenter 9.6.
  • Designed and developed complex mappings with multiple sources and targets to extract data from multiple systems.
  • Created error handling logic for all the mappings to capture any errors during the ETL process.
  • Developed PL and SQL stored procedures to perform various tasks like validation of data in staging area before loading into target tables.
  • Optimized existing ETL processes by applying different techniques like partitioning, indexing.
  • Configured workflow tasks such as event wait, email task for scheduling purposes.
  • Identified bottlenecks in ETL process and resolved them by analyzing the session log files.
  • Performed unit testing on the developed code to identify any bugs or issues prior to deployment.
  • Implemented performance tuning techniques on mappings, sessions and workflows to improve throughput rate of ETL process.
  • Worked closely with database administrators team while developing database objects such as triggers, cursors, required for ETL development activities.
  • Created technical documents including high-level design document, low-level design document and user manual documents related to the development activities done in Informatica PowerCenter 9.6 environment.
  • Provided production support for troubleshooting issues related to Informatica PowerCenter components like source qualifier transformation, lookup transformation .
  • Developed shell scripts used for executing batch jobs and monitoring their progress through automated alerts system setup using crontab utility in Linux environment.
  • Monitored daily load status of all the Informatica workflows running in production environment using command line interface.
  • Involved in debugging source code written in SQL language used by Informatica PowerCenter components while extracting data from Oracle databases into flat files or vice versa.
  • Assisted business analysts with gathering requirements needed for successful completion of projects involving Data Warehouse development activities based on client's needs.
  • Collaborated with other teams such as QA team members for bug fixing activities during UAT phase of project life cycle.
  • Participated actively in weekly meetings held between IT team members discussing about new initiatives taken up by organization concerning Data Warehousing technologies like Hadoop MapReduce framework.
  • Applied Conceptual, Logical and Physical & Dimensional/Relational model designs to ETL tasks.
  • Analyzed code and corrected errors to optimize output.
  • Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.
  • Reviewed project requirements to identify customer expectations and resources needed to meet goals.
  • Recommended improvements to facilitate team and project workflow.
  • Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
  • Analyzed user needs and software requirements to determine design feasibility.
  • Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.
  • Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
  • Improved and corrected existing software and system applications.
  • Coordinated system installations, testing and code corrections.

ETL Developer (Informatica PowerCenter)

DELL
07.2015 - 01.2021
  • Involved in using Informatica PowerCenter and Source to Target mapping to load data into Data warehouse
  • Providing periodic updates to customers on the coding, unit testing, release, and acting as Coordinator between development and business team
  • Involved in Migrating Objects from Teradata to Snowflake
  • Created mapping documents to outline data flow from sources to targets
  • Parsed high-level design specification to simple ETL coding and mapping standards
  • Developed Schedules for monthly batches using Control-M
  • Created Complex ETL Packages using Source systems to extract data from staging tables to partitioned tables with incremental load
  • Developed data warehouse model in snowflake for over 100 datasets using Scape
  • Performed data manipulations using various Transformations like Filter, Expression, Lookup, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter, and Union
  • Worked extensively on Teradata Utilities and used Teradata as a source system
  • Responsible for monitoring all the sessions that are running, scheduled, completed, and failed, debugged the mapping of the failed session
  • Analyzed and Created Facts and Dimension Tables
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
  • Written documentation to describe program development, logic, coding, testing, changes, and corrections
  • Involved in developing pre and post session commands scripts to the session properties to analyze the statistics before the actual load happens
  • Within specified time, projects are delivered making sure all the requirements gathering, business analysis and designing of the data marts
  • Used various Informatica Cloud Task – Data Replication, Data Synchronization and Mapping Task Created various Mappings and designed various Task flows to load the data Files into AWS S3 from SQL Server
  • Prepared ETL mapping specification document
  • Assisted Testing team in creating test plan and test cases
  • Involved in creating multi-dimensional universe and reports in Business Objects Environment
  • Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules
  • Worked on loading Flat Files into Data warehouse.

ETL Developer

AT&T
01.2012 - 06.2015
  • Understanding business rules and sourcing data from multiple source systems
  • Extracted the raw data from Microsoft SQL Server to staging tables using oracle Datawarehouse
  • Developed Cloud mappings to extract the data for different regions
  • Refreshing the mappings for any changes/additions to Microsoft SQL Server source attributes
  • Developed the audit activity for all the cloud mappings
  • Automated/Scheduled the cloud jobs to run daily with email notifications for any failures
  • Generated automated stats with the staging loads comparing with the present day counts to the previous day counts
  • Created File watcher jobs to setup the dependency between Source systems and PowerCenter jobs
  • Created and developed mappings to load the data from staging tables to EDW DataMart tables based on Source to Staging mapping design document
  • Implemented Type1, Type2, CDC and Incremental load strategies
  • Followed ETL standards - Audit activity, Job control tables and session validations
  • Loading data to the staging tables following the Data Integrity rules of Interface Design Specifications
  • Used source external tables to load the data to the staging tables
  • Created mapping documents to outline data flow from sources to targets
  • Modified existing mappings for enhancements of new business requirements
  • Used Debugger to test the mappings and fixed the bugs
  • Prepared migration document to move the mappings from development to testing and then to production repositories
  • Created Pre/Post Session/SQL commands in sessions and mappings on the target instance
  • Used Exceptional mappings to generate dynamic parameter files after the staging loads
  • Used Shared folders to create reusable components (Source, target, email tasks)
  • Developed single dynamic ETL mapping to load more than 30 reference tables
  • Used SQL Queries to validate the data after loading
  • Maintained and automated the production database to retain the history backup tables for 30 days
  • Developed/Automated (PowerCenter) jobs through Control M.

Education

Master’s in embedded systems -

Satyabhama University
04.2011

Bachelor’s in electronics engineering -

SRTMU
06.2009

Skills

  • Informatica Power Center
  • Informatica Data Quality
  • SQL
  • PL/SQL
  • Python
  • Unix Shell Scripting
  • Linux
  • UNIX
  • Windows
  • Big data
  • Oracle
  • SQL Server
  • Postgress Sql
  • Greenplum
  • Teradata
  • Hana
  • Snowflake
  • IICS
  • MicrosoftAzure
  • Git
  • GitHub
  • Jenkins
  • Maven
  • Pipelines
  • Code quality
  • Scans
  • Tableau
  • FR
  • Power BI
  • Control-M
  • Tcc

Timeline

Data Governance /Senior ETL Developer

AltaMed
03.2023 - Current

Senior ETL Developer

Apple
09.2022 - 02.2023

Senior ETL Developer

Wipro Technologies
02.2021 - 08.2022

ETL Developer (Informatica PowerCenter)

DELL
07.2015 - 01.2021

ETL Developer

AT&T
01.2012 - 06.2015

Master’s in embedded systems -

Satyabhama University

Bachelor’s in electronics engineering -

SRTMU

Similar Profiles

CREATE PROFILE
Vamsi M