| ETL Developer Data Engineer Loc: Seattle, WA Remote at Seattle, Washington, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=933652&uid= From: bhumika, Adifice Technologies [email protected] Reply to: [email protected] Job Title: ETL Developer/Data Engineer Client : Sound Transit Location: Seattle, WA (Remote) Visa : USC & GC only Duration: 12 months with possible extension C2C. Client: Sound Transit (No interview/Resume screening and direct offer) Experience working with some State/Federal Client required. Experience working with some Transit Authority/Transportation/Railroad department highly preferred. General Summary: Seeking a highly skilled ETL Developer / Data Engineer who will be responsible for developing ETL solutions using Microsoft SQL Server Integration Services (SSIS). This role requires experience in designing data pipelines, SQL programming, stored procedures, data modeling, ETL, API Integration, and PowerBI Dashboards. Essential Functions: Design, develop, and maintain SQL Server Integration Services (SSIS) packages to facilitate efficient data extraction from disparate data sources including Rest APIs, transformation, and loading (ETL) processes. Create and optimize complex SQL queries, stored procedures, and functions to extract, transform, and load data from various data sources including API integrations. Perform data profiling and analysis to identify data quality issues and propose appropriate solutions. Implement data cleansing, transformation, and validation rules to ensure the accuracy and consistency of data. Collaborate with data engineers, database administrators, and enterprise architects to design and maintain data models and database schemas. Create/Maintain design related artifacts including data models, mapping documents, architecture diagrams, data flow diagrams, data dictionaries, and technical specifications. Monitor and optimize the performance of SQL queries, ETL processes, and Database objects (tables, views, indexes) to ensure efficient data processing and system reliability. Troubleshoot, Monitor, Notify, and Resolve data-related issues, including data integration failures, data quality problems, and performance bottlenecks. Monitor daily ETL jobs and data loads and proactively resolve issues to ensure maximum uptime/availability of data for reporting. Test and prepare ETL processes for deployment to production and non-production environments. Support system and acceptance testing including the development or refinement of test plans. Deliverables: ETL Pipelines (Code/configuration) SSIS Packages PowerBI Dashboards Documentation Education & Experience: Experience in designing and implementing SSIS solutions according to best practices including design, configuration, data mapping, data quality, extraction, transformation, and loading. Specific Qualifications, Knowledge, and Skills: In-depth knowledge of Microsoft SQL Server Integration Services (SSIS) and experience in designing and developing ETL processes including extracting data from API(s). Proficiency in SQL programming, including complex query optimization, stored procedures, views, and functions. Solid understanding of data modeling concepts and experience in designing and implementing database schemas. Familiarity with creating data quality checks on ETL. Strong problem-solving and analytical skills with the ability to identify data-related issues and propose effective solutions. Experience with performance tuning and optimization of SQL queries, ETL processes, and database systems. Excellent communication and collaboration skills, with the ability to work effectively in a team environment. Keywords: green card Washington http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=933652&uid= |
| [email protected] View All |
| 08:25 PM 13-Dec-23 |