- 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.

Responsibilities

- 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.
- Valuable 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.

Qualifications

- 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

📌 Assistant Manager (Gurugram)
🏢 EXL
📍 Gurugram