Srikanth Reddy Vangala

Data Architect

Medline Industries, LP

Jan 2026 - Current (10 months)

Responsible for working with product team to design and implement data solutions. And responsible for the method and processes used to translate business needs into functional and technical specifications. Design, develop, and maintain robust data sets used for reporting and AI model serving. Responsible for building new Data Products in Azure, as well as optimizing data flow and integrations with external customers. Write efficient and scalable Spark code, creating high quality datasets that will be used for customer interaction and reporting. Participate in code reviews and contribute to best practices for data engineering.

Azure Data Engineer/ Data Architect

Mutual Of Omaha

Jan 2025 - Current (1 year 10 months)

• Collaborated with cross-functional teams to define data requirements, implement governance policies, and establish a data culture, leveraging Fabric's git integration for version control and collaborative development.
• Migrated legacy on-premise data infrastructure to Microsoft Fabric, leveraging shortcuts to connect to existing data sources.
• Planned, Designed and Implemented ETL Pipelines using ADF for data migration.
• As a part of Migration used Azure Data Factory and extracted data and loaded from source systems like SQL Server, CSV, Flat files to Azure Blob storage.
• Created pipelines using Azure Data Factory with datasets, transformations and loaded in Data Lake Storage2.
• Migration of on-premise data (

E

ETL Lead/Data Architect

Oct 2023 - Jan 2025 (1 year 4 months)

• Understand business requirements and prepare a design document, coding, testing and go on live production environment.
• Extract transforms and load data from source systems to Azure Data Storage services using Azure Data Factory, T-SQL, Spark SQL.
• Created pipelines in Azure Data Factory using datasets and loaded data from different sources like Azure SQL, Blob storage, SQL Data warehouse.
• Created business glossary in Purview, collaborating with data stewards and business users to define consistent data terms and improve data discoverability for analytics teams.
• Created data lineage tracking in Purview, providing comprehensive visibility into data movement from source systems to dashboards and supporting audits f

F

ETL Lead/Big Data Architect

Federal Tax Board

Oct 2021 - Jun 2023 (1 year 9 months)

• Data analysis and understanding business requirements from SMEs (BA’s). Liaising with business users for data extraction.
• Worked with Solution Architect on dimensional modelling and making recommendations on design. Also worked with SMEs to understand business requirements.
• Involved in data flow design document and technologies stack decision as part of the project.
• Worked on Python programing to ingest the data from Blob storage to snowflake using various custom programs and complex Snow SQL.
• Developed Spark applications for data extraction, transformation and aggregation from multiple systems and stored on Azure Data Lake storage using Azure Databricks notebooks.
• Writing complex snow SQL scripts in sno

Big Data Engineer/Sr. ETL developer

HCA HEALTHCARE

Apr 2021 - Oct 2021 (7 months)

• Design and develop ETL integration patterns using PySpark.
• Develop framework for converting existing mappings and to PySpark (Python and Spark) Jobs.
• Designed and developed Framework to provide fine grained access to objects in AWS S3 using AWS Lambda, Dynamo DB.
• Loading data from on-premises to AWS S3 by using Informatica Developer.
• Performed the roles of ETL Informatica and Data Quality (IDQ) developer on a data warehouse initiative and was responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (DW), perform data cleansing activities using various IDQ transfor

Senior ETL Developer

CNA insurance

Feb 2020 - Mar 2021 (1 year 2 months)

• Implemented Informatica BDM mappings for extracting data from DWH to Data Lake.
• Involved setting up Hadoop configuration (Hadoop cluster, Hive connection) using Informatica BDM.
• Design & development of BDM mappings in Hive mode for large volumes of INSERT/UPDATE.
• Used IDQ Mapping variables/output and capture into workflow variables.
• Involved in database migration from Sybase to PostgreSQL and Oracle to PostgreSQL & MYSQL using conversion tools like ORA2PG & SQL lines for tables, schema conversions. Migrated the database instances like Oracle, Sybase & DB2 to PostgreSQL and MYSQL to move to GCP cloud.
• Closely worked with Business users, Informatica Product support group and Hortonworks teams.
• Worki

Senior ETL Developer

Ameriprise Financial Services, LLC

Jul 2019 - Jan 2020 (7 months)

Engage with business partner, stakeholders to drive Problem Management related improvements.
• Working with business users for requirement gathering, business analysis, and translated the business requirements into technical specifications along with Internal and External Design documents.
• Analyzing business goals and provide IT solutions by applying application and architecture design principles.
• Assessing current technical architecture and develop Solution design, System architecture documents and Visio diagrams as per Enterprise Architecture guidelines.
• Worked on Informatica BDM mappings for extracting data from DWH to Data Lake

Architect II

American Express

Jul 2018 - Jun 2019 (1 year)

• Working with business users for requirement gathering, business analysis, and translated the business requirements into technical specifications along with Internal and External Design documents.
• Integrating Informatica BDM 102 with the Cloudera and Horton Hadoop Frameworks. This includes the post install configuration to of Informatica and run few test mappings to read data from a flat file/Oracle/SQL Server/Teradata and write it to the HDFS/Hive using JDBC and Sqoop.
• Use case was to move the traditional data warehouses to Hive which involved moving the existing code from power center to BDM creating few onetime mappings on MRS.
• Prepare and Publish Problem Management related documentation, process and procedures.

Solution Architect

Independent Health

Oct 2016 - Jul 2018 (1 year 10 months)

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational conn

E

ETL Lead

Feb 2016 - Sep 2016 (8 months)

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Identified and created aggregate tables to improve query performance.
• Assigned Data level & UI level security to the Users and managed security privileges for each subject area and dashboard according to user requirements.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-d

ETL Lead

CIMB

Feb 2015 - Jan 2016 (1 year)

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational conn

Associate Manager

NTT DATA North America

Jul 2013 - Jan 2015 (1 year 7 months)

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level.
• Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relation

i

Team Lead

iGrid Technologies

Feb 2011 - Jul 2013 (2 years 6 months)

• Installation of Informatica 9.1 and Autosys 5.0 Instances on a Solaris OS with single node architecture and multiple file systems for different applications.
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Coordinating with Business Teams / Functional Subject Matter Experts (SME) to gather Requirements and transforming them into technical specifications for the ETL Designs through which Implement ETL solutions using Informatica Power Center (v8.1.1/8.6.1/(9.0 – Started recently)
• Experienced in facilitating deployment of the ETL jobs into the Production environment along with primary production support which involved handling Change Requests and Defect Resolution and testing t

Senior Software Engineer

Accenture

Sep 2007 - Jan 2011 (3 years 5 months)

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into BID.
• Extracted the data from Flat files, Oracle, DB2 and load the data into flat files, Oracle and DB2 Using Informatica Power center
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Designing and developing ETL solutions in Informatica Power Center
• Designing ETL process and

L

Software Engineer

Leo Labs Technologies

Jan 2004 - Aug 2007 (3 years 8 months)

• Translated Business processes into Informatica mappings for building Data warehouse.
• Developed complex ETL logic to match 21st Century leads with Farmers policies to see how many converted to Farmers.
• Creation of shortcuts for source, targets and created transformations according to business logic.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, Aggregator, Update Strategy and Joiner while migrating data from various heterogeneous sources like Oracle, COBOL source, XML and Flat files to UDB DB2.
• Developed mapplets, mappings and configured sessions.
• Handled Slowly Changing Dimensions to populate current and historical data to Dimension Tables and Fact tables

Srikanth Reddy Vangala

About

Detail

Timeline

Résumé

Srikanth Reddy Vangala

About

Detail

Behavioral traits