Closed

PostGRE Sql DB Developer with ETL Experience

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

Skills: Database Administration, SQL, MySQL, Oracle, Database Development

See more: sql report developer projects, convert postgre sql server, java developer j2me experience, sql server developer wwwmediafirecom, can deploy aspnet sql server, sharjah sql software developer, web developer year experience, developer years experience, dotnetnuke net sql web developer austin texas, php sql web developer bahrain, sql freelance developer crm philippines, software developer resume experience, sql server developer fundamental, postgre sql failed connect vista, asterisk agi postgre sql, sql etl experience, php developer minimum 3 month experience fresher can appl jobs it jobs kolkata, sql server developer job description, sql report developer job description, sql database developer job description

About the Employer:
( 0 reviews ) Delhi, India

Project ID: #29868153

4 freelancers are bidding on average ₹656/hour for this job

dogradiwakar

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 More

₹600 INR / hour
(4 Reviews)
5.0
sufyanjamil9

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 More

₹800 INR / hour
(3 Reviews)
2.6
Chandrabhank

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, More

₹650 INR / hour
(0 Reviews)
0.0
vinoth011985

I am interested with this opportunity and want to discuss more. please let me know if you are available for chat?

₹575 INR / hour
(0 Reviews)
0.0