Datastage ETL Developer Transformation Specialist

6 days ago


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 efficient ETL processes that extract, transform, and load data from various sources.
  • Develop and maintain high-quality ETL code using DataStage and other relevant tools.
  • Work closely with project managers, architects, and administrators to ensure smooth data integration and reporting processes.
  • Create unit test plans and execute them to ensure the reliability and accuracy of ETL processes.
  • Maintain documentation for ETL processes, including technical specifications and user guides.
  • Monitor and administer automated and manual data integration and ETL jobs.
  • Provide support and troubleshooting assistance for ETL processes as needed.

Requirements:

  • 5-8 years' experience as a Data Engineer with expertise in ETL (Extract, Transform, Load) using ETL tools like DataStage, 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.

Estimated Salary: $120,000 - $180,000 per year, depending on location and experience.



  • 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 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

    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

    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 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...


  • 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...

  • 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 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...


  • 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...


  • 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 Raise Full time

    We are seeking a highly experienced Digital Transformation Specialist to join our team at Raise in Scarborough, ON. This is a 6-month contract with the possibility of extension.The ideal candidate will have over 10 years of experience in organizational change management and business analysis. A PROSCI certification and knowledge of Identity and Access...


  • Canada Liztek Full time

    About Liztek">Liztek is a leading provider of data engineering solutions for the insurance industry.Job Description:">We are seeking an experienced Senior Insurance Data Platform Specialist to join our team.The successful candidate will be responsible for designing, developing, and maintaining data pipelines using Snowflake for efficient data storage,...


  • Canada Mewar Info Tech Limited Full time

    Job OverviewData Engineers play a pivotal role in Mewar Info Tech Limited by designing, building, and maintaining the company's data infrastructure. Working closely with data scientists, analysts, and engineers, they extract, transform, and load data from various sources into our data warehouse and data lake. This position offers the opportunity to unlock...


  • Canada GoMaterials Full time

    Job OverviewWe are seeking a highly skilled Digital Transformation Specialist to join our team at GoMaterials.About the RoleThis is a unique opportunity to make a significant impact on our company's growth and success. As a Digital Transformation Specialist, you will be responsible for designing, developing, and implementing robust software solutions that...


  • 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...


  • Canada LGS, une société IBM Full time

    About the RoleLGS, an IBM company, is seeking a highly skilled Digital Transformation Specialist to join our team. This role offers a unique opportunity to work on large-scale projects that drive business forward and improve people's lives.As a Digital Transformation Specialist, you will be at the forefront of collaborating on large-scale digital...


  • Canada Azur Technology Full time

    Unlock Your Potential in InsurtechAzur Technology is a pioneering force in digitizing the insurance sector, working closely with leading insurers to bring innovative products to market.We're looking for highly skilled Salesforce Software Engineers to join our team and contribute to shaping the future of insurance technology.Competitive Salary: CAD $90,000 -...


  • Canada KNIGHTLABS Full time

    About the RoleWe are seeking an exceptional Digital Transformation Specialist to join our team at KnightLabs. This exciting opportunity will enable you to drive innovation and enhance customer engagement in the pharmaceutical industry.


  • Canada GlobalLogic Full time

    About GlobalLogicGlobalLogic is a leader in digital engineering. We help brands across the globe design and build innovative products, platforms, and digital experiences for the modern world.Job Title: Digital Transformation ArchitectThis exciting role offers an opportunity to lead the design and implementation of the overall architecture for large-scale...