Graduate Engineer Trainee

Employment Type

Description

Job Title:

Organization Name:

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

Prerequisites

• Data Storage and Operation
• SQL query development/building
• ETL using native SQL query
  

Base Location:

Specialization Description

• 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