Senior Consultant Mid-Level ETL Senior Consultant Mid-Level ETL job vacancy

Vacancy expired!

Job Title: Senior Consultant 1 Mid-Level ETL Senior Consultant 1 Mid-Level ETL(644788)

Duration: 6+ months contract (Possibility of extension)Location: Trenton, NJ

Job Description: ETL Developer to worclosely with data architects, business intelligence developers, and business analysts to create and maintain a variety of ETL data flows and data projects.

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

Skill Matrix:

Skill

Required / Desired

Amount of Experience DataStage ETL development experience. Experience with Version 11.5 and above is preferred. Required 4 Years Experience designing and developing data extraction/ Integration solutions using Datastage.Required 4 Years Experience with AWS S3, Redshift Required 2 Years Strong professional experience loading the data from S3 to redshift.Required 4 Years Expertise in designing/implementing Star, snowflake Schema Data Warehousing conceptsRequired 4 Years Hands on experience in writing and understanding complex SQL. Required 4 Years Experience resolving and improving performance issues Highly desired 3 Years 4-year College Degree or equivalent technical study Required 4 Years

Vacancy expired!

ID	#12262465
State	New Jersey
City	Trenton
Job type	Contract
Salary	USD $60 - $70 60 - 70
Source	Sunrise Systems, Inc.
Showed	2021-04-15
Date	2021-04-14
Deadline	2021-06-13
Category	Et cetera
Create resume

Job Details

Senior Consultant 1 Mid-Level ETL Senior Consultant 1 Mid-Level ETL

Related jobs

»NetSuite Senior Sales Consultant - Emerging - Santa Monica

»NetSuite Senior Sales Consultant - Emerging - Santa Monica

»NetSuite Senior Sales Consultant - GB West

»NetSuite Senior Sales Consultant- Products East

»NetSuite Senior Sales Consultant- Products East

»NetSuite Senior Sales Consultant

»NetSuite Senior Sales Consultant