GluJS RedShift As A Cloud Solution Architect (Jobs in Madison, WI)   Requirement id 143509 Job title Architect Job location in Madison, WI Skills required ETL Process, Data Platform, GluJS, RedShift As A Cloud Solution Open Date 28-Sep-2023 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: Kamlesh Coolsoft Job Description Architect: ETL Process, Data Platform, GluJS, RedShift As A Cloud Solution Start date : 10/16/2023 End Date : 6 Months from projected start date Submission deadline : 9/29/2023 @ 4:00PM CST. Client Info : UW - Madison Note : * Interview Process: Remote, Microsoft Teams * Duration: 6 months with the possibility of extension for another 3 or 6 months * Onsite or Remote? No WI residency required, open to nationwide candidates. This position can work 100% remote from anywhere in the continental US or in the office. Description : ------------------------------------------------------ We are seeking a talented and experienced AWS Redshift Data Engineer / Consultant to join our team in designing, developing, and optimizing data pipelines and ETL processes for our AWS Redshift-based data lake house.In this role, you will collaborate closely with cross-functional teams, leveraging your expertise in SQL, Redshift stored procedures, AWS DMS, Airflow, Python scripting and other pertinent AWS services to ensure the seamless ingestion, integration, transformation and orchestration of data. Your experience with complex ETL pipelines, Changed Data Capture (CDC), Slowly Changing Dimension (SCD) strategies will be instrumental in creating a scalable, high-performance data environment.By adhering to best practices and industry standards, you will collaborate with our engineering and data teams to design forward thinking solutions. Key Responsibilities: • Collaborate with data engineering and development teams to design, develop, test, and maintain robust and scalable ELT/ETL pipelines using SQL scripts, Redshift stored procedures, and other AWS tools and services. • Collaborate with our engineering and data teams to understand business requirements and data integration needs, translate them into effective data solutions, that yield top-quality outcomes. • Architect, implement, and manage end-to-end data pipelines, ensuring data accuracy, reliability, data quality, performance, and timeliness. • Employ AWS DMS and other services for efficient data ingestionfrom on-premises databasesinto Redshift. • Design and implement ETL processes, encompassing Changed Data Capture (CDC) and Slow Changing Dimension (SCD) logics, to seamlessly integrating data from diverse source systems. • Provide expertise in Redshift database optimization, performance tuning, and query optimization. • Design and implement efficient orchestration workflows using Airflow, ensuring seamless coordination of complex ETL processes. • Integrate Redshift with other AWS services, such as AWS DMS, AWS Glue, AWS Lambda, Amazon S3, Airflow, and more, to build end-to-end data pipelines. • Perform data profiling and analysisto troubleshoot data-related challenges / issues and build solutions to address those concerns. • Proactively identify opportunities to automate tasks and develop reusable frameworks. • Work closely with version control team to maintain a well-organized and documented repository of codes, scripts, and configurations using Git. • Provide technical guidance and mentorship to fellow developers, sharing insights into best practices, tips, and techniques for optimizing Redshift-based data solutions. Qualifications and Skills: • Bachelors or Masters degree in Computer Science, Information Technology, or a related field. • Extensive hands-on experience designing, developing, and maintaining data pipelines and ETL processes on AWS Redshift, including data lakes and data warehouses. • Proficiency in SQL programming and Redshift stored procedures for efficient data manipulation and transformation. • Hands-on experience with AWS services such as AWS DMS, Amazon S3, AWS Glue, Redshift, Airflow, and other pertinent data technologies. • Strong understanding of ETL best practices, data integration, data modeling, and data transformation. • Experience with com   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 143509 while calling.   Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2),    ETL Process job openings in other states Jobs List Database Administrator 3 - 61820 Create date: 01-Dec-2023 Start date : 12/11/2023 End date :12/11/2024 Submission deadline 12/04/2023 Client info : TN DOT Note: * Position Location: Hybrid Description : Install, upgrade, patch the oracle database infrastructure. .... (This job is for - job Jobs in TN Nashville Administrator - (in Nashville, TN)) ITSAC 529400647 Systems Analyst 3 -SP Create date: 01-Aug-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000007LzPAAU/529400647 Note: Online Submission Note: Total estimated hours per Candidate shall not exceed 2000 hours Note: RTR form must be signed by the candidate Submission Deadline: 8/8/2023 5:00 PM CT Start Date: 9/1/2023 End Dat.... (This job is for - Integration Jobs in TX Austin Analyst - (in Austin, TX)) T-SQL Developer - SME - 119468 - SP Create date: 22-Jun-2023 start date : 7/10/2023 End date : 09/30/2024 submission deadline : 6/30/2023 3:00:00 PM client info : MDEK12 Note : * Off-site Description : This position will require qualified T-SQL Developers to take the lead in the fol.... (This job is for - T SQL Jobs in MS Jackson Developer - (in Jackson, MS)) ITSAC 529300549 Developer/Programmer Analyst 3 -SP Create date: 04-May-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000006lgkAAA/529300549 Note: Online Submission Note: Total estimated hours per Candidate shall not exceed 696 hours Note: RTR form must be signed by the candidate Submission Deadline: 5/9/2023 5:00 PM CT Start Date: 6/5/2023 End Date.... (This job is for - Developer ProgrammerIntegration Jobs in TX Austin Developer - (in Austin, TX)) Big Data Engineer Create date: 09-Apr-2021 Description: The Big Data Engineering team is responsible for building and maintaining the state-of-the-art ETL pipelines that makes this data available and accessible to the entire company to make data driven decisions. The team works closely with Data scientists, Product Managers, Executives and other key parts of the business across t.... (This job is for - Jobs in CA MountainView Engineer - (in Mountain View, CA))     (Architect: ETL Process, Data Platform, GluJS, RedShift As A Cloud Solution in Madison, WI)

Featured Jobs Financial Manager (Jobs in Nashville, Tennessee) EPIC Implementation Consultant (Jobs in Nashville, Tennessee) Help Desk Software TechLead (Jobs in Jackson, Mississippi) SSRS ASP.Net&C# JavaScript Xml Developer (Jobs in Jackson, Mississippi) Analyst (Jobs in Jackson, Mississippi) MS Analyst (Jobs in Jackson, Mississippi) - - Consultant (Jobs in Chattanooga, Tennessee) FTP/SFTP SIEM Administrator (Jobs in Pontiac, Michigan) PMP Microsoft Manager (Jobs in Richmond, Virginia) Customer Analyst (Jobs in Raleigh, North Carolina)