DetroitRecruiter
the smart solution for Detroit jobs

CRM ETL - Test Lead

Company: Strategic Staffing Solutions
Location: Detroit
Posted on: May 20, 2019

Job Description:

Looking for a Test lead with Salesforce and ETL experience. With general guidance and coaching, participates in developing and executing test scenarios for unit, process, function, system integration and acceptance testing. Develops test cases, scenarios and scripts to ensure applications quality. Designs and develops usability testing scenarios, and administers portions of testing process. Defines criteria for testing, analyzes results of testing sessions and presents results. Participates in selection of testing tools and approaches. Utilizes appropriate testing tools and testing processes on projects and assists in building test environments. . Top 5 SkillsExperience 5 years experience writing complex SQL queries (NOTE Resumes must specify specific SQL concepts to ensure candidate is truly experienced with writing complex SQL queries.) 5 years experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing a. QA Testing experience must be in both manual and automated testing environments, with a strong focus in both as manual testing experience is required to create the automated test cases and SQL statements. Automated testing experience should be with IBM Rational Tools. Analytical ability to review and understand both business requirements and data to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the "testability" of requirements, and creating a comprehensive test plan that supports the business and technological solutions being delivered Extensive knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data 3 years experience with Salesforce or other CRM applications including interstation testing between multiple systems. Required SkillsExperience 5 years experience writing complex SQL queries (NOTE Resumes must specify specific SQL concepts to ensure candidate is truly experienced with writing complex SQL queries.) 5 years experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing o QA Testing experience must be in both manual and automated testing environments, with a strong focus in both as manual testing experience is required to create the automated test cases and SQL statements. Automated testing experience should be with IBM Rational Tools. Extensive knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data Capture (CDC), and relational and dimensional data modeling techniques. 5 years experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment. Candidates are expected to be able to analyze testing results to ensure accuracy when compared to requirements and to determine potential errors when expected and actual testing results to not align. 2 years current experience with the following Rational Tools o Rational Quality Manager (RQM) o Rational ClearQuest (RCQ) 5 years Oracle experience 3 Years experience with Unix Advanced knowledge of Microsoft Excel for the purpose of creating test grids and using formulas to compare test results. Ability to convert requirements documents (Business Requirements, Functional and Technical Requirements) into test strategiesplans, test scenarios and test cases, including appropriate SQL scripts to execute testing cases. Ability to evaluate the "testability" of requirements and reports to project team member's changes or additional information needed in requirements Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.) and create a comprehensive test plan that supports the business and technological solutions being delivered Ability to coordinate test execution across multiple teams Defect tracking experience (i.e. ClearQuest or HP Service Center) Experience in tuning SQL queries for performance improvements Proficiency with the following Informatica tools o Informatica PowerCenter 10.2 o Informatica PowerExchange 9.6.1 Soft Skills Required Must have the ability to multi-task and adapt quickly to changes while maintaining urgency in completing assigned tasks. Must have the ability to work independently with minimal supervision Excellent analytical, organizational, verbal, and written communication skills Will be responsible for explaining and validating test results to peers as well as clients Must be able to question the work of others to ensure accuracy and be able to defend theories and methodologies used to create individual results Extensive creativity is required Preferred SkillsExperience 2 years experience with Cognos (Version 8 or higher) General health care knowledge in any of the major subject areas listed below o Medical claims o Memberships o Pharmacy claims o Customers Knowledge of following toolsapplications are a plus o Toad for Oracle o Toad for Data Analysts o MS Office Suite Specific experience working with the BCBSM Enterprise Data Warehouse is a plus Working knowledge of scheduling tools (examples below) Educational Requirements Bachelor's Degree in related field preferred

Keywords: Strategic Staffing Solutions, Detroit , CRM ETL - Test Lead, Other , Detroit, Michigan

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Parts Counterperson with GM Experience
Description: Serra Saginaw Automotive is a proud member of the Serra Automotive Group. Currently, Serra Automotive Group consists of 37 stores selling and servicing 17 brands Cadillac, Chevrolet, Buick-GMC, Chrysler-Dodge-Jeep-Ram, (more...)
Company: Serra Saginaw
Location: Saginaw
Posted on: 05/21/2019

Freelance Job Promoter
Description: Mommy Jobs Online is now recruiting Freelance Job Promoters to work remotely. Great opportunity for the perfect person that has a home office setup to work remotely. At Mommy Jobs Online our qualified (more...)
Company: Mommy Jobs Online
Location: Saginaw
Posted on: 05/21/2019

Get New Installing/Repairing Window Work Today - Preview Leads In Your Area
Description: Over 25 million homeowners have trusted HomeAdvisor 1800Contractor to help them find quality professionals with the expertise to turn their home improvement
Company: HomeAdvisor
Location: East Lansing
Posted on: 05/21/2019


Special Procedure Radiographer
Description: We Are Hiring Special Procedure Radiographer - Interventional Radiology - PRN, Rotating - St Mary's of Michigan-MedCtr - Saginaw, MIWhy Join Ascension Based in Saginaw, St. Mary's of Michigan is a regional (more...)
Company: Ascension
Location: Saginaw
Posted on: 05/21/2019

Computer Programmer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze and build next-gen (more...)
Company: Revature
Location: East Lansing
Posted on: 05/21/2019

Want To Work At Home?
Description: Consumer driven national health benefits company is looking for consultants to specialize in marketing our
Company: Ameriplan
Location: Southfield
Posted on: 05/21/2019

Email Marketing Specialist
Description: At Mommy Jobs Online our qualified recruiters will enjoy the freedom and profitability of independent recruiting 1099 while benefiting from the tools, branding and support of a national recruiting work (more...)
Company: Mommy Jobs Online
Location: Southfield
Posted on: 05/21/2019

Email Marketing Specialist (Contract)
Description: We are now recruiting remote contractors to become an agent. To get started please complete our contractor
Company: Mommy Jobs Online
Location: Saginaw
Posted on: 05/21/2019

Data Entry Representatives
Description: This position is with Mommy Jobs Online, so please visit mommyjobsonline.com to apply and get registered on our site directly The data entry team will be taking member correspondence and making required (more...)
Company: Mommy Jobs Online
Location: Saginaw
Posted on: 05/21/2019

Physician: Anesthesiologist
Description: Job Title: Physician, Anesthesiologist The Highlights: - Competitive salary plus generous
Company: Relode
Location: Saginaw
Posted on: 05/21/2019

Log In or Create An Account

Get the latest Michigan jobs by following @recnetMI on Twitter!

Detroit RSS job feeds