SQL Developer - S5 Stratos

This is a remote position.

• Ability to write complex stored procedures, functions as well as support/enhance existing code
• Ability to create/modify database schema, tables, indexes, etc.
• Knowledge of Indexes, cursors, triggers, stored procedures
• Experience working with partitioned tables and other database design patterns
• SQL Database backup, restore experience with working knowledge of log shipping, log mirroring
• SQL code optimization, tuning with ability to work with large datasets
• Extensive knowledge of Data transformation and validation
• Responsible for creating the table structures and will process data that is required to run business critical software applications
• Ability to process source data with various file formats such xml, csv etc
• Infrastructure or Product life cycle management domain knowledge
• Work with stakeholders to assist with data-related technical issues and support data infrastructure needs.
• Ability to understand requirements provided by Business Analysts and translate into ETL and query requirements
• Apply best practices for testing and deployment in an agile environment.
• Contribute to shared Data Engineering tooling & standards to improve engineering productivity across the company

Requirements

• Minimum 3 years SQL developer experience, developing / maintain SQL code
• Solid understanding of data architecture, efficient database design, writing complex queries and query tuning and troubleshooting
• Prior experience working with Tier-1 technology consulting firms is a huge plus
• Proven hands-on experience building complex ETLs in a business environment with large-scale, complex datasets
• Scripting experience in python and bash shell
• Proficiency with Git
• Experience with error handling and data validation
• Experience working in GCP or other cloud platforms
• Bachelors in Computer Science, Engineering or similar
• Must be eligible to work in the US

Benefits

Job Type: Full-time

Originally posted on Himalayas