This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Liberty and Prosperity for all - new job offers every day

To post a job, login or create an account |  Post a Job

New

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

Sunrise Systems, Inc.

This is a Full-time position in Trenton, NJ posted April 6, 2021.

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 PLSQL 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 designingimplementing 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 designingimplementing Star, snowflake Schema Data Warehousing concepts Required 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