Find Jobs
Hire Freelancers

PostGRE Sql DB Developer with ETL Experience

₹400-750 INR / hour

Zavřený
Zveřejněno skoro před 3 roky

₹400-750 INR / hour

Description : Can 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 o Designing logical and physical models for multi-tenant OLTP SaaS solutions for highly scalable and secure solutions on AWS. o 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
IČ projektu: 29868153

O projektu

4 nabídky
Vzdálený projekt
Aktivní před 3 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
4 freelanceři nabízejí v průměru ₹656 INR/hodinu za tuto práci
Avatar uživatele
I am a microsoft certified BI developer with 10 + years of experience of working with ETL and BI tools such as SSIS , SSAS , Azure ETL , Pervasive , Informatica , castiron , SAP Bods , SAP BO , OBIEE etc . I have 5+ years working with development , administration of Netsuite one world account with multi subsidiary and multi currency setup. Integration with third party and in house systems have a lot of experience in the area of ​​data analysis. ML algorithms and methodology for the development of data analysis. write to me and let's review what you need. Python and R handling
₹600 INR v 40 dnech
5,0 (4 recenze)
5,0
5,0
Avatar uživatele
Hi, I've read the description of your posted job with the title "PostGRE Sql DB Developer with ETL Experience”. 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
₹800 INR v 30 dnech
4,9 (3 recenze)
2,6
2,6
Avatar uživatele
Hi I am Chandrabhan. Primary Skills: • ETL Tools: Talend DI, Talend Big Data Platform. • SQL Database: Oracle 12c, PostgreSQL, Snowflake (snowpipe,functions,AWS Integration). • Programming Languages: PL/SQL, Core Java, Python, UNIX Shell Script. • Tools: SQL Developer, PgAdmin (3 & 4), TAC, Jira, Confluence, GIT, SnowSQL. Additional Skills: • Data Analysis and Reporting, Data warehousing. • SQL, ETL Methodologies, Data Cleansing. • Cloud: AWS (Lamda, S3, API Gateway, User management). • HTML, Excel VBA. I have Experience of creating Procedures and functions in Oracle and Snowflake DB but not in PostgreSQL. I have excellent experience in creating and working with complex SQL queries and optimization. • Excellent experience of creating SCD Type 1, Type 2, Type3 and Delta Load ETL jobs. • Extensive knowledge of writing complex SQL Queries for data transform and extraction. • Good experience in working with Java Routines in Talend and write custom code to implement complex logics. • Worked extensively on java routines and collection framework in talend. • Deft in working on optimization of Talend Jobs and reports as a part of Productivity Improvement. • Working knowledge of regular expressions. Currently I am working on creating Procedures , functions and SQL query optimization task in Snowflake for a US client.
₹650 INR v 25 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I am interested with this opportunity and want to discuss more. please let me know if you are available for chat?
₹575 INR v 40 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z INDIA
Delhi, India
0,0
0
Členem od dub 13, 2021

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.