EXL

Analyzes business data and runs outsourced operations

Assistant Manager

Manual & Functional QA +1Confirmed live in the last 24 hours

Full-timeGurugram, Haryana, IndiaNo salary listedIn-person

About the Job

Requirements

At least 5 years of business analysis experience and at least 2 years of Python, Power BI, and SQL experience.
Mandatory experience with Oracle and SQL Server.
Strong expertise in writing and optimizing SQL queries, subqueries, complex joins, and stored procedure validations using Oracle, SQL Server, PostgreSQL, or similar databases.
Understanding of data warehouse concepts, including fact and dimension tables and star and snowflake schemas.
Working exposure to testing data ingestion and curation pipelines.
Knowledge of data profiling, data quality checks, and root cause analysis.
Experience with test management tools such as Jira, Quality Center, Azure DevOps, or Rally.
Proficiency in Snowflake for program development, data transformation, and data testing.
Business analysis knowledge, Power BI data modeling, and SQL knowledge.
Exposure to Python for automation, data cleansing, and standardization.
Exposure to client-related requirement gathering.
Experience with business data modeling and Power BI or Tableau visualization.
Working exposure to Agile/Scrum methodologies.
Strong written and verbal communication skills.

Responsibilities

Develop and execute test cases for ETL processes.
Analyze ETL requirements and source-to-target mappings 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 such as Jira, ALM, or Bugzilla.
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.
Manage finance analysis reporting and provide solutions.
Maintain project and automation documentation and log trackers.
Use Snowflake to develop programs and perform data transformation and data testing.

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

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.

About the Company

EXL

Analyzes business data and runs outsourced operations

EXL analyzes business data and runs outsourced operations for insurers, healthcare payers, banks, retailers, and other large organizations. Its teams combine industry expertise with data engineering and AI to handle tasks such as claims processing, payment reviews, customer service, and finance within existing technology environments. The company also builds software, including LifePRO, which manages insurance policies, and EXLdata.ai, which connects fragmented data for use in AI systems. Clients pay for consulting projects, ongoing managed services, and software delivered through the cloud. EXL was founded in 1999 and is headquartered in New York City.

Company size: 10,001+
Company stage: IPO
Headquarters: New York City, New York
Founded: 1999

Recently Posted Jobs

Explore more opportunities at EXL

See more jobs