Assistant Manager

Overview

EXLexlservice.comPosted 2 weeks ago

Gurugram, Haryana, INOn-site

About the role

Develop and execute test cases for ETL Processes
Proficient in Snowflake by developing programs, data transformation and Data testing.
Business Analysis understanding with Power BI Data modelling and SQL knowledge.
Exposure on Python for Automation and Data cleansing & standardization.
Analyze ETL requirements and source-to-target mappings (STTM) to design comprehensive test scenarios and test cases
Write and run complex SQL queries for data validation across different environments.
Log and track defects using tools like Jira, ALM, Bugzilla etc.
Create automated test scripts using Python
Validate data quality, data profiling, and data cleansing processes across source and target systems.
Review and validate source-to-target data mappings and transformation logic.
Good Communication and exposure with client related requirement gathering.
Finance Analysis reporting management & quicker solutions providing attitude.
Project and Automation Documentation and Log tracker management skills.
Business Data modelling and Power BI/Tableau Visualization Experience.

5+ years of Business analysis experience with a minimum of 2+ years of python, power bi and SQL.
Mandatory Oracle & SQL Server
Strong expertise in writing and optimizing SQL queries, sub queries and complex joins & stored procedures validations. (Oracle, SQL Server, PostgreSQL, etc.).
Understanding data warehouse concepts (fact/dimension tables, star/snowflake schema).
Working exposure to test the data ingestion/curation pipelines.
Knowledge of data profiling, data quality checks, and root cause analysis
Experience with test management tools (JIRA, Quality Center, Azure DevOps, Rally etc.,).
Proficient in analyzing data issues and tracing root causes.
Working exposure with agile/scrum methodologies.
Outstanding written and verbal communication skills