Oracle & Netezza Data Warehouse Expert

Role Overview :

We are seeking an experienced Oracle & Netezza Data Warehouse Expert with expertise in Talend ETL to join our team in Mumbai, Pune, or Chennai for a UK Shift role.

In this role, you will be responsible for designing and maintaining robust data warehouse solutions on Oracle and IBM Netezza, while building scalable ETL workflows using Talend (Open Studio / Data Integration).

You will work closely with architects and analysts to deliver enterprise-grade data integration solutions and ensure that all data is properly transformed, cleansed, and Responsibilities :

• You will design, develop, and maintain data warehouse solutions on Oracle and IBM Netezza, ensuring that the solutions are scalable, efficient, and high-performing.
• Your role will also include building and optimizing ETL workflows using Talend, focusing on performance tuning and optimization of SQL, PL / SQL, and NZSQL queries.
• You will collaborate with architects and analysts to ensure that the data integration processes meet business requirements and adhere to best practices.
• Additionally, you will execute tasks related to data profiling, transformation, cleansing, and enrichment, while ensuring that data quality and governance are maintained throughout the process.
• You will also be responsible for troubleshooting and tuning ETL jobs and database performance to ensure optimal Skills :
• To succeed in this role, you will need 7+ years of experience in Oracle Data Warehousing, with strong expertise in SQL and PL / SQL.
• Additionally, you should have 5+ years of experience in working with IBM Netezza and NZSQL.
• Expertise in Talend ETL (Open Studio or Data Integration) for at least 3 years is required.
• You should also have a solid understanding of data warehousing concepts, optimization, and performance tuning.
• Furthermore, experience with integrating both structured and unstructured data into data warehouses is Skills :
• Knowledge of Informatica or DataStage will be beneficial for the role, as well as familiarity with Shell scripting or Python for automation.
• Experience with visualization tools such as Tableau, Power BI, or Looker is also desirable.
• Additionally, certifications in Talend, Oracle, or Netezza would be a strong advantage for the role.

Why Join Us :

(ref : hirist.tech)