Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

ETL Developer

EXTRA HOLIDAYS - EXTRA PARENTAL LEAVE
Remote: 
Full Remote
Contract: 
Full time
Salary: 
50 - 50K yearly
Experience: 
Senior (5-10 years)
Work from: 
Canada

Offer summary

Qualifications:

5+ years of ETL development experience, Strong expertise in AWS services, Proficiency in SQL and Teradata, Familiarity with shell scripting, Experience with cloud migration projects.

Key responsabilities:

  • Analyze and assess Informatica ETL workflows
  • Migrate Informatica jobs to AWS solutions
  • Develop custom ETL processes for data integrity
  • Optimize ETL workflows within AWS
  • Collaborate with engineers for efficient pipelines
Affinity logo
Affinity Information Technology & Services Scaleup https://affinity-group.ca/
51 - 200 Employees
About Affinity
At Affinity Group, we are more than just an IT recruitment and consulting organization - we are a team of high-performing professionals who are dedicated to delivering an unrivalled experience to our employees, consultants, and clients. With offices located across Canada and the US, we are committed to providing exceptional service through our core values of efficiency, agility, flexibility, transparency, and inclusivity. Our team is comprised of talented individuals who prioritize work-life balance and share our philosophy of service delivery. We believe that by working closely with our partners, we can capture their intellectual knowledge and invest it in saving time and driving efficiency. Our agile approach ensures that we deliver the right resources quickly, utilizing the best tools and technology in the industry to stay connected and provide access to the most updated resources at all times. We are efficient- As our partnership flourishes, we diligently capture the valuable intellectual knowledge you share with us and leverage it to drive efficiency and save you time. We are agile- Your time is of utmost importance to us, which is why we remain agile by utilizing cutting-edge tools and technology in the industry. This allows us to stay connected and provide you with the most up-to-date resources at all times. We are flexible- We prioritize your interests above all else and empower you to make informed decisions with our flexible policies. You can take the necessary time to weigh your options without feeling rushed. We are transparent- We believe in sharing all aspects of our business with you, so you have the same understanding we do. We are inclusive- We foster an environment that values and respects all differences, recognizing the unique perspectives each person brings to the table.
See more Affinity offers

Job description

Logo Jobgether

Your missions

Job Description:

On behalf of our client, we are seeking an experienced ETL Developer to join our team to help decommission legacy Informatica workflows and migrate them to AWS. You will be working closely with our AWS Cloud Data Solution Architect and AWS Engineers to transform over 1,000 Informatica jobs and workflows into AWS-native solutions. The ideal candidate will have a strong background in Informatica, Teradata, AWS, and ETL processes, and will contribute to building a seamless and efficient AWS-based data environment.

Key Responsibilities:
  • Analyze and assess existing Informatica ETL workflows, mappings, scripts, and processes to understand the data transformation logic.
  • Migrate and transform existing Informatica ETL jobs to AWS-native solutions using AWS services such as Glue, Redshift, and S3.
  • Develop, test, and implement custom ETL processes that ensure data integrity and meet business requirements.
  • Optimize ETL workflows for performance, scalability, and reliability within AWS.
  • Collaborate with the AWS Engineers to design efficient ETL pipelines that integrate with other AWS services.
  • Validate transformed data through unit tests to ensure accuracy and consistency with the original Teradata source.
  • Troubleshoot and resolve issues with data ingestion and transformation, ensuring all ETL workflows run smoothly.
  • Provide ongoing support for the transformed ETL jobs, including performance tuning and optimizing resource usage in AWS.
  • Document ETL processes, migration steps, and code for handover to FCC’s internal team.
  • Collaborate closely with the QA Specialist and Data Analyst to ensure that data validation and reconciliation processes are accurate and timely.

Qualifications:
  • 5+ years of experience in ETL development, preferably with Informatica PowerCenter.
  • Strong experience in AWS services including Glue, Redshift, S3, and Lambda.
  • Proficiency in SQL and experience working with Teradata databases.
  • Familiarity with shell scripting (bash, ksh) and SQL-based scripting for automation.
  • Experience with cloud migration projects, especially decommissioning legacy ETL environments.
  • Strong understanding of data transformation techniques, data warehousing concepts, and performance tuning for large-scale ETL processes.
  • Ability to troubleshoot and resolve complex data transformation and ingestion issues in AWS.
  • Experience working in Agile environments and using collaboration tools like Jira and Confluence.

Preferred Qualifications:
  • Experience with AWS Glue for ETL transformations, AWS Lambda for orchestration, and Redshift for data warehousing.
  • Understanding of data reconciliation processes between Teradata and AWS.
  • Previous experience working in public sector or enterprise environments.
  • Excellent communication skills and ability to work collaboratively across technical and non-technical teams.


    • 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 technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

    For more information on Affinity, please visit www.affinity-group.ca

    Job Number: 11100

    Required profile

    Experience

    Level of experience: Senior (5-10 years)
    Industry :
    Information Technology & Services
    Spoken language(s):
    Check out the description to know which languages are mandatory.

    Hard Skills

    Amazon RedshiftInformaticaAWS LambdaPerformance TuningAWS GlueData Transformation

    Soft Skills

    • troubleshooting-problem-solving
    • collaboration
    • communication
    Are you interested?
    loading
    See more jobs
    Sign in or sign up with Google or LinkedIn