Summary
Overview
Work History
Education
Skills
Timeline
Generic
Perkins Jones Samuel

Perkins Jones Samuel

Bengaluru

Summary

Innovative ETL & BI Lead Developer with 15+ years of experience known for high productivity and efficient task completion. Possess specialization in data warehousing, SQL, Python programming, and data integration tools. Excel in problem-solving, teamwork, and adaptability, ensuring smooth project execution and effective team collaboration. Results-driven ETL Lead Developer with strong skills in ETL processes, data transformation, and cloud migration. Proven track record in workflow optimization and performance tuning.

Overview

15
15
years of professional experience

Work History

ETL Lead Developer

Tata Consultancy Services
Bangalore
02.2022 - Current

Developed ETL processes to extract, transform, and load data efficiently.

  • Worked in cloud-based IBM Cloud Pak for data & closely worked with platform teams during migration & post migration on validation of flows etc.
  • Identified bottlenecks in ETL process and resolved them.
  • Involved in debugging source code written in SQL language used by Datastage components while extracting data from Oracle databases into flat files or vice versa.
  • Configured workflow tasks for scheduling purposes & worked in complex codes using Unix shell scripting.
  • Developed and executed test cases for ETL processes and data transformation.
  • Conducted system integration testing to ensure seamless operation of ETL workflows.
  • Performed end-to-end validations using SQL queries across different databases like Oracle and Teradata.

Senior ETL Developer

HCL Technologies
Bengaluru
04.2019 - 01.2022
  • Developed ETL processes to extract, transform, and load data efficiently.
  • Collaborated with data architects to design scalable data models.
  • Optimized existing ETL workflows for improved performance and reliability.
  • Conducted data profiling to ensure quality and accuracy of datasets.
  • Mentored junior developers on best practices in ETL development.

ETL & BI Developer

LTI
Mumbai
01.2017 - 03.2019
  • Developed interactive dashboards using Congos, Autosys BI for data visualization.
  • Collaborated with cross-functional teams to gather business requirements.
  • Designed and implemented ETL processes using Datastage for data integration.
  • Optimized data gathering processes, analysis procedures, and visualization strategies.

ETL & DB Developer

Cognizant Technology Solutions
Bengaluru
06.2014 - 12.2016
  • Designed and implemented ETL processes using Datastage & Informatica PowerCenter.
  • Developed and maintained data mappings and transformations for data integration.
  • Designed and developed stored procedures, functions, views and triggers using oracle for efficient data transformation
  • Created complex views, materialized views, tables and indexes in Teradata database environment.

ETL Developer

Wipro Technologies
Chennai, Bengaluru
10.2010 - 05.2014
  • Developed ETL processes using Informatica for data integration projects.
  • Provided technical support to end users regarding any problems related to ETL processes.
  • Created shell scripts that can be used as wrappers around datastage sequences or jobs for scheduling purposes.
  • Created complex mappings between source and target systems using DataStage Designer.
  • Involved in performance tuning activities for better ETL job performance by optimizing queries and improving query response time.

Education

Master of Computer Applications -

St.Josephs College of Engineering
Chennai
03-2010

Skills

  • IBM Datastage(CP4D& legacy), Informatica powercentre
  • Python programming -Pandas,Numpy
  • Unix shell scripting
  • PL/SQL programming
  • Databases: Teradata, Oracle, IBM DB2, MS SQL server, Amazon Redshift
  • BI Tools: Tableau,Cognos,MSBI
  • Scheduling tools: Autosys,UAC, IBM Tivoli, Crontab
  • ErWin Data modeler
  • Data profiling
  • Workflow optimization
  • Performance optimization
  • System integration testing

Timeline

ETL Lead Developer

Tata Consultancy Services
02.2022 - Current

Senior ETL Developer

HCL Technologies
04.2019 - 01.2022

ETL & BI Developer

LTI
01.2017 - 03.2019

ETL & DB Developer

Cognizant Technology Solutions
06.2014 - 12.2016

ETL Developer

Wipro Technologies
10.2010 - 05.2014

Master of Computer Applications -

St.Josephs College of Engineering
Perkins Jones Samuel