Now you can Instantly Chat with Sumeet!
I have over 7 years of experience as an ETL Support Specialist and I am currently working as a Sr. Data Operation Analyst at TIAA GBS INDIA, with qualified skills with Teradata SQL, ETL tools - Informatica & Datastage, Unix and BigData. I feel tha...
- Analyzing software requirements and providing code fixes.
- Enhancement of modules of its previous version.
- Contributed in Implementation and Testing of Image Processing module.
- Extensively involved in enhancement of Fee Management module.
- Provided suggestions for FORM designing.
Responsible for supporting L1 & L2 tasks as a Team Lead and delegate responsibilities among peers.
Troubleshoot and recover ETL failures and provide quick resolutions to meet SLA in case of any failures.
Perform unit testing, integration testing and provide support to users in UAT phase.
Developed and tested mapping, sessions and workflows using Informatica Powercenter 9.1.
Create load scripts using Teradata utilities to automate manual processes.
Developed jobs using Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator.
Developed complex mappings using concepts like Slowly Changing Dimension(SCD) mappings of type I, II and type III (version, flag and time stamp) and Push Data Optimization (PDO).
Developed jobs using extensively reusable components with mapplets and parameters.Show More Show Less
Monitoring ETL & Hadoop daily critical jobs and giving support to the application in the production environment are the key responsibility for me.
Developed Extract/Transform/Load solutions using Informatica/Datastage to store data coming from different sources in databases(Teradata/Oracle/Hive).
Extensively engaged in code deployment into production environment with the use of Gitlab/Jenkins/Serena.
Responsible for setting up and supporting Disaster recovery (DR) environment in case of production server issues.
Used the tools/technologies such as Hadoop, Hive, Cloudera, IBM Infosphere Information Suite (DataStage), Teradata, Oracle, Autosys, Unix/Linux Scripting.
Main duties are resolving the incidents, performing code migration from lower environment to production, working with the Dev team in case of code related issues.
Enhancing the existing jobs for process improvement by SQL performance tuning or change in ETL load type.
Working on system issues on production cluster like file system issue, connection issues, system slow and monitor the HDFS file system of all digital analytics go.
Provided preliminary support to the new Hadoop projects migration to the production environment.
Responsible for performing the data extract in Hadoop as well as Teradata platform.
Automated the Data validation process of critical data loads before sending over the data to Downstream applications.Show More Show Less