Rajeeva Dwivedee

About Rajeeva Dwivedee

I have 8+ yrs of experience using ETL Informatica tools, Oracle SQL, Unix and…

Experience

1. Senior Etl Developer

   Bank of America

   Sep 2024 — Present · Charlotte, NC, US

   Project Description:Working on data warehouse enhancements and integrations supporting various financial operations for Bank of America. The project focuses on building robust and scalable ETL workflows using Informatica, PL/SQL, and Oracle technologies to support reporting and business analytics.Responsibilities:• Designed, developed, and optimized ETL processes using Informatica PowerCenter/IDMC and Oracle PL/SQL• Wrote and tuned complex SQL and PL/SQL queries for data validation and transformation• Automated job scheduling using Autosys, created calendar and different box and command jobs and implemented Unix shell scripts for pre/post ETL operations. • Participated in Agile ceremonies including sprint planning, reviews, and retrospectives.• Analyzed data on source and target databases to address end users\' data-related queries and provide accurate clarifications. • Actively engaged with the product owner to document user requirements. • Implanted data migration from schema to schema.• Used Starburst tool for the project for providing downstream to those views.• Created STM documents and reviewed other STM documents as well.• Followed warehouse metadata, naming standards, and warehouse standards to ensure consistency in application development. • Prepared design and technical specifications for the ETL process, ensuring clear guidelines for implementation. • Used informatica Power center to define source/target definitions, mappings, and sessions for extracting, transforming, and loading data from sources into target tables. • Created task flow encompassing a variety of tasks such as decision-making.