Job Description :

Job Title : Senior Executive - Data Warehouse Engineer (Vertica Talend)

Reporting Relationship : Senior Technical Specialist

Job location : Mumbai

Work Experience : 5+ years of relevant experience

Education and Certifications : Mandatory Bachelor's degree (B.Tech /B.E.)

About Company :

Company is a leader in the integration of IT and network technologies and brings more than 100 years of expertise in technological innovation to provide solutions for empowering people, businesses and society.

Headquartered in Japan, Company started operations in India in the 1950s, accelerating its growth through the expansion of business to global markets. Company in India expanded its business from telecommunications to public safety, logistics, transportation, retail, finance, unified communication and IT platforms, serving across governments, businesses as well as individuals. With its Centre of Excellence for analytics platform solutions, big data, biometrics, mobile and retail.

Specialties :

Network Systems, Personal Solutions, Electron, Devices, Big Data, SDN, Cloud, Security, Energy and environment, Work style transformation, Network Services, Virtualization, Space solutions, Common business solutions, and Common base technology.

Key Responsibilities :

- 1. Maintain and optimize existing data warehouse pipelines and data models in Vertica

- 2. Develop and enhance ETL workflows using Talend

- 3. Convert Oracle stored procedures, queries, and logic into optimized Vertica-based data models

- 4. Interpret business requirements and construct required SQL/query logic

- 5. Collaborate with business stakeholders to gather, clarify, and translate requirements into technical specifications

- 6. Ensure high precision, data quality, and auditability, especially for regulatory reporting

- 7. Support downstream reporting systems including SSAS and Power BI

- 8. Work with PostgreSQL and other auxiliary data systems as needed

- 9. Troubleshoot performance issues and optimize SQL/data models

Technical Skills, Knowledge & Abilities :

- Strong experience with Vertica (or similar MPP data warehouse platforms)

- Hands-on expertise in Talend ETL development

- Proficiency in SQL, especially query optimization and data modelling

- Experience in Oracle SQL / PL-SQL and migration to modern DW platforms

- Ability to translate business requirements into technical solutions

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