Data Engineer- GCP

Senior Database (PL/SQL)

Work Experience: 8+ Years

Number of Vacancies: 2

Location:

CTC: As per industry standards

Job Position: Oracle PLSQL Developer.

Required: Oracle Certified Database Developer

Key Skills:

• Must have basic knowledge in SQL Queries, Joins, DDL, DML, TCL, Types, Object, Collection Developer. Basic Oracle PLSQL programming experience (Procedures, packages, functions, exceptions.
• Develop, implement, and optimize stored procedures and functions using PLSQL
• Writing basic Queries, Package, Procedures, Functions, Triggers, Ref Cursors, Using Oracle 11g to 19c features, including triggers, stored procedures, queries, SQL Code, and design (stored procedures, functions, packages, tables, views, triggers, indexes, constraints, collections, bulk collects, etc..).
• Must have basic knowledge in PL/SQL Developer tool.
• Basic knowledge of MySql & Mongo DBA
• Strong communication skills
• Good interpersonal and teamwork skills
• PL/SQL, stored, procedure, functions, trigger
• Bulk Collection
• Utl_file
• Materilized View
• Performance handling
• Usage of Hint in Queries
• JSON (json object, json table, json queries)
• BLOB CLOB concept
• External table
• Dynamic SQL

Job Description

Function: Product → Product Analytics

Responsibilities:

• Assist product managers in the formulation of the company's product strategy using structured data and insights derived from the same
• Conduct research, create business cases and translate them into meaningful problems to solve
• Measure impact of experiments related to function, analysing and helping in course correction.
• Recommending product improvements based on analytical findings. Defining new metrics, techniques, and strategies to improve performance.
• Constantly monitor and analyse metrics identified, publish insights/any anomalies along with hypothesis
• Translating business requirements and user requests into effective report and dashboard designs in challenging deadlines.
• Assist with performance tuning of dashboards, background data queries as needed

Key Skills Required:

• Bachelor’s degree along with 2+ years experience in product analytics building data sets, reports, and dashboards
• Strong analytics skills and experience in Metabase, Google Analytics, Power BI, or other analytics software
• Proficiency with SQL
• Agile ability to anticipate need, be responsive and adapt to change
• Strong interpersonal and relationship skills, ability to influence decisions and gain consensus
• Excellent time and project management skills, ability to prioritise the most important projects to create business impact

Perks at Oneistox:

• Challenging work, High Product Ownership, and Steep Learning Curve are guaranteed!
• You get to be part of a highly young and energetic team.
• Envisage the growth of a company from 5X to 500X.
• Industry standard compensation and ESOPS.

4 - 8 overall experience.

• 1-2 years’ experience in Azure Data Factory - schedule Jobs in Flows and ADF Pipelines, Performance Tuning, Error logging etc..
• 1+ years of experience with Power BI - designing and developing reports, dashboards, metrics and visualizations in Powe BI.
• (Required) Participate in video conferencing calls - daily stand-up meetings and all day working with team members on cloud migration planning, development, and support.
• Proficiency in relational database concepts & design using star, Azure Datawarehouse, and data vault.
• Requires 2-3 years of experience with SQL scripting (merge, joins, and stored procedures) and best practices.
• Knowledge on deploying and run SSIS packages in Azure.
• Knowledge of Azure Data Bricks.
• Ability to write and execute complex SQL queries and stored procedures.

1. Create and maintain optimal data pipeline architecture
2. Assemble large, complex data sets that meet business requirements
3. Identifying, designing, and implementing internal process improvements including redesigning infrastructure for greater scalability, optimizing data delivery, and automating manual processes
4. Work with Data, Analytics & Tech team to extract, arrange and analyze data
5. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies
6. Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition
7. Works closely with all business units and engineering teams to develop a strategy for long-term data platform architecture.
8. Working with stakeholders including data, design, product, and executive teams, and assisting them with data-related technical issues
9. Working with stakeholders including the Executive, Product, Data, and Design teams to support their data infrastructure needs while assisting with data-related technical issues.

1. SQL
2. Ruby or Python(Ruby preferred)
3. Apache-Hadoop based analytics
4. Data warehousing
5. Data architecture
6. Schema design
7. ML

1.  Prior experience of 2 to 5 years as a Data Engineer.
2. Ability in managing and communicating data warehouse plans to internal teams.
3. Experience designing, building, and maintaining data processing systems.
4. Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions.
5. Excellent analytic skills associated with working on unstructured datasets.
6. Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata.

• 5+ years of experience in software development.
• At least 2 years of relevant work experience on large scale Data applications
• Good attitude, strong problem-solving abilities, analytical skills, ability to take ownership as appropriate
• Should be able to do coding, debugging, performance tuning, and deploying the apps to Prod.
• Should have good working experience Hadoop ecosystem (HDFS, Hive, Yarn, File formats like Avro/Parquet)
• Kafka
• J2EE Frameworks (Spring/Hibernate/REST)
• Spark Streaming or any other streaming technology.
• Java programming language is mandatory.
• Good to have experience with Java
• Ability to work on the sprint stories to completion along with Unit test case coverage.
• Experience working in Agile Methodology
• Excellent communication and coordination skills
• Knowledgeable (and preferred hands-on) - UNIX environments, different continuous integration tools.
• Must be able to integrate quickly into the team and work independently towards team goals

• Take the complete responsibility of the sprint stories’ execution
• Be accountable for the delivery of the tasks in the defined timelines with good quality
• Follow the processes for project execution and delivery.
• Follow agile methodology
• Work with the team lead closely and contribute to the smooth delivery of the project.
• Understand/define the architecture and discuss the pros-cons of the same with the team
• Involve in the brainstorming sessions and suggest improvements in the architecture/design.
• Work with other team leads to get the architecture/design reviewed.
• Work with the clients and counterparts (in US) of the project.
• Keep all the stakeholders updated about the project/task status/risks/issues if there are any.

We are establishing infrastructure for internal and external reporting using Tableau and are looking for someone with experience building visualizations and dashboards in Tableau and using Tableau Server to deliver them to internal and external users. 

Required Experience 

• Implementation of interactive visualizations using Tableau Desktop  
• Integration with Tableau Server and support of production dashboards and embedded reports with it 

• Writing and optimization of SQL queries  
• Proficient in Python including the use of Pandas and numpy libraries to perform data exploration and analysis 
• 3  years of experience working as a Software Engineer / Senior Software Engineer 
• Bachelors in Engineering – can be Electronic and comm , Computer , IT  
• Well versed with Basic Data Structures Algorithms and system design 

• Should be capable of working well in a team – and should possess very good communication skills 
• Self-motivated and fun to work with and organized 
• Productive and efficient working remotely 
• Test driven mindset with a knack for finding issues and problems at earlier stages of development 
• Interest in learning and picking up a wide range of cutting edge technologies 

• Should be curious and interested in learning some Data science related concepts and domain knowledge 
• Work alongside other engineers on the team to elevate technology and consistently apply best practices 

Highly Desirable 

• Data Analytics 

• Experience in AWS cloud or any cloud technologies 
• Experience in BigData technologies and streaming like – pyspark, kafka is a big plus 
• Shell scripting  
• Preferred tech stack – Python, Rest API, Microservices, Flask/Fast API, pandas, numpy, linux, shell scripting, Airflow, pyspark 
• Has a strong backend experience – and worked with Microservices and Rest API’s - Flask, FastAPI, Databases Relational and Non-relational 

• Expertise in designing and implementing enterprise scale database (OLTP) and Data warehouse solutions.
• Hands on experience in implementing Azure SQL Database, Azure SQL Date warehouse (Azure Synapse Analytics) and big data processing using Azure Databricks and Azure HD Insight.
• Expert in writing T-SQL programming for complex stored procedures, functions, views and query optimization.
• Should be aware of Database development for both on-premise and SAAS Applications using SQL Server and PostgreSQL.
• Experience in ETL and ELT implementations using Azure Data Factory V2 and SSIS.
• Experience and expertise in building machine learning models using Logistic and linear regression, Decision tree  and Random forest Algorithms.
• PolyBase queries for exporting and importing data into Azure Data Lake.
• Building data models both tabular and multidimensional using SQL Server data tools.
• Writing data preparation, cleaning and processing steps using Python, SCALA, and R.
• Programming experience using python libraries NumPy, Pandas and Matplotlib.
• Implementing NOSQL databases and writing queries using cypher.
• Designing end user visualizations using Power BI, QlikView and Tableau.
• Experience working with all versions of SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019
• Experience using the expression languages MDX and DAX.
• Experience in migrating on-premise SQL server database to Microsoft Azure.
• Hands on experience in using Azure blob storage, Azure Data Lake Storage Gen1 and Azure Data Lake Storage Gen2.
• Performance tuning complex SQL queries, hands on experience using SQL Extended events.
• Data modeling using Power BI for Adhoc reporting.
• Raw data load automation using T-SQL and SSIS
• Expert in migrating existing on-premise database to SQL Azure.
• Experience in using U-SQL for Azure Data Lake Analytics.
• Hands on experience in generating SSRS reports using MDX.
• Experience in designing predictive models using Python and SQL Server.
• Developing machine learning models using Azure Databricks and SQL Server