AWS Red Shift Data Warehouse Snowflake Complex SQL Equivalent Technical Study Cons   Requirement id 115632 Job title Consultant Job location in Trenton, NJ Skills required ETL Development, Designing Web Applications, Data Extraction, AWS Red Shift Data Warehouse Snowflake C Open Date 31-Mar-2021 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: Denny B Job Description Consultant: ETL Development, Designing Web Applications, Data Extraction, AWS Red Shift Data Warehouse Snowflake C Start Date :02/14/2021 End Date :08/13/2021 Submission Deadline :04/06/2021 Client Info : Judiciary Note : * Agency Interview Type:iLinc Web Cam Interview Only Description : ETL Developer works closely with data architects, business intelligence developers, and business analysts to create and maintain a variety of ETL data flows and data projects. Development and maintenance of ETLs and reports including requirements analysis, design, implementation, testing, deployment, and documentation. Document, study, and analyze current business processes and determine improvements. Tasks: - Extract, transform, and load data from various Databases, Sequential files. - Create ETL flows to Integrate the On-Prem data to Cloud AWS S3Buckets. - Use relevant test types and develop test strategy for all data integration scenarios. - Create ETL design documents that supports best practices and development standards. - Create a flow to load the data from Amazon S3 to Redshift using Glue or any other ETL tools. - Involve in developing and maintaining Scheduling and Sequence jobs with complex dependencies. - Create staging strategy for optimum reusability and performance. - Integrate data from multiple source systems into Data Warehouse using SCD type 1 and type 2 approaches. - Write the UNIX commands to load the data. - Develop DataStage Parallel Extender jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages etc. Qualifications: - Must possess experience and skills in understanding data models and developing ETL Jobs. - Demonstrates the ability to design, code and test ETL routines - Understands the principles of good ETL design. - Experience with Snowflake, AWS and ETL processes in AWS preferred. - Intermediate to advanced experience with Red Hat Satellite to include systems provisioning, content view management, host group management, Discovery, and Capsule management - Experience working with AWS big data technologies (Redshift, S3, EMR) - Experience in loading the data from S3 to Redshift. - Demonstrates a detailed knowledge and understanding of large Enterprise Data Warehouse, Data Mart. - Expert in Data Integration and Metadata Management. - Excellent knowledge of SQL and PL/SQL with the ability to extract, manipulate and integrate enterprise data, developing reports and expanding reporting capability utilizing SQL backend mining tools. - Experience in coding dimension and fact tables. General understanding of dimensional modeling and star schemas. Preferred Skills: - 4+ DataStage ETL development experience. Experience with Version 11.5 and above is preferred. Should be able to design and develop data extraction / integration solutions using DataStage. - 2 years of experience with AWS S3, Redshift required. - Strong professional experience loading the data from S3 to redshift. - 2 years Expertise in designing/implementing Star, snowflake Schema Data Warehousing concepts(preferred). - 3 years in hands on experience in writing and understanding complex SQL. - Able to resolve and improve performance issues   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 115632 while calling.   Other jobs in NJ: Edison (2), Englewood Cliffs (1), Ewing (2), Franklin Lakes (7), Hamilton (3), Hightstown (7), Hopewell (2), Jersey City (3), Little Falls (1), Maplewood (1), Mercer County (3), Mount Laurel (11), Mt Laurel (4), New Brunswick (1), Newark (1), Princeton (4), Somerset (9), Trenton (123), Unknown (2), Warren (7), Wayne (1), ETL Development job openings in Trenton, NJ Jobs List Data Mart Developer - 288869 Create date: 14-May-2012 [Note : Start Date : 04/23/2012 End Date : 08/24/2012] Description : Short Description: The Data Mart Developer will be part of a technology team for a Enterprise Data Warehouse environment utilizing DataStage 7.0, 8.0 and Business Object XI. CRASH &EMS Data Integration Project, Develop CRASH Phase 6.... (This job is for - datawarehouse Jobs in NJ Trenton Developer - (in Trenton, NJ))    ETL Development job openings in other states Jobs List Analyst-63016 Create date: 05-Jul-2024 No of Submissions : 2 start date : 07/22/2024 End date :01/17/2025 submission deadline : 07/19/2024 client info : ATL - AIM General Note: * Position Location: Hybrid Description : SUMMARY Responsibl.... (This job is for - job Jobs in GA Atlanta Analyst - (in Atlanta, GA)) Data Warehouse Architect 3 - 120756 - SP Create date: 31-Jul-2023 start date : 08/07/2023 End date : 08/06/2024 submission deadline : 8/4 at 10AM EST. client info : EICIM Note : * Interview Process: MS Teams with integrated audio and video required. Able to share screen if requested. * Duration: 1 Year with possible extension * Loc.... (This job is for - job Jobs in MI Lansing Architect - (in Lansing, MI)) Data Warehouse Developer III - 104749 Create date: 20-May-2022 start date:7/5/2022 End date:At least 1 Years from projected start date submission deadline:5/31/2022 at 4:00PM CST. client info: ETF Note: * Interview Process: 1-2 rounds via Microsoft Teams. Interview dates will be 6/6 - 6/7. * Duration: 1 year likely to extend. * Onsite .... (This job is for - CDC Jobs in WI Madison Developer - (in Madison, WI)) Scala Developer Create date: 25-Jan-2022 start date:As soon as possible End date:6 months (expected) submission deadline:1/31/2022 Description: Scala Developer – Remote and Direct Client Opportunity Key Skills: ETL, Scala, AWS The Role: The data engineer should be a techn.... (This job is for - Scala Jobs in NY Albany Developer - (in Albany, NY)) VEC - SQL Developers (663553) Create date: 23-Sep-2021 Start Date :10/4/2021 End Date :04/01/2022 Submission Deadline :09/29/2021 Client Info : VEC Note : * Agency Interview Type: Web Cam Interview Only Description : Pls note: For now, most of the team at VEC is working remotely, HOWEVER, the expectation will .... (This job is for - SQL Jobs in VA Richmond Developer - (in Richmond, VA))     (Consultant: ETL Development, Designing Web Applications, Data Extraction, AWS Red Shift Data Warehouse Snowflake C in Trenton, NJ)

Featured Jobs ASP.Net Government Developer (Jobs in Madison, Wisconsin) Manual Consultant (Jobs in Columbus, Ohio) IT Specialist (Jobs in Columbus, Ohio) Batch CMDB Management System Administrator (Jobs in Glen Allen, Virginia) 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)