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.7

Position :Data Architect

Location: Hyderabad, India

Job Type: Full Time

Role & 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.