Description
STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING!
S3 prides itself on being an international IT Staffing and Solutions company with 20 years experience recruiting and managing exceptional IT and Business consultants for customers in the Financial, Energy, Public Sector and Retail Distribution industries. We are a full service IT firm, with 25 major market locations and is a privately held, financially strong, woman owned company."
Role: ETL (BI) Tester
Location: Charlotte NC
Term: 12 months plus
Email resumes to Sophia
Bachelor's degree plus 7-10 years related experience including familiarity with testing automation tools
Required Skills
- Business Systems Analysis fundamentals and Software Quality Assurance Testing.
- Software Requirements and Data Analysis experience.
- Software Test Case Creation/Execution experience using HP Quality Center and Rational Clearquest or similar test case and defect tracking systems.
- Business Intelligence (BI) testing and/or development experience with tools like Oracle Business Intelligence EE, Business Objects, Cognos, etc.
- Strong SQL proficiency and thorough understanding of database stored procedures, views, joins, and functions.
- Strong understanding of data extraction, transformation and load processes (ETL), with preferred experience using SQL Server SSIS and Informatica.
- Knowledge of basic financial principles and statistical models.
- Prior experience with QRM applications or similar quantitative risk analytics applications (eg, Algorithmics)
Job Description :
- Business and functional requirements analysis
- Development and execution of test plan and test cases of new/existing QRM (Quantitative Risk Management) interfaces used in Liquidity risk analysis and modelling.
- Test ETL (SQL Server Integration Services) needed to incorporate new data into QRM databases and analytics Servers.
- Test ETL (Informatica) for loading source data, including QRM data into the reporting Datawarehouse.
- Validate the QRM job scheduling and distributed processing
- Validate high level QRM analytics configurations/models per requirements
- Validate the build-out of the Analytics Reporting Datawarehouse and Oracle Business Intelligence reports.
Preferred Skills:
- Knowledge in portfolios*(such as Bank Loans, Mortgage Banking, Investments, Deposits, Debts, Borrowings, Securities, Trading Assets) behaviors with relation to interest rate risk and funds transfer pricing.
- Strong quantitative and analytical skills.
- Effective communication, collaboration and influencing skills.
- Ability to integrate business knowledge and analytical insight to develop test cases for SOR interfaces for various banking portfolios.
- Ability to work independently as well as taking a lead role in any testing initiative.
- Comfortable establishing relationships and performing in an ambiguous environment.
- PM, BSA, and Technical lead experience.
- Proficiency in VB Scripting OR Perl OR Shell Scripting.