Sishir Kumar V

• Over 10.6 years of IT experience with expertise in Data Engineering and ETL development.
• Skilled in IBM DataStage, Oracle SQL, PL/SQL Development, and ETL Process Design.
• Proficient in database optimization, performance tuning, and working with scheduling tools like Tivoli and Control-M.
• Extensive experience in data warehousing, data profiling, and implementing scalable ETL workflows.
• Strong interpersonal and communication skills with the ability to collaborate across teams.

· Extract Data: Design and implement processes to extract data from various source systems.

· Transform Data: Develop scripts and workflows to clean, normalize, and transform data according to business rules.

· Load Data: Ensure transformed data is correctly loaded into data warehouses or target systems.

· Monitor Workflows: Maintain and optimize ETL workflows for efficiency and reliability.

· Error Handling: Identify and resolve issues in the ETL processes.

· Documentation: Maintain detailed documentation of ETL processes, transformations, and workflows.

• Developed complex PL/SQL scripts, including stored procedures, functions, packages, and triggers.
• Designed efficient SQL queries for database optimization and troubleshooting.
• Collaborated with teams to integrate database components into larger applications.
• Ensured database security and integrity through rigorous testing and best practices.
• Conducted performance tuning and code reviews to maintain robust systems.
• Automated repetitive tasks using PL/SQL to improve workflow efficiency.

• System Design: Design the overall ETL architecture, including the data flow and integration strategy.
• Technical Leadership: Provide guidance on ETL best practices, tools, and technologies.
• Scalability Planning: Plan for scalability to handle increasing data volumes.

• Requirement Gathering: Collaborate with business stakeholders to understand data needs.
• Data Validation: Validate the quality and accuracy of extracted and transformed data.
• Testing: Perform tests to ensure the ETL processes meet business requirements.