Sravanthi Tiruvanagiri

Backend Engineer

India11 yrs 9 mos experience

Key Highlights

5 years of experience in data engineering.
Teradata Certified Professional with strong ETL skills.
Proven ability to optimize database performance.

Stackforce AI infers this person is a Data Engineering professional with expertise in Data Warehousing and ETL solutions.

Contact

Skills

Core Skills

Data WarehousingEtlDatabase Administration

Other Skills

AzureCC++Customer ServiceDBMSData AnalysisDebuggingEnglishHTMLInformatica Power centerInformatica developerJavaMicrosoft ExcelMicrosoft OfficeMicrosoft SQL Server

About

I am a qualified Teradata Certified Professional having 5 years of experience in developing and implementing the needs of a business. I am adept at performing analysis across the development and support activities, which includes assessing and resolving issues, performing diagnosis. I possess strong communication, time management, organizational skills and I thrive in an enthusiastic team environment. My skilIs include Teradata, Teradata SQL , Informatica Power centre , Tablaeu, Python , R , Unix I am seeking a role where I can use my skills to help with business growth.

Experience

11 yrs 9 mos

Total Experience

3 yrs 3 mos

Average Tenure

1 yr 9 mos

Current Experience

Tjx global it - india

Staff principle data engineer

Aug 2024 – Present · 1 yr 9 mos · India · Hybrid

Providence

Lead Data Engineer

Jul 2022 – Aug 2024 · 2 yrs 1 mo · Hyderabad, Telangana, India

Hitachi vantara apac

Senior Data Engineer

Apr 2022 – Jul 2022 · 3 mos

Pepsico

Lead engineer-2 enterprise datawarehouse build

Oct 2019 – Apr 2022 · 2 yrs 6 mos · Hyderabad Area, India

Data Warehousing experience using Teradata, Informatica Power center/Power Exchange 8.x/7.x, Unix shell scripting.
Experience in dealing with Teradata Bteq scripts, Fast Export, Fast Load and Multi Load.
Good exposure in Data Analysis, Transformation, Data import, Data export and use of ETL tool including Informatica.
Good in implementing the applications from Build phase to till support handover phase.
Ability to handle critical situations and communicating with business in a proper manner to achieve the desired results.
Adept in understanding business processes/requirements and translating them into technical requirements.
Good understanding of Data Warehousing & RDBMS concepts with Teradata.
Creation of reusable components for Informatica/Unix shell scripts & SQL scripts.

TeradataInformatica Power centerUnixData AnalysisETLSQL+1

Teradata

2 roles

Teradata Database Engineer

Nov 2016 – Oct 2019 · 2 yrs 11 mos

Teradata Product Support Engineer

May 2014 – Oct 2016 · 2 yrs 5 mos

Member of Database Core team, primarily responsible for debugging the issues from the available information collected through crash-dumps during the database failures and then to analyze the code defects, design fix and changes in various versions.
Conducted problem triage, problem analysis on query optimizations, spool space, table partitioning, primary indexes, secondary indexes and compression for high database throughput.
Optimized queries by looking at execution plan for better tuning of the database.
Built test cases in In-House test systems to identify the bugs in the source code by performing dump analysis using GDB.
Recreated the bugs on In-House test systems using Teradata utilities (BTEQ, TSET, SQL Assistant, FASTEXPORT, FASTLOAD, MLOAD, ARCMAIN) to assist with root cause analysis.
Executed the tasks like CHECKTABLE, Scandisk, Users, Roles, Access rights, Profiles, and DB\Objects creation
Supported DBA teams in their Enterprise Backup, Archive and Restore solutions by implementing the best practices.
Interacted with Engineering and peers to isolate product defects in the future versions by creating and maintaining related Defect tracking reports and Technical Alerts.
Performance tuning, including collecting statistics, analyzing explains.
Using utilities like Filer, ferret, rcvmanager, lokdisp, show locks, gtwglobal etc. for troubleshooting the live system performance.
In depth knowledge of Teradata file system, data dictionary, Access rights, Database locks, Join strategies and UNIX commands.
Knowledge and experience on ETL tool Informatica
Experience on Workload manager, workload monitor, mapping designer, repository manager.
Knowledge on creation on various kinds on transformations and SCD’s
Knowledge Push down optimization.
Writing quick SQL Queries, Stored Procedures, User Defined Functions to implement the business logic.