Data Architect AWS with Redshift - Remote
- Jkv It Services
- 5 Positions
- Hyderabad
- 6 months ago
- Email to a friend
- Report this job
Job Description
- Design, develop, test, deploy and troubleshoot SQL scripts, Stored Procedures that implement complex PLSQL solutions.
- 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.
- 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.
- Candidate Full Name :
- Current Location:
- Preferred Mode (WFO/Remote):
- Current CTC
- Expected CTC:
- Notice Period:
- Availability for Interview:
We are currently hiring for the position of Data Architect for one of our key clients, and I wanted to check your interest and availability for this exciting opportunity.
Role: Data Architect
Mode: Work from Office (5 Days) / Remote (based on profile suitability)
Work Timing: India hours with overlap to U.S. time zones
Location: Hyderabad
Must Know Skill : Redshift
Job Description: (Architect is required to know AWS Redshift.)
Technical Skills:
If you're interested, please reply with your updated resume and the following details:
Regards
Senthil Kumaran L
Resource Manager
E: se****l@jk**********s.com
www.jkvitservices.com
JKV IT Services Pvt Ltd.
Chennai , Tamil Nadu, India
Employement Category:
Employement Type: Full timeIndustry: IT Services & ConsultingRole Category: Application Programming / MaintenanceFunctional Area: Not SpecifiedRole/Responsibilies: Data Architect AWS with Redshift - RemoteContact Details:
Company: Jkv It ServicesLocation(s): Hyderabad
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in