:

KEY RESPONSIBILITIES

● Create SQL transformation queries to clean large and complex historical data based on business requirements

● Prepare DUR report to chart out complete understanding of the existing data and results of the sanity and hygiene check conducted

● Perform data profiling and data quality assessment to create DQR reports to support data migration and analytics activities

● Maintain detailed documentation on activities performed to drive data accuracy and sanctity for each client

● Create and upload import ready file into data warehouse once DQR is approved by the client

● Perform standard checks to validate data accuracy / data loss between pre and post import stage

● Upload the delta data and perform an incremental data check to assess the system integrity post implementation

● Stay abreast of new technologies and suggest best practices to build reusable, scalable ETL modules and automation of data

● Prepare reports on data risk mitigation and escalate any data risks identified in the process

EXPERTISE AND QUALIFICATIONS

CREDENTIALS REQUIRED

● 2-3 years of relevant work experience in a ETL/DB management

● Advanced SQL skills(Optimize complex SQL queries) and experience in joining/cleansing datasets from multiple sources

● Should have knowledge on export and import of Database objects from one database to another database





● Proficiency in Microsoft Excel and Python-Statistical Programming

● Data Visualization.

● Presentation Skills

● Ability to work in high-pressure situations

● Ability to escalate problems for any support needed for problem resolution

● Ability to organize and prioritize tasks and meet deadlines

● Positive analytical and problem-solving skills

● Good oral and written communication skills, analytical skills and a highly professional attitude are essential

● German language skills (at least, B1) are mandatory. Must be comfortable conversing and managing business conversations in German

I t has been brought to our attention that there have recently been instances of fraudulent job offers, purporting to be from Capillary Technologies. The individuals or organizations sending these false employment offers may pose as a Capillary Technologies recruiter or representative and request personal information, purchasing of equipment or funds to further the recruitment process or offer paid training. Be advised that Capillary Technologies does not extend unsolicited employment offers.

Furthermore, Capillary Technologies does not charge prospective employees with fees or make requests for funding as a part of the recruitment process.We commit to an inclusive recruitment process and equality of opportunity for all our job applicants.

📌 Data Analyst _ German Speaking (Bengaluru)
🏢 Capillary Technologies
📍 Bengaluru