Karthikeyan N
Kochi
Summary
- Aspiring for a challenging career in Software development as to use my learned skills and experience for best results.
- Total 11+ Years of IT Experience in Matillion Oracle SQL, PL/SQL Developer, SQL, Snowflake, GIT, ADO, Performance tuning , Unix shell scripting. Hands on Experienced in queries using Matillion, Views, Materialized views, Sequences, Functions, Synonyms, Indexes, Triggers, Packages, Stored procedures. Extensively worked on Collections, Bulk collects, Analytical functions. Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL Programming and Query Level Performance Tuning and also good knowledge on Exception handling. Involved in worked on Oracle Pseudo columns, Joins, Group functions, SQL
- Loader, Sub queries, Constraints and Global temporary tables. Good team player with excellent work history with work ethics, dependability and willingness to go an extra mile.
Overview
15
15
years of professional experience
Work History
ETL Developer
Cognizant Technology Solutions India Pvt. Ltd
Kochi
03.2021 - Current
- Project Overview: Pacific Life Insurance Company is an American insurance company providing life insurance products, annuities, and mutual funds, and offers a variety of investment products and services to individuals, businesses, and pension plans
- Understanding the business requirement and develop the codes in Matillion and Snowflakes
- Extensively worked on Matillion on creating Orchestration and Transformation jobs
- Using GIT Repository for CICD Pipelines to Deploy DDL Script and Mapping specs
- Experience on writing scripts, developing jobs and shared jobs
- Technical reviews, Data validation, End to end testing of ETL Objects and Source data analysis
- Using Azure Devops for creating User stories and Daily activity tasks.
PL/SQL Developer
Wipro
05.2019 - 06.2020
- Project Overview: Mahindra and Mahindra, Mahindra & Mahindra Ltd (M&M) is an India-based company
- The company operates in nine segments: automotive segment comprises of sales of automobiles, spare parts and related services; farm equipment segment comprises of sales of tractors, spare parts and related services; information technology (IT) services comprises of services
- Analyzed the business requirements and functional specifications.
- Development of code based on the approved Technical Specifications
- Developed and modified SQL, PL/SQL code to make new enhancement or resolve problems, as per customer requirements
- Developed Stored Procedures, Functions, Packages for validating and migrating the data to target from Staging.
- Responsible for writing test plan and unit testing for the application modules.
- Prepared release notes and root cause analysis for problems occurred.
PLSQL Developer
Magnitudo Technologies
Trichy
07.2014 - 04.2019
- Project Overview: Afghanistan Giganor was established to administer a newly created independent company gives all telecommunications operations and services..
- Used JIRA ticketing/ticketing tool for all the given tasks.
- UAT and Live support.
- Both incident management and problem management.
- Perform application change management activities as assigned by the business.
ANALYST
CIGNAS SOLUTIONS
Chennai
08.2010 - 06.2014
- Project Overview: Bank Negara Indonesia, an incorporated bank, is a wholly owned subsidiary of the Bank of Indonesia.
- We provide a comprehensive range of banking services to customers doing business in Indonesia and other Western countries, including capital markets in investment banking, trade finance, personal banking, business banking, treasury services, commercial lending, and private banking.
- Analyzed the business requirements and functional specifications
- Development of code based on the approved Technical Specifications.
- Developed and modified SQL and PL/SQL code to create new enhancements or resolve problems, as per customer requirements.
- Developed stored procedures, functions, and packages for validating and migrating the data to the target from staging.
- Involved in troubleshooting performance issues and bugs within packages and stored procedures using DBMS_OUTPUT and EXPLAIN PLAN.
- Prepared release notes and root cause analysis for problems that occurred.
- Analyzing tables and indexes for performance tuning.
Education
Bachelor’s degree - Electronics and Communication Engineering
MAM College of Engineering
Trichy01.2010
Skills
- Matillion
- SQL
- PL/SQL
- UNIX
- DB2
- ORACLE
- Snowflake
- HTML
- XML
- Windows
- Linux
- Mac
- Control-m
- DVS
- Putty
- PL/SQL Developer
- SQL PLUS
- GIT
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge.
Languages
- Tamil
- English
Personal Information
- Date of Birth: 05/29/87
- Marital Status: Married
Timeline
ETL Developer
Cognizant Technology Solutions India Pvt. Ltd
03.2021 - Current
PL/SQL Developer
Wipro
05.2019 - 06.2020
PLSQL Developer
Magnitudo Technologies
07.2014 - 04.2019
ANALYST
CIGNAS SOLUTIONS
08.2010 - 06.2014
Bachelor’s degree - Electronics and Communication Engineering
MAM College of Engineering
Similar Profiles
Sai Jithendra VukantiSai Jithendra Vukanti
Process Executive at Cognizant Technology Solutions India Pvt LtdProcess Executive at Cognizant Technology Solutions India Pvt Ltd
Ramya A. RRamya A. R
Senior Process Executive - Voice at Cognizant Technology Solutions India Pvt Ltd.Senior Process Executive - Voice at Cognizant Technology Solutions India Pvt Ltd.
Johnson PaulJohnson Paul
Service Delivery Manager at Cognizant Technology Solutions India Pvt LTDService Delivery Manager at Cognizant Technology Solutions India Pvt LTD
HAKEEM PASHA MOHAMMEDHAKEEM PASHA MOHAMMED
Associate - Projects at Cognizant Technology solutions India pvt ltdAssociate - Projects at Cognizant Technology solutions India pvt ltd
MARY MANJUMARY MANJU
Business Development Executive at Infocom Computers LLCBusiness Development Executive at Infocom Computers LLC