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 T-SQL Developer - SME - 135469 - SP Create date: 01-Oct-2024 No of Submissions: 1 Start date : 10/14/2024 Immediately End date : 02/28/2026 Submission deadline : 10/3/2024 3:00:00 PM Client info: MDEK12 Note: * This is a two day urgent posting, note the expiration date. Description: This position will require qualif.... (This job is for - T SQL Jobs in MS Jackson Developer - (in Jackson, MS)) VDOT Data Analyst/Cloud ETL Developer (742720) Create date: 24-Jul-2024 No of submissions :2 Start date :8/5/2024 End date :06/30/2025 Submission deadline :7/29/2024 Client info : VDOT Note: * Hybrid *Agency Interview Type:Both Phone and In Person Description : *Local Richmond, VA cand.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) Data Base Programmer/Analyst - 62749 Create date: 22-May-2024 No of Submissions : 1 Start date : 06/03/2024 End date : 12/31/2024 Submission deadline : 05/24/2024 Client info : CO CDPHE Note : * Position Location : Hybrid * Bill Rate - USD 76.00 Per Hour * Max Rate - USD 96.00 Per Hour .... (This job is for - MS SQL Server GCP Jobs in CO Denver Analyst - (in Denver, CO)) 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))     (Architect: ETL Process, Data Platform, GluJS, RedShift As A Cloud Solution in Madison, WI)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)