ETL Analyst

Responsibilities:

• 5+ Years of Software Quality Assurance experience on enterprise level applications which includes Data Warehouse Testing.
• Experience in 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.
• Should have experience testing multiple test phases in medium to large projects.
• Understanding of information governance principles and how they could apply in a testing capacity.
• Should have adequate experience and clear understanding of data warehouse and data mart testing.
• Identification and Test Data Preparation Techniques.
• Ability to transform complex Business logic into SQL or PL/SQL queries.
• Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc.
• Creating requirements traceability matrix (RTM).
• Proficiency with Test Case Preparation and Execution.
• QA Automation Test tools expertise using Python.
• Extensive exposure to ETL testing with high-level of SQL skills is required.
• Experience with Cloud Snowflake and AWS(S3) including Postgres DB, SQL Database, Hadoop Data Lake, and Mongo DB.
• Must have experience in using ETL Tool informatica Power Center & BDM.
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores).
• Experience with data integration, data cleansing, and data analytics.
• Experience with data modeling and design principles for data marts and data warehouses.
• Excellent problem solving and analytical skills, able to handle challenging situations and act appropriately.
• Excellent learning skills must learn and guide other team members on their knowledge.
• Should be a self-starter; takes responsibility and ownership and is self-driven.
• Ability to work independently with minimal supervision as well as ability to work within a team.
• Good team player; commitment to high-quality output and service.

Skills:

• Digital : Adobe Analytics, Analytics

Qualifications:

• Experience (Years): 4-6

Benefits:

• 💻 QA Automation Test tools expertise using Python
• 📊 Extensive exposure to ETL testing with high-level of SQL skills
• 🛠 Experience with Cloud Snowflake and AWS(S3)
• 📈 Experience with data modeling and design principles

Application:

• Apply on ZipRecruiter
• Apply on LinkedIn