Datastage ETL Developer

1 week ago


Canada HCLTech Full time

Required Skills

5-8 years’ experience as Data Engineer

Specializes in ETL (Extract, Transform, Load) using ETL tools DataStage (Primary), Matillion, ADF etc.

Strong knowledge of relevant data query language e.g., SQL

At least 3-4 years of US Healthcare Payer experience

Experience in Snowflake, Netezza.

Experience with Data warehousing techniques(Star Schema, Snowflaking, Normalization, Denormalization, Aggregations)

Excellent communication skills to collaborate with stakeholders and convey technical concepts effectively.

Ability to work independently and as part of a team in a fast-paced environment.

Strong problem-solving skills and attention to detail to address complex data challenges effectively.

Responsibilities

Collaborates closely with the Project Manager (PM), Architect, and Administrators to develop ETL processes and reports.

Responsible for ensuring smooth data extraction, transformation, and loading processes as an ETL developer.

Create, execute and document unit test plans for ETL and data integration processes and programs

Collaborates with cross-functional teams to understand data requirements and translate them into effective solutions.

Designs and develops ETL processes to efficiently extract data from various sources and transform it for analytical purposes.

Ensures the reliability, accuracy, and performance of ETL processes and reports through rigorous testing and optimization.

Maintains documentation for ETL processes, including technical specifications and user guides.

Monitor and administer automated and manual data integration and ETL jobs

Provides support and troubleshooting assistance for ETL processes as needed.

Stays updated with the latest trends and best practices in BI, ETL, and data analytics.



  • Canada Ampstek Full time

    Ampstek Datastage Support PositionLocation: Mississauga, Canada (Hybrid)About the Role:We are seeking a skilled Datastage Developer and ETL Specialist to join our team at Ampstek.Job Description:The ideal candidate will have 5+ years of experience in data engineering with DataStage/ETL, Oracle SQL, and UNIX. Familiarity with Databricks is an added advantage,...


  • Canada HCLTech Full time

    Required Skills 5-8 years’ experience as Data Engineer Specializes in ETL (Extract, Transform, Load) using ETL tools DataStage (Primary), Matillion, ADF etc. Strong knowledge of relevant data query language e.g., SQL At least 3-4 years of US Healthcare Payer experience Experience in Snowflake, Netezza. Experience with Data warehousing techniques(Star...


  • Canada HCLTech Full time

    About the RoleAt HCLTech, we are seeking an experienced Datastage ETL Developer to join our team. This is a highly technical role that requires strong expertise in designing, developing, and maintaining ETL processes using DataStage and other tools.The ideal candidate will have at least 5-8 years of experience as a Data Engineer, with a strong focus on ETL...


  • Canada HCLTech Full time

    We are seeking an experienced Datastage ETL Developer to join our team at HCLTech, a leading global technology company. This role is perfect for a skilled professional with a strong background in data engineering and experience working with ETL tools like DataStage.Key Responsibilities:Collaborate with cross-functional teams to design, develop, and implement...


  • Canada Tamanna Technology Full time

    Job Title: Highly Skilled ETL Developer for Banking SectorTamanna Technology is seeking a highly skilled ETL (Extract, Transform, Load) developer with expertise in IBM DataStage to join our dynamic IT team. The ideal candidate will have strong experience in designing, developing, and maintaining large-scale ETL processes for financial systems.Salary...

  • ETL data engineer

    2 weeks ago


    Canada, CA HCLTech Full time

    Required Skills 5-8 years’ experience as Data Engineer Specializes in ETL (Extract, Transform, Load) using ETL tools DataStage (Primary), Matillion, ADF etc. Strong knowledge of relevant data query language e.g., SQL At least 3-4 years of US Healthcare Payer experience Experience in Snowflake, Netezza. Experience with Data warehousing techniques(Star...


  • Canada HCLTech Full time

    About the RoleHCLTech is seeking a highly skilled Senior ETL Data Integration Specialist to join our team.Key ResponsibilitiesCollaborate with Project Managers, Architects, and Administrators to design and develop ETL processes.Ensure smooth data extraction, transformation, and loading processes as an ETL developer.Create, execute, and document unit test...


  • Canada HCLTech Full time

    About the Role:">We are seeking an experienced ETL (Extract, Transform, Load) developer to join our team at HCLTech. As a Senior Data Integration Specialist, you will be responsible for designing and developing efficient ETL processes to extract data from various sources, transform it for analytical purposes, and load it into our data warehouse.">About...


  • Ontario, Canada, Canada Astellas Pharma Full time

    As part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedicated to improving lives. DigitalX our new information technology function is spearheading this...


  • Canada Tata Consultancy Services Full time

    Tata Consultancy Services (TCS) is a leading IT services company that partners with businesses to drive digital transformation.We are seeking an experienced Informatica Developer to join our team in Canada. As a key member of our data integration team, you will be responsible for designing and implementing ETL workflows using Informatica PowerCenter or other...

  • GCP Lead Developer

    3 weeks ago


    Canada Zortech Solutions Full time

    Role: GCP Lead DeveloperLocation: Remote/CanadaDuration: 6+ MonthsJob Description:Experience Level: 13-17+ yearsPlease find below a new L3/L4 Backend Developer/GCP position. Let's please focus on this requirement to fill asapInfrastructure Setup for enabling GCP Project, CloudSQL, Composer, Google Cloud Storage, Logging, Infra Access ManagementGoogle data...


  • Canada Atlantis IT Group Full time

    **Job Description:**We are seeking an experienced Essbase Developer to join our team at Atlantis IT Group.The successful candidate will have a strong foundation in Essbase 19c/Essbase21, Essbase Administration Services (EAS), ETL - SQL, Smart View, Shell scripting.Key accountabilities include:Creating new applications or improving existing ones in the...

  • GCP Lead Developer

    3 weeks ago


    Canada Zortech Solutions Full time

    Role: GCP Lead Developer Location: Remote/Canada Duration: 6+ Months Job Description: Experience Level: 13-17+ years Please find below a new L3/L4 Backend Developer/GCP position. Let's please focus on this requirement to fill asap Infrastructure Setup for enabling GCP Project, CloudSQL, Composer, Google Cloud Storage, Logging, Infra Access Management...

  • GCP Lead Developer

    3 weeks ago


    Canada Zortech Solutions Full time

    Role: GCP Lead DeveloperLocation: Remote/CanadaDuration: 6+ MonthsJob Description:Experience Level: 13-17+ yearsPlease find below a new L3/L4 Backend Developer/GCP position. Let's please focus on this requirement to fill asapInfrastructure Setup for enabling GCP Project, CloudSQL, Composer, Google Cloud Storage, Logging, Infra Access ManagementGoogle data...

  • GCP Lead Developer

    3 weeks ago


    Canada Zortech Solutions Full time

    Role: GCP Lead DeveloperLocation: Remote/CanadaDuration: 6+ MonthsJob Description:Experience Level: 13-17+ yearsPlease find below a new L3/L4 Backend Developer/GCP position. Let's please focus on this requirement to fill asapInfrastructure Setup for enabling GCP Project, CloudSQL, Composer, Google Cloud Storage, Logging, Infra Access ManagementGoogle data...

  • GCP Lead Developer

    1 month ago


    Canada, CA Zortech Solutions Full time

    Role: GCP Lead DeveloperLocation: Remote/CanadaDuration: 6+ MonthsJob Description:Experience Level: 13-17+ yearsPlease find below a new L3/L4 Backend Developer/GCP position. Let's please focus on this requirement to fill asapInfrastructure Setup for enabling GCP Project, CloudSQL, Composer, Google Cloud Storage, Logging, Infra Access ManagementGoogle...


  • Canada Raas Infotek Full time

    Job OverviewRaas Infotek is a leading provider of IT solutions in the commercial area. We are seeking an experienced Veeva CRM Developer and Admin to join our team.Salary: $120,000 - $180,000 per yearJob Description:We are looking for a highly skilled Veeva CRM Developer and Admin who can design and build innovative solutions using Veeva CRM, Salesforce...


  • Canada HCLTech Full time

    Job Description:We are seeking a highly skilled Senior Data Integration Specialist to join our team at HCLTech. As a key member of our data engineering team, you will be responsible for designing and developing ETL processes to efficiently extract data from various sources and transform it for analytical purposes. Responsibilities:* Collaborate closely with...


  • Canada PrecisionERP Incorporated Full time

    Job OpportunityPrecisionERP Incorporated seeks a skilled Senior Business Intelligence Developer for a 4-5 month contract in Montreal.The role offers a hybrid work arrangement with two days on-site per week, totaling 35 hours.Key Responsibilities:-Design and implement data engineering projects using agile methodologies and rapid prototyping...


  • Canada Agility Partners Full time

    Job DescriptionAgility Partners is seeking a seasoned Cloud Data Architect Lead to spearhead data pipeline development, model and prepare data, perform complex data analysis to address business queries, build and automate data pipeline and quality framework to empower self-service data pipelines, and assist in operationalizing AI/ML engineering...