{bc}
Apply
oracle

Assistant Manager

exl Service.com (India) Private Limited
Gurugram, IND
Full-time
Manager · 5+ years experience
Hybrid
Discovered 1 weeks ago
azurejirapostgresqlpower-bipythonsnowflake

Full Job Posting

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

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

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at exl Service.com (India) Private Limited

Manager

, IND

Discovered TodayFull-time

Senior Executive - Coding Auditor

Chennai, IND

Discovered TodayFull-time

Senior Architect - Solutioning-Application Development-Applications Development Engineering

Noida, IND

Discovered TodayFull-time

Business Analyst

Gurugram, IND

Discovered TodayFull-time

Assistant Manager

Gurugram, IND

Discovered TodayFull-time

Manager

Gurugram, IND

Discovered TodayFull-time

Assistant Manager

Pune, IND

Discovered TodayFull-time

Senior Associate

Bengaluru, IND

Discovered TodayFull-time