Urgent Role for ETL & DW Developer at Sunnyvale, CA (Onsite) at Sunnyvale, California, USA |
Email: [email protected] |
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=389323&uid= From: Shikha Gupta, USG [email protected] Reply to: [email protected] Hi, Greetings! Hope you are doing great. My name is Shikha and I am a IT- Recruiter in United Software Group Inc., an Ohio based fast growing multi-national IT & Engineering Consulting Company, serving its clients from last 20 years having staff strength of 2500 in 17 offices globally, operating across 8 countries in North America, Latin America, Asia Pacific and Europe. USG Inc. is aggressively recruiting for ETL & DW Developer to work on one of our clients project. Please review the job details below and if interested, feel free to call me at <614-495-9222 Ext. 428> or reply to this email. In-case you are not interested, you may also refer anyone you may know who is looking for similar job. Job Title: ETL & DW Developer Location: Sunnyvale, CA (Onsite) Duration: Long Term Contract Mode Of Interview: Video Interview Job Requirement: ETL Developer in Engineering Business Intelligence team will demonstrate a strong working knowledge of extract, transform, and load (ETL) development using SQL Server Integration Service (SSIS). Position requires a proven leader in large-scale Data Integration and Date Warehousing environments. Developer will assist in the design and development of data feeds, interfaces, data warehouses and enterprise reporting. Developer should also have knowledge of performing migration from Informatica to SSIS and also from SSIS to ADF. In addition, developer will have the opportunity to consult with non-technical business customers to determine requirements and apply the business rules to the data. This individual will work closely with internal departments and counterparts during implementation and through ongoing operations. Developer will also focus on solution design based on the strategic direction of the organizations data tier. 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. 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. Strong experience in Oracle Database Development. Impact analysis of changing upstream processes to Data Warehouse and Reporting systems. Design and development of Power BI reports and Dashboards. 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, and maintain ETL best practices. Own the change request process and coordinate with other teams as necessary. Create and maintain documentation. 6+ years of experience utilizing Microsoft technologies in development and operation of Data Warehouse, and application integration solutions via SSIS. Strong understanding of DW/ETL processes, OLAP concepts, SQL Queries and Stored Procedure writing. SQL Server Reporting Services (SSRS) and PowerBI experience. Develop OBIEE Reports and Dashboards Migration from OBIEE to PowerBI At least 3 years experience as a project lead, team lead, etc. with the ability to mentor others 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 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) Good exposure in Oracle DB Good understanding of Oracle Business Intelligence Tools, Oracle Reporting OBIEE Submission Details: Name: Contact No.: Email Id: Location: Linkedin: Skype: Interview Availability: Education Rate: -- Thanks & Regards, Shikha Gupta IT- Recruitment | Direct: 4197194135 Board-line: 614-495-9222 Ext. 428 Keywords: access management business intelligence database information technology microsoft California Idaho http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=389323&uid= |
[email protected] View All |
01:37 AM 28-Feb-23 |