Redshifttrabajos

...proyecto específico. El proyecto debe completarse en el plazo de una semana. Tareas: - Entender una macro de Excel VBA que hace uso de muchos archivos. - Luego de entender que hace replicar una forma de obtener el mismo resultado con SQL o Python - El Python resultante debe ser ejecutable en AWS lambda o AWS Glue y/o el SQL resultante debe ser lomas estandar posible porque debe funcionar en AWS Redshift Habilidades y experiencia ideales: - Dominio de Excel VBA, con una sólida comprensión de las macros y la automatización - Conocimientos de Python o SQL para la manipulación y extracción de datos - Experiencia en el desarrollo de soluciones eficientes y escalables para el procesamiento y análisis de datos - Gran capacidad de reso...

Proyecto modelado para un cliente con el programa cinema 4D y motor de render Redshift

...tener conocimientos de animación 3D y aplicar las diferentes técnicas para solucionar los retos técnicos que se planteen en la escena. - Trabajo remunerado (sueldo bruto/mensual a negociar) con duración de Septiembre a Noviembre (incluido), con la posibilidad de darle continuidad en el 2023 para el resto de episodios. Requisitos imprescindibles: - Experto en software Cinema 4D y Motor de render Redshift (sólo presentarse candidatos con estos mínimos requisitos). Además, se valorará tener conocimiento en otros softwares y motores de render. - Dominio del paquete Adobe CC, principalmente After Effects. - Experiencia en animación, diferentes técnicas, eficiencia y optimización de escenas, VFX. - Acostumbra...

Hola que tal, estoy buscando una persona que me pueda ayudar y orientar con un proyecto de Ingesta de Datos en Python. 1. Extraer información de una BD de Postgress y llevarlo al S3 de AWS 2. Llevar el archivo de S3 a una tabla en Redshift. **Tengo un proyecto ejemplo ya moldeado pero necesito una persona(guía) para aplicar y probar cambios. Nota: Comunicación en Español. Saludos.

...comportamiento del cliente, bases de datos estructuradas y no estructuradas. - Deseable tener experiencia en la extracción de información a través de URLs. - Buena experiencia en la detección y resolución de problemas de calidad de datos y lagunas de datos. - Experiencia en SQL trabajando con grandes bases de datos transaccionales y de clientes en diferentes plataformas (por ejemplo, SQL Server, Vertica, Redshift, etc.) - Experiencia con herramientas analíticas (por ejemplo, R, SAS, Python, etc.) - Deseable experiencia en técnicas de ciencia de datos - Habilidades avanzadas con software de visualización de datos (como el uso de Tableau, Qlikview, PowerBI, Datorama). El proyecto necesita que el candidato tenga disponibilidad...

Hi Ignacio Gabriel M.,un gusto me presento soy iluminador igual y estoy buscando una persona que tenga houdini redshift que me pueda ayudar a iluminar una escena, estarias interesado?

Hola pedro me ha gustado lo que haces y me pregunto si tienes Houdini con redshift render. Tengo un trabajo de luz para una escena. saber si tienes ese sofware con ese motor de render. saludes

Chicos tengo una escena con luces en houdini renderizado en mantra, me gustaria que estas luces que puse en la escena alguien las convierta a redshift porfavor

En VATES S.A. nos encontramos en la búsqueda de un Cloud Data Engineer para trabajar freelance por tres meses. Orientamos nuestra búsqu...con su experiencia. Se requieren conocimientos y experiencia en: Conocer y saber navegar por los distintos componentes de AWS Conocimientos sólidos en python, Lamdas y API REST Nivel de inglés intermedio. Lugar de trabajo: Remoto. Requisitos mínimos * Licenciatura / Diploma en informática, ingeniería en informática o carrera a fin. Experiencia trabajando con tecnologías de big data de AWS (Redshift, S3, EMR) Experiencia en la construcción / operación de sistemas distribuidos de extracción, ingestión y Procesamiento de grandes conjuntos de datos de gran...

Necesitamos personas que tengan conocimientos en modelación y animación 3D y 2D implementando herramientas como Cinema 4D y Redshift R20 para diversos proyectos.

ARQUITECTO DE SOLUCIONES JAVA – SECTOR BANCA(Envía tu CV ó recomienda a un amigo)Tú puedes ser la persona que estamos buscando, esta es tu oportunidad, revisa nuestro perfil: Edad: Indistinta Sexo: IndistintoIdiomas: Inglés AvanzadoSolo debes cumplir con los siguientes requisitos:Escolaridad: Licenciatura o Ingeniería en Sistemas Computacionales, Informática, Actuaria o carr...en alguna de las siguientes tecnologías:? JAVA (Certificación necesaria)? Integración Continua (Jenkins, Nexus, Sonar, Git)? MongoDB (Certificación deseable)? CassandraDB? Elasticsearch? OpenStack (Certificación deseable)? AWS Solution Architect(Certificación necesaria)? Docker? Apache Hadoop (Certificación deseable)? Ap...

Actualmente buscamos una persona con conocimientos en Business Intelligence y Data Mining para que nos apoye en picos de trabajo como freelance. Si te interesa simplemente apúntate y si conoces a alguien que podría encajar te agradecemos mucho si lo compartes. Necesitamos a una persona con conocimientos en: - Amazon Redshift - Amazon DynamoDB o MongoDB - Amazon Kinesis - Herramientas de ETL y Reporting - Javascript - PHP, MySQL y POSTGRESQL Buscamos a una persona flexible, con capacidad de aprendizaje y capaz de mantenerse al día en las últimas tendencias en desarrollo, tecnología y marketing digital. Valoramos: - Multidisciplinaridad y visión global: que pueda abstraerse del ámbito de la programación para e...

I'm a beginner in AWS and would like to receive hands-on training on specific services. My goals for this training are to: - Gain a thorough understanding of the Cloud formation service - Learn best practices and use-cases of the RDS and S3 services - Explore the data handling capabilities of Glue and RedShift - Understand the working of EC2 and its significance - Get insights on SQS/SNS services and their usage I'm looking for an AWS expert who has experience in these services, and can provide me with clear explanations and practical examples. A structured approach to learning, with emphasis on real-world applications, would be greatly beneficial. Please share your relevant experience and teaching methodologies in your proposal.

...schedules. Timings : 10:00 am - 07:00 pm IST Remote (India) • Collaborate with business analysts to understand and gather requirements for existing or new ETL pipelines. -Connect with stakeholders daily to discuss project progress and updates. -Work within an Agile process to deliver projects in a timely and efficient manner. -Have worked extensively on Redshift and understands performance tuning techniques and management of Redshift data workloads. -Design and develop Airflow DAGs to schedule and manage ETL workflows. -Implement best practices for data engineering, including data modeling, data warehousing, and data pipeline architecture. -Monitor and troubleshoot ETL pipelines to ensure smooth operation. -Custom Python functions to handle data quality and validat...

As the owner of a large SQL Server database, I'm looking for the expertise to convert my SQL Server code to Redshift SQL. The database in question is greater than 10GB and primarily contains valuable customer data. The ideal freelancer for this project should: - Have a strong understanding of SQL and Redshift - Experience in data conversion of Stored procedures, views, functions etc., specifically from SQL Server to Redshift - Familiarity with transforming and restructuring customer data Your job will be to ensure the correct and efficient migration of all customer data without loss of any rows. Be prepared to handle the larger data volume of this SQL Server database

Explain the concept : Amazon RDS Amazon Aurora Amazon DynamoDB Amazon Neptune Amazon Memory DB for Redis DocumentDB Amazon QLDB Athena Overview Redshift Overview EMR Overview

Budget: 5$ I...png. I am also attaching some logos below but feel free to browse the internet and find the png logos. All the logos provided should be standard sized, transparent background in png format with one color and one grayscale export. I need the following logos: SAP SAP Business Objects SAP Analytics Cloud Microsoft Microsoft Power BI Microsoft Power Apps Microsoft Azure Microsoft Fabric AWS AWS Redshift Google Google Cloud Platform Google Big Query Tableau Qlik Salesforce Zendesk For your application to be considered, please: - Be experienced in creating and editing logos - Include at least one example of a logo for me to see you can edit this properly. Attention to detail and a quick turnaround time are critical for this project. I look forward to your speedy ...

...tasks that need to be performed to ensure that our data structures run smoothly and effectively. Specifically: - One of your main responsibilities would be to add 5 new calculated columns in our Redshift table. To do this, you will need to update existing Glue jobs that are written in Python. Test this in DEV, UAT and Production. - Furthermore, you will need to create or update views and stored procedures in Redshift to create a tableau extract. The core competences that candidates need to possess are: - Extensive experience with AWS data stack including Glue (used with Python), S3, Redshift etc. - Strong understanding of data structures and databases. - Solid knowledge of Python. - A proven track record working on similar projects would be adva...

I'm looking to have a SQL view query written in Redshift. With no specific tables indicated, the freelancer should be adept enough to identify the relevant tables during the development process. Requirement: - Expertise in SQL and Amazon Redshift. What To Include In Your Proposal: - Please include any past work related to SQL queries, especially if you've previously worked with Redshift. Deliverable: - The use of this SQL view query is for reporting purposes, so it needs to be efficient and reliable.

...custom scripts as needed. ● Ensure the efficient extraction, transformation, and loading of data from diverse sources into our data warehouse. Data Warehousing: ● Design and maintain data warehouse solutions on AWS, with a focus on scalability, performance, and reliability. ● Implement and optimize data models for efficient storage and retrieval in AWS Redshift. AWS Service Utilization: ● Leverage AWS services such as S3, Lambda, Glue, Redshift, and others to build end-to-end data solutions. ● Stay abreast of AWS developments and recommend the adoption of new services to enhance our data architecture. SQL Expertise: ● Craft complex SQL queries to support data analysis, reporting, and business intelligence requirements. ● Optimize SQL code for performance and efficiency, ...

...understanding of cloud and cloud native principles and practices · Hands-on experience with cloud environments - AWS, GCP, Azure · AWS Services:EC2, EC2 container service, Lambda, Elastic beanstalk, S3, EFS, Storage gateway, Glacier, VPC, Direct connect, Transit Gateway, ELB, Auto Scaling, ACM, Cloud Front, Cloud Formation, Cloud Watch, Cloud Trail, SNS, SES, SQS, SWF, IAM, RDS, DynamoDB, Elasticache, Redshift, AWS Backup · Operating Systems: UNIX, Redhat LINUX, Windows · Networking & Protocols: TCP/IP, Telnet, HTTP, HTTPS, FTP, SNMP, LDAP, DNS, DHCP, ARP, SSL, IDM 6.0 and 7.0 · DevOps Tools: Puppet, Chef, Subversion (SVN), GIT, Jenkins, Hudson, Puppet, Ansible, Docker and Kubernetes · Scripting Languages: UNIX Shell Scripting (Bour...

I need an experienced AWS Data Engineer to develop a robust data warehouse for moving data from Sql Server to S3 using AWS DMS. Then from S3 to Redshift. The data, which is currently in CSV files, will need to be efficiently imported into AWS. The ultimate aim is to enable seamless analytics and reporting from the data warehouse. Ideal Skills and Experience: - Proficiency in AWS data warehousing - Strong experience with CSV files - Prior experience with Sales Data highly preferred - Clear understanding of data warehouse design and architecture. - Proficiency in AWS DMS , AWS S3. - AWS Email Notification.

...specifically Cassandra, BigQuery, Snowflake, and Redshift. Key Responsibilities: - Research, understand, and articulate the distinct approaches of and the other specified databases - Translate complex concepts into clear, concise, and reader-friendly articles Ideal Candidate Should Have: - You need to have very deep expertise in databases and distributed systems. - Ideally, a Ph.D. or some deep research writing experience. Any conference publications in top conferences are a plus. - An understanding of database architectures - Prior experience writing technical articles for a technical audience - The ability to explain complex topics in an easy-to-understand manner - Knowledge about Cassandra, BigQuery, Snowflake, and Redshift will be a big plus. In the scope of this ...

As part of a critical project, I'm looking for an AWS data engineer who has substantial experience in the field spanning 8-10 years. Key Responsibilities: - AWS data engineering - Handling data migration tasks - Working exclusively with structured data. Required Skills and Experience: - Deep knowledge of AWS services such as AWS Glue, Amazon Redshift, and Amazon Athena is mandatory. Prior experience working with these services is a prerequisite. - The candidate should have extensive experience in managing structured data - A minimum of 8-10 years experience in data engineering is required, specifically within the AWS environment - A strong background in data migration tasks is paramount for effective execution of duties. Given the nature of the data involved in this pr...

I'm seeking a talented 3D artist to create a high-quality, realistic model of a bottle. My goal is to use this model for static product visualizations. Key Project Elements: - Craft a detailed 3D bottle model - Ensure realistic textures and materials - Optimize for static product visualization renders - Tailor specifically for rendering with Redshift in Cinema 4D Ideal Skills: - Proficiency in Cinema 4D and Redshift - Experience with product visualization - Strong portfolio of realistic 3D models - Ability to deliver detailed and accurate work The final output should be a meticulously detailed, photo-realistic 3D model that can be rendered in high-quality static images. I need an artist who can not only capture the intricate details of the bottle but also present it...

...spearhead the operation. I plan to utilise Amazon S3, Amazon Redshift, and Amazon EMR for this project. I need your insight and hands-on experience with these AWS services, to effectively manage and shape the course of this project. The project will handle medium-sized data, approximately between 1TB-10TB. It indicates a large-scale job that demands acute attention and expertise. In regards to data security and privacy,itional encryption measures will be required on top of basic security measures. If you are well-versed in data encryption methods and can ensure the reliability and security of sensitive information, then you are who I am looking for. Skills and Experience: - Comprehensive knowledge of Amazon S3, Amazon Redshift, Amazon EMR - Experience with medium t...

I am seeking an experienced AWS data architect capable of designing an optimized data architecture for my project. This would involve the integral use of multiple AWS services including Amazon S3, Amazon Redshift, Amazon Athena, AWS Glue, AWS Lambda, and AWS DynamoDB. It's crucial for the project that the freelancer has expertise in integrating AWS Aurora into this data structure. Key responsibilities: - Comprehensive understanding of Amazon S3, Redshift, Athena, Glue, Lambda, and DynamoDB. - Experience integrating AWS Aurora into data structures. - Design of highly optimized and scalable data architectures. - Familiarity with data migration and management strategies. - Robust problem-solving abilities with a keen attention to detail. Our ideal candidate is analytical...

...pipe, streams, Stored procedure, Task, Hashing, Row Level Security, Time Travel etc. Proficiency in SQL, data structures, and database design principles. Strong experience in ETL or ELT Data Pipelines and various aspects, terminologies with Pure SQL like SCD Dimensions, Delta Processing etc. 3+ years of Experience of working with AWS cloud services- S3, Lambda, Glue, Athena, IAM, CloudWatch, Redshift etc. 5+ years of proven expertise in creating pipelines for real time and near real time integration working with different data sources - flat files, XML, JSON, Avro files and databases Excellent communication skills, including the ability to explain complex technical concepts clearly. Prior experience in a client-facing or consulting role is advantageous. Ability to manage p...

...performance and efficiency Pyspark ,sql,python Cdk Typescript Aws glue ,Emr and andes Currently Migrating from teradata to aws. Responsibilities: - Migrate data from another cloud provider to AWS, ensuring a smooth transition and minimal downtime - Design and develop applications that utilize AWS Glue and Athena for data processing and analysis - Optimize data storage and retrieval using AWS S3 and Redshift, as well as other relevant AWS services - Collaborate with other team members and stakeholders to ensure project success and meet client requirements If you have a strong background in AWS migration, expertise in working with structured data, and proficiency in utilizing AWS Glue and Athena, then this project is perfect for you. Apply now and join our team to hel...

I am seeking assistance with a research project focused on data warehouse implementation, specifically in the area of cloud-based data warehouses. Skills and experience required for this project include: - Strong knowledge of data warehousing concepts and principles - Experience with cloud-based data warehousing platforms, such as Amazon Redshift or Google BigQuery - Proficiency in data modeling and designing data warehouse schemas - Understanding of ETL (Extract, Transform, Load) processes and tools - Ability to analyze and integrate data from multiple sources - Familiarity with SQL and other programming languages for data manipulation and analysis The deliverable for this project is a comprehensive report that summarizes the research findings and provides recommendations for i...

...Spark, is also crucial. In addition to these core skills, we require expertise in AWS cloud services, particularly AWS Glue and Amazon Kinesis. Experience with AWS Glue will be vital for ETL operations and data integration tasks, while familiarity with Amazon Kinesis is important for real-time data processing applications. Furthermore, the candidate should have a solid understanding of Amazon Redshift, our data warehousing solution, to manage and analyze large datasets efficiently. The Senior Data Engineer will be responsible for designing and implementing scalable data pipelines, ensuring data quality and integrity, and optimizing data processing workflows. The role involves close collaboration with data scientists, analysts, and other stakeholders to support data-driven decis...

I have AWS RDS MySQL database that is of 1TB (1000GB) size. I'm looking for freelancer to migrate it to AWS Redshift. I have ~10 MySQL queries that I want to be re-written for Redshift. I will share all the details. Start your proposal with "Redshift" keyword to be considered.

I am looking for a freelancer to create a document that compares the performance and cost of Redshift serverless and Redshift provisioned. The purpose of this document is to help me make a decision between the two options. I want the comparision in terms of query time, pricing, warm up time and compare with Redshift provisioned and redshift serverless. Specific dimensions that I would like to compare include speed, cost, and scalability. The target audience for this document is technical experts. Ideal skills and experience for this project include: - Strong knowledge of Redshift serverless and Redshift provisioned - Experience in conducting performance and cost comparisons - Ability to present complex technical information in a clear and ...

I am looking for a freelancer who can complete some somewhat simple SQL queries for data analysis. The ideal candidate should have experience in MySQL and be comfortable working with intermediate queries involving JOINS and GROUP BY. This project requires the following skills and experience: - Strong proficiency in SQL - Experience with MySQL or Redshift SQL - Ability to write intermediate queries involving JOINS and GROUP BY If you have the necessary skills and experience, please submit your proposal.

...Timings : 12pm - 9pm IST M - F AWS Data Engineer Requirements • Collaborate with business analysts to understand and gather requirements for existing or new ETL pipelines. • Connect with stakeholders daily to discuss project progress and updates. • Work within an Agile process to deliver projects in a timely and efficient manner. • Have worked extensively on Redshift and understands performance tuning techniques and management of Redshift data workloads. • Design and develop Airflow DAGs to schedule and manage ETL workflows. • Implement best practices for data engineering, including data modeling, data warehousing, and data pipeline architecture. • Monitor and troubleshoot ETL pipelines to ensure smooth operation. • Custom Python f...

I am looking for a freelancer who can help me with a project that involves reading data from a Redshift serverless DB using AWS Glue. The project requirements are as follows: Output format preference: - The extracted data should be in JSON format. Data transformation and cleaning: - No significant cleaning or transformation is required. - I just need the raw data extracted from the Redshift serverless DB. Ideal skills and experience: - Experience working with Redshift serverless DB and AWS Glue. - Experience in python and typescript If you have the necessary skills and experience, please submit your proposal outlining your approach to this project.

I am a professional with advanced knowledge and experience in Redshift. I am interested in furthering my understanding of the subject by delving deeper into the topics of data warehousing and query optimization. I am seeking individual training to best fit my needs.

...following AWS services: EC2, S3, Redshift, and Glue. The main objective of this project is to efficiently store, analyze, and migrate data using AWS services. I expect the project to be completed within 1-3 months. Responsibilities: The chosen candidate will be responsible for the following tasks: - Utilize EC2 for scalable computing power and efficient data processing. - Utilize S3 for secure and reliable data storage. - Utilize Redshift for high-performance data warehousing and analytics. - Utilize Glue for ETL (Extract, Transform, Load) processes to efficiently transform and migrate data. Requirements: The ideal candidate for this project should have the following skills and experience: - Strong expertise in AWS services, specifically EC2, S3, Redshift, and G...

...Observatory Data Repository etc; You are free to use any visual tool that is free for research purposes. Some suggestions include Tableau Public, Google Data Studio,Microsoft Power BI, etc. You may also consider the following visual tools for data extraction, transformation, and loading: you can use any of the following : , Talend Open Studio,MarkLogic,Oracle Data Integrator,Amazon RedShift I will need assistance with data extraction, transforming ,loading and perform exploratory data analysis to understand patterns and trends in the data and Create meaningful visualizations to represent your findings. My desired end result is an Excel spreadsheet or some other file for the data presentation . If you are able to execute this task effectively and timely, I would be very eager to

Hello, I need someone who can provide a support for my aws glue job project. Its mainly involve in: -creating glue job script, -configuring connection with redshift, pgAdmin db, s3 -creating triggers and crawlers -transforming and enriching data -python knowledge is required -testing and debugging experience - creating glue workflow is a plus please reach out if you are interested in providing support. Regards Sanch Adane

I need a Java developer who can create a lambda function to read and write data to a Redshift serverless DB. The purpose of this operation is data backup. Requirements: - Experience with Java and lambda functions - Experience with Redshift serverless DB - Ability to prioritize data types or tables (if specified) - Knowledge of strict security and compliance protocols

Hi there! I am looking for a talented 3D modeller to provide a rough quote for creating a decent quality 3D model of an agricultural machine for use in animations. The reference image attached is the only one I have at the moment but I'm in the process of getting more imagery, dimensions and hopefully diagrams of the object. It doesn't need to be super-...quote for creating a decent quality 3D model of an agricultural machine for use in animations. The reference image attached is the only one I have at the moment but I'm in the process of getting more imagery, dimensions and hopefully diagrams of the object. It doesn't need to be super-photorealistic but should have some basic materials applied that I'll be able to work with in Cinema 4D 2023 and Redshift. L...

Looking for Backend Developer in python who have a Good knowledge in Python, pycharm,Developing Django Application , Deployment and AWS services such as S3, Redshift, Dynamodb, SQL, MySQL etc

Project Title: Expertise in Python (pycharm), AWS s3, redshift, dynamodb, lambdas, Git, Jenkins, and Aurora I am looking for a skilled Python developer with experience in AWS services and Git version control. The ideal candidate should be familiar with the following: AWS Services: - AWS S3 - Redshift - DynamoDB - Lambda - Aurora Git and Jenkins: - Proficient in using Git for version control - Knowledge of Jenkins for continuous integration and deployment The candidate should also be good with Unit testing in Python. If you have the required skills and experience in Python, AWS services, and Git, please apply for this project.

Time : 9am to 1 pm Total duration : 20hr Total 5 days of training Toc/syllabus attached

I am looking for an experienced AWS data engineer who can assist me with Serverless Redshift and PySpark. I do not need help with setting up a system of automation, but I may require assistance with running analytics on the data. The ideal candidate should have experience with the following: - Serverless Redshift - PySpark Skills and experience required for this project: - Strong knowledge of AWS services, particularly Serverless Redshift and PySpark - Experience in data engineering and analytics - Familiarity with S3, Lambda, Boto3, and step functions would be a plus - Ability to work independently and efficiently - Excellent problem-solving and communication skills Working time = 8:30 PM EST to 10:30 PM EST (6 AM IST to 8 AM IST) Duration = 3 to 6 months

We need AWS Data Engineer (Redshift, Talend is must) to work for 2 hours a day remotely. We will give 25-28k per month

Task 1: Create an Infrastructure as Code (in Cloud Formation Python) to spin-up an S3 bucket, 2 EC2 instances, 1 RDS. Also create an auto-scaling capability in when the EC2 CPU usage goes more than 80%. Please demo the code and deploy it in AWS to show it works. Taks 2: Question 1: Create a project in GIT in GIT CI, upload a sample code from Task 1, fork the code and add AWS Redshift service to the code, run the pipeline, merge it back to the main branch. Task 3: Describe with an architecture diagram on how we can migrate an Weather Forecast application installed in EC2 to AWS Faregate in details step by step guide.

Role & Responsibilities: ● Work with cloud engineers and customers to solve for ...developing Big Data solutions (migration, storage, processing) ● Experience in SQL and Query optimisation ● Ability to clearly communicate technical roadmap, challenges and mitigation ● Experience building and supporting large-scale systems in a production environment Technology Stack: ● Cloud Platforms – AWS ● Mandatory – High programming skill in Python and Pyspark, Hands-on experience with the AWS Redshift ● Nice to have - Experience in Bigdata Technologies such as Hive, Spark, Lambda, AWS Cloud with focus on AWS Glue to create ETL pipelines ● Design Dimensional Models for Data Warehouse and Data Marts ● Knowledge of version control systems, build automation and CI/CD tools and fram...

Looking to have ometria rest api set up to connect into redshift database