Description

You will build, optimize, and maintain data integration pipelines and automated workflows.

Responsibilities

• Develop and test robust ETL interfaces, mappings, and complex workflows using Informatica and SnapLogic.
• Design efficient database schemas and optimize SQL queries, stored procedures, and views to improve retrieval times.
• Automate file transfers between AWS S3 buckets and Linux servers using shell scripting and AWS CLI.
• Implement automated archiving solutions and error-handling mechanisms within S3 and Linux environments.
• Collaborate with stakeholders to integrate business logic into SnapLogic pipelines and Redshift databases.
• Provide production support and on-call monitoring for Informatica workflows and SnapLogic pipelines.

Required Skills

• 5+ years of experience in ETL development and data integration.
• Proficiency in SQL and PL/SQL for database optimization and schema design.
• Hands-on experience with Informatica and SnapLogic.
• Strong experience managing data within AWS S3 buckets.
• Experience working with Amazon Redshift databases.
• Proficiency in Linux environments and shell scripting for workflow automation.
• Experience managing file transfers via SFTP and MOVEit.
• Ability to conduct technical analysis of business objectives to align ETL processes.

Key Skills

Education

Any Graduate