ETL/SQL Developer - HCL Global Systems Inc.

• Skills required
o Expert level PL/SQL Development skills
o Expert level SAP Data Services ETL Development skills
o Strong understanding of dimensional models for Data Warehouses and hands-on experience building them.
• Duties include
o Design, develop, and test ETL (Extract, Transform, Load) processes using Oracle PL/SQL and SAP Data Services
o Collaborating closely with business analysts and data architects to understand the business requirements.
o Perform data profiling and data analysis to assess data quality.
o Develop and implement scripts for data cleaning, thoroughly verifying the integrity and quality of extracted data.
o Troubleshoot issues with existing ETL jobs, designing and implementing necessary fixes.
o Adhere to the organization's data privacy regulations and ensure that ETL processes carry out data compliance.
o Creating technical documentation to allow for easy maintenance and data recovery.
o Work on performance tuning to improve speed and efficiency of the data transformation processes.
o Collaborate with various IT teams and management to ensure smooth and reliable operations