ETL Developer

Review data and ETL requirements and work with DBA to validate or extend data model based on new requirements. If appropriate, create DDL for new objects, attributes, etc. Review with DBA and Data Architect as required. Provide detailed design documents as per SDLC requirements. Create ETL workflows and objects as required and provide unit and system testing activities and documentation. Work with IT to migrate code between test, UAT and production

Responsibilities:

• Establish secure connections between data sources using Matillion and Snowflake under appropriate security protocols.
• Design, develop, and implement ETL jobs using Matillion ETL to extract data from various applications through Application Programming Interface (API) based data pipelines and data extracts.
• Cleanse, transform, and validate data to ensure its accuracy and consistency.
• Design and implement data quality checks and error handling routi...