| SQL Data Engineer - View Creation and Optimization Specialist - Onsite - Houston TX at Houston, Texas, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1999016&uid= Hi, Dear hope this finds you well.. Kindly go through below JD and let me know your Interest along with an updated resume Title: SQL Data Engineer View Creation and Optimization Specialist Location: Houston, TX - Day 1 Onsite Duration: Long Term Contract Must Have: Expert level in SQL Query, Data Modelling, Query Performance Tuning, Data Mapping, Data Integration, Azure Databricks Job Description: 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 Experience : 5+ years as a SQL Developer, Data Engineer, or in a similar role focused on data integration and transformation. SQL Proficiency : Advanced knowledge of SQL and proven experience in writing complex queries, stored procedures, and Views. Data Source Familiarity : Experience working with various data platforms such as SQL Server, Oracle, and Azure Data Lake. Performance Tuning : Knowledge of query optimization and indexing strategies to enhance View performance. Data Integration : Familiarity with ETL/ELT processes, data pipelines, and tools for data integration, such as SSIS, ADF etc. Analytical Skills : Strong analytical and problem-solving skills with attention to detail in data quality and integrity. Communication : Ability to translate technical requirements into user-friendly, efficient Views and collaborate with cross-functional teams. Preferred Qualifications Familiarity with Databricks Familiarity with Databricks Unity Catalog, and Hive Metastore. Familiarity with Azure Cloud Services. Knowledge of data governance, security, and compliance principles. Thank You, have a great day ahead! Kind Regards, Dhiraj Kumar | Lead Recruiter SIRI INFO SOLUTIONS INC Email id : [email protected] Direct: (732) 228 8310 Connect me on LinkedIn www.siriinfo.com 3 Ethel Rd, Suite # 302 Edison NJ 08817 CPUC Certified Disclaimer:We respect your online privacy. If you would like to be removed from our mailing list please reply with "Remove" in the subject and we will comply immediately. We apologize for any inconvenience caused. Please let us know if you have more than one domain. The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient, be advised that the unauthorized use, disclosure, copying, distribution, or the taking of any action in reliance on this information is strictly prohibited. We are an equal opportunity employer with a diverse workforce.Note : Any resume submitted by Siri Info is presented with the understanding that the candidate is being considered for your direct end-client (end-client is the company where the work will be performed). If there is any other company involved between the end-client and your company, please do not submit this resume without our written approval. If you submit the resume to another third party, Siri Info reserves the right to work with the third party directly. US Citizens and Green Card Holders are also encouraged to apply Keywords: business intelligence information technology golang Idaho New Jersey Texas SQL Data Engineer - View Creation and Optimization Specialist - Onsite - Houston TX [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1999016&uid= |
| [email protected] View All |
| 08:01 PM 10-Dec-24 |