Data Warehouse Engineer (Vertica Talend)

Key Responsibilities: Maintain and optimize existing data warehouse pipelines and data models in VerticaDevelop and enhance ETL workflows using TalendConvert Oracle stored procedures, queries, and logic into optimized Vertica-based data modelsInterpret business requirements and construct required SQL/query logic Collaborate with business stakeholders to gather, clarify, and translate requirements into technical specificationsEnsure high precision, data quality, and auditability, especially for regulatory reportingSupport downstream reporting systems including SSAS and Power BIWork with PostgreSQL and other auxiliary data systems as neededTroubleshoot performance issues and optimize SQL/data modelsEducation and Certifications: Mandatory Bachelor's degree (B.Tech /B.E.) Technical Skills, Knowledge & Abilities Strong experience with Vertica (or similar MPP data warehouse platforms)Hands-on expertise in Talend ETL developmentProficiency in SQL, especially query optimization and data modellingExperience in Oracle SQL / PL-SQL and migration to modern DW platformsAbility to translate business requirements into technical solutionsUnderstanding of data warehousing concepts (dimensional modelling, ETL, data quality)Familiarity with data warehousing concepts, including OLAP and data cubes.Experience with metadata management and implementing data quality frameworks.Programming skills in Python, SQL, or Java for building data workflows and automation scripts. .