Senior Etl Tester/Data Qa Analyst

Skills and Experience Required:

• Hands on experience with testing in ETL and Data warehouse.
• Strong experience in data warehouse concepts and Snowflake or similar databases.
• Good experience in data analysis, data profiling, preparing test data, etc.,
• Review and analyze functional and design specifications documents
• Understand the data model used in global data MDM and solutions.
• Understand the concepts and attributes of the data and manage the data dictionary of the tables.
• Identify test requirements from design document and mapping documents
• Involve in test planning, prepare test plan, develop test cases/scripts, creating and manage test data, test execution and defect management.
• Validate quality of data and steer data quality improvement action plans.
• Ensure and assess data quality on organization data, building KPIs (incident management, completeness of data, etc.) and setting up and automate consistency checks Identify root causes of potential malfunctions and allocate actions to the right stakeholders.
• Strong SQL skills and strong experience in testing SQL reports, paginated reports, etc.,
• Experience with RSBMS, SQL Server, SAP HANA 4
• Experience with data models, database design development, data mining, and segmentation techniques
• Experience on an Agile delivery team
• Experience with Jira and Confluence collaboration tools
• Experience on Business Intelligence programs
• Partner with team on data and BI business/data analyst efforts to collaborate with key partners gathering requirements and assist with User Acceptance Testing.
• Ability to work under stress, handle multiple concurrent and contending tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness
• Ability to prioritize work, meet goals, and stay on task when completing special projects and daily assignments

Minimum Qualification:

• Bachelor's Degree in computer science, information systems, business administration or other industry related curriculum) or combination of education and equivalent experience
• 5 to 7 years of experience in testing ETL, Data, BI, and reporting applications
• 5 to 7 years of experience in reporting/data visualization tools Tableau, and Business Objects
• 5 to 7 years of experience in SQL with ability to write complex SQL scripts in relational databases irrespective of cloud or on-prem
• 5 to 7 years of working in agile team is must
• 3 to 5 years of experience in Informatica MDM, Master Data Integration etc.

Tools:

• SQL, Excel Data Analysis, MS Office, JIRA, QTest, API testing, Soap UI, postman.
• ETL Automation tool: such as ICEDQ, TOSCA DI, IDQ and Informatica is plus.

Required Skills : Test Plans/Cases/Scripts,ETL,Data Warehouse,SQL
Additional Skills : QA / Tester,Data Warehouse Engineer,Database Developer