For the given job description <<General Summary
The Sr Business Systems Database Software Engineer will be a key player in designing, implementing, and optimizing our data architecture to support our production, accounting, business intelligence, and financial reporting functions. This position will collaborate closely with cross-functional teams, including production, finance, technology and operations, to ensure seamless data integration and provide actionable insights for strategic decision-making.
Job Functions
Design, administer and maintain a robust and scalable data warehouse for our Solver-based Corporate Performance Management (CPM) system within the Microsoft Azure cloud environment.Utilize domain knowledge of production tracking tools such as ShotGrid and Ftrack to streamline data collection and analysis processes, feeding into the data warehouse.Manage Azure based SQL databases, ensure data integrity, performance and security for both the data warehouse and other relevant databases.Develop and optimize Python APIs to facilitate efficient and secure data access and retrieval from the data warehouse.Collaborate with Accounting and Finance departments to gather, transform and integrate financial data into the data warehouse architecture for accurate financial and operational reporting.Build comprehensive and insightful financial and operational reports, leveraging the data warehouse.Create and implement well-organized data collection processes and thoughtful schema taxonomies to ensure data accuracy, consistency and ease of reporting.Take a hands-on approach in a green space to build new financial and operational reporting processes and operations that span various departments and workflows.Provide ongoing support and troubleshooting for data-related issues, ensuring data quality and availability for reporting purposes.
Qualifications
5+ years of professional experience in Computer Science, Information Technology, Finance or a related field as a Database Architect, Database Engineer or similar role.Proficiency in Microsoft Azure services and architecture, with experience in designing and implementing cloud-based data warehousing solutions, required.Strong working knowledge of SQL databases, data modeling, and performance optimization techniques.Proven experience developing Python APIs for data retrieval and integration.Demonstrated ability to collaborate effectively with cross-functional teams, including production, finance, technology and operations departments.Expertise in working with production tracking tools such as ShotGrid and Ftrack.Advanced skills in Microsoft Excel for building financial and operational reports.Excellent problem-solving skills and the ability to navigate complex business and financial requirements.Strong communication skills, both written and verbal, with the ability to convey technical concepts to non-technical stakeholders.Self-motivated, detail-oriented and adaptable to changing business needs.A passion for continuous learning and a proactive attitude towards exploring advanced topics and emerging technologies.
Physical Demands and Work Environment
The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical demands: While performing the duties of this job, the employee is required to walk; stand; sit; use hands to operate standard office equipment; reach with hands and arms; balance; stoop; talk or hear both in person and by telephone. The employee must lift andor move up to 15 pounds. Vision abilities include close vision, distance vision, and the ability to adjust focus.Work environment: While performing the duties of this job, the employee works under typical office conditions and is exposed to variable indoor temperatures. The noise level is usually quiet or moderate.
Location
On-site in Hillsboro, OR  and also eligible for hybrid work  Remote Eligible.
Salary
Salary Is Commensurate With Skills And Experience.
Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.
Please review our EMPLOYMENT DISCLAIMER and MATERIALS SUBMISSION AGREEMENT.>> the resume: <<Summary5+ years of professional experience in Manual Testing and Automation Testing of web-based applications with the purpose of assuring that software meets the highest standards of quality.
SkillsTesting Tools:Selenium WebDriver, Selenium Grid, JDBC, Cucumber, JavaScript executer,SQL Developer, REST Assured, Postman.Languages:Java, SQL, HTML, XML, JSONIDE:intellij, EclipseTesting Framework:JUnit, TestNGBuild Tools:MavenBug Tracking Tools:Jira, Jira X-RayRepository System:Git, GitHubContinuous Integration:JenkinsDatabases:Oracle, MySQLWeb Services:RESTful APIOperating Systems:Windows, macOSMethodologies:Agile, Waterfall
ExperienceSDET (Software Development Engineer in Test),01/2021-CurrentApex Systems–Franklin,WI,Following theSDLCMethodologies throughout the testing process from initiation until development.Analyze and studyRequirements and Documentationto plan and createTest Plan, Test, Test Set, and Test Executions utilizing Jira X-Ray.As a member ofScrum teamactively participated inDaily Scrum, Sprint Planning, Sprint Demo, and Sprint Retrospective Meetings.Create from scratch and maintaining testAutomation Framework (Hybrid - BDD, and DDT)built as aMavenproject written onJavato develop and executeAcceptance TestsfromCucumber Feature Files and Scenarios.CreateFeature Filesand writeTest Scenarios and Step Definitions in CucumberusingGherkin languageand integrating withJira X-Ray.ApplyPage Object Model (POM)design for reusability and enhancing Test creation and as well as in maintenance.ConductSmoke, Functional, Positive, Negative, Integration, Regression Teststo support the project and deliver clean code, functionality to the client and users usingJava, Maven, Selenium WebDriver, Selenium Grid, Cucumber, JUnit.Work onCross-Browser TestingthroughSelenium WebDriver,Selenium Gridby testing the Website on different browsers likeChrome, IE, andFirefox in Parallel.Prepare and executeTest ScriptsusingJavawithSelenium WebDriver in IntelliJfor automatingManual Test ScenariosforWeb applications,Database, andClient/Server (API Automation)applications.UtilizeJenkinsas aContinuous Integrationserver configuring withGit and Mavenon anAWS EC2machine to provide continuous testing for the project.Execute theRegression Test SuiteandSmoke Tests,and generateHTMLreports among the screenshots of the failures to be sent to emails as well as other communication tools.PerformAPI Testingto validate endpoints and properJSON/XMLstructure usingPostmanandREST AssuredapplyingGET, POST, PUT, PATCH, DELETEmethods.ConductSystem TestingandUser Acceptance Testingfor every client and conductBack-End Testingwriting extensiveSQL Queries.PerformBack-End Testingby writingSQL QueriesforData ValidationinSQLDeveloper and implementingJDBCconnection forAutomationpurposes.Participate in meetings with product owner and developers to discuss requirements, reviews, testing, and documentation for the application developed in anAgileenvironment.Work closely with developers and product owner to define the components of theAutomation Testingto validate the requirements of the application.Research, analyze, report, and retest resolved bugs/defects both with the help ofAutomation TestingandManuallywhen necessary.DevelopTest Scriptsto test the functionality of the application and executeAutomation Scriptson different browsers/environments and report defects/results to the team.Responsible for testing the application against different environments in testing, development, and production.Work with source version controlGit,creating branches for code reviewing and storing master branch of theFramework.Environment:Agile, Java, Selenium WebDriver, Cucumber, Gherkin, Maven, JUnit, REST API, IntelliJ, Jira, Jenkins, Git, HTML, Selenium Grid, AWS EC2, XML, Chrome, Firefox, IE, SQL, JDBC, Oracle, Windows, iOS.Java SDET,01/2019-01/2021UnitedHealth Group–City,STATE,Successfully built and maintained Automation Framework withPage Object Model (POM)Design Pattern utilizingJava Selenium WebDriverandCucumber.CreatedFeature FilesusingGherkinlanguage, generated, and implementedStep Definitionsin synchronization withCucumber Runnerclasses.UtilizedMavenfor project build, dependencies, and documentation purpose.CreatedSQL Queriesas part ofBack-End Testingby usingJDBC library.Participated in preparingTest CasesusingSelenium WebDriverto validate all UI components,Mouse Actions,andPopup Windows.Identified elements using various locators such asID, Name, Class, Tag Name, Link Text, Partial Link Text, XPath, and CSSselectors to createPage ClassesforPOM Design Pattern.PerformedCross-Browser TestingagainstFirefox, Chrome, Internet Explorer, Safari, andHeadlessto improve theBrowser Compatibilityof the application.Developed reusable functions, exception handling, and methods to improve work efficiency.Performed Scenario screenshots of important checkpoints and exceptions whenever it occurred during the execution of the application.PerformedAPI TestingusingPostmanandREST Assured libraryexecuteGET, POST, PUT, PATCH, DELETEmethods as well asJSON Pathsyntax.GeneratedCucumber TestsummaryHTMLreports mainly utilizingMaven-Cucumber-reporting plugin.Participated in all activities and all phases of theAgile Software DevelopmentandTest Development Life Cycle.Set up aContinuous Integrationsystem usingJenkinsgating to the merges in the code repository system such asGitHub.Created and maintained theRequirements Traceability Matrixfor better Test coverage.Logged the defects inJiraand maintained track of the defects inJira X-Ray.As a member of Scrum team actively participated inDaily Scrum, Sprint Planning, Sprint Demo, and Sprint Retrospective Meetings.CreatedTest Plans, Test Scenarios, Test Cases, and Test Stepscovering bothPositive and Negative Scenarios.Environment: Agile, Java, Selenium WebDriver, Cucumber, Maven, Gherkin, Jenkins, Jira, Git, HTML, XML, IntelliJ IDEA, Postman, Chrome, Firefox, SQL, POM, API, Windows.QA Engineer,02/2018-01/2019Vibrent Health–City,STATE,Responsible for web testing of COMPANY-3's intranet application, which provides employees features like employee database search, access to online documents, news/articles, events, etc.Participated inFunctional Specificationsreview meetings with other teams.Conducted manual testing for key features on each module and generated reportsPerformedPositive and Negative Testing.User Interface (UI) Testing.Involved in efforts to implement theUI Test AutomationusingJavaandSelenium WebDriver.ConductedRegression Testingfor each release and maximized the test coverage.>>. The result is, Good Fit

Fit assessment: Good Fit