• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 23rd Mar 2023

This role will be hands-on position primarily focusing on understanding ETL test requirements and performing all facets of data testing. Create and execute test plans & scripts that will validate the projects data quality and data integrity as the data is transitioned through the ETL data warehouse process. Create test data to exercise data validations and test the compliance of information flows and data stores against data quality standards

Skill/Experience Requirements

Experience in Data Testing, Data Conversion, Data Migration, Data Transformations, Data Profiling, Data Analysis and Data Quality Validation

Experience in testing of ETL Mappings to extract data from multiple sources like Oracle, SQL Server, Flat files etc. into target tables using transformations.

Hands on experience in design and implementation of E2E Data testing strategies and developing data testing automation frameworks.

Work on End-to-End product feature testing and Business Report Testing. Designing, testing, and troubleshooting data and reports.

Knowledge of any of database systems like SQL Server, Oracle or db2 etc and experience writing complex queries and creating stored procedures

Good understanding or knowledge in Azure Cloud, ADF.

Good exposure to Python, Pyspark, Databricks notebook.

Interact with project teams, development, operations, and infrastructure resources to recommend solutions to remediate data issues.

Experience in defect life cycle management - logging, replication, triaging, verification, closing, metrics reporting, etc.

Demonstrated ability to acquire high volumes of test data required to support Test execution.

Good understanding of Agile methodology.

Experience in test environment and test data management

Strong communication and collaboration skills to challenge the norm

Key Responsibilities

Effectively work in a fast paced environment utilizing the Agile methodology

Develop and maintain functional automation test scripts utilizing modular frameworks and best practices

Execute test scripts to validate correct functionality of application

Perform various types of testing including smoke, white box, black box, integration, end-to-end, regression, and system testing as needed

Participate in requirement & design review sessions; evaluate requirements & design docs from a quality test automation standpoint

Manage test coverage based on risk analysis

Document defects and evaluate priority of defect based on overall application functionality

Coordinate test script reviews with stakeholders as appropriate.

Adhere to requirement review, defect writing & test script writing guidelines

Ensure completion of all deliverables within schedule, budget and quality constraints.

Participate in Root Cause Analysis sessions

Ensure that projects follow prescribed software development life cycle standards.

Develop and maintain good relationships with project team.

Identify obstacles and roadblocks; and offer suggestions to work around obstacles

Help drive and improve QA process within the team you are assigned

Required

5+ years of software product development and delivery experience.

4+ years of ETL testing/SQL experience.

3+ years of Informatica Power Center, IDQ experience.

3+ years’ experience overseeing the development of data test plans, test scenarios, test cases, execution of test case and documentation of test results

2+ years of experience in some of the Azure Cloud tools: ADF, Pyspark, databricks notebooks

Experience with Python and libraries like Panads, Numpy & Matplotlib.

Preferred

Ability to interpret and draw System & Architecture diagrams.

Experience in summarizing large number of metrics into meaningful graphs and reports.

Familiar with Latest Cloud Technologies.