ETL Data Warehouse Developer
Posted on :
21-10-2022
Employer Active
1 Vacancy
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 1728823
Job Title: ETL Data Warehouse Developer
Job Location: Sunnyvale, CA(Day 1 onsite)
Job Duration: Long-Term
Job Location: Sunnyvale, CA(Day 1 onsite)
Job Duration: Long-Term
Job Description:
- 6+ years of experience utilizing Microsoft technologies in development and operation of Data Warehouse, and application integration solutions via Microsoft SSIS.
- Strong understanding of DW/ETL processes, OLAP concepts, SQL Queries and Stored Procedure writing.
- Good hands-on experience on migrating SSIS packages to Azure ADF
- Experience in migrating on premise databases to Azure SQL Database and Azure Cloud using Azure Data factory.
- SQL Server Reporting Services (SSRS) and Powerbi experience is nice to have.
- Expert skills in performance tuning, monitoring, and troubleshooting data integration solutions; solid communication, interpersonal, leadership, and collaborative skills and a demonstrated ability for creative problem solving.
Technical Skills:
- At least 2 years Finance experience is preferred, understanding of Finance data, application server, and network security
- Experience in migrating on premise databases to Azure SQL Database and Azure Cloud using Azure Data factory.
- Good exposure in delivering solutions on the Azure Cloud using core cloud data warehouse tools (Azure Data Factory, Azure SQL DW and other Big Data related technologies).
Desirable skills:
- Responsible to serve as a technical expert in designing robust Logical Data Models and stewarding the data design of the asset and ensuring alignment with the larger roadmap goals
- Work closely with business users to determine business requirements, lead requirements gathering meetings, propose future enhancements, resolve queries around existing design or any issues.
- Develop and define application scope and objectives. Prepare specifications for development of SQL Server Integration Services (SSIS) based solutions for migrating data in both OLTP and Data Warehouse environments.
- Develop ADF pipelines, Migrate SSIS packages to Azure Data Factory.
- Design, develop, debug and support complex data integration interfaces and processes (including stored procedure and queries) using various tools and technologies including SSIS, SSAS, SSRS, T-SQL and SQL Server technology.
- Strong experience in MS SQL Server Database Development and Administration. Hands on experience with constructing stored procedures, triggers, tables, user functions, views, indexes, relational database models.
- Impact analysis of changing upstream processes to Data Warehouse and Reporting systems.
- Design database objects as necessary to meet ongoing business needs for reporting.
- Responsible to coordinate and mentor a team of mid/junior level developers and ensure project deliverables are met
- Perform technical design reviews and code reviews.
- Establish, enhance, implement, enforce, and maintain ETL best practices. Own the change request process and coordinate with other teams as necessary.
- Create and maintain documentation.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
