Hybrid Batch Administrator Batch Administrator with verification

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