Prabhu Patil

Talend ETL Developer

India 4+ yrs exp 89 · Excellent

About

Data Analyst and ETL Developer with 4.8+ years of experience in Talend ETL, SQL Server, T-SQL, Power BI, SSRS, DAX, and Power Query. Experienced in developing and supporting Talend ETL jobs for data extraction, transformation, validation, cleansing, and loading into SQL Server. Strong expertise in SQL development, including complex queries, joins, CTEs, subqueries, window functions, stored procedures, views, and query optimization, SSRS Report development. Skilled in developing Power BI dashboards, data models, DAX measures, KPIs, and business reports using large-volume datasets. Experienced in data migration, source-to-target validation, data quality checks, ETL troubleshooting, and delivering scalable reporting solutions across Healthcare and Banking domains.

Skills & Expertise (36)

Power BI Advanced

8.5/10

4.8

Years Exp

SQL Server Advanced

8.0/10

4.8

Years Exp

T-SQL Advanced

8.0/10

4.8

Years Exp

Talend ETL Advanced

8.0/10

4.8

Years Exp

ETL workflows Advanced

8.0/10

4.8

Years Exp

SSRS Advanced

7.5/10

4.8

Years Exp

DAX Advanced

7.5/10

4.8

Years Exp

Data Modeling Advanced

7.5/10

4.8

Years Exp

Indexing Report Optimization Data Extraction Data Transformation Data Cleansing Interactive Dashboards Drill-through Drill-down Bookmarks Tooltips Slicers Filters Conditional Formatting Query performance tuning Views Stored Procedures Window Functions Subqueries CTEs Joins Dashboard Development KPI development Time intelligence Measures Calculated Columns Snowflake Schema Star Schema Power Query

Work Experience

Data Analyst | Talend ETL Developer | SQL & Power BI Developer

Craft Silicon

Mar 2025 - Present

Developed and optimized SQL Server stored procedures, complex queries, views, and database objects supporting banking application functionality and business processes. Worked on banking application development using SQL Server, implementing database logic, data validation, business rules, and transaction-related requirements. Analysed business requirements and translated them into SQL-based solutions for banking application modules and reporting needs. Designed and developed Power BI dashboards to monitor loan performance, customer transactions, branch-wise metrics, and key banking KPIs. Developed and maintained SSRS operational reports including Loan Agreements, Sanction Letters, Passbook Stickers, and Claim Forms. Created complex SQL queries using Joins, CTEs, subqueries, and window functions to support application and reporting requirements. Developed interactive Power BI dashboards by integrating data from SQL Server, creating data models and DAX measures, and implementing KPIs, slicers, drill-downs, and filters to provide actionable insights into banking operations. Developed and maintained Talend ETL jobs to extract, transform, validate, and load data from multiple sources into SQL Server target tables. Used tMap and other Talend components to perform data transformation, lookups, joins, filtering, data cleansing, and source-to-target mapping.

Data Analyst | Talend ETL Developer | SQL & Power BI Developer

HTC Global Services

Feb 2022 - Mar 2025

Developed and optimized SQL Server stored procedures, complex queries, views, and database objects to support application functionality, ETL processes, and reporting requirements. Developed Talend ETL jobs to extract, transform, validate, and load healthcare and telecom data into MS SQL Server. Developed and maintained Talend ETL jobs to extract healthcare and telecom data from multiple source systems, perform data transformation and validation, and load the processed data into MS SQL Server. Used Talend tMap and other ETL components for data mapping, lookups, joins, filtering, data cleansing, and source-to-target validation to ensure accurate and reliable data processing. Designed and developed interactive Power BI dashboards for agent performance, call management, ticket tracking, and operational business metrics. Developed Power BI data models and DAX measures to create KPIs, calculated metrics, trend analysis, and performance indicators. Integrated SQL Server data with Power BI, using Power Query for data transformation and cleansing, and developed interactive reports with DAX, KPI cards, charts, slicers, filters, drill-downs, and drill-throughs. Published and shared Power BI reports and dashboards with agents and hospital stakeholders through Power BI Service, enabling users to monitor operational metrics, KPIs, and performance insights.