QA自动化工程师 / 企业ETL测试员
QA Automation Engineer / Enterprise ETL Tester
QA自动化工程师 / 企业ETL测试员
职位描述
我们正在证券交易委员会（SEC）寻找一位经验丰富的QA自动化工程师。该职位支持SEC的企业定性支持服务（EQSS）合同，为机构不断增长的云和数据分析环境提供独立的验证和确认。在此职位上，您将对支持IV&V活动的软件和数据工作流进行系统分析、验证和确认，执行软件QA和缺陷评估，处理和验证结构化和半结构化数据，包括XML、JSON和固定宽度格式，为Oracle、PostgreSQL和Iceberg环境开发SQL脚本和测试，使用Python构建自动化和验证脚本，并在AWS中使用Redshift、Glue和S3支持数据仓库和数据湖测试活动。这是一份全职职位。我们可提供具有竞争力的薪资和全面的福利包。
职责
· 对支持IV&V活动的软件和数据工作流进行系统分析、验证和确认。
- 执行软件QA、功能/回归/系统测试和缺陷评估。
- 处理和验证结构化和半结构化数据（XML、JSON、分隔符、固定宽度）。
- 为Oracle、PostgreSQL和Iceberg环境开发SQL脚本和测试。
- 支持数据工程流程、ETL/ELT工作流和数据质量评估。
- 使用Python构建和维护自动化和验证脚本。
- 在AWS环境中操作，并使用Redshift、Glue和S3支持数据仓库和数据湖测试活动。
- 使用Linux、CLI工具和GitHub进行版本控制和开发流程。
- 准备正式的技术文档，并向政府利益相关者传达发现结果。
所需技能/经验
· 在软件QA、测试工程、测试自动化和数据工程方面有实际经验。
- 精通XML、JSON、CSV、分隔符和固定宽度数据格式。
- 熟练掌握SQL，并有使用Oracle、PostgreSQL和Iceberg数据库的经验。
- 有使用Python进行脚本编写和自动化的实践经验。
- 有使用Git进行CI/CD自动化部署管道的实际经验。
- 有在AWS环境中使用Redshift、Glue和S3的实际经验。
- 熟练使用Linux、命令行操作和GitHub仓库。
优先考虑的技能/经验
· 良好的书面和口头沟通能力。
查看英文原文
QA Automation Engineer / Enterprise ETL Tester
ROLE
We need an experienced QA Automation Engineer at the Securities and Exchange Commission (SEC). This role supports the SEC's Enterprise Qualitative Support Services (EQSS) contract, providing independent verification and validation across the agency's growing cloud and data analytics environment. In this role, you will perform system analysis, verification, and validation across software and data workflows supporting IV&V activities, conduct software QA and defect evaluation, process and validate structured and semi-structured data including XML, JSON, and fixed width formats, develop SQL scripts and tests for Oracle, PostgreSQL, and Iceberg environments, build automation and validation scripts using Python, and support data warehousing and data lake testing activities within AWS using Redshift, Glue, and S3. This is a full-time opportunity. We can offer a competitive salary, and a comprehensive benefits package.
RESPONSIBILITIES
· Perform system analysis, verification, and validation across software and data workflows supporting IV&V activities.
- Conduct software QA, functional/regression/system testing, and defect evaluation.
- Process and validate structured and semi-structured data (XML, JSON, delimited, fixed width).
- Develop SQL scripts and tests for Oracle, PostgreSQL, and Iceberg environments.
- Support data engineering processes, ETL/ELT workflows, and data quality assessments.
- Build and maintain automation and validation scripts using Python.
- Operate within AWS environments and support Data warehousing and Data-lake testing activities using Redshift, Glue and S3.
- Utilize Linux, CLI tools, and GitHub for version control and development workflows.
- Prepare formal technical documentation and communicate findings to government stakeholders.
REQUIRED SKILLS/EXPERIENCE
· Demonstrated experience in software QA, test engineering, test automation, and data engineering.
- Strong proficiency with XML, JSON, CSV, delimited, and fixed width data formats.
- Skilled in SQL and experience with Oracle, PostgreSQL, and Iceberg databases.
- Practical experience with Python for scripting and automation.
- Hands on experience with CI/CD automated deployment pipelines using Git.
- Hands on experience working within AWS environments, Redshift, Glue and S3.
- Proficiency in Linux, command line operations, and GitHub repositories.
PREFERRED SKILLS/EXPERIENCE
· Strong written and oral communication skills.
- Ability to work independently and collaborate in multidisciplinary technical environments.
- High attention to detail, strong analytical thinking, and structured problem-solving skills.
REQUIRED EDUCATION / CERTIFICATIONS· Bachelor's degree in computer science, data science, engineering, finance, or a related quantitative field (Master's preferred)
LOCATION· Remote – Based in National Capital Region - Preferred
CLEARANCE
· U.S. citizenship is required. Must not hold citizenship with another country.
- Ability to obtain SEC security clearance
CLIENT· Securities and Exchange Commission (SEC), Office of Information Technology
WORK HOURS
· 40 hours per week
- 8 hours per day
EMPLOYMENT CLASSIFICATION· Employment Classification Eligibility — W2
RELOCATION· Not eligible for relocation benefits
COMPENSATION
· Salary range: $140,000 – $150,000
- Benefits: Benefits package includes options for health, dental, and vision insurance coverage; 401k contribution options
West 4th Strategy is an Equal Opportunity (EEO) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, gender, sexual orientation, ancestry, national origin, age, marital status, mental disability, physical disability, medical condition, pregnancy, political affiliation, military or veteran status, or any other basis prohibited by federal or state law.
Other Considerations: applicants will be subject to a background investigation. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 80% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include the use of computer monitor screens up to 80% of the time.Originally posted on Himalayas