Hybrid Batch Administrator Batch Administrator with verification
Affinity · Regina, SK (Remote) · nan, · Hybrid
About the job
On behalf of our healthcare client, Affinity is looking for a Batch Administrator to be responsible for all activities related to support of ETL processes for large-scale data warehouses using Informatica Power Center.
Responsibilities:
• Responsible for all activities related to support of ETL processes for large scale data warehouses using Informatica Power Center.
• Regularly monitor the execution of AWS Glue data pipeline jobs to ensure they are running as expected.
• Monitoring and providing support application batches in all the environments.
• Diagnose and resolve issues related to ETL Informatica and AWS Glue data pipeline job failures, data discrepancies, or performance bottlenecks.
• Configure and manage job schedules using AWS Glue triggers or other orchestration tools like AWS Step Functions.
• Automate repetitive tasks to improve efficiency and reduce manual intervention.
• Communicate job status, issues, and resolutions to relevant teams and stakeholders.
• Maintain detailed documentation of ETL & AWS Glue data pipeline processes, job configurations, and troubleshooting steps.
• Stay updated with the latest AWS Glue features and best practices to enhance job performance and capabilities.
• Participate in code reviews and knowledge-sharing sessions to foster a culture of continuous improvement and learning.
• Collaborate with cross-functional teams to identify and implement solutions to prevent recurrence.
• Weekend support for daily and month-end batch activities.
Qualifications:
• 5 years of ETL Administration
• 2 years AWS Glue data pipeline batch support experience
• Experience working with code repositories such as Git, Gitlab, GitHub
• Proficiency in SQL, PySpark, Redshift, AWS Glue and Basic Unix Scripting.
• Basic DB knowledge.
• ETL Knowledge.
Hourly rate: $30 per hour.
Affinity Earn:
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity:
Affinity Group is a full-service Information Technology services and staffing company. We believe recruiting is about creating long term relationships that foster a mutually beneficial partnership - an affinity. Bringing a new style of recruiting founded on five core principles: Transparency – Flexibility – Efficiency – Agility – Inclusivity.
We teamed up with ClimatePartner on 2022 to offset our emissions and move toward being a more environmentally friendly company and we are proud to now be officially Carbon Neutral Certified.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 10915