Teja Goud Kandula
Verified Expert in Engineering
Data Engineer and Developer
Hyderabad, Telangana, India
Toptal member since December 8, 2022
Teja is a senior data engineer with seven years of experience building robust and scalable data pipelines for clients like Ladbrokes Coral and Mohegan Sun. He specializes in setting up data pipelines from scratch, migrating data pipelines from one ETL tool to another, and handling migrations from on-premise data warehouses to the cloud. Teja is a dedicated professional with the drive and skill set to embrace new challenges and provide clients with the best solutions.
Portfolio
Experience
- SQL - 6 years
- Data Engineering - 6 years
- ETL - 6 years
- Data Warehousing - 5 years
- Microsoft SQL Server - 3 years
- Snowflake - 2 years
- Data Build Tool (dbt) - 2 years
- Metabase - 1 year
Availability
Preferred Environment
Snowflake, Data Build Tool (dbt), Slack, Visual Studio Code (VS Code), Windows, SQL
The most amazing...
...project I've worked on required me to master the basics of Informatica PowerCenter within three days and finish the migration in three months.
Work Experience
Senior Business Analyst
Timestone
- Worked on building the data vault layer using raw data.
- Developed required data models for reporting using dbt.
- Implemented reporting in the Sigma computing BI tool.
Senior Data Engineer
Timestone
- Implemented data orchestration using Apache Airflow.
- Built the data pipelines using Dataform, the equivalent of dbt.
- Participated in architecture review calls to follow the project's changing guidelines and adhere to them.
Senior Data Engineer
Timestone
- Optimized existing Snowflake tables that are more than one terabyte in size for better performance.
- Rebuilt existing dbt data pipelines for efficiency to achieve optimization.
- Conducted data ingestion to Snowflake from Amazon S3 using Snowflake stages and Snowflake pipes.
- Set up Snowpipe to auto-ingest data CSV and Parquet files from Amazon S3 to Snowflake.
Senior Data Engineer
5x
- Built a consolidated data warehouse to track the company's financials.
- Created dashboards to track the bills incurred by consulting companies based on developer and infrastructure usage.
- Developed a dashboard to track the payments received from consulting companies.
Senior Data Engineer
5x
- Built end-to-end data pipelines from scratch using dbt.
- Built the business logic layer in Snowflake using dbt, which is the metrics layer, the single source of truth to look at any business metric.
- Set up data ingestion from Salesforce to Snowflake using Fivetran.
- Set up data ingestion from Quickbooks, MySQL RDS, Google Ads, Facebook Ads, and LinkedIn Ads to Snowflake using Fivetran.
- Built reports from scratch using the open-source BI tool Metabase.
- Developed a team tracking dashboard to track the performance of the team.
- Set up a Snowflake Snowpipe to auto-ingest data CSV files from AWS S3 to Snowflake.
Senior Data Engineer
5x
- Built a data model to examine user analytics from the data generated by Twilio Segment.
- Set up a business reporting process using Google Data Studio.
- Tested Twilio Segment configuration on the website to ensure the data team got all the information they needed to answer business questions.
ETL Consultant
BizAcuity
- Migrated Informatica PowerCenter mappings and workflows to Informatica Cloud.
- Developed mappings, task flows, and mapping tasks to manage the data migration from SQL Server and Db2 to Teradata.
- Validated the objects migrated from PowerCenter to Informatica Cloud.
- Scheduled Informatica Intelligent Cloud Services (IICS) task flows using the Skybot scheduling tool.
- Deployed the Informatica objects from the development environment to the production environment.
Production Support Engineer
BizAcuity
- Provided production support for a month after project delivery.
- Created project handover documents, including the data flow and schema design.
- Documented how to backload the data upon the failure of the task flows.
ETL Developer
BizAcuity
- Built an audit framework using BTEQ scripts and batch files to log the Informatica Cloud session onto the Teradata database.
- Developed mappings, task flows, and mapping tasks to manage the data migration from Microsoft SQL Server to Teradata.
- Deployed the Informatica objects from the development environment to the production environment.
- Documented the audit framework ETL pipeline data flow and deployment steps.
- Prepared data mapping documents and performed data validation tasks.
- Implemented incremental data loading into Teradata using Microsoft SQL Server CDC and IICS.
Production Support Engineer
BizAcuity
- Managed daily ETL jobs within the product environment, ensuring they were concluded and the business team received daily reporting data.
- Ensured the daily completion of the ETL jobs in the test environment and the release of new code changes to the production environment.
- Fixed production failures in the ETL flow and ensured the ETL process was finished according to the SLA.
Experience
Mohegan Sun
Education
Bachelor's Degree in Computer Science
Bapatla Engineering College - Bapatla, Andhra Pradesh, India
Certifications
Hands On Essentials – Data Engineering
Snowflake
Hands On Essentials – Data Applications
Snowflake
Hands On Essentials – Data Sharing
Snowflake
Hands On Essentials – Data Lake
Snowflake
Hands On Essentials – Data Warehouse
Snowflake
dbt Fundamentals
dbt Labs
Skills
Libraries/APIs
Sigma.js
Tools
BigQuery, GitHub, Slack, Informatica PowerCenter, WinSCP, Jira, Looker, cURL Command Line Tool, SnowSQL, Microsoft Power BI, Apache Airflow
Languages
Snowflake, SQL, Python, Stored Procedure, Python 3
Paradigms
ETL, Database Design, Database Development, Dimensional Modeling, Business Intelligence (BI)
Storage
Microsoft SQL Server, Teradata, Data Integration, Databases, Database Structure, Database Transactions, Data Pipelines, PostgreSQL, PL/SQL, IBM Db2, DataWare, Amazon S3 (AWS S3), Database Modeling, MySQL, MERGE, JSON
Platforms
Oracle, Windows, Windows Server 2016, Oracle Data Integrator (ODI), Visual Studio Code (VS Code), Salesforce, Google Ads, Apache Kafka, Amazon Web Services (AWS)
Frameworks
Streamlit
Other
Data Engineering, Data Warehousing, Monitoring, Production, Data Modeling, Data Analysis, ELT, Data Transformation, Data Analytics, Data Build Tool (dbt), Metabase, Fivetran, Data Visualization, Informatica Intelligent Cloud Services (IICS), Big Data, Informatica Cloud, Batch Scripting, Google BigQuery, Google Data Studio, Data Warehouse Design, Orchestration, BI Reporting, Amazon RDS, Facebook Ads, Segment, Dashboards, CSV File Processing, Parquet, Warehouses, Change Data Capture, Snowpipe, GeoJSON, Views, APIs, Web Services, Rivery, Data Vaults, Dataform, Data Cleaning, Data Cleansing, Excel 365, Data Classification
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring