Job Description

Required Skills

• Data Architecture
• Data Modelling and Design
• Data Storage and Operation
• SQL query development/building
• ETL using native SQL query
• Data Security
• Data Warehousing and Business Intelligence
• Metadata management
• Data Quality
• PostgreSQL, MySQL, MS-SQL, Oracle Databases
• DWH Experience (Greenplum/Teradata/Exadata/Vertica/Hadoop or Open Source based)
• Experience / Knowledge in data mining
• SQL Management (Query building, Execution, Programming)
• ETL using native SQL query
• Database archival management, purging, etc.
• Data ingestion and Database integration
• Database User management and Key management
• Database migration/upgrade same and cross platform
• Experience in database middleware tools.

KEY RESPONSIBILITIES:

• Responsible for the Architecting systems architecture, design, and development of a large, scaled-out, real-time, high performing Data Lake / Data Warehouse systems (including Big data and Cloud)
• Requirements analyses and finalize in discussion with the customer
• Design, modelling based on the customer ecosystem based on the set the guidelines
• Convert the work package into modules and work closely to deliver the task
• Manage the team for the technical deliveries
• Creation of complex Queries to retrieving data from database using joins, Sub Queries, Correlated Sub-queries, and Hierarchical queries for data retrieval operations and converting into Views and materialized views based on business requirement.
• Creation of database objects like tables, indexes, views, Sequences, Synonyms, and constraints.
• Experience with application programs such as stored Procedures, Functions, Packages, cursors, collections, and triggers and materialized views using SQL and PL/SQL with exception handling.
• Develop Packages (SQL loader, Data pump, and Import/Export utilities) each to import data to Oracle base tables from external files like CSV, Excel, JSON and XML.
• Develop Shell Scripts for invoking SQL scripts and scheduled in using jobs.
• Performing Unit Testing and Performance Tuning for each program developed.
• Preparing below mentioned documents for each project;
• Prepare Requirement specification document
• Prepare Technical Design Document
• Coding and scripts documentations
• Supporting team for integration with apache Spark and other open source framework for data processing
• Well versed in the Data domains (Data Warehousing, Data Governance, MDM, Data Quality, Data Catalogue, Analytics, BI, Operational Data Store, Metadata, Unstructured Data, ETL, ESB)
• Responsible for installation and configuration of Databases, back up, restoring databases, setting up High Availability, Disaster recovery, performance tuning etc.
• Perform Relational Database Modeling and Database Design on different operating systems
• Responsible for PostgreSQL/MS SQL Database administration.
• Design and deploy high availability load balancing and DR in On-Premise as well in Cloud environment
• Design backup policy/template and configure overall database backup and recovery
• Database Performance tuning and optimization which includes Operating System-level parameters also.
• Responsible for Database migration from one platform to another
• Responsible for providing CDC solutions
• Responsible for Database middleware related work and coordinating with application and development team
• Responsible to deploy and manage No-SQL databases like Hadoop HDFS, Hive etc.
• Responsible for working on cloud infrastructures such as Azure and AWS
• Responsible for developing SQL administration or data ingestion script using shell/PowerShell, PL SQL T-SQL, and PL/SQL
• Design and Development of database migration strategy

PrerequisitesBachelor\'s degree in computer science or a related field with over minimum 5 years of relevant experience.Base Location: Noida / MumbaiSpecialization DescriptionPlease enter manually when posting a roleLevel DescriptionPlease enter manually when posting a roleHeadquartered 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.-

NEC Corporation