OnBenchMark Logo

Ajay (RID : x1l8lkasmplp)

designation   Talend Developer

location   Location : Jaipur, India

experience   Experience : 5 Year

rate   Rate: $18 / Hourly

Availability   Availability : Immediate

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 1
Total Views : 135
Key Skills
Talend Open Studio 5.3 to 7.0 Apache Airflow Mapping Design Palette AWS Redshift SQL MsSQL
Discription

Professional Summary:

 Having 5 year of total IT experience as a Talend Developer.
 Having strong knowledge in Data Warehousing, extensively used ETL methodology formsupporting Data Extraction, Transformations & Loading processing, in a corporate-wide-ETL
Solution using Talend Open Studio 5.3 to 7.0.
 Involved Jenkins Support Activities for Data Schedules.
 Good Knowledge on Talend Data Integration Tool – Mapping Design & Palette (Components)
 Have worked on components like tRedshift, tMsSql, tOracle components, tMap, tJava Components, DB Components, Sorter, Filter and Etc.,
 Having Knowledge in SQL.
 Excellent Written and Verbal communication skills, has clear understanding of business procedures and ability to work as an individual and as a part of a team.
 Worked on Apache Airflow as a orchestration tool which provides options to schedule, sequence and run scripts via DAG(Directed Acyclic Graph)


TECHNICAL SKILL SET:

Data Warehousing Talend 5.3 to 7.0
Databases SQL, MsSql & AWS Redshift
Languages SQL
Operating Systems MS Windows 10,Unix

EDUCATION:

 BCA Degree from William Carey University in 2017.





EXPERIENCE SUMMARY:

 CURRENTLY WORKING AS A SOFTWARE DEVELOPER FROM NOVEMBER 2022 TILL PRESENT.
 Worked as Software Developer from Sep 2021 to October 2022
 Worked as Software Developer from June 2018 to Aug 2021

PROJECT EXPERIENCE:

Organisation Confidential
Project Title #1 Pharma
Period Sep 2021-July 2022
Position Software Developer
Client Confidential


Project Description:

It is a diagnostic systems manufacturer with products focusing on the diabetes market, specifically blood glucose monitoring systems. They are leading a revolution in oncology to redefine cancer care. Our ambition is to provide cures for cancer in every form. They are following the science to understand cancer and all its complexities to discover develop and deliver life-changing treatments and increase the potential to cure.

Responsibilities include

 Involved in Data Extraction, Transformation and Loading (ETL Process) from Source to target systems using Talend.
 Created ETL’s to extract the data from AWS Redshift database by using S3 Bucket.
 Have worked on Redshift Copy/Unload commands for getting data from different sites of Clients user data.
 Creating a instance wise tables for better transparency on dashboards on different environments.
 Worked on transforming records from S3 bucket to JCPM Site (Dashboard) by converting the data into different data types (UTF) in UNIX platform of EC-2 instance.
 Executing the Apache Airflow DAG for running scripts and to reflect on Front End Dashboards.





Project Description:

It is one of the world’s leading biotechnology company. They develop medicines that change the lives of people living with neurodegenerative diseases and their Three blockbuster drugs make $5.5B in revenue annually – Avonex, Tysabri, Rituxan. For more than 35 years, Biogen Idec has been helping to improve the lives of people living with serious medical conditions. Since 1978, They produced therapies for diseases that affect hundreds of thousands of people around the world.
A pioneer in the biotechnology industry and one of the first biotech companies, It now has the world’s leading portfolio of MS therapies and in 2014 introduced new treatments for
haemophilia, bringing the first innovation to patients in almost two decades.

Responsibilities include

 Involved in the designing and implementation of the mappings for stage to data warehouse data loading.
 As a fresher I have involved in ETL Jenkins Jobs Support Activities.
 Monitoring the Jenkins schedules like Daily, Weekly, Bi-Monthly and Monthly.
 Resolved Production issues and keep involved the senior’s on priority.
 Worked Jenkins scheduling part like as per the client requirement scheduling the Jenkins jobs and scheduling.
 Also involved in Data Extraction, Transformation and Loading (ETL Process) from Source to target systems using Talend.
 Created ETL’s to extract the data from MsSql Server database and loaded to Redshift by using S3 Bucket.
 Have worked on Redshift Copy/Unload commands.
 Involved in the SCD types 1 and 2 implementations.

 

 

 

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!