职业名称:Software Quality Assurance Analysts and Testers
技能等级:Level IV
现行工资:102918
现行工资周期:Year
现行工资信息实体:OES
其他现行工资信息来源:
现行工资确定日期:2022-12-09
现行工资失效日期:2023-06-30
起薪点:102918
工资最高点:120050
工资支付周期:Year
工作地址:8325 NW 62nd Avenue
工作地址:
工作城市:Johnston
工作州:IOWA
工作邮编:50131
工作职位:Data Warehouse Test Analyst
最低学历:Bachelor's
其他教育学历:
对应专业:Computer Engineering
所需培训:N
培训时长:
所需培训领域:
前置经验:N
经验时长（月）:
替代领域学历:Y
替代专业:Computer Science or related field
可替代教育及经验组合:N
所需教育层级:
其他可替代教育层级:
认可经验年限:
境外教育背景:Y
可替代职业:Y
可替代职业时长（月）:60
可替代职业名称:Related Occupation i.e. Software Test Engineer, Senior Project Engineer
是否为正常职业要求:Y
是否需要外语:N
特殊技能:This position requires a bachelors degree or equivalent in Computer Science, Computer Engineering, or a related field and 5 years related progressive, postbaccalaureate experience. Must also have 12 months of experience which may have been gained concurrently with each of the following 1 creating efficient SQL queries and test scripts using PythonSQL to analyze data between transactional applications and the data warehouse. Writing SQL test scripts based on existing template and incorporating logic from STM Source to Target documents; 2 building the testing platform for various Data integration projects in Crop Protection, Digital and other areas supporting RD data integration; 3 executing SQL tests manually and through automation framework. Writing Python scripts for miscellaneous bulk data testing; 4 leading the Quality Assurance team in developing automated testing framework using Python, SQL, Automation scripts for AWS S3 to DW Stage, REST APIs to DW stage and various source DB to DW Stage data migration; and 5 utilize the following toolstechnologies MS SQL Server Management studio, Teradata, Informatica DVO, Ready API, Advanced Query Tool.