Eshwari Ballari
ETL Developer/ PL/SQL developer /Teradata/GCP
Hire this person
Send a job offer directly to this candidate
About
Over 17 Years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems in Data warehousing for business system like Power, Utilities, Entertainment and Insurance industries. Over 9 years of experience in ETL methodologies for supporting data extraction, transformations and loading processing using Teradata, Informatica, Datastage. Development using Oracle 12.10/11g/10g/9i, SQL PLUS, SQL*Loader TOAD and SQL DEVELOPER.
Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements. Proficiency in using Informatica Power Center tool to design data conversions from disparate source systems. Proficient in understanding business processes/requirements and translating them into technical requirements.
Expertise in database programming in writing of the SQL, Stored Procedures, Functions, Triggers, Views in Teradata, Oracle, DB2 & MS Access. Extensively utilized Business intelligence reporting Tools such as Business Objects 5.X/6.X. Extensively worked on Database utilities like SQL*Loader, DTS, Teradata Utilities (Fast Load, Multi Load, Fast Export, Tpump, queryman, BTEQ) and Toad.
Experienced in UNIX Shell scripting as part of file manipulation and text processing.
Experience with cloud platforms such as Google Cloud (GCP Preferred). GCP - TPT solution / Bigquery DTS, GCP Composer / Airflow, Data validation strategy. Involved in all the stages of the software development cycle, namely design, specification, coding, debugging, testing (test plan and test execution), documentation and maintenance of the programs.
Strong
Communication, Presentation and Interpersonal skills with excellent problem-solving capabilities.
Experience
ETL Developer/ PL/SQL developer /Teradata/GCP - Verizon - GA
(2022-02)
Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities. Apply broad in-depth business and technical knowledge to resolve production support and sustainment activities.
- Explored ways to optimize existing ETL processes and enhance their performance.
- Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fastexport and BTEQ.
- Automated related tasks by developing UNIX shell scripts used to maintain the core EDW
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Working closely with business users and analyze source data to develop the transformation logic.
- Ensure data integrity and performance in Teradata environments.
- Integrate Teradata solutions with GCP.
- Leverage cloud-based services for data storage, processing, and analytics.
- Optimize data movement between on-premises Teradata and cloud environments.
- Identify and address performance bottlenecks in Teradata queries and processes.
- Optimize and fine-tune queries and processes for improved efficiency.
- Lead or contribute to the migration of data from on-premises Teradata databases to cloud-based solutions.
- Ensure smooth and accurate data migration processes.
- Collaborate with cross-functional teams, including data scientists, analysts, and infrastructure teams.
- Provide technical expertise and support to team members.
- Create and maintain comprehensive documentation for Teradata development processes.
- Document integration points and processes between Teradata and cloud platforms.
- Designed and developed Python-based ETL pipelines to extract data from REST APIs, relational databases, and flat files, transforming and loading data into Teradata and BigQuery environments.
- Used Pandas and PySpark for complex data transformations, aggregations, and data quality validation.
- Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
- Collaborate with architects, analysts, data scientists, and business stakeholders to design scalable data engineering solutions.
- Utilize GitHub Copilot and Claude AI to accelerate SQL development, code reviews, documentation creation, troubleshooting, and engineering productivity.
- Create and maintain technical documentation, operational runbooks, and data flow diagrams supporting enterprise data platforms.
Teradata/ PL/SQL developer - Bank of America - Remote
(2019-08 - 2021-10)
- Designed the Logical and Physical Data Model (LDM and PDM) on the new Ratings Stream data mart, and enhanced the existing EDW Physical Data Model
- Coded complex and highly-optimized SQLs looking up at core EDW in Third Normal Form Physical Data Model to output at denormalized data mart requirements
- Create and execute test plans for Unit, Integration, and System test phases
- Automated related tasks by developing UNIX shell scripts used to maintain the core EDW
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Created indexes on the tables for faster retrieval of the data to enhance database performance.
- Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
- Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
- Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
- Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
Teradata/ PL/SQL developer - Accenture - GA
(2017-10 - 2019-07)
- Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fastexport and BTEQ.
- Explored ways to optimize existing ETL processes and enhance their performance.
- Designed the Logical and Physical Data Model (LDM and PDM) on the new Ratings Stream data mart, and enhanced the existing EDW Physical Data Model
- Coded complex and highly-optimized SQLs looking up at core EDW in Third Normal Form Physical Data Model to output at denormalized data mart requirements
- Create and execute test plans for Unit, Integration, and System test phases
- Automated related tasks by developing UNIX shell scripts used to maintain the core EDW
- Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Created indexes on the tables for faster retrieval of the data to enhance database performance.
