Test Automation Developer – ETL/API/Rules

This position, a Test Automation Developer for ETL, API, and Rules, is with CGI Group, Inc. located in Arlington, VA with a hybrid work arrangement. The role focuses on designing, developing, and maintaining automated test solutions for ETL pipelines, APIs, and business rules with CI/CD integration.

Responsibilities

• Design and implement automation frameworks for testing ETL processes, APIs, and business rules, using languages and tools such as Python, Java, SQL, Selenium, Postman, SoapUI, or custom scripting.
• Develop and execute automated test scripts to validate data extraction, transformation, and loading workflows.
• Ensure data integrity, accuracy, and completeness across diverse data sources and target systems.
• Perform data reconciliation and verify data mappings and transformations.
• Design and execute automated tests for RESTful and SOAP APIs, covering functional, integration, performance, and security aspects.
• Validate API responses, error handling, and conformance to specifications.
• Develop automated tests to verify the correct implementation and execution of complex business rules within applications or rules engines.
• Ensure alignment with defined business requirements and expected outcomes.
• Create, maintain, and execute comprehensive test cases, test scripts, and test plans across all areas of responsibility.
• Identify, document, track, and prioritize defects, collaborating with development teams for timely resolution and retesting.
• Integrate automated tests into CI/CD pipelines to enable continuous testing and rapid feedback.
• Generate detailed test reports, analyze results, and provide recommendations for process improvements and quality enhancements.
• Collaborate with developers, product owners, business analysts, and QA colleagues to understand requirements, define test strategies, and ensure quality deliverables.

Requirements

• Bachelor's degree and/or 2 to 5 years of experience
• Security Clearance: TS/SCI required with the ability to obtain a TS/SCI with Poly
• Strong experience in test automation development, including designing and implementing automation frameworks
• Proficiency in programming languages such as Python, Java, or similar for test automation
• Expertise in SQL for data validation, querying, and database testing
• Experience with ETL testing methodologies and tools (e.g., Informatica, Talend, SSIS, or custom scripts)
• Hands-on experience with API testing tools (e.g., Postman, SoapUI, JMeter)
• Understanding of business rules engines and experience testing complex rule sets
• Familiarity with CI/CD tools and practices (e.g., Jenkins, Azure DevOps, GitHub Actions)
• Experience with version control systems (e.g., Git)
• Strong analytical, problem-solving, and communication skills
• Bachelor's degree and/or 5 to 10 years of experience
• Bachelor's degree and/or 10+ years of experience

Technologies

• Python
• Java
• SQL
• Selenium
• Postman
• SoapUI
• JMeter
• Informatica
• Talend
• SSIS
• Git
• Jenkins
• Azure DevOps
• GitHub Actions

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and the share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid parental leave
• Learning opportunities and tuition assistance
• Wellness and Well-being programs