Open to opportunities

Kamesvar Vijay

@kamesvarvijay

Message

Technical Architect specializing in ETL/ELT, data platforms, and team leadership for banking and insurance.

India

Message

What I'm looking for

I seek senior-level roles building and optimizing ETL/ELT pipelines on modern cloud data platforms, with opportunities to lead teams, drive architecture decisions, and work in collaborative, delivery-focused environments.

I am a Technical Architect with 16 years of experience in ETL/ELT development, production support, people management, and project execution across banking and insurance domains.

I design, develop and optimize data pipelines using IBM DataStage, Informatica PowerCenter and DBT on Snowflake and DB2, lead release and deployment activities with Control-M, GitHub and IBM UCD, and drive performance tuning and automated validation.

I have led multi-member teams, handled client technical discussions, prepared technical specifications, and managed support and delivery for major clients including USAA Bank and Kaiser Permanente.

Experience

Work history, roles, and key accomplishments

Current

Technical Architect

Current

HCL Technologies

Dec 2022 - Present (2 years 11 months)

Architected and developed ETL/ELT solutions using IBM DataStage, DBT and Snowflake for banking and insurance clients, improving pipeline reliability and deployment automation. Led integrations with Control-M, GitHub and IBM UCD across multiple projects.

DataStage DBT Snowflake GitHub ELT Data Pipelines

Technical Lead

MFX Infotech

Mar 2014 - Dec 2022 (8 years 9 months)

Led a 9-member development and production support team delivering Informatica PowerCenter ETL solutions for insurance clients, owning requirement analysis, performance tuning and release management. Managed resource allocation, deployments and client technical discussions.

Informatica Oracle Autosys Performance Tuning Release Management Team Leadership Jira ServiceNow

Programmer Analyst

Cognizant Technology Solutions

Mar 2012 - Feb 2014 (1 year 11 months)

Developed and supported ETL workflows using Informatica PowerCenter across Oracle, Teradata and SQL Server environments for clients in insurance, telecom and healthcare. Focused on ETL development, data validation and performance improvements.

Informatica Teradata Oracle SQL Server SQL Pl SQL ETL Developer Linux

Associate Analyst

OBSI Technologies

Jul 2009 - Mar 2012 (2 years 8 months)

Implemented ETL processes using Informatica and developed BI reports/dashboards using MicroStrategy to support analytics and reporting requirements. Contributed to data integration and dashboard delivery for telecom and logistics clients.

Informatica Microstrategy Greenplum SQL Data Warehousing Reporting ETL

Trainee

OBSI Technologies

Sep 2008 - Jul 2009 (10 months)

Completed data warehouse training covering Informatica PowerCenter, Oracle Warehouse Builder, MicroStrategy, OBIEE, SQL and PL/SQL to support junior ETL development tasks.

Informatica Oracle Microstrategy SQL Pl SQL Data Warehousing