*Hello Folks,*

*Kindly find the job descriptions and confirm me with your available
candidates on my email id*

bi...@techwiresol.com



*BI Tester (ETL QA)*

*6+ months*

*Houston, TX *



The ETL/ BI Test Engineer must have atleast 6 to 8 years of relevant work
experience and a minimum of 3+ years of experience in BI projects. The
selected ETL/ BI Test Engineer will be required to  create, review and
execute test cases that ensure data extraction, transformation, and
migration according to requirements and technical specifications. Validate
data is transformed correctly according to various business requirements
and rules and ensure that all projected data is loaded into the data
warehouse per requirements. Ensure ETL application appropriately rejects,
replaces with default values and reports invalid data.

 *Required Skills:*

·         Must have minimum 8 to 10 years of QA testing experience

·         Minimum 3-4 years of testing large scale data warehouse, ETL,
data conversion and/or data migration testing.

·         Minimum 3 years of experience in ETL & BI testing

·         Minimum 3 years writing complex SQLs, DB Design, Schema, Data
modeling

·         Minimum 2 years of experience in Unix environment and shell
scripting

·         Strong knowledge on ETL and BI processes

·         Work with project team in requirements gathering and analysis

·         Exposure to End-to-End data validation for ETL & BI systems

·         Strong in STLC process, Test Strategy/Plan, Test Estimation

·         Strong SQL skills and should be able to write SQL to compare and
reconcile source and target databases.

·         Writing, executing and debugging SQL queries to perform data
completeness, correctness, data transformation and data quality testing

·         Expertise in development of Test Scripts for
Extract-Transform-Load (ETL) Routines in the data warehousing environment.

·         Experience with Test Automation and Performance Tools.

·         Understand Business/Functional Requirement to Develop, Validate,
and Implement Test Plans and Test Cases

·         Experience in defect tracking and management using defect
tracking tools

·         Strong knowledge of system testing best practices and
methodologies

·         Strong data analysis, data verification, and problem-solving
abilities

·         Experience testing data for data marts, data warehouses or ETL
tools such as Informatica is a plus

·         Work with Business Analysts, Developers, ETL and Data warehouse
engineers to validate ETL scripts

·         Prepare / review test conditions, test cases and test scripts

·         Execute test cases / scripts

·         Log and track defects to closure

·         Excellent communication and client facing skills



Skills:

ETL BI Testing, Informatica, MicroStrategy, Test Plan, Test Estimation,
data validation, SQL, Queries, DB Design, Schema, Unix, shell scripting,
data warehouse, data conversion, data migration test



*Regards*



*BIJAY*



*Techwire Solutions, Inc*

101 Hudson St, Suite # 2100, Jersey City, NJ 07302 USA

Phone: 248-534-1630|| Email: bi...@techwiresol.com || Web:
www.techwiresol.com

-- 
You received this message because you are subscribed to the Google Groups 
"Oracle Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to oradev+unsubscr...@googlegroups.com.
To post to this group, send email to oradev@googlegroups.com.
Visit this group at http://groups.google.com/group/oradev.
For more options, visit https://groups.google.com/d/optout.

Reply via email to