Talend etl ssisPekerjaan

Deskripsi Pekerjaan PT Sharing Vision Indonesia masih membutuhkan beberapa orang minimal S1/D4/S2 dari Teknik Informatika/Sistem Teknologi Informasi/Teknik Elektro/Teknik Telekomunikasi/Sistem Informasi/Fisika/ Matematika/Statistika/Ilmu Komputer/Engineer lainnya, untuk posisi sebagai: SSIS Engineer Penempatan WFO di Jakarta Persyaratan: 1. Pengalaman dalam SSIS Admin 2. Berpengalaman dalam pekerjaan ETL 3. Memiliki kemampuan query MySQLdan SQL Server tingkat lanjut 4. Diutamakan mempunyai background pemrograman (misal python) 5. Menguasai tool dashboard seperti Tableau, Google Studio, dll akan menjadi nilai tambah

I need a Python developer who can handle automation tasks related to ETL pipeline, data extraction from Snowflake, and a dbt environment. Key Requirements: - You should be proficient in Python programming. - Be familiar with the Window Task Scheduler. - Have experience with ETL pipeline development. - Know how to extract data from Snowflake and a dbt environment. The Purpose: - The ETL pipeline is crucial for handling data analysis, reporting, and data integration tasks. - The data size to be processed in the ETL pipeline is medium, up to 10 GB. Ideal Candidate: - You should have prior experience in handling similar tasks. - A strong understanding of data handling and automation through Python and ETL tools. - Proven expertise in data extraction from...

...ensuring accuracy and consistency. - Data Modeling: The ideal candidate should have a deep understanding of how to organize data in a way that supports business needs and decision-making. - ETL Processes: The selected freelancer will be responsible for the extraction, transformation, and loading of data into our warehouse. We are working with a medium-sized dataset (1-10 terabytes), so we need someone who is not only experienced in data warehousing but also with datasets of this size. Ideal Skills and Experience: - Proven track record in data warehousing, with a focus on data integration, data modeling, and ETL processes - Experience working with medium-sized datasets (1-10 terabytes) - Excellent analytical and problem-solving skills - Strong communication skills to eff...

I'm in need of a data processing expert who can assist me in developing an architecture to analyze knowledge graphs using ETL and machine learning. Key Tasks: - Leveraging Data Processing Expertise: I need someone with a strong background in data processing, particularly in relation to graph technologies. Your role will be to harness this knowledge to create an efficient and effective architecture for analyzing knowledge graphs. Ideal Skills and Experience: - Strong Data Processing Background: A deep understanding of data processing is crucial for this project, particularly in the context of graph technologies. Experience in working with large datasets and complex data structures is highly desirable. - Familiarity with Graph Technologies: Knowledge of graph databases and asso...

I'm in need of a data processing expert who can assist me in developing an architecture to analyze knowledge graphs using ETL and machine learning. Key Tasks: - Leveraging Data Processing Expertise: I need someone with a strong background in data processing, particularly in relation to graph technologies. Your role will be to harness this knowledge to create an efficient and effective architecture for analyzing knowledge graphs. Ideal Skills and Experience: - Strong Data Processing Background: A deep understanding of data processing is crucial for this project, particularly in the context of graph technologies. Experience in working with large datasets and complex data structures is highly desirable. - Familiarity with Graph Technologies: Knowledge of graph databases and asso...

I'm currently working on a project that involves fetching data from an API and loading it into SQL Server using SSIS. I've made significant progress, and I'm facing challenges that require immediate attention. Key Details: - I'm encountering error messages during the data loading process. - I require assistance writing the SSIS package to ensure efficient and error-free data transfer. - The data source is an API, so experience handling API data is essential. Skills/Experience Required: - Proficiency in SQL Server Integration Services (SSIS). -Must know SQL server - Ability to troubleshoot and resolve data loading errors effectively. - Familiarity with API keys for authentication.

I'm looking for a skilled data engineer to help me with the OMOP ETL process. Your main responsibilities will be: - Extracting and transforming data: You'll be working with me to extract data from a data warehouse and transform it into the OMOP CDM. - Loading data into a database: After transforming the data, it will need to be loaded into a PostgreSQL database. Experience with ETL processes and PostgreSQL is critical. You should also be familiar with data validation checks, as we need basic data type and range checks applied during this project. You must have experience loading data into the OMOP CDM.

I'm looking for an AWS Glue expert to handle my large MySQL database, over 10GB, and write it to S3. You will need to have: - A strong understanding and experience in handling large databases. - Proficiency in using AWS Glue for data ETL processes. - Knowledge in determining the best strategy to quickly load large amounts of data. - Experience working with Parquet output format. The database gets updated daily, so a fast and efficient process is required to ensure optimal performance. Please detail your experience with similar projects when making your bid.

I'm seeking a proficient Power BI expert who can help me create ...BigCommerce, Google Adwords, and Google Sheets - Metrics to Track: Sales revenue, Website traffic, Customer acquisition cost, Inventory levels, and Gross Margin - Update Frequency: Daily Ideal Skills and Experience: - Proficient in Power BI; capable of integrating various data sources seamlessly - Experience in creating dashboards and reports for Sales, Marketing, and Inventory data - Strong knowledge of ETL processes and data visualization techniques - Ability to automate data refresh on a daily basis Your deliverable will be a fully functional and automated Power BI dashboard that visualizes the mentioned metrics accurately and succinctly, providing me with real-time insights into the health and performance ...

...looking to design and build a basic data warehouse utilizing MS SQL Server's various services such as SSIS, SSAS, and SSRS. This includes analyzing and reporting on large sets of data while integrating and transforming data from different sources. Key specific requirements include: - Creating a basic data warehouse structure. This should involve a few tables and relationships. - Using SSIS (Integration Services) for transferring and integrating data. - Implementing SSAS (Analysis Services) for performing advanced analytics. - Utilizing SSRS (Reporting Services) for generating comprehensive reports. The ideal freelancer for this gig should have: - Proficiency in MS SQL Server, specifically in SSIS, SSAS, and SSRS. - Experience in designing and creating data w...

I am seeking a professional with proficiency in MS SQL Server’s SSIS (Integration Services), SSAS (Analysis Services), and SSRS (Reporting Services) to create a basic level, sample case for using data warehousing. Specific Goals: - Develop a data warehouse for analyzing business data. - The case should familiarize the users with the concept, rather than providing an advanced level of expertise. In SSIS Integration section, the following concepts are to be included: - Data Extraction - Data Transformation - Data Loading The ideal candidate will have a solid understanding of data warehousing and extensive experience with MS SQL Server’s services. A knack for simplifying complex information and a background in training or education will be appreciated.

As the professional handling this project, you'll engage with big data exceeding 10GB. Proficiency in Python, Java, and Pyspark are vital for success as we demand expertise in: - Data ingestion and extraction: The role involves managing complex datasets and running ETL operations. - Data transformation and cleaning: You'll also need to audit the data for quality and cleanse it for accuracy, ensuring integrity throughout the system. - Handling Streaming pipelines and Delta Live Tables: Mastery of these could be game-changing in our pipelines, facilitating the real-time analysis of data.

I am seeking a skilled data engineering trainer, speed in using Hadoop, Apache Spark, and SQL is paramount. Your expertise will guide me through nuanced uses of these technologies, with a particular focus on data migration. Key Requirements: - Proficiency in Hadoop, Apache Spark, and SQL - More than 10 hours availability weekly - Proven experience in real-world data migration projects Ideal candidates should have a flair for explaining complex concepts in simple language. This engagement will focus on moving data from diverse sources into a data warehouse, thereby making it readily available for business intelligence functions.

As a client, I'm seeking a Python developer who that can help me trasforming data. The primary source of the data will be company-related information. Ideal Skills and Experience: - Proficiency in Python - Extensive experience in data analysis, particularly with telecomdata - Familiarity with APIs for data collection - Knowledge of telecom - Ability to understand Python appl...experience in data analysis, particularly with telecomdata - Familiarity with APIs for data collection - Knowledge of telecom - Ability to understand Python application and python scripts -Know about Airflow , Spark, Kafka, Transaction Mysql Key Requirements: - Develop a Python program that can efficiently trasform non useful to useful data. - Strong understanding of telecom data -Spark sessions, ETL...

...and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing analytics requirements. - Efficient Data Export and ETL Processes: Set up and manage the rapid export of data from various platforms using APIs. Develop and implement ETL (Extract, Transform, Load) processes to clean, transform, and load data into the database swiftly. - Documentation: Produce concise and clear documentation on the data architecture, ER diagrams, and ETL processes to support ongoing maintenance and scalability. - Collaborative and Rapid Execution: Work closely with the project manager and other team members to ensure alignment of the database design with business...

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finance Domain Knowledge Automation Scri...

As an ETL Expert Data Engineer with Airflow expertise, I require a professional who can take on a sophisticated data integration task. Key Responsibilities: - You will be responsible for data integration. - The data will be pulled from various APIs. - The processing logic required is advanced, aimed at facilitating analytics and machine learning. You should possess: - Extensive ETL experience. - Deep knowledge of Apache Airflow. - Proven track record in handling complex data integration tasks. - Capability in building data pipelines for advanced analytics. - Familiarity with APIs, ensuring efficient data extraction. - Strong problem-solving skills and attention to detail. I am looking for someone who can take this project and deliver high-quality results promptly.

...in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data with target data structures. ETL Development: * Develop and maintain ETL (Extract, Transform, Load) processes using standard tools. * Handle dat...

I require an experienced SSIS developer to aid in a data transformation project. The key tasks will involve taking data from a Relational Database Management System and transforming it to fit into our data warehouse. Key tasks: - Understand the structure of the source data - Develop an SSIS package tailoring to these requirements - Test the functionality of the SSIS package for effective data transformation Many of these tasks will be dealing with structured data, hence a strong understanding and experience in handling such data type is critical. Only consider participating if you have: - Proven experience with SSIS data transformation processes - An in-depth knowledge of handling structured data - Past experience transforming data from Relational Database ...

Job Title: Senior Master Data Management (MDM) Developer Monday to Friday Remote via Zoom 2-3 hours/day IST Night (7pm to 12amIST) Salary: 30,000 INR per month We are seeking a Senior M...Zoom 2-3 hours/day IST Night (7pm to 12amIST) Salary: 30,000 INR per month We are seeking a Senior Master Data Management (MDM) Developer with a focus on healthcare. Strong SQL skills for data manipulation and querying. Experience with ETL development and integration. Familiarity with Azure Data Factory and cloud/on-prem migrations is advantageous. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: Master Data Management (MDM) ETL development and integration Strong SQL skills SSIS Azure Data Factory ...

I recently attempted to upgrade my SSIS to the 2019 version, on my Windows Server 2019. However, I am encountering problematic error messages relating to the odbc 64 bit issue. Specific Qualifications and Tasks: - Extensive knowledge and experience with SSIS 2008, 2012, 2016 and most importantly 2019 - Proficient in troubleshooting and upgrading processes on Windows Server 2019 - Ability to pinpoint and rectify the odbc 64 bit issue on SSIS upgrade - Efficiently resolve the emerging error messages Your past experiences with similar issues will be highly beneficial in this project. Your role is to figure out the root cause of these errors, fix the problem and ensure a successful upgrade to SSIS 2019.

As a client, I am in search of a skilled Python developer with experience in XML parsing and handling database operations. I require a Python utility program to parse Talend jobs and determine source and target column details. Key Requirements: * Parse XML files - The Talend mapping file will be supplied in XML format. We're in need of someone fluent with Python's XML parsing libraries. * Extract information - The utility must be able to extract critical information including source and target table columns, as well as source and target databases. * Dynamic Output format - The extracted information must be formatted in CSV or potentially other formats. It should be flexibly designed as we will use this data to load into a database. * Database expertise - An unders...

I'm constructing a robust real estate scoring model, and need a skillful database engineer proficient in Google Big Query. The project involves: 1. ETL Development: Your main task is to develop an ETL process. You should have experience managing CSV files and integrating APIs. 2. Data Management: The data to handle includes property addresses, sale price history, property characteristics, and people details related to properties. The expert should know how to organize and manage this huge amount of data effectively. 3. Real-Time Updates: Due to the volatile nature of the real estate market, the ability to integrate real-time updates is an asset. An expert in Google Big Query, effective in handling CSV files, and capable of seamless API integration would make the best f...

I'm in search of a Azure Data Factory expert who is well-versed in Delta tables, Parquet, and Dedicated SQL pool. As per the requirement, I have all the data and specifications ready. The successful freelancer will need to be familiar with advanced transform...in search of a Azure Data Factory expert who is well-versed in Delta tables, Parquet, and Dedicated SQL pool. As per the requirement, I have all the data and specifications ready. The successful freelancer will need to be familiar with advanced transformations as the ETL complexity level is high. It's a plus if you have prior and proven experience in handling such projects. Key Skills Required: - Expertise in Azure Data Factory - Deep knowledge of Delta tables, Parquet and Dedicated SQL pool - Familiarity with adv...

Job Description: Develop & support Power BI artefacts and participate in the analytics product development Participate in the analysis of requirements to understand the business and system needs regarding user interfaces, reporting enhancements, new functionality, and back-end ETL operations, should be able to provide estimates against requirements. Code and modify reports using DAX & MDX programming languages. Document all code using standard forms and procedures, adhering to all naming conventions Participate in unit, system, and user acceptance testing Adopt new and emerging technologies to provide solutions to client needs. Additional responsibilities will be team performance management, timesheet reviews, ensuring project delivery on time. Required Primary Skills: ...

I'm looking for an experienced .NET developer with a solid understanding of SQL Server Integration Services (SSIS) to help with critical data integration tasks. The primary objective is to help me understand extract, transform, and load data into a databases. Your responsibilities will include: - Extracting data from multiple sources - Handling data transformation procedures - Loading transformed data into the target destination I need someone who can show me a demo of how to work with SSIS via screen sharing.

More details: ¿Qué tipo de datos desearía cargar desde SQL Server a Sharepoint List? Datos de ventas ¿Con qué frecuencia necesita actualizar los datos en Sharepoint List? Diariamente ¿Desea incluir alguna funcionalidad de automatización o alertas cuando se actualicen los datos? Actualización automática de datos

"Airflow pipeline I require a professional with experience in Airflow and dbt for my project. You will be handling an ETL/ELT integration specifically for data migration. This migration task involves moving specific tables from one MySQL database to another one. I'm trying to migrate data from mysql to mysql. We need to transfer incremental data on an hourly basis. We are looking to use open source ETL or ELT. In addition to airflow, you can use other open source ETL tools.".

More details: What specific tasks do you need assistance with in regards to SSIS? Troubleshooting existing packages What data sources are you integrating with SSIS? SQL Server What is the primary goal of troubleshooting these SSIS packages? Resolving connectivity or security errors

...to be connected to Azure; this is contract management system. 2. One more company recently which was acquired has financial data on-prem on different tenant we need to bring in this data to the Azure cloud. Note : Business central is for the financial data and GL entry ,Dynamics 365 is for the sales and invoicing ,Hubspot for the sales lead, Service Now is the ticketing system , Workato is the ETL tool which connects all the system,Kimble one is the project management platform. There is one billing system acquire going on we might need to bring in the data from this source also. Data Handling: Perform necessary data normalization or transformation before storing the data in Azure SQL Database. The ideal candidate for this role will have past experience with Azure SQL Database...

...with experience in Airflow and dbt for my project. You will be handling an ETL/ELT integration specifically for data migration. This migration task involves moving specific tables from one MySQL database to another one. Your key responsibilities for this project will include: - Identifying the specific tables needed for migration, as indicated by me. - Developing and implementing an efficient migration process using Airflow and dbt. - Ensuring successful and accurate data migration. Ideal skills: - Incremental data must be transferred every hour. - Transfer speed is important. - Extensive experience in Airflow & dbt. - Proficient in MySQL databases. - Experience in data migration projects. - Thorough knowledge of ETL/ELT processes. - Attention to detail as the task ...

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

I need an ETL developer to streamline and automate an existing manual process. This includes: - Transferring two encrypted *. files from a source server to a local machine. - Decrypting these files into *.csv format. - Running SQL on one file and a PowerShell command on the other file to create a staging table. - Setting up a Microsoft SQL Server database into read-write mode from read-only. - Reverting the database back to read-only upon task completion. - Sending a report to the user upon task completion. Ideal skills for this job include advanced SQL, PowerShell, and ETL development. Familiarity with read/write permissions on Microsoft SQL Server and experience with data transfer and encryption/decryption processes are also highly beneficial.

I am seeking an IICS (Informatica Intelligent Cloud Services) specialist to effectively set up and integrate AWS S3/EC2 services with this platform. Key Requirements: - Set up project infrastructure per given specifications - Ensure successful integration of AWS S3 and EC2 with IICS - Establish robust connections and develop ETL processes - Configure parameter files as part of the setup While not specified, an intermediate or advanced level of IICS proficiency would be ideal for this task. Previous experience with AWS services is a must. I have not stated a timeframe for completion, indicating flexibility; however, I would appreciate if interested freelancers could provide their estimated timelines of delivery in their responses.

I am looking for an experienced Senior Data Engineer for in...looking for an experienced Senior Data Engineer for interview training. Your primary responsibility would be data cleaning and preprocessing, design and optimize database and implement ETL processes. Key responsibilities include: - Clean and preprocess data to ensure its quality and efficiency. - Design and optimize databases, aiming for both flexibility and speed. - Implement ETL (Extract, Transform, Load) processes to facilitate the effective and secure moving of data. Skills and Experience: - Proficient in Python, SQL, and Hadoop. - Expertise in handling medium-sized databases (1GB-1TB). - Proven track record in ETL processes handling. Your expertise in these areas will be crucial to the successful com...

Objective: Upgrade an existing ETL process to enhance data validation, error handling, and user feedback for structured Excel files uploaded to SharePoint 2019, for subsequent transfer to a database. The solution could be also implemented via Azure Functions and Sharepoint online if deemed possible. Existing Setup: A basic ETL process developed with the Luigi library, lacking advanced validation and user feedback mechanisms. Solution uses parsing code (Pandas) for Excel files data parsing that can be utilized for the upgrade also. There are 4 different excel files, so 4 different parsers will be provided. The system should manage four unique Excel file types, each in its own SharePoint folder, requiring separate parsers for their distinct structures. An initial selection...

Looking for an experienced MSBI and powerbi developer. You would be working with me to troubleshoot and optimize an existing MSBI solution and powerbi report. Your tasks include but are not limited to: - Data Modeling - ETL Development - Report Development For this project, your primary tools would be: - SQL Server Integration Services (SSIS) - SQL Server Analysis Services (SSAS) - power bi Your experience and skills in these areas will be critical to the success of our project. Only serious and high-quality professionals need apply. This is a challenging role and previous experience in the given areas is a must. Let's enhance our MSBI solution together and make it the best it can be.

...manage and organize data within it. - Ability to ensure data security and integrity throughout the extraction and integration process. **Ideal Skills and Experience:** - Proven track record of working with POS systems, especially Clover, for sales data extraction. - Strong background in cloud-computing platforms, specifically Azure. - Comfortable with setting up and managing data pipelines and ETL processes. - Experience in setting up automated workflows between different technological platforms. - Knowledge of data visualization and interpretation, to guide the final format of sales data within Snowflake. This project requires a freelancer who can swiftly understand our data infrastructure and implement a solution that minimizes manual intervention and maximizes data utility f...

...guidance especially in the area of ETL processes. I need to focus on: - This is an interview support role, You are supposed to help in live interviews. • Extraction techniques – The primary data sources of my interest are platforms like Spark, AWS, Azure, GCP, and Hive. I want to understand effective methods for data extraction from these particular sources. Ideal Skills and Experience: - Expertise in ETL tools for data extraction - Hands-on experience with Spark, AWS, Azure, GCP, Hive - Profound knowledge in data engineering - Experience in career coaching or mentoring will be a bonus - SQL -Python This assistance will give me a competitive edge in my upcoming interviews by providing me with practical skills, knowledge, and confidence in addressing ETL...

I'm seeking an experienced Data Engineer with proficiency in SQL and PySpark. Key Responsibilities: - Develop and optimize our ETL processes. - Enhance our data pipeline for smoother operations. The ideal candidate should deliver efficient extraction, transformation, and loading of data, which is critical to our project's success. Skills and Experience: - Proficient in SQL and PySpark - Proven experience in ETL process development - Previous experience in data pipeline optimization Your expertise will significantly improve our data management systems, and your ability to deliver effectively and promptly will be highly appreciated.

Looking for a seasoned AWS expert to assist in optimizing EC2 instances, S3 storage, and Lambda functions for improved performance. The ideal candidate will have: Mainly working on Aws glue jobs , S3,lambda, Crawler, step functions, dynamo DB ,Clouldwatchs, Appflow, parameter store , API Gateways, ETL Jobs,splunk logs CloudFormation - important big bucket,Spunk, Jenkins pipelines* CI/CD * , YAML for creating templates and manifest files * Sql mandatory for date base * ⁠using Postman for API calls * ⁠Python and spark Musk know

To update ssis pacjage embedded api in ssis

...integrity throughout the data lifecycle. - Implement monitoring and alerting systems to proactively identify and address issues. - Stay up-to-date with emerging technologies and best practices in data engineering. *Requirements:* - Bachelor's degree in Computer Science, Engineering, or a related field. - Proven experience as a data engineer or similar role, with a strong understanding of data modeling, ETL processes, and database technologies. - Proficiency in at least one programming language commonly used in data engineering (e.g., Python, Java, Scala). - Hands-on experience with cloud platforms (e.g., AWS, Google Cloud, Azure) and related services (e.g., S3, GCP BigQuery, Azure Data Lake). - Familiarity with containerization and orchestration tools such as Docker and Kub...

I'...of data from spreadsheets. The end goal is to improve the data accuracy. Your Key Responsibilities: - Understand the current data structure in the spreadsheet - Merge information from various sections accurately - Ensure no data is lost or inaccurately merged during the integration process Required Skills and Experience: - Extensive experience with data extraction, transformation, and loading (ETL) tools - Proficient in data integration methodologies - Expert in handling spreadsheets and large sets of data - Proven track record of improving data accuracy When submitting your application, please include your experience in handling similar projects. Your ability to demonstrate a clear understanding of this project and its requirements will be a key factor in my decision-...

I need an SQL and SSIS developer for my personal project. My primary goal is to optimize my SQL database, which is currently facing several performance issues. Key Problems: - Slow query execution - High resource consumption - Inefficient indexing The ideal candidate should have a strong background in SQL and SSIS for database optimization. A thorough knowledge of SQL query optimization, resource management, and indexing is essential. I am seeking an expert who can effectively address these specific issues and enhance the overall efficiency of my SQL Server development. Any suggestions for further improvements are also welcome.

As the project owner, I urgently need a skilled SQL Server and SSIS (SQL Server Integration Services) Developer to propel my database optimization objectives. Your primary tasks will focus on: - Fine-tuning SQL queries - Carrying out schema optimizations - Development using SQL I'm currently dealing with several performance issues, including slow query execution, high disk I/O, and index fragmentation. Therefore, for this task, the ideal candidate should possess a sharp understanding of query tuning and optimization, as well as practical experience with complex SQL Server and SSIS development projects. If you have proven experience in eliminating these types of issues and know how to implement effective optimizations, I am eager to work with you. Your high-level SQL...

...and maintaining Oracle databases to support our organization's applications and business processes. This role requires proficiency in SQL, PL/SQL, database functions, triggers, ETL processes, and database performance tuning. Key Responsibilities: • Design, develop, and implement Oracle databases to meet business requirements. • Perform database administration tasks, including installation, configuration, backup and recovery, and monitoring. • Write efficient SQL and PL/SQL code to support application development, including the creation of functions, stored procedures, triggers, and packages. • Develop and maintain ETL processes to extract, transform, and load data from various sources into Oracle databases. • Optimize database performance t...

I'm seeking a developer skilled in SSIS, C# and SQL for this project. The task involves fetching JSON data from an API using oauth with a username and password. This data will then need to be written to a SQL table. The main specifications are: - API provides JSON data - Only specific fields are required from the JSON data for the SQL table write operation - These fields are constant and will not change in the future Confident understanding and experience with JSON, C#, API fetch, SSIS, and SQL are paramount. The ideal candidate will be adept at creating smooth integrations, dealing with API provided data and handling SQL scripts.

As an organization, we are aiming for proficient data analysis and reporting using the SQL database, which is below 1GB. We need an experienced professional with skills in: - Writing strong SQL queries - Developing effective SSIS packages - Creating insightful SSRS reports This project primarily focuses on enhancing our data comprehension and subsequent reporting, thus requiring a thorough command of SQL related tasks. The suitable freelancer for this job should possess strong analytical skills and have a proven track record of database management and optimizing results.

...seeking a skilled Talend Integration Freelance Developer and Deployment Specialist (preferable local Malaysian freelancer) to play a pivotal role in our dynamic team. In addition to the responsibilities mentioned earlier, the successful candidate will be entrusted with deploying Talend solutions in both testing and production environments. If you possess hands-on experience in deploying ETL solutions and ensuring their seamless operation in varied environments, we encourage you to apply. Responsibilities:- Talend Job Design: Develop efficient and scalable Talend job designs for various data integration and ETL processes. Implement best practices for job design to ensure maintainability, reusability, and performance. Version Control: Implement...