Data Architect

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

**Qualifications and Experience**:
**Years Of Experience**: 10+ years

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

**ABOUT QUALIZEAL**:

- QualiZeal is North America’s fastest-growing independent digital quality engineering services company.With a diverse portfolio of digital transformation services encompassing Quality Engineering, Digital Engineering, Advisory and Transformation, and Emerging Technology Testing, QualiZeal empowers organizations of all sizes globally to achieve quality excellence and sustainable market leadership. With a headcount of 850+ elite software quality engineers and trusted by 70+ global enterprises over 200+ projects across 12+ industries, QualiZeal is widely recognized for its pioneering innovation and industryleading client and employee Net Promoter Scores (NPS).

QualiZeal has been acknowledged as Gold Stevie® Award winner for 2025 in the Fastest Growing Tech Company of the Year category. Additionally, QualiZeal has also been named the winner of the Bronze Stevie® Award for 2024 Tech Startup of the Year (Services) category in the 22nd Annual American Business Awards®. We also have been recognized as a Major Contender in Everest Group’s Specialist and Next-Generation QE Services PEAK® Matrix 2023 reports and as a notable provider in Forrester’s Continuous Automation and Testing (CAT) Services Landscape Report (Q4 2023).