| SSIS Lead with AWS at Phoenix, Arizona, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=781801&uid= From: Rex, Smart IT Frame [email protected] Reply to: [email protected] Role: SSIS Lead with AWS Location: Phoenix, AZ (Remote) Duration: Contract Interview Mode: Video Start Date: ASAP Interview process: Video call Experience: 10 Years Note: Need genuine profiles along with visa documents, DL Job Description: Hands-on experience on technologies like SSIS, SSRS, SSAS, MS SQL. Strong knowledge /Experience of Database queries (SQL) , performance tuning , SSIS and SSRS tool. Have deep knowledge of SSIS/SQL/MS SQL / SSRS Server required for maintaining data warehouse, data integrations, and providing data support. Knowledge of Change Data Capture (CDC), Type 2 Dimension Data Model and Data Warehouse ETL techniques Experience of analysis and resolution of data quality and integration issues Experience in developing/supporting SCD1/SCD2/SCD3 Dimension Data models and data warehouse Experience of working both independently and collaboratively with various teams and global stakeholders (Operations/Support/Business) in an agile approach while working on data issues and support tickets Experience in development and support on SSRS/SSAS Cubes, along with troubleshooting performance and processing issues exereince. Experience in complex / enterprise data warehouse implemented over standard RDBMS (using SSIS, SSRS and SQL Server / Azure cloud). Strong understanding of data integration issues ( validation and cleaning), familiarity with complex data and structures Expert in best practices in areas like - writing queries, designing various database objects like - data structures tables, indexes, relationships, stored procedures, functions, triggers, etc as required to support application development activities. Good Knowledge of Data warehouse concepts Should be very strong in database concepts. Experience with all phases of Software Development Life Cycle Highly motivated, needs minimal hand holding, Ability to multitask and work under pressure Strong Analytical and Problem-solving skills; ability to analyze data for trends and quality checking Implement stored procedures and effectively query a database Translate requirements from the business and analyst into technical code Identify and test for bugs and bottlenecks in the ETL/Reporting solution Ensure the best possible performance and quality in the packages Provide support and fix issues in the packages Writes advanced SQL including some query tuning Experience designing and building complete ETL, SSIS and SSRS processes moving and transforming data for ODS, Staging, Data Warehousing and Reporting. Experience in providing and maintaining support documentation, STM / FSD / Design documents etc. Ability to write stories and understand the business requirements Experience in work with the business/client. Excellent communication, interpersonal and listening skills. Ability to communicate in English to a high standard is essential. Keywords: information technology microsoft Arizona http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=781801&uid= |
| [email protected] View All |
| 01:44 AM 24-Oct-23 |