Sourav Chakraborty
Bengaluru
Summary
Having 4yr of total IT experience in the Analysis, Design, Development, Testing and Implementation using Teradata & Mainframe platform. Good knowledge on Teradata SQL,ETL tools like Informatica and Devops tools. Have worked in Snowflake for some time. Good understanding on Agile methodologies. Performed Analysis and Development activities as per the requirement of the project. Performed Unit testing, System and System Integration Testing and took part in troubleshooting the issues in the testing environment. Involved in Development, Quality Processes, Supported the estimation techniques for the project cost. Ability to translate the functional/ Non Functional requirements of project for respective teams. Good Knowledge on writing test cases Scenarios based on the specification of the project.
Overview
4
4
years of professional experience
Work History
SQL Developer, ETL Developer and Testing
Carelon Global Solution
09.2020 - Current
- Company Overview: Carelon Global Solution a health insurance company i
- Involved in Design and Development of simple and complex Teradata SQL scripts as per the project requirement
- Interacted with multiple teams according to the data transformation and upstream/Downstream impacts
- Preparing the documentation of the requirement and securing approvals and engagement of different teams like DBA, PRC teams for the new project implementations
- Did ETL modifications, testing, and support using Informatica, SCAT, FCAT, Bitbucket, and Control-M.Prepared and implemented test plans for the project
- Implement end to end Etl Process using Informatica
- Prepared the efficient test cases for the project activities
- Resolving the JIRA tickets or defects which are assigned after deployments and during implementation activities
- : Validated DDLs and DMLs during migration processes, achieving high data accuracy
- Performed System and Integration testing activities as per the requirement of the team using Urban code deployment tool
- Involved in error resolution during UT, ST, SIT and implementation activities for better performance
- Preparing of the requirement for functional and Nonfunctional activities
- Solving the Incidents, Problem tickets and Change request tickets according to the given SLA
- Worked on the quality of the project majorly and provide the accurate result with in the deadlines and target assigned
- Tools used: INFORMATICA, SQL, Oracle, Unix and Anaconda testing
- From: SEPTEMBER 2020 to Till Date
Education
Bachelor of Technology - EE
Institute of Technical Education & Research
Bhubaneshwar08.2019
Higher Secondary -
Kalinga Bharati Residential Collage
Cuttack05.2015
SSC -
Stewart School
Jajpur03.2013
Skills
- SQL
- ETL
- Bitbucket
- Informatica
- Snowflake
- Control-m
- Teradata
- Unix Shell Scripting
Personal Information
Date of Birth: 03/07/98
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge.
Skillsset
SQL scripting in Teradata,Snowflake and ORACLE,ETL tools like Informatica, JIRA, Agile, Bitbucket, Scheduler tool like Control m,Unix Shell Scripting
Timeline
SQL Developer, ETL Developer and Testing
Carelon Global Solution
09.2020 - Current
Bachelor of Technology - EE
Institute of Technical Education & Research
Higher Secondary -
Kalinga Bharati Residential Collage
SSC -
Stewart School
Similar Profiles
Anupam PandeyAnupam Pandey
Product Manager at Carelon Global SolutionProduct Manager at Carelon Global Solution
Asfar UsmaniAsfar Usmani
Senior Software Engineer at Carelon Global SolutionSenior Software Engineer at Carelon Global Solution
Amit Ramesh BramhechaAmit Ramesh Bramhecha
Software Engineer II at Carelon Global SolutionSoftware Engineer II at Carelon Global Solution