AWS Data Warehouse BI Reports Test Automation Engineer
Summit2Sea Consulting, LLC, United States

Have you been looking to shift your career into high gear? This is your opportunity to take your ambitions and convert them into a solid career in a supportive and innovative environment!

Summit2Sea is a technology consulting firm run by hands on technologists that combines people, process and technology to deliver innovative solutions to our clients. We have been named on The Washington Post's list of top work places for the past 3 years! We invest in our biggest asset - our people! You can be a part of a winning team that will contribute to your career growth.

We are seeking a Junior to Mid-level Test Automation Engineer with AWS experience to join a data warehouse and business intelligence (BI) team supporting our federal client working to migrate an on-prem Oracle Enterprise Edition (EE) data warehouse to Redshift data warehouse in AWS. This is a full-time position with on-site work performed at the client’s office in Washington, DC with some hybrid flexibility.

Impactful Work You'll Do:

• Work in tandem with our Solutions Architect, ETL, and BI developers to develop regression test suite to execute prior to code drop in pre-production and production environments for both data warehouse and reporting application
• Develop test automation suite to validate data load from Oracle transactional system to Redshift Data warehouse
• Perform integration testing to validate data push/pull to/from external systems
• Develop and maintain reusable code to help build streamlined and efficient automated test processes
• Analyze and evaluate defect metrics, providing feedback and reports to developers
• Validate BI TIBCO WebFOCUS report values matches with the values in Redshift Data Warehouse
• Perform end to end testing to validate data movement from OLTP to OLAP to BI reports
• Maximize test coverage for the most critical features of the system
• Create test plan and additional documentation for automated processes including test procedures, test dependencies, and test cases
• Incorporate test automation suite into a CI/CD pipeline using GitLab and GitLab runner
• Ensure test scripts and test data are expanded and updated as needed throughout the testing lifecycles
• Suggest Automation Test tools to shorten the regression testing timeliness
• Conduct Test Automation code reviews with developers and BA’s

Requirements

• Ability to represent and uphold our core values of integrity, client service, expertise, adaptability, communication, and teamwork

• 5 years of QA automation experience is required
• Six to ten years of SQL knowledge to validate ETL data load and data transformation jobs in Redshift
• Six to ten years of programming skills to develop test scripts in Python, Javascript, and common Linux scripting languages
• Good understanding of AWS cloud data architecture including Redshift, Lambda, SQS, SNS and S3 bucket
• Experience with logging, tracking and documenting defects in the JIRA
• AWS Certification such as AWS Certified Cloud Practitioner is a plus
• Experience in data warehouse and BI reports cloud migration testing
• Experience with performance, load and stress testing of BI reports
• Excellent collaboration skills to work with multiple teams in the organization
• Understanding of network and data security architecture
• Experience with Agile/SCRUM framework
• Active Top Secret clearance required

Benefits

Upper Tier Compensation includes a base salary and bonuses based upon: performance, business development, employee referrals and knowledge sharing. We value the individual and share our company's success across our team.

Summit2Sea is committed to offering our employees a benefits package that is competitive and comprehensive enough to meet their goals and needs. As a valued member of the S2S team, employees are provided with a collection of benefits to include paid holidays, health and dental care to name a few.

Compensation Components
-Competitive Base Salary
-Quarterly Recruiting Bonus
-New Sales Bonus
-Knowledge Contribution Bonus

Benefit Components
-Paid Holidays
-Vacation/Sick Leave/Personal Time Off
-Health Insurance
-Dental Insurance
-Life Insurance
-401K

Summit2Sea Consulting is an Equal Opportunity Employer (EOE) and E-Verify employer. Qualified applicants are considered for employment without regard to age, race, color, religion, sex, national origin, sexual orientation, disability, or veteran status. If you need assistance or an accommodation during the application process because of a disability, it is available upon re

Job Rewards and Benefits