- Migrate existing ETL workflows from Informatica and SSIS to SnapLogic.
- Design and develop current ETL pipelines using SnapLogic for data ingestion, transformation, and loading.
- Implement cloud-based ETL solutions leveraging:
- AWS Services: S3 for storage, Lambda for serverless processing, Glue for ETL orchestration, and CloudWatch for monitoring.
- Infrastructure as Code: CloudFormation for provisioning ETL environments.
- Write and maintain shell scripts for automation and job orchestration.
- Develop and optimize SQL queries, stored procedures, and scripts for data processing.
- Collaborate with data architects and business analysts to understand data requirements and ensure accurate data flow.
- Implement best practices for data quality, error handling, and performance tuning.
- Monitor and troubleshoot ETL jobs to ensure reliability and scalability.
- Document processes and provide knowledge transfer to team members.
Preferred candidate profile: We are looking for an experienced ETL Developer to design, develop, and migrate data integration workflows from legacy platforms to modern solutions. The role involves transitioning ETL processes from Informatica and SSIS to SnapLogic, implementing automation using shell scripting, and ensuring robust data operations through SQL expertise. The candidate will also work on cloud-based ETL orchestration and data pipelines