SQL Jobs

Job description: · 5+ years of experience in ETL and Data warehousing · Should be able to handle the ETL team · Good Experience in AWS such as AWS Aurora, AWS Redshift & AWS S3. · Strong expertise in writing complex SQL Queries, Stored procedures and functions · Experience in Talend ETL and Agile Methodology. · Experience in Core Java and JasperSoft is a plus

The SQL PROC will need to compare two database tables ( I will provide the table structure and sample data) New additions to the table are new staff that have joined the organisation and should be emailed to the Service Desk within the PROC. Leavers are records which do not exisit in the table and should be emailed to the Service Desk within the PROC. Changes in staff departments or roles should be emailed to the Service Desk within the PROC. Teh PROC will need to maintain an audit trail of record changes

fix a small SQL query for report generation. 15-20 mins job. Will pay max 10$

java. Should be easy level for an experienced coder. starts 31.05 and have to be finished the same day.

We would like to write between 5 and 10 reports using Microsoft Sentinel against a M365 Audit database.

Need someone proficient with php to work on an ongoing project - with an on demand type of style - will be paid per hour worked. Will need the dev to create endpoints, create/modify some api and create new tabs on sql

Project duration: Upto December 2022 Hours required : 40+ per week Payment per hour Mandatory Skills and Knowledge: Core Java/J2EE/REST API/Spring MVC/Sprint Boot/XML/Hibernate Must have experience in REST API and Spring and Dev Ops (Maven/Bit Bucket/automated build) Good in Java Security Concepts Experience in PL/SQL, SQL Server Good Communication Skills Roles and Responsibilities: Write Java code modules and as per coding standards Experience and Knowledge of Agile and Scrum Process and coordinate with teams Participate in client meetings to communicate status or give demos Abide by team coding standards, development processes and best practices Develop low level design documents and review technical documents from Solution Architects for projects Perform code review and follow iterat...

Project Objective: 1. Build tally plugin which can download ledger data from tally to the local machine and then publish the same online using our APIs 2. Extend the tool to be able work with all Tally version About NAKAD: NAKAD is founded by former graduates of IIM Ahmedabad, IIT Bombay and IIT Guwahati who previously worked at BCG, HUL and Oracle, The company is transforming supply chain finance through their tokenization mechanism. This way Anchor's creditworthiness traverses across supply chain making easy and cheap credit available to MSMEs.

We are looking for a Data Analytics expert with the below mentioned skills : Mandatory skills : SQL, Python, Py-Spark Required experience : 3-7 years Location : India Hours required : 40+ per week Payment per hour

DotNet developers required for errors removal thenafter synchronisation of sourcecodes & host. Lots of good opportunities and financial benefits for DotNet, Xamarin, Cordova, Android, iOS developers after Launch. Explaining 'Basic functionalities' video- Explaining 'Errorlist' video- Website address- Useremailid- @gmail.c Password- kaspersky

Module to be covered: Introduction to SAP and SAP Overview SAP Business Suite 3 Tier structure and S/4 HANA overview Overview on the key function modules like SD,MM & FI, PP, PM, PS, HCM etc Overview on the SAP Organization structure ERP/SAP Overview ABAP Language Overview and Workbench Concepts and Tools Programming Techniques Overview of SAP cloud and Saas, Pass and Lass ABAP Language Overview and Workbench Concepts and Tools SAP Database Architecture SAP GUI and Netweaver Search help in SAP transactions & SAP Library Exception handling Overview of SAP cloud ABAP List Processing File Handling Techniques & OSS Notes Application Debugging & Dump Analysis Programming Database access and updates Batch Data Communications (BDC)/BAPI/LSMW Module Pool Development SapScript/Smart...

We are looking for Python ETL Developer Minimum Experience- 3 Years Shift -Indian Shift Contract- 6 Months (Can be Extended)

Databases er diagram about social network databases , report writing contains data requirement analysis, conceptual data, DDMS specification

Databases er diagram about social network databases , report writing contains data requirement analysis, conceptual data, DDMS specification

Need a procedure to create database schema as per the user_name. 1. Create a public database with sample data table. 2. Create a procedure to create a user and id. 3. Create a procedure to create a user based on user name and copy in new user schema.

We are looking for full time Oracle Software Developers who are able to undertake support and development in Oracle 19c using PL/SQL and SQL. Preference will be given to those who can work from home on a full time, dedicated basis for our project wholly.

I need to build a basic CRM/database (Ideally with airtable) of customer name a demographics that also links through to multiple documents per record in a separate table with other information

Se requiere una base de datos distribuida de al menos 2 servidores diferentes y su interfaz está sería sencilla, solo para interactuar con las bases Podría ser entre el gestor Oracle y SQL para la conexión La interfaz puede ser una aplicación móvil una página web o programa para escritorio Las bases serían sobre una tienda de mochilas llamada el mochilero, se cuenta ya con la base de datos en SQL con sus tablas y rellenadas solo estaría pendiente la interfaz y la conexión con Oracle

Se requiere recoger los datos de una base de datos en Microsoft SQL Server para convertirlos en un archivo pre determinado. La definición del archivo esta atachada a este proyecto. Un 60% del trabajo ya esta completado.

Necesito continuar con el desarrollo de una aplicación Web en ASPNET Core, lenguaje C# a nivel del servidor y react a nivel del cliente. La aplicación deberá permitir que los empleados de una compañía puedan ingresar por cada uno de los dias del mes, la cantidad de horas invertidas en distintas tareas predeterminadas.

Display in table form the results of the following two SQL instructions (you might use the characters | , ! , - or _ to help display the table in the text response)

I am looking for a Java software engineer who can help us develop new features and regular maintenance on the existing Gym management software. SQL, Spring experience would be helpful.

I need someone with skillset of database CDM that can help with development, validation programming, discrepancy management, database release, extraction and graphical representation of safety data during study conduct, review of data before database lock, review of CSRs.

I need a trainer who can give corporate training on Data Engineering on Microsoft Azure Total Number of Day - 15 Topics need to be cover 1. Overview of Azure ecosystem 2. Relational Databases 3. NoSQL Databases 4. Data Warehousing 5. Azure Synapse (formerly SQL Data Warehouse) 6. PySpark and Components 7. Azure Data Engineering Services introduction 8. Explore compute and storage options for data engineering workloads 9. Run interactive queries using serverless SQL pools 10. Data Exploration and Transformation in Azure Databricks 11. Explore, transform, and load data into the Data Warehouse using Apache Spark 12. Ingest and load data into the data warehouse 13. Transform data with Azure Data Factory or Azure Synapse Pipelines 14. Integrate data from notebooks with Azure Dat...

IMPORTANT: My budget is very limited This task is super basic: Connect to MSSQL database and display a sample SELECT query results in a datagridview You only have to connect to my MSSQL. Then fetch data with this query: SELECT TOP (1000) [SiteID] ,[ResourceID] ,[ItemNmbr] ,[QtyOnHand] ,[StockDT] FROM [AIMS].[dbo].[TrxDailyStock] Then display it in a datagridview (attached image). I will provide access to the VPS that has the database and also the C# project.

basic select, joining, grouping, nested, common table expressions. should be simple job for a pro. I will present you with schemas and about 20 queries. sqldeveloper using oracle.

I’m looking for someone to help me build a portfolio management and analysis program. We have been using an excel based system for a long time which works really well, but we want to try and wrap it up in a software program that is more solid and robust. the program works by sucking data from a financial administration (eg netwealth or HUB24) platform in CSV format. This data contains information about clients, investments, values, units held, cost base information, transactions etc. the excel program slices and dices the data to present it in a way that we want. It’s very dynamic

My server crashed so i was only able to recover data, had no access to phpmyadmin or sql Hi, I downloaded all data and i have the mysql folder from the server It contains all folder and tables for my databses but the files are frm file and ibd files I need to use those in anyway to be able to export sql file that i can upload to my new server It might be possible the ibd or frm are corrupted, so should be able to fix those. Thanks

I am looking for a Tableau expert to support my Tech Lead based out of India on daily basis

I have a Volusion store. I need to retrieve Order details for each order that I can then use to build excel spreadsheets. I want to be able to control which data fields from the Orders database are pulled. I think the best way to do this is through API but open to suggestions.

We provide gyms and health clubs with sales, marketing and membership services to help them grow. We are looking to build a new mobile App that will allow our gym and health club customers to provide their members with useful functionality to help manage their memberships. The app needs to be available in multiple languages (EN and DE initially) and should be designed to allow further languages to be added easily in the future. Our Health Clubs should be able to: - Publish news and information about their club to the Newsfeed for App users to view - Share local offers and information with their members - Send updates/ push notifications to their members The apps will need to integrate with our enrolment process for new user registration and our internal SQL data to allow memb...

Looking for python developer expert for mobile app backend including rest API, database and scalable architecture

hey i have an excel file with 16K rows containing a website urls column and additional columns with data on that website i have lots of dupluicated rows i need uniqu values in the website column, removing duplicates, merge values to 1 line per website

This module will collect all the Appreciation/Suggestion/Feedbacks from the will go though a approval process from HR. After approval Appreciation will show on our website & Suggestion should have acknowledgement from HR & Feedback will be given to that person though mail. Reports will be required on this. Note - Application should be Mobile Responsive, Database connectivity and hierarchy (Reporting to Reportees) in Laravel/8 or Laravel/9 and Login Page and session and Email for each process(stage) and approval cycle.

We are looking for ETL Developer Minimum Experience- 3 Years Shift- Indian Shift Contract- 6 Months (Can be Extended ) Working Days- Monday to Friday

We have a Postgresql database in google cloud containing ~10 tables with transactions, master data etc. We would like to achieve the following to start consume this data: 1. Set up a new instance of bigqueery 2. Secure that all tables from our database are streamed live (or close to live) to bigqueery 3. Create one new table that joints some of the tables loaded 4. Create a connector to big queery and: - allow us to access the tables through powerquery in excel - same as above for import to Google sheets - spin up some simple report in Data Studio for us to continue to build from 5. Secure a handover of the above so that we can maintain the solution and develop further and advice on how we can go ahead to import data sources to our DW

Need IICS (CDI) offline job support in Bangalore

I'm looking for an Pyhton Expert. I have two XML / RSS Feeds, which should be parsed by Python and stored into MS SQL database.

PLEASE READ (do not waste my time) Need untouched fresh UK phone number lists. Old people phone numbers are preferred. I do not need scraped or easily accessible data. Do not message me offering scraped data, or old used up data that has been run through call centres. The data must come from a websites database (not scraped), or from marketing campaigns such as CPA etc... Again - please do not waste my time with bad data, I will not buy anything until I have an adequate sample of at least 3,000 phone numbers!

Job Title: Technical Analyst- ETL Dev Experience : 3 to 8 Yrs Relevant Experience: Tech Analyst ETL - Overall experience of 3 to 5 Yrs and 3+ Yrs into Informatica Power Center and experience into IICS will be plus. Analyst ETL - Overall experience of 7+ Yrs and 4+ Yrs into Informatica Power Center and 1+ Years of experience into IICS Notice Period: Immediate or Max 15 days Job Location: Bangalore Shift Time: 1 PM to 10 PM Experience and Mandatory Skills: ETL development using Informatica Power Center. 3+ years of experience in developing SQL code in Snowflake/Oracle/MS SQL. Good knowledge about Business Intelligence, Data warehousing concepts and methodologies and Reporting tools Experience designing complex ETLs extracting data through RDBMS, Flat file, XML files, Json sources Shou...

Hi I am receiving report on CSV file and wants to upload on my server. Admin can upload these report and user can check those Basic User system also required. Admin create user and user can see those report with some unique password (Predefine password can add)

get data from sql server 2000 to azure sql db

Se requiere una base de datos distribuida de al menos 2 servidores diferentes y su interfaz está sería sencilla, solo para interactuar con las bases Podría ser entre el gestor Oracle y SQL para la conexión La interfaz puede ser una aplicación móvil una página web o programa para escritorio Las bases serían sobre una tienda de mochilas llamada el mochilero, se cuenta ya con la base de datos en SQL con sus tablas y rellenadas solo estaría pendiente la interfaz y la conexión con Oracle

Create, design and implement a web-based application capable of running SQL queries and displaying the results of said query. The application must include a space which accepts SQL queries in the form of user inputs, then runs the given query, and displays the result within the application.. Please note: - **This is a dummy application**. - **You must include a space to accept SQL queries**. This can be as simple as a textarea or as complex as a full-blown code-editor. This does not figure in the judging criteria though. - Your application **does not need to have a backend, a query engine or query validation**. - You **do not need to add any syntax validation**. - The data that your application displays can be any chunk of data. It does not need to be the actual result that the query wou...

Se requiere una base de datos distribuida de al menos 2 servidores diferentes y su interfaz está sería sencilla, solo para interactuar con las bases Podría ser entre el gestor Oracle y SQL para la conexión La interfaz puede ser una aplicación móvil una página web o programa para escritorio Las bases serían sobre una tienda de mochilas llamada el mochilero, se cuenta ya con la base de datos en SQL con sus tablas y rellenadas solo estaría pendiente la interfaz y la conexión con Oracle

using oracle database, forms, XML,API

I am looking for a Java software engineer who can help us develop new features and regular maintenance on the existing Gym management software. SQL, Spring experience would be helpful.

I have a customized WordPress website that needs to speed the SQL queries and fix a bug.

Sql,SSIS,ssrss,ssas to be used for the data warehouse

I am looking for someone with expertise in R/Python to build a web based app where user will upload data on a webpage (a set of excel files) and should be able to generate a visualization report. The files will undergo transformation and upon clicking download, it should generate a report with static visualizations and descriptions. Qualifications and Skills: - R/Python - Computer Science/ IT/ MCA - B.E (Final year students)