Hi I am Chandrabhan.
Primary Skills:
• ETL Tools: Talend DI, Talend Big Data Platform.
• SQL Database: Oracle 12c, PostgreSQL, Snowflake (snowpipe,functions,AWS Integration).
• Programming Languages: PL/SQL, Core Java, Python, UNIX Shell Script.
• Tools: SQL Developer, PgAdmin (3 & 4), TAC, Jira, Confluence, GIT, SnowSQL.
Additional Skills:
• Data Analysis and Reporting, Data warehousing.
• SQL, ETL Methodologies, Data Cleansing.
• Cloud: AWS (Lamda, S3, API Gateway, User management).
• HTML, Excel VBA.
I have Experience of creating Procedures and functions in Oracle and Snowflake DB but not in PostgreSQL.
I have excellent experience in creating and working with complex SQL queries and optimization.
• Excellent experience of creating SCD Type 1, Type 2, Type3 and Delta Load ETL jobs.
• Extensive knowledge of writing complex SQL Queries for data transform and extraction.
• Good experience in working with Java Routines in Talend and write custom code to implement complex logics.
• Worked extensively on java routines and collection framework in talend.
• Deft in working on optimization of Talend Jobs and reports as a part of Productivity Improvement.
• Working knowledge of regular expressions.
Currently I am working on creating Procedures , functions and SQL query optimization task in Snowflake for a US client.