23 Oct
|
Indus Infotech
|
Karnataka
23 Oct
Indus Infotech
Karnataka
Custom Software Engineer.
Exp : 5 (Min) - 10 (Max)
Location: Bangalore, Chennai, Coimbatore, Hyderabad
Job Type: Contract
Duration: 6 Months
Work Type: Onsite
Position: Custom Software Engineer
Location: Chennai/ Coimbatore/ Hyderabad/Bangalore
Job Type: Contract
Duration: 6 Months
Work Type: Onsite
Job Description:
- The Senior Business Analyst is responsible for ensuring the accuracy, integrity, and quality of enterprise data assets and reporting solutions.
- This role serves as a bridge between business stakeholders and technical teams, translating business requirements into validation strategies, data quality controls, and testing plans.
- The ideal candidate possesses strong SQL and programming skills, experience validating large-scale datasets, and the ability to perform comprehensive source-to-target reconciliation across legacy and modernized data platforms.
Key Responsibilities:
Business Analysis & Requirements Management
- Collaborate with business stakeholders to gather, document, and validate business and reporting requirements.
- Translate business requirements into detailed functional specifications, data mapping documents, and test scenarios.
- Facilitate discussions between business, analytics, and technology teams to ensure alignment on data definitions and reporting metrics.
- Analyze existing business processes and identify opportunities to improve data quality and reporting accuracy.
Data Quality & Validation
- Design and execute data validation and reconciliation strategies for reporting, analytics, and data migration initiatives.
- Compare large-volume datasets between source and target systems to verify completeness and accuracy.
- Perform source-to-target data validation, identifying and resolving data inconsistencies.
- Develop data quality rules, controls, and monitoring processes.
- Investigate data anomalies and partner with technical teams to determine root causes and corrective actions.
Testing & Quality Assurance
- Create and execute detailed test plans, test cases, and validation scripts.
- Lead User Acceptance Testing (UAT), System Integration Testing (SIT), and regression testing activities.
- Validate business logic, calculations, and transformation rules across multiple systems.
- Ensure reporting solutions meet business requirements and data quality standards before deployment.
SQL & Technical Analysis
- Utilize advanced SQL techniques to analyze, profile, and validate large datasets.
- Write complex queries to compare record counts, identify variances, and validate business rules.
- Develop automated validation scripts and reconciliation processes.
- Support data profiling, impact analysis, and root cause investigations.
- Work with structured and unstructured data across multiple platforms.
Data Migration & Modernization Support
- Support data warehouse, cloud migration, and reporting modernization initiatives.
- Validate migrated datasets and ensure parity between legacy and target platforms.
- Collaborate with development teams to verify code conversions and transformation logic.
- Document validation results, findings, and remediation recommendations.
Required Qualifications
- Bachelor's degree in Business, Information Systems, Computer Science, Data Analytics, Statistics, or related field.
- 5+ years of experience in Business Analysis, Data Quality, Data Validation, Testing, or Data Analytics roles.
- Strong SQL development skills with the ability to write complex queries for data analysis, reconciliation, testing, and validation.
- Hands-on experience with Databricks for data analysis, data validation, and support of modern cloud-based data platforms.
- Proven experience validating large-scale datasets and performing source-to-target reconciliation across multiple systems.
- Experience creating and executing test plans, test cases, validation scripts, and quality assurance processes.
- Strong understanding of data warehousing, ETL processes, data transformation logic, and data lineage.
- Experience identifying, investigating, and resolving data quality issues through detailed root cause analysis.
- Strong analytical, problem-solving, and communication skills.
- Ability to translate business requirements into data validation and testing strategies.Preferred Qualifications
- Programming experience in Python, SAS, or other analytical languages.
- Experience with Spark SQL, PySpark, or Databricks development environments.
- Experience validating data migrations from legacy data platforms to modern cloud-based architectures.
- Experience with Power BI, Tableau, or other business intelligence platforms.
- Familiarity with Agile delivery methodologies and SDLC processes.
- Experience working in healthcare, insurance, financial, or other large enterprise environments.
Technical Skills:
- Advanced SQL Development and Query Optimization
- Databricks Data Validation and Data Analysis
- Data Quality Assessment and Monitoring
- Large-Scale Data Reconciliation and Dataset Comparison
- Source-to-Target Validation
- Test Planning, Test Execution, and UAT Support
- ETL and Data Transformation Validation
- Root Cause Analysis and Defect Resolution
- Python/SAS Programming
- Spark SQL and PySpark (Preferred)
- Data Warehousing and Dimensional Modeling
- Business Requirements Analysis and Documentation
Position Summary
- The Senior Business Analyst Data Quality & Validation serves as a key partner between business and technology teams, ensuring the accuracy, integrity, and reliability of enterprise data assets and reporting solutions.
- This role requires advanced SQL skills, hands-on Databricks experience, strong testing and validation expertise, and the ability to compare and reconcile large-volume datasets across legacy and modern platforms.
- Programming experience with Python or SAS is preferred, while experience with Spark SQL and PySpark is considered a solid plus.
- The individual will play a critical role in data modernization initiatives, ensuring that migrated and transformed data meets business requirements, quality standards, and governance expectations.
- Shift B Support: Availability to provide support until 11 AM PST.
- Return to Office: Mandatory 5-day RTO from 4 strategic office locations. (Chennai, Coimbatore, Hyderabad and Bangalore).
Skills:
- SQL
- Databricks
- Data Validation & Reconciliation
- Testing (UAT/SIT/QA)
- Data Quality Management
- Data Warehousing & ETL
- Business Analysis
- Python/SAS
- Spark SQL / PySpark
- Power BI / Tableau
📌 Custom Software Engineer (Karnataka)
🏢 Indus Infotech
📍 Karnataka