Perkins Jones Samuel

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.

• 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.

• 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.

• 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.

• 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.