RQ00589 – ETL Data Analyst

  • Company:
    Yoush Consulting
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    18 hours ago
  • Category:

Must-haves: 5+ Years of experience with large volume data quality analysis, data profiling, data masking, transformation & cleansing, data extraction & loading from heterogenous data sources to Cloud 5+ Years experience with data quality and ETL technologies, programming and tools such as IBM InfoSphere Information Analyzer, Informatica Data Quality or OEDQ PL/SQL 5+ Years experience with data migration principles and best practices with SQL Nice to Have: Public Sector experience NOTE Assignment Type: This position is currently listed as “Onsite” due to COVID-19 related WFH direction. Once HSC staff are required to return to the office, the resource under this request will be required to work onsite as well. Responsibilities: Analyze data and business/data rules, profile the data and validate results, identify data issues and provide data quality resolution Data analysis and identification of data anomalies requiring data profiling Data tokenize and standardization Code business and data rules, profile the data, analyze and document profiling results and data quality issues Investigate data issues and provide data quality resolution Participate in data cleansing requirement discussion Participate in Business, IT and SME review meetings Provide day to day consultation and mentoring to the client Ongoing reviews with client to ensure understanding and address questions Knowledge transfer to Ministry staffs or resources designated by the Ministry Requirements Skill Set 5+ Years of experience with large volume data quality analysis, data profiling, data masking, transformation & cleansing, data extraction & loading from heterogenous data sources to Cloud 5+ Years experience with data tokenization, standardization, matching and address validation 5+ Years experience with data quality and ETL technologies, programming and tools such as IBM InfoSphere Information Analyzer, Informatica Data Quality or OEDQ Experience and knowledge with application of Machine Learning on data quality and profiling Experience and knowledge with data quality life cycle, data trending, dashboard and reporting with tools such as PowerBI 5+ Years experience with data migration principles and best practices Experience and knowledge of data migration between different sources/targets on-prem and Cloud, of varying data repository technologies, IMS, DB2, Oracle, SQL Server and Data Lakes Proven experience with program design, development and maintenance in Linux/Unix/Windows and Oracle 12c and SQL Server environments Proven experience in developing SQL*Loader scripts, optimized PL/SQL, complex queries with SQL, T-SQL, Unix/Linux scripts (e.g. Perl), Excel, Python/R/Jupiter and one or more other programming languages Experience with Oracle, SQL Server, relational and hierarchical database technologies Experience and knowledge with Azure Cloud Computing, Azure Service Model (e.g. IaaS, PaaS) and Azure storage technologies Experience with the Application Lifecycle Management (ALM) Tool and DevOps Experience and knowledge with Siebel EIM/EAI, OCH, EBS Experience working in accordance with policies and procedures of Ontario Public Service Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal and negotiation skills Ability to work independently and with good quality on concurrent multiple projects Evaluation Criteria RQ00589 Data Quality and Data Migration Experience 5+ Years of experience with large volume data quality analysis, data profiling, data masking, transformation & cleansing, data extraction & loading from heterogenous data sources to Cloud 5+ Years experience with data tokenization, standardization, matching and address validation 5+ Years experience with data quality and ETL technologies, programming and tools such as IBM InfoSphere Information Analyzer, Informatica Data Quality or OEDQ Experience and knowledge with application of Machine Learning on data quality and profiling Experience and knowledge with data quality life cycle, data trending, dashboard and reporting with tools such as PowerBI 5+ Years experience with data migration principles and best practices Experience and knowledge of data migration between different sources/targets on-prem and Cloud, of varying data repository technologies, IMS, DB2, Oracle, SQL Server and Data Lakes 40 ETL, Design and Development Skill and Experience Proven experience with program design, development and maintenance in Linux/Unix/Windows and Oracle 12c and SQL Server environments Proven experience in developing SQL*Loader scripts, optimized PL/SQL, complex queries with SQL, T-SQL, Unix/Linux scripts (e.g. Perl), Excel, Python/R/Jupiter and one or more other programming languages 30 Heterogenous Databases, Cloud and Seibel Technologies Experience with Oracle, SQL Server, relational and hierarchical database technologies Experience and knowledge with Azure Cloud Computing, Azure Service Model (e.g. IaaS, PaaS) and Azure storage technologies Experience with the Application Lifecycle Management (ALM) Tool and DevOps Experience and knowledge with Siebel EIM/EAI, OCH, EBS 15 Problem Solving and Communication Experience working in accordance with policies and procedures of Ontario Public Service Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal and negotiation skills Ability to work independently and with good quality on concurrent multiple projects 15