Senior Executive Data Warehouse Engineer
Job Location:
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
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 Bachelors degree ( /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
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
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 Indias 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.
NEC Career Site-LinkedIn
Required Experience:
Senior Exec
About Company
NEC Group under the Solution for Society principle delivers safety, security, fairness and efficiency to our society with our partners around the globe.
