Durgarao Kaalla

About VOZIQ AI:

Clients: Brinks, Prime, Guardian Alarm, Alert 365, Aptive, and Hawx.

VOZIQ provides an end-to-end, cloud-based customer retention solution to help recurring revenue.

Businesses accurately predict and mitigate customer churn risk very early in the life cycle. It is achieved by applying.

A suite of 10 or more machine learning models on combined structured and unstructured customer data.

Working as a Senior. Data Engineer at VOZIQ LLC from December 2019 to present.

Worked as a Data Engineer at VOZIQ LLC from April 2017 to November 2019.

Worked as a Database Developer at VOZIQ LLC from Sept 2015 to March 2017.

Professional Experience:

• Over 9+ years of professional experience in ETL methodologies, including data extraction, migration, and transformation using Pentaho Data Integration (PDI) and MSSQL.
• Proficient in designing and optimising ETL workflows using Pentaho PDI tools like Spoon and Kitchen to integrate diverse data sources, such as relational databases, flat files, and cloud systems.
• Expertise in dimensional data modelling, including Star and Snowflake schemas, OLAP cubes, fact-dimension tables, and change data capture (CDC) with SCD Types 1, 2, and 3.
• Skilled in creating reusable transformation components such as Lookup, Filter, Router, Joiner, Aggregator, and XML handling, to streamline and optimise ETL processes.
• Hands-on experience with advanced partitioning techniques and SQL query optimisation for improving ETL performance and load times.
• Proficient in MSSQL database management, including writing complex SQL queries, stored procedures, views, and triggers.
• Experienced in automating ETL workflows using Jenkins and Groovy scripts for scheduling, error handling, and execution monitoring.
• Hands-on expertise in integrating and transforming data from sources such as SFTP, AWS S3, Azure Blob Storage, GCS, and REST APIs.
• Designed and developed business intelligence reports using BIRT, and created SQL schema and ER diagrams for data modelling and reporting.
• Worked extensively in Agile environments, participating in sprint planning, daily stand-ups, and testing reviews for timely project delivery.
• Led standardisation efforts for ETL templates and Jenkins jobs across multiple clients to ensure consistency and efficiency.
• Developed database security procedures by managing roles and privileges to ensure data protection and governance.
• Provided production support by troubleshooting ETL processes, debugging issues, and maintaining data integrity in staging and target systems.
• Proficient in programming languages such as SQL, PL/SQL, and UNIX shell scripting across Linux, UNIX, and Windows platforms.
• Documented technical specifications, mappings, test scripts, and ETL workflows to ensure seamless handover and future maintenance.