Job Details

ID #19998980
State New York
City Nyc
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Marlabs, Inc
Showed 2021-09-21
Date 2021-09-20
Deadline 2021-11-18
Category Et cetera
Create resume

ETL Tester

New York, Nyc, 10001 Nyc USA

Vacancy expired!

please send resumes to latha.menon(AT)marlabs.comThis position requires a strong engineer with extensive experience in Testing of complex Data-warehouse, Reports and AWS Cloud eco systems. This position also required existing experience in working with multiple teams and manage offshore team (size 5 to 7). This resource should capable of working on his\her deliverables as well manage offshore team.

Duties and Responsibilities:
  • Review project deliverables (for example, Business Requirements, Functional Requirements, Technical Designs) as they relate to a given test stage.
  • Manage offshore team (provide guidance, task assignment and communicate project updates to offshore)
  • Review offshore deliverables and communicate to delivery team.
  • Review and provide input to test deliverables.
  • Define test plan / strategy and identify risks related to testing efforts.
  • Create test cases based on requirement & technical design specifications for data validation.
  • Understand ETL logic & write complex SQL queries for data and Report Validation
  • Understand Cognos Report logic and develop SQL queries for report data quality validation
  • Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
  • Ensure issues are identified, tracked, reported on and resolved in a timely manner
  • Works across various groups & effectively drive testing of cross-team solutions that have complex dependencies and requirements.
  • Inform the Project Test Lead of issues that may affect the schedule, budget, or quality of the solution or the testing process.

Supervisory Responsibilities:
  • None

Minimum Qualifications:
  • Bachelor’s Degree in Information Technology or related field, or equivalent work experience
  • 5 to 8 years’ experience in QA analyst roles in BI (Data warehouse & Report) environments

Requirements and General Skills:
  • Good public speaking and presentation skills.
  • Interpersonal skills and ability to interact and work with staff at all levels.
  • Excellent written and verbal communication skills.
  • Ability to work independently and in a team environment.
  • Ability to pay attention to details and be organized.
  • Ability to project professionalism over the phone and in person.
  • Ability to handle multiple tasks in a fast-paced environment.
  • Commitment to “internal client” and customer service principles.
  • Willingness to take initiative and to follow through on projects.
  • Creative writing ability.
  • Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment.
  • Must have legal right to work in the U.S.

Technical Skills:
  • Background with traditional databases such as Oracle, Teradata, SQL Server, ETL tools / processes and data warehousing architectures.
  • Experience in AWS eco systems (S3, Redshift, Aurora, etc.)
  • Experience in using tools such as Informatica, job scheduling and Unix scripting
  • Extensive testing experience in Data warehouse, DataMart, Stored procedure, ETL jobs, Report ,Cube
  • Experience in Test data management
  • Strong knowledge of data structures, algorithms, enterprise systems, and asynchronous architectures.
  • Experience with raw, unstructured data.
  • Strong quantitative,

    data tabulation and analytic skills.
  • Ability to investigate discrepancies in data by writing queries and comparative analysis.
  • Ability to develop and use test plans, test cases, test scripts, test results
  • Experience using technical documents such as business requirements, functional requirements, database design representations, data and systems flow diagrams.
  • Streaming data validation experience is plus

Vacancy expired!

Subscribe Report job