Find Jobs
Hire Freelancers

PostgreSQL/ETL developer

₹400-750 INR / hour

В роботі
Опублікований almost 3 years ago

₹400-750 INR / hour

an design and deploy mid to complex and optimized database supporting OLTP systems in a fast paced environment with ETL experience sourcing from multiple third parties for use in the transactional system. Requirements - 3-5 years hand-on with Postgress Designing logical and physical models for multi-tenant OLTP SaaS solutions for highly scalable and secure solutions on AWS. Expertise in DB Development (stored procedures, advance queries and query optimization, functions, triggers, sequences 3-5 years heavy experience with ETL design, coding, deployment and management to suite transactional application and business intelligence needs 3+ years’ experience deployment and management of data stores, data lakes and ETL development in AWS environment 3 – 5 years’ experience with opensource ETL tools such as Pentaho and Glue, Talend, ETLLeap Must have experience in designing, developing, testing, implementing and maintaining Postgress DB from scratch for a new project. ETL – must have expertise in designing, developing, testing, implementing, maintaining and controlling pipelines and ETL jobs developed from scratch. Determine data storage needs, design and creating data stores, manage exceptions, data stages, audit trails, exception management, and complex rules. Must have experience with sourcing data from multiple sources, complex transformation, and optimization. Must have experience with modeling tools. Supports, designs, and manages upgrades with developed software that interacts with databases Monitors transaction activities and assists in the utilization of databases. ETL maintenance and job monitoring is required. On-call support is sometimes required. Responsible for the integrity and security of data across all environments Performance tuning of database objects, stored procedures, ETL jobs, and related scripts. Additional skills Self starter Required little oversight Ability to design, develop and manage production and lower environment databases Query optimization Debugging and problem solving skills Ability to work with technology managers, developers and QA staff Conduct code walkthroughs and participate in peer reviews Must have flexibility to learn and embrace a dynamic environments Nice to have: Java, familiarity with CI/CD
ID проекту: 29857909

Про проект

4 пропозицій(-ї)
Дистанційний проект
Активність 3 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
4 фрілансерів(-и) готові виконати цю роботу у середньому за ₹931 INR/год.
Аватарка користувача
Hi, I've read the description of your posted job with the title "PostgreSQL/ETL developer”. I’m doing this job for the last 7 years. Which carries out different complexity level SQL/MySQL/PostgreSQL/MS Access task few of them are mentioned below, 1. Database Creation from Scenario 2. Create ERD from the documentation. 3. Extraction of Data from database through quires. 4. Writing Store procedure and views. 5. Indexing, look after query performance. 6. DB backup and restoration. 7. Data analysis and attractive visualization dashboards with (Tableau and Power BI) 8. Custom Visualization (I can show my works screenshot in chat). 9. Customize dashboards using different apps as a data source(Acumatica/Healthcare apps) I can give you my best rates for this role because I know I can do it in a better way. Thanks, Sufyan Jamil
₹600 INR за 40 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I'm a Talend developer with 2 certifications and over 5 years of experience. Message me for more details.
₹1 222 INR за 30 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I'm interested with this job description and would like to discuss about further details of project. I have good experience on pentaho data integration tool and also extracting the data from legacy system. Also have good knowledge on ETL process and development. Worked on large queries. Maintaining the ETL process with bug free on production. Please let me know with your response about further details. Thanks
₹700 INR за 40 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
Alpharetta, United States
0,0
0
Спосіб оплати верифіковано
На сайті з бер. 19, 2020

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.