Etl project powercenterdela
Estoy buscando...y oportuna, utilizando las mejores prácticas de integración de datos. Requisitos Técnicos: Amplia experiencia en integración de bases de datos y soluciones de análisis de datos. Conocimientos sólidos en SQL, así como experiencia en la conexión y gestión de bases de datos relacionales (MySQL, PostgreSQL, SQL Server, etc.). Dominio en el uso de herramientas y tecnologías de integración de datos (ETL, APIs RESTful, Web Services, etc.). Experiencia en la configuración de entornos de acceso seguro a bases de datos, incluyendo autenticación y autorización de usuarios. Capacidad para trabajar con herramientas de visualización de datos y otros sistemas analítico...
I'm looking for a part-time, remote MLOps engineer who can help with a range of tasks related to model deployment, data pipeline management, and monitoring and maintenance. Role Overview We are seeking a skilled Part-Time MLOps Engineer with 3+ years of experience to drive the deployment, mon...orchestration (Docker, Kubernetes). Proficiency in cloud platforms (AWS, GCP, or Azure) for ML infrastructure. Experience with version control systems (Git) and CI/CD pipelines. Solid understanding of machine learning workflows and challenges in production. Preferred Skills: Knowledge of monitoring and logging tools (Prometheus, Grafana, ELK stack). Experience in data engineering concepts (e.g., ETL pipelines, data preprocessing). Familiarity with DevOps practices and tools (e.g., Jenk...
*Description*: We are seeking an experienced consultant to integrate *JD Edwards* and *Epicor Kinetic ERP* systems, specifically focusing on *Accounts Receivable (AR)* and *Accounts Payable (AP)* modules. The ideal candidate should have expertise in ERP integration, data mapping, API development, and ETL processes. *Key Requirements*: • Proven experience with JD Edwards and Epicor Kinetic ERP systems. • Strong knowledge of AR/AP workflows and data structures. • Proficiency in API integration and data security best practices. • Ability to deliver within a defined timeline. *Deliverables*: ]• Seamless integration of AR/AP modules between the two systems. • Documentation of the integration process. • Post-integrat...
...with the implementation of SAP Analytics Cloud for Planning (SAC Planning) Scope of project is to deliver a Planning & Reporting solution which includes Financial Statements Planning and Revenue Planning aligning with the S/4 go-live The solution will be used by approximately 40 users and such work will incorporate the tasks to define, develop, test and rollout the planning system Offshore role responsibilities include: • Understanding of integrating SAP SAC Planning with other SAP solutions such as SAP S/4HANA, SAP S/4HANA Cloud using standard integration methods and APIs • Experience in integrating SAP SAC Planning with other SAP and non-SAP systems for data extraction, transformation, and loading (ETL) • Experience in configuring Import Jobs for Ma...
...details for every execution. Documentation and Guidance: - Provide clear instructions for running and maintaining the scripts. - Minimal guidance to help me perform small tasks like testing queries or troubleshooting basic issues in BigQuery if needed. Requirements: - Strong experience with SQL and Python. - Proficiency in Google BigQuery for setting up and managing datasets. - Familiarity with ETL/ELT processes and cloud platforms like Google Cloud. Deliverables: Python scripts that: - Extract data from SQL and load it into BigQuery. - Run automatically at scheduled intervals. - Organized BigQuery datasets ready for analysis. - Documentation for maintaining the process and handling common issues....
I'm looking for a seasoned data engineer to assist with my data warehousing project on Amazon Redshift. Key Responsibilities: - Design and implement an efficient and scalable data warehousing solution - Ensure seamless integration of data from various sources - Optimize the data warehouse for performance and cost-efficiency Ideal Skills: - Extensive experience with Amazon Redshift - Proficient in ETL pipeline development - Knowledgeable in data warehousing best practices - Strong problem-solving skills and attention to detail.
Overview Design and implement ETL processes on GCP, optimize data workflows, ensure data accuracy and integrity, troubleshoot pipeline issues, and collaborate with cross-functional teams to support data integration and analytics for the EDW program. Job Description Responsibilities: Design, develop, and implement ETL processes on Google Cloud Platform (GCP) to ensure efficient data extraction, transformation, and loading for EDW program. Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions on GCP. Utilize Google Cloud services, such as native services, BQSQL, DAG, Cloud composer, Dataflow, and Cloud Storage, to optimize data processing and storage workflows. Create and maintain documentation for E...
...business continuity strategies: • Acts on Disaster recovery tests to process fail over and fail back. • Interventions scheduled on weekends and non-working hours. Profile Skills required: • Technical Skills for Production Support Engineer • Linux REDhat since 6.2 version mandatory, CentOS • Scripting KSH Skill and SSH • Windows servers since 2012 version • Experience on ETL tools (Informatica) • Experience on Databases (Oracle, Teradata, PostgreSql) • Experience on BI Tools (MSBI, Business Object, Power BI) • Experience on Files Transfer Tool (Tom, SFTP,) • Experience on scheduling tools (Control-M, Jenskins) • Experience on automation (Jenskins, Ansible, Nexus , Terraform) •...
**Project Title:** Power BI Report for Sales and Marketing Data **Description:** We are seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are ea...
We are looking Strong candidates for Automation QA Excellent communication is mandatory. Automation QA Exp req- 5+yrs JOB DESCRIPTION: Automation QA Strong in Java programming Strong at creating automation frameworks. Good at Web and API automation Good to have mobile automation Python QA 5 plus experience Remote Python, SQL- strong command ETL - good to have ability to work with database using python
I am seeking a seasoned Data Engineer with over 4 years of experience. The ideal candidate should possess strong skills in ETL processes, Data warehousing, and Big data technologies. Proficiency in tools like Apache Spark, Hadoop, and SQL is a must. Key Requirements: - Extensive experience in ETL processes, Data warehousing and Big data technologies - Proficient in Apache Spark, Hadoop and SQL - Seeking for a Full-time employment Skills and Experience: - 4+ years in Data Engineering - Mastery of relevant tools and technologies - Ready for Full-time commitment If you're a dedicated professional with the required skills and experience, I look forward to your application.
Job Title: Power BI Freelancer Needed for Data Visualization and Reporting J...measures and columns. Ensure data accuracy and troubleshoot issues within the data model. Optimize dashboards for performance and user experience. Collaborate with stakeholders to gather requirements and deliver solutions. Required Skills: Proficiency in Power BI and its components (Power Query, DAX, etc.). Strong knowledge of data visualization best practices. Experience with data modeling and ETL processes. Familiarity with integrating multiple data sources. Good communication skills for understanding requirements and presenting insights. Preferred Qualifications: Experience in [specific industry, if relevant]. Knowledge of SQL, Python, or other relevant tools. Previous experience in creating similar d...
I'm looking for a skilled Data Engineer/Full Stack Developer with extensive knowledge and experience in database structuring and implementation on AWS. The project revolves around a financial platform, necessitating the design and implementation of a robust ETL (Extract, Transform, Load) pipeline for our data warehouse. Key Responsibilities: - Creating the ETL pipeline - Data extraction primarily from vendor APIs with occasional web scraping - Data loading to various databases Ideal Skills: - Strong expertise in AWS and cloud-based database implementation - Proficiency in designing and optimizing ETL pipelines - Experience in integrating vendor APIs - Knowledge in database structuring and optimization Good to Have: - Proficiency in AI and prompt engineer...
**Project Title:** Power BI Report for Sales and Marketing Data **Description:** We are seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are ea...
**Project Title:** Power BI Report for Sales and Marketing Data **Description:** We are seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are ea...
**Project Title:** Power BI Report for Sales and Marketing Data **Description:** We are seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are ea...
1. Project Overview Objective: Build a robust backtesting pipeline for options trading strategies using AI/ML techniques. The pipeline will incorporate: GDFL 1-minute OHLCV data. Level 2 order book data (market depth). Computed Greeks (Delta, Gamma, Theta, Vega, etc.). AI/ML models for generating trading signals and evaluating performance. Scope: Acquire, clean, and store the relevant data. Calculate and integrate Greeks for each option contract. Engineer features from OHLCV, Level 2 order book, and Greeks. Develop AI/ML models for predictive signals or strategy optimization. Backtest and analyze strategy performance. Provide documentation, deliverable code, and a final report. 2. Key Deliverables Data Management & Integration Scripts/Processes to fetch and organize GDFL 1-m...
We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting...databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing...
We are migrating data from our current ERP system (that is stored in an SQL database) to Microsoft Dynamics Business Central Cloud. The source database structures is different than Business Central. We have been a...been able to reverse engineer both the databases and create ERD models and DDL scripts. Also we know how to create Dynamics APIs and use AL to interact with Dynamics. We are looking some consulting advice on how best migrate the data into dynamics. For example looking for ideas how to best table and field match, what software tools to use, best proccess etc for this ETL project. Please describe any experience you have with ETL/migrating data between different systems. Please add the word DYMANICS123 to the start of your proposal so we can weed out autom...
... o Data wrangling using SAC Modeler (acquired and live connections). o SAC Planning: Complex data actions, aggregations, and input schedules. o Finance Planning: Supporting budgeting, forecasting, and financial reporting processes. • Design and optimize SAP BW/4HANA models, including: o DSOs, ADSOs, Composite Providers, and InfoObjects. o Develop BW queries using BEx Query Designer. o Implement ETL pipelines for structured data loading and transformation. • Support integration between SAC and SAP BW using live and acquired connections. • Assist in system testing, debugging, and troubleshooting. • Prepare and maintain technical documentation for analytics solutions. Specific Skills Required: • Proficiency in SAC Story Design, data blending, and linked ana...
...Utilize relational databases and ORMs (e.g., SQLAlchemy) effectively for data management. Technical Skills Must-Have Skills ● Python Programming (Advanced): ○ Comprehensive knowledge of syntax, semantics, multi-threading, multi-processing, regular expressions, and exception handling. ○ Expertise in libraries such as Pandas and NumPy. ● ETLPipelines: ○ Proficiency in designing and implementing ETL pipelines for large-scale data projects. ● Object-Oriented Programming (OOP) (Intermediate): ○ Understanding of classes, objects, inheritance, polymorphism, and encapsulation. ● Relational Databases (Advanced): ○ Experience in query optimization, query building, and managing databases such as PostgreSQL, MSSQL, and Oracle. Expected Proficiency ● AWSCloudServices: ○ Fami...
I am looking for an experienced Data Integration Specialist for a 3-month contract, based in Pune or Bangalore. The ideal candidate will have over 6 years of experience, with a strong focus on Informatica PowerCenter, SQL, and Microsoft SQL Server. Key Responsibilities: - Creating and maintaining end-to-end source to target flows using Informatica PowerCenter. - Conducting data analysis and reporting, utilizing SQL expertise. - Basic Unix commands and shell scripting to support tasks. - Direct communication with users to understand and fulfill requirements. Compensation will be based on experience. Strong communication skills are essential, as the role involves independent task completion based on user requirements. Production monitoring and issue handling experience will ...
...embeddings, sentiment analysis, , RESTful APIs, OAuth2, Pinecone, PostgreSQL, MongoDB, Scraping tools, ETL pipelines, and multi-agent systems. Looking for someone passionate about AI that can work thoughtfully and independently. The first project we are working on is an automation Workflow process, based on the Dream 100 concept to identify, track, and built relationships with influential content creators. Here is an outline of the project: Please review carefully and then reply with your relevant qualifications and MORE IMPORTANTLY your specific observations on this specific project along with budget and timeline. We're looking for a long term relationship, so we will schedule meetings
Job Title: Freelance Data Engineer/Programmer for ETL Development Job Description: We are seeking an experienced Data Engineer/Programmer to develop robust ETL (Extract, Transform, Load) processes to seamlessly integrate our Warehouse Management System (WMS) with our Enterprise Resource Planning (ERP) system. This role is critical in ensuring smooth and reliable data flow between these systems to enhance operational efficiency and decision-making. Key Responsibilities: - Design, develop, and maintain ETL pipelines to connect WMS and ERP systems. - Extract data from various sources, transform it to meet business requirements, and load it into the target system or data warehouse. - Work with Python and Pandas for data manipulation and automation of workflows. - Levera...
...Description: This project focuses on designing and deploying a robust data pipeline using Delta Live Tables (DLT) on Databricks. The pipeline ensures high data quality through defined expectations within DLT or an equivalent framework. Once the pipeline is developed and validated, it will be deployed using Databricks Asset Bundles, enabling seamless and scalable management of data workflows. The project will cover the following steps: Pipeline Development with Delta Live Tables: Creating ETL pipelines to process and transform data incrementally. Data Quality Assurance: Implementing expectations to validate and monitor data at every stage of the pipeline. Deployment with Databricks Asset Bundles: Packaging and deploying the pipeline for operational use in productio...
I'm looking for a seasoned Python Engineer with extensive Flask experience to build a robust API service. Key responsibilities will include: - Web development with Flask: Your primary focus will be creating a scalable and efficient API service that meets our project's requirements. - Data Handling and ETL: While the bulk of the work will be web development, a strong capability in data handling, extraction, transformation, and loading is essential. Experience with Panda is a must. - Integration of Data Analytics: The API will need to have data analytics capabilities. Prior experience in this area will be beneficial. - Implementing Real-time Updates: The API service should be able to support real-time updates. Experience with similar features in previous projects is a plus....
I am in need of a highly skilled Senior Python Engineer to assist with the backend of a web application. The ideal candidate should have substantial experience with Python, MongoDB...Handling data processing and storage. - Developing robust APIs. Critical Skills: - Proficiency in Python and Flask. - Extensive knowledge of MongoDB and PostgreSQL. - Experience with object-oriented programming. - Understanding of scalable architecture. - Proficient in data extraction, transformation, and loading (ETL) using Pandas. This role will focus heavily on data processing and storage, as well as API development, so experience and skills in these areas are vital. The project requires a full backend development, so a full-stack developer would also be considered, but the primary focus is...
I'm looking for a freelance resume writer who specializes in tech resumes, particularly for data e...in the UK. My goal is to create a compelling resume that highlights my skills and experiences effectively for mid-level roles. Key Skills to Highlight: - Proficiency in Python and SQL - Experience with Cloud platforms like Azure - Familiarity with Databricks, PySpark, PowerBI, Snowflake, DBT cloud, Azure Data Factory, Synapse Analytics, ETL, CI/CD, Azure DevOPs, C# .Net Most Recent Job Experience: - Data Engineering The ideal candidate for this project should have: - Proven experience in writing tech resumes, particularly for data engineering roles - In-depth understanding of the data engineering field - Ability to articulate and present technical skills and experience...
I am looking for someone to mentor, train and provide project support on Talend and complex sql tasks. This is at least a 3-6 months arrangement. I would require a right person to give me a demo before we can start the project together. Confidently is an important part of the process.
Develop a comprehensive dashboard in Tableau to track and analyze sales performance across multiple regions and stores, enabling stakeholders to make data-driven decisions. Key Responsibilities: Data Integration: Gathered data from multiple sources, including SQL Server, SAP, and Excel files. Designed and optimized ETL pipelines using Alteryx to clean, transform, and load data into a centralized data warehouse. Dashboard Development: Built interactive Tableau dashboards showcasing KPIs such as total sales, profit margin, sales trends, and regional performance. Incorporated advanced features like drill-downs, filters, and trend analysis to provide actionable insights. Created custom visualizations to highlight underperforming regions and top-selling products. Data Modeling: Desi...
I am looking for an experienced ETL tester with strong skills in various ETL testing tools and methodologies. Your expertise in data warehousing and cloud platforms will be highly beneficial for this project. SHARE RESUME Key Requirements: - Proficient in ETL Testing tools like Informatica Power Center, IICS, and Informatica DVO - Familiar with Agile Scrum, Waterfall, and STLC methodologies - Experienced with cloud platforms, particularly GCP (Google Cloud Platform), AWS Cloud, and Azure Cloud - Proficient in databases such as MySQL, Oracle, SQL Server, and PostgreSQL - Comfortable working with various operating systems, including Windows XP/7/10, UNIX, and MAC OS - Skilled in SQL, PL/SQL, and Python - Experienced with test management tools like HP ALM / Qualit...
...Data Analytics and Data Science. The target trainees are absolute beginners, so the trainer must be adept at simplifying complex concepts. The Trainee should explain all the topic that are required but not subject to the one mentioned below. The Trainer should also execute end to end hands on project with the trainee. Please refer to the attached Training topic requirement. The training should cover: - Python and R - SQL and Excel - Tableau and Power BI - Data Extracting, Transforming, and Loading (ETL) processes - Large data platforms Ideal candidates are those with extensive experience dealing with corporate clients and delivering projects. A proven track record of training success is a plus. Your ability to engage with beginners and make learning enjoyable a...
I'm looking for a Senior Java Backend Application Developer, primarily focused on integration and development with Kafka. Key Responsibilities: - Spearhead integration development tasks - Potential for application development tasks Essential Skills: - Over 5...Experience with cloud platforms such as AWS, Azure, or Google Cloud. - Proficiency with container orchestration tools like Kubernetes or Docker Swarm. - Proficiency in scripting languages such as Python, Bash, or PowerShell. - Knowledge of API management tools and practices. - Understanding of security protocols and best practices in application integration. - Experience with data transformation and ETL tools. If you have a strong background in integration development and are eager to work with Kafka, I would like to...
I am in need of an ETL engineer who can assist with transferring data from our Oracle database to a MySQL server. The project involves: - **Data Transfer**: The volume of data to be transferred is less than 10 GB. - **Frequency**: The data will be transferred on a weekly basis for one case and as and when available for other case. Your script should fire automatically to perform the transfer. - **Data Transformation**: Some level of data transformation is required during the transfer process. - Incorporate data validation checks to ensure the accuracy and integrity of the transferred data. - Implement robust error handling and logging mechanisms to capture any issues during the ETL process. - Set up and configure a scheduling mechanism to automate the weekly a...
I am in need of an ETL engineer who can assist with transferring data from our Oracle database to a MySQL server. The project involves: - **Data Transfer**: The volume of data to be transferred is less than 10 GB. - **Frequency**: The data will be transferred on a weekly basis for one case and as and when available for other case. Your script should fire automatically to perform the transfer. - **Data Transformation**: Some level of data transformation is required during the transfer process. - Incorporate data validation checks to ensure the accuracy and integrity of the transferred data. - Implement robust error handling and logging mechanisms to capture any issues during the ETL process. - Set up and configure a scheduling mechanism to automate the weekly a...
...pipeline for a project I'm currently working on. Key Project Details: - Data Type: The project primarily deals with structured data, so familiarity and expertise with processing structured datasets is crucial. - Data Storage: The processed data will be stored in a SQL database. Experience with SQL and database management is necessary. - Data Source: The primary source of the data is APIs. Proficiency in working with APIs and extracting data from them is important. Ideal Skills and Experience: - Strong background in data engineering - Proven experience in building end-to-end data pipelines - Proficient in SQL and managing SQL databases - Experienced in processing structured data - Skilled in working with APIs - Knowledge of data warehousing concepts would be ...
I need a professional to automate my FME workflow, focused on integrating data from various spreadsheets into a cohesive dataset. The primary type of data is tabular, and the main goal of this project revolves around efficient data integration. Ideal Skills: - Proficiency in FME (Feature Manipulation Engine) - Extensive experience with tabular data - Competence in data integration - Familiarity with working with spreadsheets - Knowledge of ETL (Extract, Transform, Load) processes - Proficiency in scripting languages such as Python or R Experience: - Prior work with FME workflow automation - Proven track record of successful data integration projects - Experience in handling large sets of tabular data from spreadsheets. The final integrated dataset should be provided in CSV...
...configuration of Apache NiFi. Designing and managing data flow pipelines. Proficiency in NiFi Processors, such as: Data ingestion: GetFile, GetHTTP, GetKafka, etc. Data transformation: ConvertRecord, ReplaceText, etc. Data distribution: PutFile, PutKafka, PostHTTP, etc. Knowledge of NiFi Registry for version control and deployment of flow definitions. 2. Data Integration and Management: Experience with ETL (Extract, Transform, Load) processes. Understanding of data streaming and batch processing. Ability to connect to various data sources (APIs, databases, file systems, cloud storage). 3. System Administration: Proficiency in server setup and management on Linux/Windows. Knowledge of networking and firewalls for secure NiFi access. Experience with SSL/TLS for secure data transmis...
I'm in need of a seasoned data engineer who has extensive experience with Azure, AWS, and Databricks. The primary focus of this project is data pipeline development. Key Requirements: - Proficiency in Python, Spark, and SQL - In-depth knowledge of data engineering tools and platforms such as Databricks, Azure, and AWS - Experience in developing robust data pipelines - Experience with ETL processes for data extraction, transformation, and loading - Experience in data migration between databases and data warehouses - Expertise in SQL query optimization for performance improvements Ideal Skills: - Data analysis - Familiarity with Hadoop - Data cleaning and preprocessing expertise Please provide your credentials and examples of similar projects you've completed in th...
I am looking for a skilled database analyst experienced with Excel ,Access databases to help manage my customer data. As my database analyst, you will: - Assess the current structure of my SQL database - Identify areas for improvement or...structure of my SQL database - Identify areas for improvement or optimization - Provide recommendations for future database design Ideal Skills: - Proficiency in Spread sheets - Experience with customer data management - Strong analytical and problem-solving skills - Knowledge of ETL (Extract, Transform, Load) processes. - Expertise in database performance tuning and optimization. - Experience in data modeling and schema design. - Competency with database reporting tools like Tableau or Crystal Reports. The project needs to be completed ...
I'm looking for a professional data analyst who can help me make sense of my sales data. The data is currently in Excel/CSV files. Ideal Skills: - Proficient in data analysis software (Excel, Python, R, etc...professional data analyst who can help me make sense of my sales data. The data is currently in Excel/CSV files. Ideal Skills: - Proficient in data analysis software (Excel, Python, R, etc.) - Experience with sales data analysis - Ability to identify trends and patterns - Strong statistical skills - Skills in managing and querying databases (SQL, NoSQL, etc.) - Experience with Extract, Transform, Load (ETL) processes Please note that specific insights I want from the data have not yet been defined, so I will appreciate your expertise in uncovering significant insights...
...procesos de migración de datos. - Creación de procesos almacenados, y la creación de cursores. - Especialmente en el diseño y desarrollo de soluciones ETL mediante stored procedures. - Sus principales funciones serán: Oracle Database Management. - Experiencia sólida en diseño, desarrollo y optimización de bases de datos Oracle. - Capacidad para escribir y optimizar consultas complejas SQL y PL/SQL. - Conocimiento de las últimas versiones de Oracle Database y sus características. #Procesos ETL: - Experiencia en la creación de procesos ETL robustos y eficientes utilizando stored procedures. - Capacidad para diseñar y mantener flujos de datos ETL que aseguren la consist...
...deploying AI/ML models Familiarity with containerization and orchestration tools (e.g., Docker, Kubernetes) Strong problem-solving and analytical skills, with the ability to work on complex data-driven projects Excellent communication skills and the ability to work collaboratively in a multidisciplinary team Preferred Qualifications: Familiarity with data engineering concepts and tools, including ETL processes and data warehousing Knowledge of distributed computing and high-performance computing (HPC) for scaling machine learning models Familiarity with Agile methodologies and version control systems (e.g., Git) Compensation: The compensation for this position ranges from $100,000 - $120,000 depending on experience. Why Join Us? As part of our dynamic team, you will have th...
...deploying AI/ML models Familiarity with containerization and orchestration tools (e.g., Docker, Kubernetes) Strong problem-solving and analytical skills, with the ability to work on complex data-driven projects Excellent communication skills and the ability to work collaboratively in a multidisciplinary team Preferred Qualifications: Familiarity with data engineering concepts and tools, including ETL processes and data warehousing Knowledge of distributed computing and high-performance computing (HPC) for scaling machine learning models Familiarity with Agile methodologies and version control systems (e.g., Git) Compensation: The compensation for this position ranges from $100,000 - $120,000 depending on experience. Why Join Us? As part of our dynamic team, you will have th...
...coding • Integrate with Web services including SOAP, WSDL, REST, SSL standards, security models and typical API client architecture. Plus experience in working with Platform Events, Bulk API and the Metadata API • Implementation knowledge of Flow, App Builder, Process Builder, validation rule, approval process, reports and dashboards • Experience using Apex Data Loader (or other ETL tools like Informatica or Boomi or Cast Iron or Mulesoft) • Experience with database development, SQL or PL/SQL, database schemas, stored procedures is is a plus. • Follow unit testing and test class best practices, and be capable of coding for positive/negative scenarios • Must have experience with production deployment using CI/CD tools like GitHub, Gitlab, Bamboo, Co...
I'm in need of a Redshift SQL specialist who can assist me with writing intricate queries primarily focused on analytics and ETL processes. This will involve integrating my existing datasets. Ideal Skills: - Proficiency in Redshift SQL - Experience with writing complex queries using redshift Please note, the task will not involve database optimization or data migration.
Description: Collaborate with me on integrating SQL Server and Oracle APIs using SSIS. This project involves setting up a robust ETL pipeline for efficient data management, building a data model for HR and Procurement, and developing an interactive 8 dashboard in Power BI deployed on Power BI Report Server. Tasks: SSIS and SQL Server Integration: Configure SQL Server and SSIS, ensuring a seamless ETL pipeline. Design and execute workflows to extract, transform, and load (ETL) data between sources. Oracle API and Excel Integration: Set up secure Oracle API integration for real-time or scheduled data extraction. Integrate data from Excel files and APIs for HR and Procurement departments. Map and load data into SQL Server, ensuring schema compatibility. Power B...
...me. The primary aim of this application is to extract text data from various e-commerce sites. Key Requirements: - Expertise in Python, particularly in libraries/APIs used for web scraping (e.g., BeautifulSoup, Scrapy, Selenium). - Previous experience in developing web scraping applications, preferably for e-commerce sites. - A strong understanding of data extraction, transformation and loading (ETL) processes. - Ability to write clean, efficient and well-documented code. - Good problem-solving skills and attention to detail. Your task will be to create an application that can navigate e-commerce sites, identify relevant text data, and extract it efficiently and accurately. The final deliverable should be an easy-to-use Python application, with comprehensive documentation and u...
I'm looking for an API and Data Analytics specialist to help automate our data extraction from Practice Hub. Currently, we are manually entering data into Google Sh...report generation. Need someone who can streamline this process by utilizing Practice Hub's API to pull: - Patient records - Appointment schedules - Billing information The extracted data will primarily be used for generating operational reports. Given our competitors are working on a similar product, I would like to start this project as soon as possible. Skills needed: - Experience with APIs - Data analytics expertise - Familiarity with ETL processes - Knowledge in generating operational reports. Please check the Practice Hub API info here for reference:
...reputable and experienced full-stack service agency with a strong presence on Freelancer to work on several enterprise clients projects: Requirements for Azure Data Engineer: Experience in designing, building, and maintaining large-scale data pipelines using Azure Data Services (Azure Synapse Analytics, Azure Databricks, Azure Data Factory, etc.) Strong knowledge of data modeling, data warehousing, and ETL/ELT processes Experience with Azure cloud services, including Azure Storage, Azure Databricks, and Azure Active Directory Strong programming skills in languages such as Python, Scala, or .NET Experience with Agile development methodologies and version control systems like Git Requirements for Full Stack Team/Agency: We are looking for a full-stack service agency that can prov...