Basil Raju
Verified Expert in Engineering
Data Engineer and Developer
Toronto, ON, Canada
Toptal member since May 27, 2025
Basil is a senior data engineer with 9+ years of experience in the IT and service industry. Passionate about data engineering and analytics, he strives to deliver quality solutions that add value to customers. Basil collaborates with stakeholders and SMEs to design and implement data warehouse solutions that support the team's business needs. He's delivered real-time data pipelines that process non-structured data from 30+ sources and designed a data warehouse for a robust client profile.
Portfolio
Experience
- SQL - 9 years
- Microsoft Data Transformation Services (now SSIS) - 7 years
- SQL Server Integration Services (SSIS) - 7 years
- SSIS Custom Components - 7 years
- SQL Server 2019 - 6 years
- C Shell - 4 years
- Netezza - 3 years
- Alteryx - 3 years
Preferred Environment
Agile Software Development, Alteryx, SQL Server Integration Services (SSIS), Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, SQL, SQL Server 2019, Netezza, Linux, C Shell
The most amazing...
...real-time data pipelines I've implemented process semi-structured data by integrating 20+ data sources in the warehouse with around 13 billion raw records.
Work Experience
Senior Data Engineer
CIBC
- Implemented real-time data pipelines to process semi-structured data by integrating 20+ data sources in the warehouse with around 13 billion raw records.
- Implemented data pipeline architectures to improve the performance of monthly workflows and generate daily profile data that appends to the live client base.
- Developed and maintained the data warehouse for a robust client profile for around two million clients. Worked on full lifecycle development using structured design methodologies.
Senior Software Developer
IQVIA
- Collaborated with 20+ global pharmaceutical clients and stakeholders to gather requirements, create a scope, and finalize clients' needs. Cross-trained team members for effective stakeholder communication, peak volumes, and prompt deliveries.
- Recommended and executed plans to improve development tools and processes. Automated 30+ ETL jobs, saving the vast majority of resources. Improved project performance by query optimization and tuning, ensuring quality deliverables.
- Perfected Power BI reports and dashboards. Mentored junior colleagues in business and development tasks. Upgraded SQL Server, SSIS packages, and migrations. Advised clients and other teams on troubleshooting data and dashboard issues quickly.
Software Engineer
Finastra
- Developed and maintained web and desktop-based software applications and 50+ stored procedures in SQL Server. Implemented SSRS tabular and multi-dimensional reports and carried out 8+ report model upgrades.
- Collaborated with the implementation team to deploy applications in the client environment during the go-live phase. Prepared and managed team reports, project information, and statistics related to reported cases.
- Led end-to-end software development for custom projects tailored to client needs. Collaborated with 50+ US banking clients and stakeholders to collect and analyze requirements, develop scopes, and draft BRDs and SOWs for client approval.
Software Developer
UST Global
- Performed major and minor enhancements in the legacy system's existing code, scripts, and procedures to enhance system performance and ensure stability, resulting in a 97% success rate.
- Created 15+ Linux shell scripts to implement scheduled jobs and facilitate the implementation of different POS applications by working with the R&D team.
- Oversaw problem management and conducted root cause analysis of live production issues, ensuring accountability for maintaining SLA and OLA compliance.
Experience
Data Warehouse for a Client Complete Profile
Education
Post-graduate Diploma in Human Resources Management
Alagappa University - Karaikudi, India
Bachelor's Degree in Information Technology
Anna University - Chennai, India
Skills
Tools
Excel 2013, Excel 2010, SQL Server BI, Hue
Languages
SQL, C Shell, SAS, Java
Paradigms
Agile Software Development
Platforms
Alteryx, Linux
Storage
SQL Server Integration Services (SSIS), SQL Server 2019, Netezza, MySQL, PostgreSQL
Other
Microsoft Data Transformation Services (now SSIS), SSIS Custom Components, Data Modeling, Data Engineering, Human Resources (HR), Software Development, Point of Sale, Office 365, SQL Server 2015, IBM Netezza
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