Tirumal Guttha

Senior Data Engineer at Alithya

Led the ownership of database architecture, including schema design, performance optimization, and scalability. Managed end-to-end data integration processes, ensuring high-quality ingestion, validation, cleaning, updating, exporting, and sharing. Orchestrated seamless data migration, ensuring compatibility with evolving schemas. Optimized AWS ETL pipeline development for data sales clients, enhancing efficiency and scalability. Developed and optimized complex SQL queries, stored procedures, and functions to extract data from relational databases.

Data Engineer at Impel

Conducted ad-hoc data queries for user segmentation, match-rate analysis, and business intelligence. Developed a client-facing API framework, incorporating tracking systems for client credits and usage. Built and maintained client-facing data APIs, automating and scaling the data sales business. Provided innovative solutions and technical support to data clients, ensuring client satisfaction. Worked with MSSQL Server, reporting services, integration services, and T-SQL scripting for data manipulation and querying. Implemented ETL design and data extraction for new data products and applications.

Data Engineer at Wipro

Collaborated with data architects to design and implement ETL processes using Azure Data Factory and SQL Server Integration Services (SSIS). Assessed and optimized SQL queries and stored procedures to enhance data retrieval and transformation. Conducted data profiling and data mapping to defined data lineage and transformation rules. Worked closely with business analysts to understand data requirements and translate them into technical solutions. Assisted in the development of data models and data dictionaries to maintain data consistency and integrity. Implemented data partitioning and indexing strategies to improve query performance. Collaborated with cross-functional teams to integrate REST APIs into PowerShell solutions, enhancing system functionality. Implemented version control using Git, ensuring code integrity and fostering collaborative development.

Senior Data Engineer at Bausch

Led the ownership of database architecture, including schema design, performance optimization, and scalability. Managed end-to-end data integration processes, ensuring high-quality ingestion, validation, cleansing, updating, exporting, and sharing. Orchestrated seamless data migration, ensuring compatibility with evolving schemas. Optimized AWS ETL pipeline development for data sales clients, enhancing efficiency and scalability. Developed and optimized complex SQL queries, stored procedures, and functions to extract data from relational databases.

Data Engineer at Impel

Collaborated with internal teams and external clients to design and implement ETL processes using Azure Data Factory and SQL Server Integration Services (SSIS). Assessed and optimized SQL queries and stored procedures to enhance data retrieval and transformation. Conducted data profiling and data mapping to defined data lineage and transformation rules. Worked closely with business analysts to understand data requirements and translate them into technical solutions. Assisted in the development of data models and data dictionaries to maintain data consistency and integrity. Implemented data partitioning and indexing strategies to improve query performance. Collaborated with cross-functional teams to integrate REST API into PowerShell solutions, enhancing system functionality. Implemented version control using Git, ensuring code integrity and facilitating collaborative development.