Senior Executive - Data Warehouse Engineer
Andheri East, MH, IN, 400059
Reporting Relationship: Senior Technical Specialist
Job location: Bengaluru
Key Responsibilities:
- Maintain and optimize existing data warehouse pipelines and data models in Vertica
- Develop and enhance ETL workflows using Talend
- Convert Oracle stored procedures, queries, and logic into optimized Vertica-based data models
- Interpret business requirements and construct required SQL/query logic
- Collaborate with business stakeholders to gather, clarify, and translate requirements into technical specifications
- Ensure high precision, data quality, and auditability, especially for regulatory reporting
- Support downstream reporting systems including SSAS and Power BI
- Work with PostgreSQL and other auxiliary data systems as needed
- Troubleshoot performance issues and optimize SQL/data models
Education 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 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.
Work Experience:
5+ years of relevant experience
Specialization Description
Software Development Engineering (High Tech) focus on developing multiple types/categories of software including end-user applications and operating systems/utility software, that provides a platform for running end user applications for sale to external customers. The work includes:
- Conducting requirements gathering and analysis to understand the domain of the software problem and/or functionality, the interfaces between hardware and software, and the overall software characteristics
- Using programming, scripting, and/or database languages to write the software code
- Supporting software testing, deployment, maintenance, and evolution activities by correcting programming errors, responding to scope changes, and coding software enhancements
- Applying knowledge of software development best practices, including coding standards, code reviews, source control management, build processes, testing, and operations
Level Description
Entry to developing level professional with little or no prior experience required. Applies a broad theoretical job knowledge typically obtained through advanced education. Work is closely supervised. Works to deliver day-to-day objectives with limited impact on achievement of results for the job area. Explains facts, policies and practices related to job area. Problems faced are not typically difficult or complex.
Headquartered in Japan, NEC is a leader in the integration of IT and network technologies. With over 123 years of expertise in providing solutions for empowering people, businesses, and society, NEC stands tall as a champion in enabling change and transformation across the globe. Present in India since 1950, NEC has been instrumental in burgeoning India’s digitization journey continually for the past 70 years.
NEC India has proved its commitment to orchestrating a bright future through its diverse businesses from Telecommunications to Public Safety, Logistics, Transportation, Retail, Finance, Unified Communication and IT platforms, serving across the public and private sectors. NEC India, through the deployment of cutting-edge technology, has been powering India in seminal ways, making lives easier, safer, and more productive for all.
With its Centre of Excellence for verticals like Analytics platform solutions, Big Data, Biometrics, Mobile and Retail, NEC India brings to the table, innovative, seamless solutions for India and across the world.
NEC India is headquartered in New Delhi and has its offices panned across the country. It has branches in Ahmedabad, Bengaluru, Chennai, Mumbai, Noida and Surat.
Specialties:
IT & Networking Solutions, Unified Communication Solutions, Safety and Security Solutions, Integrated Retail Solutions, Data Centre Solutions, Safe and Smart City Solutions, Transportation Solutions, SDN Solutions, Carrier Telecom Solutions, and Solutions for Society.
