Vedasree Veerabomma Data Engineer

Data Engineer

BNY Mellon

Feb 2023 - Current (3 years 7 months)

• Utilize Python scripting for automating Informatica workflows and ETL processes, integrating libraries like pandas and NumPy for efficient data manipulation. • Implement machine learning algorithms, leveraging Python libraries such as scikit-learn and TensorFlow, to enhance data analysis and predictive modeling. • Collaborate with data scientists to integrate machine learning models into Informatica workflows, optimizing data transformation and decision-making processes. • Develop custom Python scripts to extend the functionality of Informatica transformations and mappings, ensuring seamless integration with existing infrastructure. • Stay abreast of Python and machine learning advancements, applying best practices to optimize perfor

M

Data Engineer

Molina Health Care- HEDIS-AMS SUPPORT

May 2022 - Jan 2023 (9 months)

• Provide dedicated support for Informatica workflows and mappings (version 10.1) at client locations, ensuring seamless production environment operation. • Perform configuration updates using SQL queries and Python scripting, while monitoring job execution in Autosys for timely operations and data integrity. • Validate Autosys job success, debug failures through logs, and utilize Python with NumPy and Pandas for data analysis, while documenting remediation processes for future reference. • Write Autosys JILs, schedule Informatica workflows, and automate tasks using Python, incorporating NumPy, Pandas, and MS Excel for efficient job execution and resource utilization.

H

ETL Developer

Horizon BCBS

Jul 2021 - May 2022 (11 months)

• Spearhead the design, development, and testing of ETL mappings, workflows, and worklets using Informatica PowerCenter, ensuring adherence to project timelines and specifications. • Implement advanced optimization techniques in ETL Informatica code at mapping and session levels, leveraging deep expertise in SQL queries to maximize database performance. • Execute rigorous data validation in target tables through the implementation of complex SQL queries, guaranteeing data accuracy and integrity across all modules. • Develop and deploy UNIX shell scripts for Informatica pre/post session operations, automating routine tasks and streamlining workflow execution for maximum efficiency. • Orchestrated the design, development, and documentati

ETL Developer

Discover Financial Services

Aug 2019 - Jun 2021 (1 year 11 months)

V

ETL/ Informatica Developer

VetSez INC

Sep 2017 - Jun 2019 (1 year 10 months)

• Analyzed business requirements and formulated Business Logic for ETL Process, maintaining the ETL process using Informatica Power Center, ensuring alignment with organizational objectives. • Created intricate Informatica mappings for data mart loading, incorporating transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer, and Sequence generator, ensuring data accuracy and integrity. • Developed ETL Informatica mappings to load data into the staging area, extracting from Mainframe files and databases and loading into Oracle 11g target database, optimizing data flow and performance. • Designed workflows and worklets for Informatica mappings, while also handling SQL coding for overriding generated SQL querie

F

ETL/ Informatica Developer

Follet corporation

Jun 2017 - Aug 2017 (3 months)

• Played a key role in creating Informatica mappings, facilitating the upload of data files into staging tables, and subsequently into the Data Warehouse system, ensuring smooth data integration processes. • Extracted data from diverse sources including Flat files, SQL Server, and Oracle, and loaded it into Postgres staging and target tables while applying business rules as per requirements, ensuring data accuracy and integrity. • Implemented SCD Type1 and SCD Type2 techniques to update slowly changing dimension tables, utilizing Debugger to test mappings and rectify any bugs, ensuring data consistency. • Created Informatica mappings with PL/SQL Procedures/Functions/Triggers to implement business rules for data loading, ensuring adheren

ETL/ Informatica Developer

ventois INC

May 2016 - May 2017 (1 year 1 month)

• Engaged in the initial stage of requirement gathering to comprehend Business Requirements and Business Rules, ensuring alignment with organizational objectives. • Utilized Power Center Designer tools to develop mappings and Mapplets for extracting and loading data from flat files and Oracle into Oracle database, facilitating seamless data integration. • Implemented code using various Informatica Transformations including Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Source Qualifier, Union, Lookup, Joiner, XML Source Qualifier, and Stored Procedure transformations, ensuring data accuracy and integrity. • Developed SQL overrides in Source Qualifier/Lookup transformations as per business requirements, optimizing d

Vedasree Veerabomma

About

Detail

Timeline

Résumé