Negotiable
Outside
Remote
USA
Summary: The ETL Developer role focuses on designing, developing, and maintaining ETL workflows and data pipelines using Snaplogic and PostgreSQL. The position requires collaboration with data engineers and analysts to ensure efficient data solutions and quality. The role is remote and emphasizes database development and optimization skills. The candidate should have hands-on experience with Snaplogic as an integration platform.
Key Responsibilities:
- Design, develop, and maintain ETL workflows and data pipelines using Snaplogic iPaaS.
- Develop and optimize PostgreSQL database objects to support data extraction, transformation, and loading activities.
- Collaborate with data engineers, analysts, and other stakeholders to understand data requirements and deliver efficient solutions.
- Troubleshoot and resolve data issues ensuring data quality and consistency across systems.
- Document ETL processes, mappings, and data flows.
- Monitor ETL jobs and address any failures or performance bottlenecks.
Key Skills:
- Proficient in PostgreSQL, including writing complex queries and managing databases.
- Experience in database development, schema design, and performance tuning.
- Hands-on experience with Snaplogic integration platform as a service (iPaaS).
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
- PostgreSQL: proficient in writing complex queries, functions, and managing PostgreSQL databases.
- Database development: Experience designing, developing and optimizing database schemas, stored procedures and performance tuning.
- Spanlogic (iPaaS): Hands on experience with Snaplogic integration platform as aa service (iPaaS) for building and managing data workflows and integrations.
- Design, develop, and maintain ETL workflows and data pipelines using snaplogic iPaaS.
- Develop and aptimize PostgreSQL database objects to support data extraction, transformation, and loading activities.
- Collaborate with data engineers, analysts and other stakeholders to understand data requirements an deliver efficient solutons.
- Troubleshoot and resolve data issues ensuring data quality and consistency across systems.
- Document ETL processes mappings and data flows.
- Monitor ETL jobs and address any failures or performance bottleneck.