SQL Developer – Remote

• SQL Server / T-SQL:  
• SSIS / ETL:  
• SSRS / Power BI:  
• ADF -Intermediate
• Data Mart

Responsibilities

• Architect and design enterprise level datawarehouse and data lake
• Build and maintain data infrastructure and pipelines
• Gather and process raw data from disparate data sets
• Read, extract, transform, stage and load data (ETL process) on datawarehouse
• Process unstructured data into suitable form for analysis.
• Support data and analytics by adhering to quality, governance, lifecycle management, and compliance.
• Analyze large amounts of data and help derive insights and value from them.
• Partner with data scientists to perform ad hoc analysis to support business decisions
• Maintain existing production systems
• Stay on top of evolving technology (ADF, etc.) to suggest, prototype and implement improvements to the data architecture
• Mentor junior members of the data and analytics teams.

Skills and Abilities 

• Commitment to best software engineering practices (unit testing, TDD, code reviews etc.) and agile process.
• Ability to design solutions independently based on high-level architecture.
• Technical aptitude to partner with development teams.
• Ability to facilitate discussions within and outside team to derive alternatives or different approaches.
• Ability to own tasks outside of immediate scope of responsibility.
• Ability to own and complete tasks with minimum supervision.
• Analytical thinker and problem solver.
• Detail oriented with a strong focus on quality.
• Strong written communication skills.

Requirements:

• 5 years of Hands-on experience in data modeling and data architecture
• 8+ years of experience in working with relational database systems like SQL Server, MySQL etc. is required. 
• 5+ years of strong system design/development experience in building large scale distributed systems and products.
• 3-5 years’ experience of with SQL SSIS or similar ETL tools
• Experience writing and troubleshooting SQL queries, optimizing to improve performance, automizing using indexes, stored procedures is required.
• Previous experience with designing OLAP systems in data-warehouse platforms like Snowflake, Amazon Redshift etc. is preferred.
• Previous experience with cloud platforms like Azure or AWS is preferred
• Troubleshooting: The candidate must be able to engage in solving complex problems. Programming problems are a good example.

Regards,

Vani Priya B | Recruitment Executive

vanipriya.b@diamondpick.com

phone: +1(732)394-6016 

A Great Place to Work-Certified Organization

This e-mail message, including any attachments, is for the sole use of the person to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message along with any attachments