SQL SERVER DEVELOPER, HOUSTON, TX (ONSITE)-6 months Contract

SQL SERVER DEVELOPER

HOUSTON, TX - ONSITE ON DAY 1

To conceptualize| design and deliver product / sustenance delivery through the team as per defined scope and standards in a particular technology

(1.) To architect| design and develop (through Team) solution for product / project & sustenance delivery

(2.) To support as an SME

(3.) To ensure knowledge up-gradation and work with new technologies so that the solution is current and meets quality standards and the client requirements

(4.) To train and develop team so as to ensure that there is an adequate supply of trained Client in the said technology and deliver risks are mitigated

(5.) To gather specifications and deliver solutions to the client organization based on understanding of a domain or technology

(6.) To review project deliverables.

(7.) To recommend client value creation initiatives and implement industry best practices (on specific technology / product) Skill (Primary) Tools and Standards (APPS)-Development Tools-SQL Developer

About the Role

We are looking for a skilled SQL Developer with expertise in building and optimizing Views to support data integration efforts from multiple sources, including databases, data warehouses, and data lakes. You will play a critical role in ensuring seamless access to data for analytics and reporting by creating performant, well-organized Views that can be leveraged by downstream users and applications.

Key Responsibilities

• View Creation and Optimization : Design and develop SQL Views to integrate data from various sources, such as transactional databases, data warehouses, and data lakes. Optimize Views for performance and ensure they meet business requirements.
• Data Modeling : Collaborate with data engineers, analysts, and other stakeholders to understand data requirements and structure Views that support business intelligence, analytics, and operational needs.
• Data Source Integration : Work with data from multiple sources including relational databases like SQL Server, Oracle, etc., data warehouses, and data lakes (Azure Data Lake).
• Query Performance Tuning : Analyze and enhance SQL queries to improve performance, ensuring that Views are efficient, scalable, and align with best practices.
• Documentation : Document the structure and logic of Views, including table relationships, transformations, and dependencies, to support maintainability and knowledge sharing.
• Data Mapping : Try to establish the source and target data mappings, to ensure the support needed for building Data lineage and to support development of data transformation pipelines.
• Data Quality Assurance : Validate data consistency, accuracy, and completeness within Views and troubleshoot issues related to data integrity across sources.
• Collaboration : Work closely with data architects, data engineers, ETL developers, BI teams and Business Users to provide data accessibility while adhering to governance and data security policies.

Required Qualifications

Preferred Qualifications