Data Architect

Position: Data ArchitectLocation: Hyderabad, IndiaJob Type: Full Time, Work from office 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 queriesMust 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 specificationsExpert understanding of PostgreSQL, Stored Procedures, Views, and Functions.Provide the estimates for the ETL workDatabase/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 tablesTroubleshooting and fixing the codeUnit testing the code and documentation of resultsMust 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 customersAbility to perform independent research to understand the product requirements and customer needsCommunicates 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-SSISSQLStored Procedure, Functions, Triggers etcQuery OptimizationServer monitoringETL:-AWS-GlueDBMS:-AWS Aurora MySQL, AWS Redshift, PostgreSQLCloud 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 practicesGreat learning attitudeEagerness to take ownershipA global mindsetExcellent communication skills.About us:QualiZeal is North America's Fastest-growing Independent Digital Quality Engineering services company with a global head count of 500+ Quality Engineering & Software Developers . We have implemented Quality Engineering and Test Automation engagements for small, medium and large companies. Trusted by 40+ Global enterprises, QualiZeal has delivered over 200 successful projects earning client NPS score of 85. QualiZeal's dedication, expertise, and ability to deliver the right solutions at a fast pace is recognized by customers and partners. We were recognized as "The Fastest Growing Digital Quality Engineering Services Company" at the 2022 Global Choice Awards.With a diverse portfolio for all your Quality Engineering service needs, we offer customized solutions ensuring the best outcomes. Our expertise includes Quality Engineering, Digital Engineering, Advisory and Transformation, and Emerging Technology Testing. Using AI and ML-powered predictive capabilities, we accelerate the testing process by 3x and reduce the cost of testing by 4x. Our customized services and solutions are designed to ensure higher quality applications to meet your business and marketing demands. Our specialized and customized services include – Software Test Automation, Software Performance Testing, Mobile App Testing, Functional Testing, Process Automation, Agile Testing, and Accessibility testing.Awards and Certifications -Great Place To Work Certified (GPTW).Economic Times Excellence Award 2023NASSCOM MemberThe 2022 Global Choice AwardISO 13485 2016 and ISI 90012015