Job Description

Location: Bangalore/Hyderabad/Gurgaon/Chennai/Coimbatore/Mumbai About Annalect India We are an integral part of Annalect Global and Omnicom Group, the second largest advertising agency holding company in the world in terms of revenue and is the leading global marketing communications company. Our portfolio includes: three global advertising agency networks: BBDO, DDB and TBWA; three of the world\'s premium media services under Omnicom Media Group: OMD, PHD and Hearts & Science. Annalect India plays a key role for our group companies and global agencies by providing stellar products and services in areas of Creative Services, Technology, Marketing Science (data & analytics) and Media Services. We currently have 2000+ awesome colleagues (in Annalect India) who are committed to solve our clients\' pressing business issues. We are growing rapidly and looking for talented professionals like you to be part of this journey. Let us build this, together! Roles and Responsibilities Work closely with Data Analyst, Architects to achieve DQ objectives Validating data pipelines and ensuring the quality of datasets Collaborate with the Data Delivery technology teams and architects to define and develop solutions Gather business requirements for the building of the Data Quality Dashboard that will include the full set of functionalities from exception identification to remediation Formulate and actively develop test cases, test scripts, and output report specifications for data remediation projects Maintain up-to-date documentation for the Data quality audits and processes Manage and provide data quality control. Create and manage functional test cases Able to integrate data QA automation in local places. Should be able to research for new tools and technologies for project. Troubleshooting skills to optimize performance. Required Skills 5+ Years of Experience in Data Test Automation, Data Comparison and Validation. Must have experience in ETL/ELT tools and pipeline - ETL Testing Working experience with Python libraries such as Pandas, NumPy, and SQL Alchemy for ETL Strong understanding of Data Warehouse/Data Lake Architecture and Development Experience with relational SQL and NoSQL databases Good knowledge of SQL, DB Procedures, Packages, and Functions. Experience with data pipeline and workflow management tools Experience working with relational databases Experience in SQL injection, and query performance (Athena). Must have CI/CD knowledge Knowledge of best practices in data analysis Excellent interpersonal and communication skills.

foundit