Assistant Manager

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