Apply now »
Graduate Engineer Trainee
Company : NEC Corporation India Private Limited
Employment Type
Office Location :
Noida, UP, IN, 201305
Work Location : Hybrid
Req ID : 5307
Description
Job Title : Data Engineer
Organization Name : NEC Corporation of India Ltd.
Reporting Relationship
Required Skills
- Data Architecture
- Data Modelling and Design
- Data Storage and Operation
- SQL query development / building
- ETL using native SQL query
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 customerDesign, modelling based on the customer ecosystem based on the set the guidelinesConvert the work package into modules and work closely to deliver the taskManage the team for the technical deliveriesCreation 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 documentPrepare Technical Design DocumentCoding and scripts documentationsSupporting team for integration with apache Spark and other open source framework for data processingWell 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 systemsResponsible for PostgreSQL / MS SQL Database administration.Design and deploy high availability load balancing and DR in On-Premise as well in Cloud environmentDesign backup policy / template and configure overall database backup and recoveryDatabase Performance tuning and optimization which includes Operating System-level parameters also.Responsible for Database migration from one platform to anotherResponsible for providing CDC solutionsResponsible for Database middleware related work and coordinating with application and development teamResponsible to deploy and manage No-SQL databases like Hadoop HDFS, Hive etc.Responsible for working on cloud infrastructures such as Azure and AWSResponsible for developing SQL administration or data ingestion script using shell / PowerShell, PL SQL T-SQL, and PL / SQLDesign and Development of database migration strategyPrerequisites
Bachelor's degree in computer science or a related field experience.
Data Storage and OperationSQL query development / buildingETL using native SQL queryBase Location : Noida
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 characteristicsUsing programming, scripting, and / or database languages to write the software codeSupporting software testing, deployment, maintenance, and evolution activities by correcting programming errors, responding to scope changes, and coding software enhancementsApplying knowledge of software development best practices, including coding standards, code reviews, source control management, build processes, testing, and operationsLevel Description
An experienced support level position that requires a basic knowledge of a given job area and tools, typically seen through work experience as well as vocational or technical training. Works under moderate supervision. Problems are typically of a routine nature, but may at times require interpretation or deviation from standard procedures. Communicates information that requires some explanation or interpretation to achieve business results for a given area of a department or function.
Apply now »
Show more
Show less
Skills Required
T-sql, Hadoop, Powershell, Postgresql, Pl Sql, hdfs , Ms Sql, Hive, Data Architecture, Azure, Aws