自动回复: [android-developers] ETL QA Tester with Banking || San Ramon,CA/Tempe, AZ

['360401217' via Android Developers]

这是来自QQ邮箱自动回复邮件。
 
您好，您的邮件已收到，尽快给您回复。



-- 
You received this message because you are subscribed to the Google Groups "Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/android-developers/tencent_655720E3005F815B20CF2A44%40qq.com.

[android-developers] ETL QA Tester with Banking || San Ramon, CA/Tempe, AZ

[ST Global LLC]

*Position: ETL QA Tester*

*Location: San Ramon, CA/Tempe, AZ*

*Duration: Long-term*



*Banking exp is must to have*





   - Experience in writing complex *SQL*, *python*/shell Scripts to test
   data ingestion framework based on the data mapping & requirements provided
   and perform extensive data analysis to identify the defects.
   - Strong Data Analytics, *ETL,* *Data warehouse*, Data Virtualization,
   BI Dashboard concepts.
   - Experience in working with large scale Big data/Enterprise Data
   Warehouse, Data Integration, Data Migration and upgrade projects.
   - Experience in testing complex data systems, data ingestion pipeline
   through batch, real time/streaming framework.
   - Experience in building/updating automating frameworks using
   programming languages such as Python/Java/Shell or previous proven
   programming experience in any relevant scripting languages.
   - Testing data ingestion pipeline through batch, real time/streaming
   framework implemented using *Spark or NIFI.*
   - Testing different types dimension and FACT tables with in-depth data
   warehousing knowledge.
   - UNIX environment by writing HDFS and Shell commands for job execution,
   file validation, etc.,
   - Programming language (*Python or Shell scripts or Scala*) to
   understand data ingestion functionalities implemented using Spark and
   python scripts, analyze the log for failures.
   - Hive – understand the mapping/requirement document and write medium to
   complex level HiveQL for data validation between different tables, DDL &
   DML operations
   - Different file formats – validating data in different file formats
   (Json, xml, parquet, delimited, fixed width) with another file or
   Hive/HBase table using SparkSQL or python/shell scripts.
   - Test data setup in different file formats for positive and negative
   scenarios.
   - Integration testing of E2E data ingestion pipeline integrating
   different tools.



*Pankaj Kumar*

*ST Global LLC*

Fax: 206-319-4579

pan...@stglobaltech.com

www.stglobaltech.com



Note: We respect your Online Privacy. This is not an unsolicited mail.
Under Bills.1618 Title III passed by the 105th U.S. Congress this mail
cannot be considered Spam as long as we include Contact information and a
method to be removed from our mailing list. If you are not interested in
receiving our e-mails then please reply with a "REMOVE" in the subject line
at mention all the e-mail addresses to be removed with any e-mail
addresses, which might be diverting the e-mails to you. We are sorry for
the inconvenience.

-- 
You received this message because you are subscribed to the Google Groups 
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to android-developers+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/android-developers/CALTGpg8%3DZs6CBp1jdh939pp5%3D0cr%3DeOCmgfGsTahUoN1udqPzQ%40mail.gmail.com.

[android-developers] ETL QA Tester

[ratedr nikhil]

*ETL QA Tester*

With general guidance and coaching, participates in developing and 
executing test scenarios for 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. Utilizes 
appropriate testing tools and testing processes on projects and assists in 
building test environments.


 *Top Three Skills/Experience:*

5+ years’ experience in Quality Assurance testing with a focus in ETL 
(Extract, Transform, Load) Testing, within a Data Warehousing environment


*QA Testing experience must be in a manual testing environment*,


*not an automated testing environment that predominantly utilizes tools,*


such as SQL Developer, Toad for SQL execution.  The bulk of our testing 
work is performed by manually creating and executing testing cases and 
SQL.  Manual Test cases are stored in Jira using the Zephyr extension.

5+ years’ experience writing complex SQL queries

Ability to determine the types of testing that must be conducted (i.e., 
data validation, regression, etc.), including evaluating the testability of 
requirements, and create a comprehensive test plan that supports the 
business and technological solutions being delivered


*Required Skills/Experience:*

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

5+ years Oracle experience

5+ years SQL Server experience

3+ Years’ experience with Linux

Ability to convert requirements documents (Business Requirements, 
Functional and Technical Requirements) into test scenarios and test cases, 
including appropriate SQL scripts to execute the test cases.

Ability to evaluate the testability of requirements and reports to project 
team member's changes or additional information needed in requirements

Able to effectively communicate with application SMEs, project teams, and 
Data Management to ensure that the test case requirement analysis and 
coverage is appropriate.

Defect tracking experience (i.e. Jira, ClearQuest or HP Service Center)

Experience in tuning SQL queries, Stored Procedures, Views, etc for 
performance improvements

Proficiency with the following Informatica tools

   - PowerCenter
   - Workflow Manager
   - Workflow Monitor
   - PowerExchange

Knowledge of data models and entity relationship diagrams

Knowledge and experience in data masking methodologies

Familiar with Meta Data Management tools

 

*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 Skills/Experience:*

2+ years’ experience with business reporting tools e.g. Cognos

Prior experience with Healthcare domain (Claims, Enrollment, Billing) 
preferred:

Knowledge of following tools/applications are a plus:

Toad for Oracle

SQL Developer

SQL Server Enterprise Manager

Jira with Zephyr extension

Knowledge of IBM’s UDMH Data Models (preferred but not 
required)

Automation experience knowledge in Selenium / QTP

EDUCATIONAL REQUIREMENTS

Bachelor’s Degree in related field required.  Master's Degree in related 
field preferred

 


*Best Regards,*

*Nikhil*

*HQ Tech Solutions*

*Address:*   175, Capital Blvd, 4th floor, Rocky hill, CT, 06067.

*Desk :  *860-248-4740

*Email : * *nikhi...@hq-techsolutions.com ** │ 
Website :  **www.hq-techsolutions.com* 

*E-Verified Employer*

-- 
You received this message because you are subscribed to the Google Groups 
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to android-developers+unsubscr...@googlegroups.com.
To post to this group, send email to android-developers@googlegroups.com.
Visit this group at https://groups.google.com/group/android-developers.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/android-developers/187d5255-03f6-47a0-95bc-f15ec7cbb084%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.