Data Tester (SQL) at DFCS Technologies · Remote, Chennai, Anywhere India · 1 - 5 years · ₹8L - ₹12L / yr · Remote friendly · Posted 21 Oct 2022

• Key Skillset: -
• Advanced SQL Skills and good Communication Skills are mandatory.
• Develop and execute detailed Data warehouse related functional, integration and regression test cases, and documentation
• Prioritize testing tasks based on goals and risks of projects and ensure testing milestones, activities and tasks are completed as scheduled.
• Develop and Design Datawarehouse testcases, scenarios, and scripts to ensure quality Data warehouse /BI applications.
• Report the status of test planning, defects and execution activities, including regular status updates to the project team.
• Hands on Experience on any SQL Too

Similar jobs (2)
Role Overview
We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.
Key Responsibilities
- Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
- Build and maintain data models to support business processes, reporting needs, and integration workflows.
- Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
- Work closely with cross-functional teams to gather data requirements and understand business logic.
- Develop and execute integration test plans, including functional, data validation, and regression testing.
- Support data migration activities, including extraction, transformation, and loading (ETL).
- Monitor and troubleshoot integration issues, ensuring timely resolution.
- Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
- Ensure integration security, data integrity, and compliance with organizational standards.
Required Skills & Qualifications
- 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
- Hands-on experience with data mapping, data modelling, and database schema design.
- Proficiency in SQL (complex joins, stored procedures, performance tuning).
- Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
- Strong analytical and problem-solving skills.
- Experience with API-based integrations (REST/SOAP) is a plus.
- Familiarity with testing methodologies for integrations and data validation.
- Ability to work with business users, understand workflows, and translate requirements into technical solutions.
Preferred Qualifications
- Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
- Knowledge of JSON, XML, CSV transformation.
- Exposure to scripting languages (Python, Shell).
- Experience in Agile/Scrum environments.
- Prior involvement in ERP implementation or upgrade projects.
Competencies
- Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
- Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
- Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
- Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.
Why Join Us?
- Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
- Work on impactful projects that make a difference across industries.
- Opportunities for professional growth and continuous learning.
- Competitive salary and benefits package.
Application Details
Ready to make an impact? Apply today and become part of the QX Impact team!
Position title: Business Intelligence and Data Analyst
Summary -
• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.
• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.
• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.
Responsibilities:
• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.
• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.
• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.
• Design and maintain relational data models and data warehouse structures for CARS BI.
• Integrate data from ERP and other enterprise systems into the BI backend.
• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.
• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.
• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.
• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.
• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.
Education and Experience:
Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.
Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.
Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.
Competencies:
• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)
• Database, data modeling and SQL (preferred Oracle PLSQL)
• Good analytical and communication skills
• Teamplayer
• English
• Strong hands-on experience with SQL (advanced level)
• Solid understanding of relational databases and data warehouse concepts
• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)
• Performance tuning and query optimization skills
• Structured, detail-oriented, and quality-focused working style
• Good understanding of enterprise data flows (SAP/CARS is a plus)
Key Interfaces and Stakeholders:
Only internal customers with different topics: e.g. SCM, Sales etc.
Geography to cover and Travel requirements:
Asian Time Zone, Sometimes travel is required
Behavioral Characteristics
Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.
Interview process
2 rounds - Virtual interview and 1 round Face to Face
Any other Criteria
- Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
- Gender: Female and Male; Female preferred
- Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology,








