S3 Management RedShift As A Cloud Solution SQL Analyst Data Warehouse Snowflake 4   Requirement id 134709 Job title Consultant Job location in Trenton, NJ Skills required Datastage ETL, Data Extraction, AWS Certified Solutions Architect Prodessional, S3 Management RedShift As A Cloud Soluti Open Date 23-Jun-2022 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: Datastage ETL, Data Extraction, AWS Certified Solutions Architect Prodessional, S3 Management RedShift As A Cloud Soluti Start date :04/24/2022 End Date :10/22/2022 Submission deadline :6/28/2022 Client Info :Judiciary Description : Note: Contractor will work remotely with the expectation that they will come into the office to work On-Site a few times per month or more frequently if policies change. As such, Contractor needs to live locally. 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: 134709 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),    Datastage ETL job openings in other states Jobs List Sr. ETL Developer - 36323 Create date: 09-Jul-2018 Job Description : Sr. ETL DataStage Developer 12 month contract The DataStage ETL Developer will be responsible for designing, and implemetning enterprise ETL solutions for a multi-terabyte DB2/Unix environment using IBM DataStage 11.5 and SSIS Project Description: Complete Design Documentation; ETL Progr.... (This job is for - FTP Jobs in MO KansasCity Developer - (in Kansas City, MO)) Data Stage Create date: 10-Nov-2014 Job Description: "5+ yrs on Datastage (Version 7 or 8) Very strong Datastage ETL stage creation experience using various different source and target connectors (Sybase, oracle, files, XML) Strong understanding of different types of transactions Datastage maps scheduling and monitoring Strong database skills (SQL) Oracle Jobs in AZ Phoenix Developer - (in Phoenix, AZ)) Datastage ETL Developer Create date: 15-Nov-2011 Datastage ETL Developer Experience: Datastage- 3 years (This job is for - Jobs in MA Boston Developer - (in Boston, MA))     (Consultant: Datastage ETL, Data Extraction, AWS Certified Solutions Architect Prodessional, S3 Management RedShift As A Cloud Soluti in Trenton, NJ)

Featured Jobs Java Kafka Microservices Developer (Jobs in Orange County, California) Software Analyst (Jobs in Richmond, Virginia) Business Analyst (Jobs in Bismark, North Dakota) QA Analyst (Jobs in Madison, Wisconsin) Consultant (Jobs in Bismarck, North Dakota) - Consultant (Jobs in Greeneville, Tennessee) SCCM PowerShell Specialist (Jobs in Raleigh, North Carolina) ASP.Net UI Developer (Jobs in Madison, Wisconsin) - Consultant (Jobs in Bismarck, North Dakota) Help Desk Consultant (Jobs in Madison, Wisconsin)