Summary
Overview
Work History
Education
Skills
Disclaimer
Certification
Languages
Timeline
Generic

Surendran Natarajan

Chennai

Summary

Highly skilled Database Developer with over 10.7 years of experience, including 7+ years in Oracle SQL and PL/SQL, 3+ years in Informatica ETL, and 3 years in Snowflake. Proven ability to design, develop, and implement complex data solutions across diverse industries like banking, insurance, logistics, and retail. Passionate about data quality, performance optimization, and automation.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Technology Lead

Infosys
Chennai
01.2023 - Current
  • Client: APL Logistics
  • Environment: Oracle 11g, SQL Developer, Unix
  • Delivered a 40% reduction in data processing time by developing a data pipeline using Snowflake and AWS Glue
  • Optimized Snowflake data warehouse query performance by 30% through materialized views and strategic clustering
  • Increased data refresh frequency by 25% by automating ETL processes using Snowflake Streams and Tasks
  • Enhanced data consistency by 50% by integrating Snowflake with third-party data sources and APIs
  • Reduced data discrepancies by 20% through data quality checks and implementing validation processes

Manager

CARE Health INSURANCE
Chennai
02.2015 - 01.2023
  • Client: IndusInd Bank Pvt Ltd
  • Environment: Oracle 11g, SQL Developer, Unix
  • Collaborated with the business team to gather requirements and design/develop database objects (tables, views, sequences, synonyms, stored procedures, functions, packages, cursors) to meet business needs
  • Wrote complex SQL queries (joins, subqueries, correlated subqueries) for efficient data retrieval
  • Developed PL/SQL objects (stored procedures, packages, functions, triggers) for data manipulation and automation
  • Performed performance tuning using explain plans to optimize query performance
  • Created user-defined functions with error handling capabilities
  • Enhanced, developed, and deployed reports based on new requirements
  • Prepared detailed design documents (DDL) and impact analysis documents
  • Worked collaboratively with the team to develop ETL processes using Informatica PowerCenter for data extraction, transformation, and loading

Executive

Relyon Facility Services Pvt Ltd (Service Provider for IndusInd Bank)
Chennai
02.2014 - 01.2015

Education

Master of Computer Applications (MCA) -

Anna University
Chennai, India

Skills

  • Databases: Oracle 11g and 19c, Snowflake
  • ETL Tools: Informatica PowerCenter
  • Scripting Languages: SQL, PL/SQL
  • Development Tools: SQL Developer
  • Operating Systems: Windows family, Unix
  • Analytical Tools: Tableau, Excel, and Power BI
  • Performance Analysis
  • Data Analysis
  • Software testing
  • Analytics

Disclaimer

I hereby declare that the information furnished above is true to the best of my knowledge.

Certification

  • understanding the complex workflows and handled the performance issue in dataloading

Languages

English
First Language

Timeline

Technology Lead

Infosys
01.2023 - Current

Manager

CARE Health INSURANCE
02.2015 - 01.2023

Executive

Relyon Facility Services Pvt Ltd (Service Provider for IndusInd Bank)
02.2014 - 01.2015

Master of Computer Applications (MCA) -

Anna University

Similar Profiles

CREATE PROFILE
Surendran Natarajan