Abhishek Surkar

• Designed and developed end-to-end ETL pipelines using IBM DataStage 11.5, Informatica, DBT, and Snowflake for insurance and financial data processing.
• Migrated legacy warehouse data to Snowflake Cloud, enhancing query performance by 40%.
• Built loss analysis dashboards in Tableau with drill-down capabilities for policy, coverage, and claim dimensions.
• Automated data ingestion from HDFS, Hive, Essbase cubes, and SFTP into staging and Snowflake layers.
• Implemented Unix shell scripts with Control-M orchestration, decreasing manual intervention by 30%.
• Created source-to-target mappings, job design documents, and technical specifications for compliance and business audits.
• Developed Python and Pandas-based Lambda functions to load structured and unstructured data into AWS S3 and Snowflake.
• Managed offshore/onsite coordination, task tracking in Jira, and stakeholder reporting.

Environment: DBT, Snowflake, IBM WebSphere IBM Infosphere DataStage 11.5, Informatica 10.5.1, Salesforce, Oracle 10g, Netezza, DB2, SQL, PL/SQL, UNIX Shell Scripting, Python, IBM Infosphere DataStage Version Control, MS SQL server, Control M, Talon Batch Development, qTest.

• Developed DataStage ETL jobs (v8.5/9.1) to integrate 42+ global data sources for HSBCNet (P2G, Admin Reporting, DMP).
• Automated Teradata migration (v15 to v16) with BTEQ + Shell scripts, reducing migration effort by 25%.
• Designed and optimized complex SQL/ BTEQ Scripts for high-volume transaction processing.
• Enabled restart ability and recovery mechanisms in Control-M, improving SLA adherence.
• Led performance tuning of DataStage pipelines, cutting execution times by 20%.
• Mentored junior developers, provided code reviews, technical guidance, and escalated issue resolution.
• Ensured compliance with audit requirements by integrating logs (API, LDAP) into centralized reporting systems.

Environment: DataStage v8.5/v9.1, Teradata 15/16, DB2, SQL, PL/SQL, Control-M, UNIX Shell Scripting, BTEQ Scripting.