All open jobs
EXL

Assistant Manager

Gurugram, Haryana, India · hybrid
Company's own board5+ yrs

Posted 12d ago · First seen Oct 24 · seen live today · from EXL's own Oracle Cloud board

Skills mentioned

pythonsqlpostgresqlazuredevops

The posting, as published

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

Similar open roles