ETL Developer

Found in: Talent CA C2 - 1 week ago

Toronto, Canada Maarut Inc Full time

Job Deliverables:

  • Work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support of Azure Cloud data technologies such as Azure Data Factory, Databricks, Azure Synapse and/or SQL Data Warehouse. 
  • Experience with enterprise ETL and data integration tooling such as IBM Infosphere Information Server DataStage solution is a plus.
  • Provide support for Enterprise Data Warehouse operations (e.g. daily data refreshes of mirror and warehouse components) to ensure the delivery of timely, accurate and reliable data to CLIENT business users. 
  • This includes monitoring the update processes, updating/maintaining the appropriate system documentation, identifying potential problems and implementing solutions to ensure the efficiency and reliability of the IM operations.
  • Maintain the ETL environments by monitoring their performance to ensure functionality,Integrity and security of the environments and compliance with BTS information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within BTS for resolution
  • Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance.
  • Work with management to provide technical assistance, advice and guidance to CLIENT ITstaff and business clients in response to enquiries on the functionality of BI/ETL tools, and data in warehouse and related data marts to ensure efficient and uninterrupted IM services to the business users.
  • Candidate should be conversant with Cloud ETL methodologies and job design with a sound
  • knowledge and experience of integrating input/jobs from disparate systems and be able to maintain the CLIENT's standard of ETL best practic
  • Worked on Data warehousing projects and involved in supporting data modelling activitiesas part of building the data warehouse in Azure. Strong understanding of data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).

 

Resource Responsibilities

  • Provide technical design, developing and implementing IT solutions
  • Translate client business systems requirements and associated functional designs into technical design documentation, ensuring that the solution(s) satisfy all business requirements.
  • Work with Analysts, Administrators, and Testing teams to support configurations, code customizations, code migrations, and testing from Unit, System, Integration, User Acceptance and performance.
  • Participate in technical sessions to prototype new system functionality.
  • Participate in workshops with project teams to explain and gain consensus on the solution(s) to be developed.
  • Work with systems analysts to ensure the solution meets the approved solution design.
  • Perform code reviews to identify potential issues.
  • Perform unit testing and troubleshoot coding issues.
  • Provide support during systems integration testing.
  • Provide knowledge transfer and create/update technical documentation.
  • Provide coordination in release and change management processes


Requirements

MUST HAVE:

  • 3+ Years of experience in designing, developing, testing and implementing Extract/Transform/load (ETL) data pipelines with Azure data technologies such as Azure Data Factory, Databricks, Azure Synapse and/or SQL Data Warehouse
  • 4+ years’ experience in data modeling and working with common data warehouse Models
  • 4+ years’ experience doing analysis and developing with SQL (e.g. Oracle, MS SQL, DB2)
  • 5+ years’ experience working DevOps tools and practices
  • 5+ year experience working with accepted methods, standards, techniques and best practices for development in agile/scrum practices
  • Oral communication skills to work effectively with and discuss development approaches to clients/senior management and external stakeholders; written communications skills to document and communicate development specifications
  • 2+ years’ development experience with  PeopleSoft V 9.1, PeopleTools V8 with data integration and ETL experience with relevant application design, development and testing experience

NICE TO HAVE:

  • Good knowledge of popular data standards and formats (e.g, JSON, XML, Proto, Parquet, Avro, ORC)
  • Experience working with high volume data exchange and transaction processing systems Experience writing well documented unit tests and executing them
  • Experience of reverse-engineering data mappings based on application-layer code highly desirable Ability to express complex technical concepts effectively, both verbally and in writing
  • Strong understanding of SDLC and Agile Methodologies
  • Degree in computer science, math, engineering or equivalent work experience Excellent Communication Skills



  • ETL Developer

    Found in: beBee S CA - 3 weeks ago

    Toronto, Canada GTT, LLC Full time

    ETL Developer Job Responsibilities The ETL Developer will design, develop, and implement the ingestion framework from Oracle data source to Azure Data Lake - initial load and incremental ETL. Tools used are:Azure Data Factory (good knowledge required) to maintain the pipeline from Oracle to Azure Data LakeAzure Databricks/PySpark (good Python/PySpark...

  • ETL Developer

    Found in: beBee jobs CA - 2 weeks ago

    Toronto, Ontario, Canada GTT, LLC Full time

    ETL DeveloperJob ResponsibilitiesThe ETL Developer will design, develop, and implement the ingestion framework from Oracle data source to Azure Data Lake - initial load and incremental ETL. Tools used are:Azure Data Factory (good knowledge required) to maintain the pipeline from Oracle to Azure Data LakeAzure Databricks/PySpark (good Python/PySpark knowledge...

  • ETL Developer

    Found in: Appcast CA C2 Glassdoor - 6 days ago

    Toronto, Canada AMISEQ Full time

    MANDATORY REQUIREMENTS:7+ years of experience in developing data conversion and migrationExtensive experience in data migration in terms of digital transformation,ETL experience in migrating data from legacy applications to modernized solutions.Experience in migrating document attachments from legacy solution to a new modernized solution.Experience working...

  • ETL Developer

    Found in: Whatjobs CA C2 - 6 days ago

    Toronto, Canada AMISEQ Full time

    MANDATORY REQUIREMENTS: 7+ years of experience in developing data conversion and migration Extensive experience in data migration in terms of digital transformation,ETL experience in migrating data from legacy applications to modernized solutions. Experience in migrating document attachments from legacy solution to a new modernized solution. Experience...

  • ETL Developer

    Found in: Appcast CA A2 P - 6 days ago

    Toronto, Canada AMISEQ Full time

    MANDATORY REQUIREMENTS:7+ years of experience in developing data conversion and migrationExtensive experience in data migration in terms of digital transformation,ETL experience in migrating data from legacy applications to modernized solutions.Experience in migrating document attachments from legacy solution to a new modernized solution.Experience working...

  • Senior ETL Developer

    Found in: JG CA C2 - 1 week ago

    Toronto, Canada Procom Full time

    Senior ETL Developer On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior ETL Developer. Senior ETL Developer - Job DescriptionThis role involves leading the migration of data and files from legacy systems to modernized platforms, ensuring best practice solutions and maintaining high standards of data integrity and...

  • Senior ETL Developer

    Found in: beBee S CA - 2 weeks ago

    Toronto, Canada GTT, LLC Full time

    Senior ETL Developer Job ResponsibilitiesDesign, develop, and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are:Azure Data Factory (expert knowledge) to maintain the pipeline from Oracle to Azure Data LakeAzure Synapse to build stored procedures and read data from the data lakeReview the...

  • ETL Developer

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionJob...

  • ETL Developer

    Found in: Appcast CA A2 P - 1 week ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • ETL Developer

    Found in: Appcast CA C2 Glassdoor - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • ETL Developer

    Found in: Whatjobs CA C2 - 1 week ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and...

  • ETL Developer

    Found in: Talent CA 2A C2 - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCSTCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to...

  • ETL Developer

    Found in: Whatjobs CA C2 - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCS TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed...

  • ETL Developer

    Found in: Appcast CA C2 Glassdoor - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCSTCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to...

  • ETL Developer

    Found in: Appcast CA A2 P - 2 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCSTCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to...

  • Senior Informatica ETL Developer

    Found in: JG CA C2 - 1 week ago

    Toronto, Canada Procom Full time

    Senior Informatica ETL Developer On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior ETL Developer. Senior Informatica ETL Developer - Job DescriptionAssist with the design and configuration of the cloud infrastructure to optimally support IDMCMentor and support our ETL developers in their transition to IDMCHelp with the...

  • ETL BI Developer

    Found in: Talent CA C2 - 3 days ago

    Toronto, Canada Maarut Inc Full time

    Resource ProfileThis requirement is for a ETL and BI Developer to work  with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere Information Server...

  • Senior Informatica ETL Developer

    Found in: Talent CA C2 - 3 days ago

    Toronto, Canada GTT, LLC Full time

    Senior Informatica ETL Developer /Senior Software Developer (ETL) Contract Duration 18+ MonthsJob Overview:The Senior Software Developer (ETL) with strong experience using IDMC will: mentor and support our ETL developers in their transition to IDMC help with the ETL code conversion from legacy Informatica PowerCenter to IDMC help with design and...

  • Database Developer

    Found in: Talent CA 2 C2 - 1 week ago

    Toronto, Canada CB Canada Full time

    Database Developer - SQL, ETL On behalf of our client in the Banking Sector, PROCOM is looking for a Database Developer - SQL, ETL. Database Developer - SQL, ETL – Job Description Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs Familiar with a variety of the field's concepts, practices,...

  • Senior ETL Developer

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada Lorven Technologies Full time

    Job Title: Senior ETL Developer Job Location: Toronto, Canada (onsite) Job Type: Contract 12+ Months (T4/ Incorporated) Skills Must have Bachelor's degree in Computer Science, Information Systems, or a related field. Proven experience working with ETL tools (DataStage, SQL/PLSQL); Scheduling tools (JAMS); Database (Oracle).. ...