About QualiZeal:QualiZeal is North America's Fastest-growing Independent Digital Quality Engineering Services company with a global headcount of 800+ Software Quality and Development Engineers. Trusted by 40+ global enterprises, QualiZeal has delivered over 200 successful projects—in the areas of Quality Engineering, Digital Engineering, Advisory and Transformation, and Emerging Technology Testing—earning an industry-leading client NPS score of 85. Founded on principles of delivery excellence, service orientation and customer delight, we are a fast-paced, culture-driven organization on a high-growth trajectory.Recognitions:· Great Place to Work Certified (2023,2024)· Major Contender in Quality Engineering by Everest Group (2023)· Economic Times Excellence Award (2023)· The Global Choice Award (2022)· NASSCOM Member· ISO 13485:2016 and ISO 9001:2015· Glassdoor Rating: 4.7Position :Data ArchitectLocation: Hyderabad, IndiaJob Type: Full TimeRole & responsibilities:- Design, develop, test, deploy and troubleshoot SQL scripts, Stored Procedures that implement complex ETL processes. - Must have experience in Query Optimization. - Must be able to understand complex business logic, fine tune long-running queries - Must be expert at reverse engineering and extracting business requirements and rules from the code. - Scheduling and monitoring the ETL jobs using SSIS. - Build and review functional and business specifications - Expert understanding of PostgreSQL, Stored Procedures, Views, and Functions. - Provide the estimates for the ETL work - Database/Data Warehouse performance tuning, monitoring and troubleshooting expertise. - Expertise in query construction, including writing and optimizing complex SQL queries that contain sub queries, joins, and derived tables - Troubleshooting and fixing the code - Unit testing the code and documentation of results - Must be expert at providing non-functional requirements. - Help creating test data and provide support to QA process. - Work with gate keeper on promoting the data stage jobs from QA to Production. - Build, patch and data fix in production environment. - Ensure very high availability to scale of 99.999%. - Establish coding practices, best practices, and SoPs. Participate in code reviews and enforce relevant process. - Strong analytical and thinking capabilities, good communication skills to conduct requirement gathering sessions/interview customers - Ability to perform independent research to understand the product requirements and customer needs - Communicates effectively with the project teams and other stakeholders. Translate technical details to non-technical audience. - Expert at creating architectural artifacts for Data Warehouse. - Team, effort management. - Ability to set expectations for the client and the team. Ensure all deliverables are delivered in time at highest quality.Technical Skills:- ETL-SSIS - SQL - Stored Procedure, Functions, Triggers etc - Query Optimization - Server monitoring - ETL:-AWS-Glue - DBMS:-AWS Aurora MySQL, AWS Redshift, PostgreSQL - Cloud Services:-AWS cloud services, including EC2, RDS, S3, and IAM. - Data Skills:- SQL Performance tuning. - Coding:- knowledge of programming language like C#, Python or Java. To oversee dev resources. - Team and people management. - Agile scrum practices - Great learning attitude - Eagerness to take ownership - A global mindset - Excellent communication skills.
Job Title
Data Architect