Chennai, Chennai districtMember since 3 February 2025
·
Hire this person
Send a job offer directly to this candidate
About
Over 9 years and 6 months of experience in the IT industry.
Strong technical skills in Teradata and Informatica.
Extensively worked on data extraction, transformation, loading with teradata, flat files using INFORMATICA
Expertise in writing large/complex queries using SQL.
Proficient in performance analysis,monitoring and SQL query tuning using Explain Plan, Collect Statistics, and SQL in Teradata.
Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
Well versed with all stages of Software Development Life Cycle i.e. Requirement(s) Gathering& Analysis, Design/Redesign, Implementation and Testing.
Having basic knowledge on Unix, Amazon Redshift and AWS Lambda.
Worked in version control technologies such as Git and wincvs.
Good knowledge on Agile Methodology and the scrum process.
Good understanding of business in the Aviation domain and Banking domain.
Proven expertise in understanding specifications and standards to successfully deliver projects in a timely, cost- effective manner.
Experience
Developed and maintained the Control IT portal for reporting business exceptions.
Created business reports for reconciliation and revenue analysis.
Implemented projects using agile methodology in sprint cycles.
Proficient in using GIT for version control.
Involved in all phases of the software development life cycle, from requirements gathering to deployment.
Utilized IBM Tivoli as the job scheduler tool.
Successfully handled all aspects of application development, testing, deployment and live implementation.
Conducted sit-down sessions with the team to gather requirements effectively.
Created and loaded tables and views, utilizing Teradata for data warehousing.
Created scripts using FastLoad and Multiload to efficiently load data into the Teradata data warehouse.
Implemented business rules using SQL scripts, Macros, and stored procedures in Teradata.
Updated numerous BTEQ/SQL scripts, ensuring appropriate DDL changes were made, and completed unit and system tests.
Responsible for Extracting, Transforming, and Loading data from Oracle into the Data warehouse.
Implemented various transformations such as expression, aggregator, lookup, sequence generator, joiner.
Conducted testing of Informatica objects to validate test data and reviewed mappings.
Created, built, and scheduled workflows and sessions using the Workflow Manager.
Education
B.E. CivilEngineering Coimbatore Institute of Technology (CIT),Coimbatore CGPA 9.42/10.00
