Kiruthika Kumar

• Head SQL functions, utilizing Joins, Procedures, Macros, Sub-queries, Set Operators, and functions. • Exercise in-depth understanding of Teradata Architecture and Data Warehouse Architecture, including protection concepts such as Fallback, Journals, and more; with complete understanding of data warehousing development life cycle. • Conduct comprehensive root cause analysis on recurring issues, developing and implementing tailored solutions for long-term remediation.

• Analyzing and designing the ETL process to meet goals and objectives. • Pioneered the development of BTEQ scripts to populate data into Teradata database. • Wrote SQL queries and delivered results as per the client requirement. • Championed strategic data Extraction, transformation and loading from source to target system using BTEQ and Informatica PowerCenter; completed various types of loading (Direct, Incremental, SCD Type2, and more) using scripts and configuration files.

• Collaborated with various teams on Mainframe and Teradata Application and Platform Maintenance and Support Team, as well as the ETL team of bank’s data warehouse, to effectively manage and protect data. • Utilized the ETL (Extraction, Transformation and Loading) Technology, applying expertise in this vital component of the Data Warehousing Architecture; the ETL software extracts data, transforms values of inconsistent data, cleanses "bad" data, filters data and loads data into a target database.