Data Integration Specialist

Migrate existing ETL workflows from Informatica and SSIS to SnapLogic. Design and develop new 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.