Closed

Postgres DB and ETL developer

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

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

Skills: PostgreSQL, ETL

See more: can deploy aspnet sql server, broadcast graphic developer description, postgres java web developer, software developer description, can deploy opentaps, monitor postgres db, android developer account can create, electronics developer description, can deploy html5 code joomla, remote etl developer, etl developer remote, bi etl developer in india, Etl developer, i need a developer who can help me develop my app, i want to find a video game developer who can create a 40th birthday game, looking for a developer who can assist with parsing an xml, looking for software developer who can finish website single handedly, ssis etl developer job description, etl developer job description, informatica etl developer job description

About the Employer:
( 0 reviews ) Alpharetta, United States

Project ID: #29867252

1 freelancer is bidding on average ₹750 for this job

(0 Reviews)
0.0