ETL Developer
Resume:
ARIJIT ROY
Permanent Address:
A-Zone,Durgapur-713204,
West Bengal
15th November 1995, India Mobile: 790-***-**** / 876-***-**** E-mail: *************@*****.***
OBJECTIVE
To work and develop amidst a challenging and competitive environment, being innovative, honest and hardworking, maneuvering to bring the best out of me, so that my endeavors are conducive to constant personal growth and can adjoin in the goals of the organization. I am working as an ETL Developer in Cognizant and have working experience on technologies like Informatica PowerCenter, Oracle, Pl/SQL, Unix, SQL, Data warehousing, Data Integration. WORK EXPERIENCE
Programmer Analyst
Cognizant, October 2019 – Present
Role : ETL Developer
Read, analyze and provide feedback and changes on business requirement documents
Strong data warehousing and OLTP system knowledge from database/ETL development perspective
Assist with design and implementation of staging areas and data warehouse
Design, build, testing and maintenance of data integration / ETL processes
Prepared technical designs for Informatica mappings
Created and executed mapping using Slowly Changing Dimensions Type 2
Experience in designing and building complete ETL processes, including moving and transforming data for ODS, Staging, Intermediate and production environment
Knowledge of Oracle DB including database querries, package, procedure, functions, indexes
Participated in providing the project estimates for development team efforts for the off shore as well as on-site.
Programmer Analyst Trainee
Cognizant, October 2018 – September 2019
Role : ETL Developer
Read, analyze and understand on business requirement documents
Analyze and support real time or production failures within deadline
Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 9.x to extract the data from multiple source systems that comprise databases like Oracle 11g, flat files to the Staging area, Intermediate tables and then to the production environment.
Strong management skills with the ability to work in a team-based environment including employees, vendors, and third party contractors
Effectively prioritize and execute tasks in a high pressure environment
Detail design of source to target data mappings
VOCATIONAL TRAINING
INTERN AT DURGAPUR STEEL PLANT,SAIL
DURGAPUR STEEL PLANT, SAIL
The topics included: Single line Diagram, DC and AC motors, Transformers, Cables, Steel Making, Relays, Switches and Gears, Power Plant Working.
EDUCATION
COURSE INSTITUTION
YEAR
OF
COMPLETION
GRADE/PERCENTAGE
B.E. in Electrical and
Electronics
Engineering
Nitte Meenakshi Institute Of
Technology, Bangalore
April,2018 8.12 CGPA
CBSE – XII (PCMC) Guru Teg Bahadur Public
School, Durgapur
May,2014 79.4%
CBSE – X Durgapur Ispat Vidyalaya,
Durgapur May,2012 89.4%
PROJECTS
DESIGNING OF FLIGHT CONTROLLER BOARD USING ARDUINO AND IMPLEMENTING IT IN MULTIROTOR AERIAL VEHICLE (FINAL YEAR PROJECT)
To design a flight controller board using Arduino Uno and interfacing it with IMU to detect the angle of movement of the quadcopter and also to balance it. NOVEMBER 2017-APRIL 2018
ARDUINO BASED DTMF CONTROLLED SURVEILLANCE CAR (SUMMER PROJECT) The project is to develop a car which can be controlled through smart phone using DTMF decoder to send information, from anywhere in the world.
JUNE 2017 – JULY 2017
SAND SAMPLE COLLECTOR (UNDER CENTRE FOR ROBOTICS RESEARCH) The challenge of the project was to make a robot which should be capable of moving on uneven terrain and also to make the design so as to collect the sample of sand from a particular area after drilling and pouring the sand into a separate container.
JULY 2016
Mini Project
o Smart Home Security System using ARDUINO UNO.
o Temperature controlled DC fan using 8051 Microcontroller. o Contactless Tachometer using 8051 Microcontroller. o C++ based TIC-TAC-TOE game using OOPS concept.
WORKSHOPS
Workshop on Lego Mindstorm and Tetrix by Centre for Robotics Research, NMIT
Workshop on Recent Trends in Digital signal processing by Dept. of EEE, NMIT
TECHNOLOGY &TOOLS
Proficient in: Oracle SQL, UNIX, Informatica PC, Control-M
Familiar with: Arduino, Microcontroller 8051
Having core knowledge of Transformers, DC and AC machines, Power System lines, Op-Amps, Power Electronic devices.
STRENGTHS AND PERSONAL SKILLS
Good communication skills
Adaptability to change
Open to learning
Creative
Dedicated
Hardworking
Goal Oriented
Leadership.
PERSONAL DETAILS
Languages known- English, Hindi, Bengali.
Hobbies- Surfing web about latest technologies, Watching Japanese Anime, Reading Novel, Travelling with friends, Sketching.
Campus Activities:
Organized TEQUIP seminars, conducted workshops as Technical Head of the EEE branch from 2016 – 2018
Organization and hosting of events as Technical member of ANAADYANTA, the college annual techno- cultural fest from 2017-2018
ACHIEVEMENTS
Certificate of Completion in "ROBOTICS ENGINEERING-LEGO MINDSTORM & TETRIX" (06/2016)
Certificate of Participation in "RECENT DEVELOPMENTS IN DIGITAL SIGNAL PROCESSORS FOR INDUSTRIAL APPLICATIONS” (02/2017)
Certificate of Excellence in Sports(12/2003 – 01/2011) I hereby solemnly declare that the above written particulars are true to the best of my knowledge and belief. Regards,
Arijit Roy.
Contact this candidate