Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Lalitha Kareti

Houston,TX

Summary

Senior Data Engineer with over 10 years of experience in data warehousing, profiling, analysis, and integration. Proven expertise in business intelligence tools such as Informatica, DataStage, and Talend, alongside strong capabilities in Big Data and cloud integration. Notable achievements include successful project implementations for clients in healthcare, banking, and manufacturing sectors. Core competencies include data modeling, ETL development, and proficiency in AWS DevOps tools like GitHub and Jenkins.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Sr. Data Engineer

Truist
Raleigh, NC
02.2024 - Current
  • Company Overview: Truist Financial Corporation is an American bank holding company, headquartered in Charlotte, North Carolina.
  • Requirements, Analysis, and Design - Involved in requirement gatherings along with the Business Analyst and Data Architects.
  • Responsible for developing, supporting, and maintaining the ETL (Extract, Transform, and Load) processes using Informatica PowerCenter.
  • GitHub and Jenkins are used for auto code builds and deployments.
  • Contribute to performance tuning and volume testing of the application
  • Built a reusable framework, including error handling, duplicate file checks, etc.
  • I have done a few POCs on IICS/IDMC to move the code from Informatica PC to IICS in the AWS cloud journey.
  • Manage a team of 10 members across North America and the APAC regions.
  • Perform SRE activities on a rotational basis.

Tech Lead/Sr. ETL developer

Zurich
Peoria, IL
06.2023 - 01.2024
  • Company Overview: Zurich is a global insurance company that is organized into three core business segments: General Insurance, Global Life, and Farmers.
  • Requirements, Analysis, and Design - Involved in requirement gatherings along with the Business Analyst and Data Architects.
  • Responsible for developing, supporting, and maintaining the ETL (Extract, Transform, and Load) processes using Informatica PowerCenter.
  • Migration activities: Change management.
  • Autosys: Job creation, scheduling jobs, and monitoring jobs.
  • GitHub and Jenkins are used for auto code builds and deployments.
  • Contribute to performance tuning and volume testing of the application.
  • Built a reusable framework, including error handling, duplicate file checks, etc.

Tech Lead/Sr. ETL developer

Caterpillar
Peoria, IL
03.2021 - 05.2023
  • Company Overview: Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives.
  • Requirements, Analysis, and Design - Involved in data analysis, preparation of mapping documents, and procuring sign-offs on design.
  • Responsible for developing, supporting, and maintaining the ETL (Extract, Transform, and Load) processes using Datastage.
  • Migration activities: Teradata to Cloud Snowflake.
  • Tivoli - Job creation, scheduling jobs, and monitoring jobs.
  • GitHub and Jenkins are used for auto code builds and deployments.
  • Contribute to performance tuning and volume testing of the application
  • Built a reusable framework, including error handling, duplicate file checks, etc.
  • Involved in scheduling jobs and workflows to automate the various inbound/outbound transactions using Autosys.

Sr. ETL Developer

BHP
Houston, Texas
02.2018 - 03.2021
  • Company Overview: BHP is a world-leading resources company, headquartered in Melbourne, Australia.
  • It develops well-advanced automobiles and petroleum energy for a better future and an easier life.
  • Requirements and Analysis: Understanding the requirements of the client and acting as a sole functional resource.
  • Design: Preparing the functional, technical documents, and the test cases for the given application.
  • Participate in defining and implementing project-level standards and guidelines, and ensure adherence to enterprise-level policies.
  • Develop robust ETL designs (functional and technical) for the ETL solution.
  • Lead and mentor the team offshore in designing, developing, and delivering the ETL tasks.
  • Work with the testing team to define a robust test plan, and support them during the functional testing of the application.
  • Contribute to performance tuning and volume testing of the application.

Sr. ETL Developer

US Bank
SFO, California
07.2015 - 02.2018
  • Gather and understand the business and technical requirements, and prepare the physical solution design documents.
  • Participating in scrum meetings for agile methodology and discussing the daily progress and areas of concern.
  • Creating the mapping, sessions, and workflows for the respective application.
  • Performance tuning in Oracle and Informatica.
  • Review, managing, and coordinating with the offshore team members.
  • Implementation of the audit framework for ETL loads.
  • Data modeling for the CSR data mart.

ETL Developer

IBM
01.2010 - 07.2015
  • Requirements, Analysis, and Design - Involved in data analysis, preparation of mapping documents, and procuring sign-offs on ETL design.
  • Responsible for developing, supporting, and maintaining the ETL (Extract, Transform, and Load) processes using Informatica PowerCenter 10.1.x, as well as PL/SQL procedures and packages.
  • Maintained B2B data exchange in terms of trading partner creations, endpoints, and profiles.
  • Contribute to performance tuning and volume testing of the application
  • Work with the testing team to define a robust test plan, and support them during the functional testing of the application.
  • Built a reusable framework, including error handling, duplicate file checks, etc.
  • Involved in Unix shell scripts for the automation of ETL and various other processes.
  • Involved in scheduling jobs and workflows to automate the various inbound/outbound transactions.

Education

Bachelor of Engineering - Computer Science

Anna University
India
05-2009

Skills

  • Informatica Power Center
  • Informatica Cloud
  • IBM DataStage
  • Talend
  • Webfocus
  • Cognos
  • AWS
  • Salesforce
  • IICS/IDMC
  • Informatica BDM
  • Talend BDI
  • Sqoop
  • Hue
  • GitHub
  • Jenkins
  • Maven
  • Tomcat
  • SonarQube
  • Nexus
  • Oracle
  • SQL Server
  • Teradata
  • SQL
  • PL/SQL
  • UNIX Shell Scripting
  • Python
  • Autosys
  • Tivoli
  • TOAD
  • ServiceNow
  • Windows
  • DOS
  • UNIX
  • LINUX
  • Data quality assurance
  • Big data processing
  • Real-time analytics
  • Hadoop ecosystem
  • Metadata management
  • ETL development
  • Data integration
  • Performance tuning
  • Data warehousing
  • Data modeling

Certification

  • AWS Cloud Practitioner
  • Informatica Certified Specialist
  • ITIL

Timeline

Sr. Data Engineer

Truist
02.2024 - Current

Tech Lead/Sr. ETL developer

Zurich
06.2023 - 01.2024

Tech Lead/Sr. ETL developer

Caterpillar
03.2021 - 05.2023

Sr. ETL Developer

BHP
02.2018 - 03.2021

Sr. ETL Developer

US Bank
07.2015 - 02.2018

ETL Developer

IBM
01.2010 - 07.2015

Bachelor of Engineering - Computer Science

Anna University

Similar Profiles

CREATE PROFILE
Lalitha Kareti