Abhijeet Kamthe
ETL Developer
Hire this person
Send a job offer directly to this candidate
About
Around 9 years of IT experience in the analysis, development and testing of data warehousing applications primarily using Informatica, Oracle. Good understanding of Dimensional Modeling. Planning, analysis, design, development & implementation of various Data warehousing assignments involving Informatica (ETL).
Hands on Experience in Informatica Power center 8.6.0/9.1 with focus on developing mappings, Workflow monitoring and scheduling. Good understanding of UNIX Shell Scripting. Flexibility in adapting to any new technology.
A good team player and can also work as an individual contributor. Proactive and have a good sense of time management.
Experience
Software Engineer at Amdocs (2016-11 – 2024-09)
- Part of Teradata to snowflake transformation project
- We have few manual work to do then existing utility to convert. bteq to. snowsql
- We have to build few mappings in IICS as per request
- Being T1 team, We are supposed to send them (T2 Team) a failure detail and command to execute to continue with Production jobs in case of failure
- Automation related work, Implemented auto shell scripts which sends email as well as file in particular log files directory with exact reason so that T2 team can take action
- Part of the Enterprise Datawarehouse team (eCDW) team
- Design, develop, and deliver end to end Datawarehouse/BI solutions
- Use control file in Vertica to support and TWS schedular to maintain and enhance the existing applications
- Optimize Copy utility in Vertica for faster loads
- Write shell scripts to create wrappers for batch execution and interaction with Vertica Databases
- Optimize internal configuration parameters in Vertica for best performance
- Use IBM Tivoli to schedule jobs
- Working in an Agile workflow with iterative deployments
Developer at Amdocs (2019-01 – 2024-09)
Client: AT&T
Developer at Amdocs (2016-11 – 2018-12)
Client: Rogers
- The project was a Migration one in which Applications were migrated from Teradata to Oracle
- The ETLs had to be rebuilt/modified and made to be pointed to Oracle instead of Teradata
- Modified/Rebuild logic to achieve same result in Oracle as in TD for various tables part of different applications
- Worked on performance optimization which was a major concern of the migration project
- Worked closely with DBAs to have better execution plan for the queries impacted and used proper hints in the queries
- Did unit testing right after any enhancement or new development in project
Software Engineer at Mannara Technologies pvt ltd (2015-07 – 2016-08)
Client: Guthy Renker
- Understanding the Business Requirements and Develop an ETL process to load data from source to target
- Creating mappings, sessions and workflows. Scheduled and monitored loading Informatica Workflow Manager
- Performing Unit Testing of ETL Mappings
- Manage day today ETL production support along with error resolution
- Implemented UNIX shell scripts
- Doing Analysis and finding the inconsistence in Informatica jobs, to resolve the problems and sending the right data to the end users
- Involved in Performance tuning in Informatica
- Sending corrected Email Campaign data to End user and third party vendor for e-mail marketing
- Designed Email opt out process and supporting same when required
- Analyzed existing system and developed Support documentation on changes required
Education
Master of Computer Science in Computer Science – PUNE UNIVERSITY
