Senior BI Developer

Role: Senior developer working on BI project which involves OAC RPD design, Data warehousing, Data modelling, Reports/dashboard development and to work in global teams and support global cross-functional environment partnering with internal customers to help, support and enhance business systems
Qualifications & Certifications
Engineering Graduate or Master of Computer Applications (MCA)
Certified in one or more of the following is an advantage – OAC, OAC, Oracle Apex

Experience
6-8 years of BI experience
5+ years of experience on ETL testing involving Informatica and reporting tools like OBI, OAC & SQL
Must have worked on at least 2 complete life cycle implementations of BI projects

Required Skills (Must have) along with necessary industry experience
General
Data & BI Testing (SQL, Python, Automation):
Strong experience in testing data warehouses, BI reports, dashboards, and analytics pipelines across multiple layers.
Expert-level hands-on experience in SQL for data validation, reconciliation, root cause analysis, and performance assessment.
Strong working experience in Python for building reusable data validation and test automation frameworks.
Own end-to-end testing for data pipelines, reports, and BI products, including functional, regression, and data quality testing.
Define and enforce data quality standards, validation rules, and control checks across platforms.
Proactively identify data issues, quality gaps, and design risks early in the development lifecycle.
Drive improvements in testing efficiency, coverage, and reliability through automation.

Functional
Strong exposure to HCM domain, People Analytics, ERP, or large-scale data warehouse environments (preferred).
Ability to independently gather requirements and translate business expectations into comprehensive test strategies.
Lead test planning, effort estimation, and dependency analysis for complex BI and data initiatives.
Act as a key testing SPOC for cross-functional teams including Data Engineering, BI, Product, and Business stakeholders.
Challenge requirements constructively from a data quality, testability, and business relevance standpoint.
Own BAU testing operations and support critical releases with minimal supervision.
Review and validate change requests, assessing downstream impact on data, reports, and automation suites.
Maintain strong documentation for test scenarios, automation coverage, and defect analysis.


Technical
Advanced expertise in SQL, including complex joins, CTEs, window functions, aggregations, and performance tuning.
Strong hands-on experience in Python-based test automation, using libraries such as pandas, pytest, or custom frameworks.
Proven experience in designing and maintaining automated data testing frameworks for ETL / ELT pipelines and BI layers.
Deep understanding of ETL / ELT architectures, data pipelines, and orchestration workflows.
Strong knowledge of data modelling concepts (STAR, SNOWFLAKE) and how they impact testing strategy.
Experience validating data across source → staging → warehouse → semantic / reporting layers.
Ability to independently debug complex data issues and work with engineering teams on resolution.
Experience in performance testing and data volume validation for BI reports and dashboards.
Familiarity with CI/CD pipelines for data and test automation execution.
Strong understanding of test design principles, defect lifecycle management, and root cause analysis.
Experience working in Agile / sprint-based delivery models, with ownership of test readiness and release sign-off.



Additional Expectations
Automation-first mindset; manual testing should be exception-based, not the default.
Ability to mentor junior testers and guide best practices in data testing and automation.
Strong communication skills to articulate data issues, risks, and quality concerns to technical and business audiences.
Ownership mindset with focus on long-term quality, scalability, and reliability of analytics platforms.

Requirements