Senior ETL developer/ Data modeler, Dallas TX

Job Title: Senior ETL developer/ Data modeler

Location: Dallas, TX 

Client: Frontier

Duration: 6 Months

Job Description:

Responsible for modeling and mapping data fields from legacy systems to target systems. Working with the legacy teams and the business in helping define and develop business rules, value maps, Source to Target Data Mapping documents and assisting ETL Development Team in development activities. Excellent Verbal and Written Communication Skills. Must be able to have strong problem resolution mentality with a proven ability to be self-motivated. Must be able to work in fast paced environment.

Education: BS degree in a technical discipline desired. CC&B: specializing in Customer Care (Retail, Business, and CLEC) Products, Promotions. Knowledge of Retail (residential) Products, Services & Equipment (S&E’s), and USOC’s preferred.

Experience with Data Profiling using SQL and other methods. Solid understand of data analysis techniques or processes. , DB2, Oracle, UNIX and AS/400 knowledge - preferred. Informatics, Talend or other ETL tool experience - preferred. Expert level SQL programmer. DB2 experience and Work on Oracle SQL Queries, Stored Procedure, Oracle Data dumps, Reporting.

Well versed in Excel and XML including XSL.

5-10 years of Telecom experience and large scale data conversions.

5-10 years of business analysis in mapping data, tracing business/data dependencies, making decisions,

5+ years expertise in PL/SQL queries/programming and Oracle/DB2 database.

AS400 Experience strongly desired

We have a very good relationship with the Hiring Manager and for the right candidate we can arrange an interview within a few days.

Look forward to connecting with you.

Thanks & Regards

Aravind

COMPQSOFT, Inc.

HUB Zone, SDB, MBE Certified

An ISO 9001:2008 & ISO 27001:2005 Certified

Phone: 281-978-4434  І  Fax: 281-657-6717

Email: aravind.k@compqsoft.com

Information Developer, Olympia, WA

Title: Information Developer

Location: Olympia, WA

Duration: 3 Months

Client : HP

Description:

Work Location: Lacey, WA is the preferred location; will consider Vancouver, WA for right candidate.

Work On boarding can occur in either Lacey or Vancouver.

Job Level Definitions:

Identification and construction of test scenarios, generation of inbound files and generation of expected results. The comparison of expected results will be using SQL. The organization of test cases and its associated will be through VSTS –TFS. Tester should have ability to apply intermediate level of subject matter knowledge to solve a variety of common business issues. Exercises independent judgment within defined practices and procedures to determine appropriate action. Acts as an informed team member providing analysis of information and limited project direction input. Participates as a member of a Testing Team. Designs testing scenarios and test cases that will demonstrate conformance to all functional and non-functional requirements, relative to the test level, as defined in business or technical specifications. Executes tasks related to test cases and test data. Analyzes the results of the testing process and recommends solutions. Interacts with the project team to gain an understanding of the business environment, technical context, and conformance criteria.

Required Qualifications: Must Have All Of These Skills To Be Considered

• Experience of at least 2-3 years in testing including test case creation, execution and validation of results

• At least 2 plus years of hands on experience in writing SQL Queries

• Ability to write complex SQL scripts for repeatability

• Exposure to batch processing

• Experience in testing stored procedures and databases

• Excellent verbal communications and teaming skills

• Experience in data analysis and Database Testing

Optional Skills:

Test Automation experience

Experience of technically leading teams is a big plus

Responsibilities:

• Understand business requirements and develop test cases

• Build, customize and configure SQL Queries for execution and verification of results for   various Data Archive test efforts.

• Execute and test the data related functional scenarios for a test effort.

• Work with build teams to run jobs within the Test environment

• Work with development, Business, and QA teams to determine Data testing approach and   maintenance

Thanks & Regards

Tabrez

COMPQSOFT, Inc.

HUB Zone, SDB, MBE Certified

An ISO 9001:2008 & ISO 27001:2005 Certified

Phone: 281-657-6726  І  Fax: 281-657-6717

Email: stabrez@compqsoft.com