Senior ETL Developer

Found in: Appcast CA C2 Glassdoor - 2 weeks ago

Toronto, Canada Maarut Inc Full time

Resource Profile:

  • 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 DataStage and/or Cognos.
  • 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 information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within for resolution
  • Monitor and administer automated and manual data integration and ETL and reporting jobs to verify execution and measure performance
  • Work with management to provide technical assistance, advice and guidance to CLIENT IT staff 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 practices
  • Worked on Data warehousing projects and involved in supporting data modelling activities as 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 Data 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

Knowledge & Skills

MUST HAVE:

  • 5+ Years of experience in designing, developing, testing and implementing Extract/Transform/load (ETL) data pipelines and reporting with InfoSphere DataStage and/or Cognos
  • 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)
  • Knowledge of Python language
  • Strong understanding of Data Engineering best practices for moving large volumes of data
  • Good knowledge in Message Broker and or Event frameworks (e.g., Kafka, PubSub).
  • 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

NICE TO HAVE:

  • 2+ years’ development experience with Genesys Contact Manager with data integration and ETL experience with relevant application design, development and testing experience

  • Senior Informatica ETL Developer

    Found in: Talent CA C2 - 4 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...

  • Senior ETL Developer

    Found in: Talent CA C2 - 2 weeks 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).. ...

  • Software Developer

    Found in: Talent CA C2 - 2 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    Title: Software Developer - ETL – Senior Duration: Business Days Location: Jarvis St, Toronto, Toronto, Ontario (Hybrid) General Skills:  Experience in programming and analysis; specialized software package support at the specified experience level  ...

  • Senior ETL Software Developer

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada NR Consulting Full time

    Title :: Senior ETL Software Developer (- Days Onsite/Hybrid) Location :: Toronto, ON, Canada Duration : Contract SCOPE: A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution DELIVERABLES: ...

  • Software Developer

    Found in: Jooble CA O C2 - 7 days ago

    Toronto, ON, Canada Teacup Tech Systems Full time

    Please apply ONLY if you have Public Service Experience in CanadaA senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.MANDATORY REQUIREMENTS:• 7+ years of experience in developing data conversion and migration•...

  • Software Developer

    Found in: Jooble CA C2 - 1 week ago

    Toronto, ON, Canada Teacup Tech Systems Full time

    Please apply ONLY if you have Public Service Experience in CanadaA senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.MANDATORY REQUIREMENTS:• 7+ years of experience in developing data conversion and migration•...

  • ETL Developer

    Found in: Talent CA C2 - 2 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job...

  • Senior Software Developer ETL

    Found in: Jooble CA O C2 - 4 days ago

    Toronto, ON, Canada Knewin Full time

    Senior Software Developer ETL Contract Duration 2+ years Scope: A Senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution Deliverables: Provide best practice migration solutions and oversee all facilities...

  • Senior Software Developer ETL

    13 hours ago

    Old Toronto, Canada Knewin Full time

    Senior Software Developer ETL Contract Duration 2+ years Scope: A Senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution Deliverables: Provide best practice migration solutions and oversee all facilities of the data...

  • Senior Software Developer ETL

    3 days ago

    Old Toronto, Canada Knewin Full time

    Senior Software Developer ETL Contract Duration 2+ years Scope: A Senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution Deliverables: Provide best practice migration solutions and oversee all facilities of the data...

  • Senior Software Developer ETL

    6 days ago

    Old Toronto, Canada Knewin Full time

    Senior Software Developer ETL Contract Duration 2+ years Scope: A Senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution Deliverables: Provide best practice migration solutions and oversee all facilities of the data...

  • Software Developer

    Found in: Appcast CA A2 P - 1 week ago

    Toronto, Canada Teacup Tech Systems Full time

    Please apply ONLY if you have Public Service Experience in CanadaA senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.MANDATORY REQUIREMENTS:• 7+ years of experience in developing data conversion and migration•...

  • Software Developer

    Found in: Appcast CA C2 Glassdoor - 1 week ago

    Toronto, Canada Teacup Tech Systems Full time

    Please apply ONLY if you have Public Service Experience in CanadaA senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.MANDATORY REQUIREMENTS:• 7+ years of experience in developing data conversion and migration•...

  • Software Developer

    Found in: Whatjobs CA C2 - 1 week ago

    Toronto, Canada Teacup Tech Systems Full time

    Please apply ONLY if you have Public Service Experience in Canada A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution. MANDATORY REQUIREMENTS: • 7+ years of experience in developing data conversion and migration •...

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

  • Senior Software Developer ETL

    Found in: Talent CA C2 - 3 days ago

    Toronto, Canada GTT, LLC Full time

    Senior Software Developer ETL Contract Duration 2+ yearsScope: A Senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution Deliverables: Provide best practice migration solutions and oversee all facilities of the data and files...

  • ETL Developer

    Found in: Talent CA C2 - 2 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionJob...

  • Software Developer ETL

    Found in: Talent CA C2 - 1 week ago

    Toronto, Canada Global Pharma Tek Full time

    Title: Software Developer - ETL Senior Location: Toronto, ON (Hybrid) Duration: Business Days + Possible extension Job Description: Full life-cycle data conversion experience with enterprise systems, including deployment experience. Experience working with all steps of data migration activities such as data profiling, data mapping, developing...

  • ETL Developer

    Found in: Appcast CA C2 Glassdoor - 1 week 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...