Agile Data Developer

7 days ago


Regina, Saskatchewan, Canada Affinity Group Full time
About the Role

We are seeking an experienced Data Transformation Specialist to join our team at Affinity Group. As an Agile Data Developer, you will play a key role in decommissioning legacy Informatica workflows and migrating them to AWS.

Key Responsibilities
  • Analyze and Assess Existing ETL Workflows

Assess existing Informatica ETL workflows, mappings, scripts, and processes to understand the data transformation logic and identify areas for improvement.

Develop and Implement Custom ETL Processes

Develop, test, and implement custom ETL processes that ensure data integrity and meet business requirements, leveraging your expertise in Informatica, Teradata, AWS, and ETL processes.

Optimize ETL Workflows for Performance and Scalability

Optimize ETL workflows for performance, scalability, and reliability within AWS, collaborating closely with our AWS Engineers to design efficient ETL pipelines that integrate with other AWS services.

Validate Transformed Data

Validate transformed data through unit tests to ensure accuracy and consistency with the original Teradata source, and troubleshoot and resolve issues with data ingestion and transformation.

Provide Ongoing Support

Provide ongoing support for the transformed ETL jobs, including performance tuning and optimizing resource usage in AWS, and collaborate closely with our QA Specialist and Data Analyst to ensure that data validation and reconciliation processes are accurate and timely.

Requirements
  • Strong Background in Informatica, Teradata, and AWS

You will need a strong background in Informatica, Teradata, and AWS, as well as experience working with cloud migration projects, especially decommissioning legacy ETL environments.

Proficiency in SQL and Shell Scripting

Proficiency in SQL and experience working with shell scripting (bash, ksh) and SQL-based scripting for automation are essential.

Experience with Agile Environments

Experience working in Agile environments and using collaboration tools like Jira and Confluence is also required.

Preferred Qualifications
  • Experience with AWS Glue and Redshift

Experience with AWS Glue for ETL transformations, AWS Lambda for orchestration, and Redshift for data warehousing is highly desirable.

Excellent Communication Skills

Excellent communication skills and the ability to work collaboratively across technical and non-technical teams are essential.



  • Regina, Saskatchewan, Canada Affinity Full time

    Job Description**About the Role**We are seeking an experienced Data Transformation Specialist to join our team at Affinity. As an Agile Data Developer, you will play a key role in decommissioning legacy Informatica workflows and migrating them to AWS.**Key Responsibilities**Analyze and Assess Existing ETL WorkflowsAssess existing Informatica ETL workflows,...


  • Regina, Saskatchewan, Canada Affinity Full time

    Job Description**About the Role**We are seeking an experienced Data Transformation Specialist to join our team at Affinity. As an Agile Data Developer, you will play a key role in decommissioning legacy Informatica workflows and migrating them to AWS.**Key Responsibilities**Analyze and Assess Existing ETL WorkflowsAssess existing Informatica ETL workflows,...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    Job Title: Senior Data DeveloperCompany: BQ International Ltd.Job Type: Full-timeLocation: RemoteJob Description:We are seeking a highly experienced Senior Data Developer to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and implementing data warehouses and related structures using Teradata.Key...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    Job Title: Senior Data DeveloperCompany: BQ International Ltd.Job Type: Full-timeLocation: RemoteJob Description:We are seeking a highly experienced Senior Data Developer to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and implementing data warehouses and related structures using Teradata.Key...

  • ETL Developer

    1 week ago


    Regina, Saskatchewan, Canada Affinity Group Full time

    About the RoleWe are seeking an experienced ETL Developer to join our team at Affinity Group to help decommission legacy Informatica workflows and migrate them to AWS. As a key member of our Cloud Data Solutions team, you will work closely with our AWS Cloud Data Solution Architect and AWS Engineers to transform over 1,000 Informatica jobs and workflows into...

  • ETL Developer

    1 week ago


    Regina, Saskatchewan, Canada Affinity Group Full time

    About the RoleWe are seeking an experienced ETL Developer to join our team at Affinity Group to help decommission legacy Informatica workflows and migrate them to AWS. As a key member of our Cloud Data Solutions team, you will work closely with our AWS Cloud Data Solution Architect and AWS Engineers to transform over 1,000 Informatica jobs and workflows into...


  • Regina, Saskatchewan, Canada Farm Credit Canada Full time

    Position Overview:As a Senior Scrum Master at Farm Credit Canada, you will play a pivotal role in guiding our teams through the agile development process. Your expertise in agile methodologies will be essential in fostering a culture of continuous improvement and collaboration.Key Responsibilities:1. **Facilitate Agile Practices:** Promote and implement...


  • Regina, Saskatchewan, Canada Affinity Group Full time

    About the Role:Affinity Group is seeking an experienced Senior Data Developer to lead the decommissioning of legacy Informatica workflows and migrate them to AWS. As a key member of our team, you will work closely with our AWS Cloud Data Solution Architect and AWS Engineers to transform over 1,000 Informatica jobs and workflows into AWS-native solutions.Key...


  • Regina, Saskatchewan, Canada Affinity Group Full time

    About the Role:Affinity Group is seeking an experienced Senior Data Developer to lead the decommissioning of legacy Informatica workflows and migrate them to AWS. As a key member of our team, you will work closely with our AWS Cloud Data Solution Architect and AWS Engineers to transform over 1,000 Informatica jobs and workflows into AWS-native solutions.Key...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    BQ INTERNATIONAL LTD. is seeking a skilled ETL Technical Analyst to join our team. The ideal candidate will have expertise in data extraction, analysis, and quality, as well as proficiency in SQL, Python, Informatica, Active Batch, and SAS. As a member of our Agile Product Team, the successful candidate will participate in development activities related to...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    BQ INTERNATIONAL LTD. is seeking a skilled ETL Technical Analyst to join our team. The ideal candidate will have expertise in data extraction, analysis, and quality, as well as proficiency in SQL, Python, Informatica, Active Batch, and SAS. As a member of our Agile Product Team, the successful candidate will participate in development activities related to...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    BQ INTERNATIONAL LTD. is seeking a skilled ETL Technical Analyst to join our team. The ideal candidate will have expertise in data extraction, analysis, and quality, as well as proficiency in SQL, Python, Informatica, Active Batch, and SAS. As a member of our Agile Product Team, the successful candidate will participate in development activities related to...

  • Data Analyst Specialist

    48 minutes ago


    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    BQ INTERNATIONAL LTD. is seeking a skilled ETL Technical Analyst to join our team. The ideal candidate will have expertise in data extraction, analysis, and quality, as well as proficiency in SQL, Python, Informatica, Active Batch, and SAS. As a member of our Agile Product Team, the successful candidate will participate in development activities related to...

  • Data Analyst

    1 week ago


    Regina, Saskatchewan, Canada Finesse Tech Full time

    About the RoleFinesse Tech is seeking a highly skilled Data Analyst to join their team and contribute to the development of their analytics capabilities.Key ResponsibilitiesData Interpretation: The successful candidate will be responsible for interpreting complex data sets and developing insights that drive business decisions.Database Development: The Data...

  • Data Analyst

    1 week ago


    Regina, Saskatchewan, Canada Finesse Tech Full time

    About the RoleFinesse Tech is seeking a highly skilled Data Analyst to join their team and contribute to the development of their analytics capabilities.Key ResponsibilitiesData Interpretation: The successful candidate will be responsible for interpreting complex data sets and developing insights that drive business decisions.Database Development: The Data...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    BQ INTERNATIONAL LTD. is seeking a skilled ETL Technical Analyst to join our team. The ideal candidate will have expertise in data extraction, analysis, and quality, as well as proficiency in SQL, Python, Informatica, Active Batch, and SAS. As a member of our Agile Product Team, the successful candidate will participate in development activities related to...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    BQ INTERNATIONAL LTD. is seeking a skilled ETL Technical Analyst to join our team. The ideal candidate will have expertise in data extraction, analysis, and quality, as well as proficiency in SQL, Python, Informatica, Active Batch, and SAS. As a member of our Agile Product Team, the successful candidate will participate in development activities related to...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    About the RoleWe are seeking a highly skilled Data Insights Specialist to join our team at BQ INTERNATIONAL LTD.Key Responsibilities:Participate in Agile Product Team development activities related to Client's Risk and Finance ETL processes.Conduct requirement analysis and data analysis to ensure high-quality data extraction and processing.Develop and...


  • Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    About the RoleWe are seeking a highly skilled Data Insights Specialist to join our team at BQ INTERNATIONAL LTD.Key Responsibilities:Participate in Agile Product Team development activities related to Client's Risk and Finance ETL processes.Conduct requirement analysis and data analysis to ensure high-quality data extraction and processing.Develop and...

  • Agile Project Owner

    2 weeks ago


    Regina, Saskatchewan, Canada Farm Credit Canada Full time

    **Job Summary**Farm Credit Canada is seeking a highly skilled Senior Product Owner to join our team. As a key member of our product development team, you will be responsible for prioritizing and executing project backlogs in an agile environment.**Key Responsibilities**Lead and prioritize work for product enhancements, ensuring alignment with business...