Jobs
Interviews

Data Architect

10 - 15 years

35 - 40 Lacs

Hyderabad

Posted:10 hours ago| Platform: Naukri logo

Apply

Skills Required

Graphics Performance tuning Automation Data modeling Coding MySQL Stored procedures SSIS SQL Python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Experience
10+ Years
Job Type
Full Time
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.

More Jobs at Qualizeal India

Test Lead Guidewire

Hyderabad

5.0 - 10.0 yrs
|

INR 7 - 12 Lacs

Team Lead - Revenue

Hyderabad

5.0 - 10.0 yrs
|

INR 7 - 12 Lacs

Senior Test Engineer

Hyderabad

5.0 - 10.0 yrs
|

INR 7 - 12 Lacs

Test Architect

Hyderabad

10.0 - 15.0 yrs
|

INR 35 - 40 Lacs

Dotnet Developer

Hyderabad

4.0 - 9.0 yrs
|

INR 6 - 11 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Google Play App Store
coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Qualizeal India

RecommendedJobs for You

Qualizeal India logo

Data Architect

Qualizeal India

Hyderabad

Data Architect

Lexmark International, Inc.

kolkata, west bengal

ACME SERVICES PRIVATE LIMITED logo

Data Architect

ACME SERVICES PRIVATE LIMITED

Pune

Xoriant logo

Data Architect

Xoriant

Mumbai, Hyderabad, Pune

Intellics Global Services Mumbai logo

Data Architect

Intellics Global Services Mumbai

Hyderabad, Pune, Bengaluru

CAI logo

Data Architect

CAI

Bengaluru

Rohnium India Private Limited logo

Data Architect

Rohnium India Private Limited

Chennai, Tamil Nadu, India

Orchid Management Consultancy logo

Data Architect

Orchid Management Consultancy

Pune

Ifintalent Global Private Limited logo

Data Architect

Ifintalent Global Private Limited

Mumbai, Maharashtra, India

Data Architect

Grazitti Interactive

punjab