Remote till Covid:: State of New Jersey - Senior ETL Developer - 659414 - Trenton, NJ

Hello Vendors,

 

This is Urvish from Cambay Consulting LLC, I tried calling you regarding an amazing opportunity with New Jersey Agent Orange Commission (NJAOC) for the position of Senior Consultant 1Sr. ETL Developer.

Kindly go through the email below and let me know the best time to reach you.

 

Position Details:

Client:	New Jersey Agent Orange Commission (NJAOC)
Job Title:	Senior Consultant 1 Sr. ETL Developer
Job ID:	659414
Interview Mode	Web Cam
Location:	25 Market Street Trenton NJ 08625
Duration:	6+ Months with Extension

 

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.

 

Job Description:

This Position responsible for developing data integration programs that load, transform and extract data To/From the data warehouse, assures that architecture and development follow data warehouse best practices. You will design, develop, and test extract, transform, and load processes for enterprise-wide data warehouse and data store implementations. Design, develop, and test ETL processes for enterprise-wide data warehouse implementations mainly with  DataStage and Cloud Architect assuming overall responsibility for data migration solution and capable on Working  with AWS services like S3 EC2 VPC Glue Lambda, python and Jason etc. and any of the databases like AWS Aurora Dynamo DB RDS database engines and Redshift

 

Tasks:

- Work closely with Leadership and Data Governance to define and refine the Data Lake platform to achieve business objectives.

- Extract, transform, and load data from various Databases.

- Develops and automates advanced level ETL processes to gather or provide data to and from different sources respectively.

- Document, publish and maintain ETL processes and related documentation.

- Apply Best Practices in developing AWS Data Lake flow.

- Create ETL flows to Integrate the On-Prem data to Cloud AWS S3 Buckets.

- Translate detailed business requirements into optimal database and ETL solutions.

- Create an ETL jobs to load data into AWS S3 buckets by performing cleansing.

- Create a flow to load data from Amazon S3 to Redshift using Glue.

- Diagnose complex problems, including performance issues, and driving to resolution.

- Write reusable, testable, and efficient code in Python.

- Create Collibra Data Governance Center (DGC) models including assets, relationships, domains and communities.

- Configure Data Governance on Business requirements and specifications.

- Assist Cloud Architect design overall for data migration solution.

- Connect to extract the (meta) data from multiple source systems that comprise databases like Oracle, SQL Server, Hadoop etc. into data governance platform.

- 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:

• Experience in coding dimension and fact tables. General understanding of dimensional modeling and star schemas.
• Experience with data warehousing concepts for Data Quality and Governance implementation.
• Working experience with database like DB2 and Redshift is required.
• Having knowledge on Python and its related libraries.
• Experience in creating technical design and implementing ETL solutions.
• Knowledge of algorithms, data structures, and Python design patterns.
• Must possess experience and skills in understanding data models and developing databases and database objects.
• Solid experience in Python and great motivation to have it as your primary programming language.
• Experience with data governance tools like IBM Information Governance Catalog, Collibra.
• Experience in loading the data from S3 to Redshift.
• Experience with web related technologies like JSON.
• 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 working with AWS technologies (S3, Glue, RedShift).
• Advanced experience with Red Hat Satellite to include systems provisioning, content view management, host group management, Discovery, and Capsule management.
• Develop design & architect solution using AWS foundation services VPC is a plus.
• Advise senior staff on technical issues as appropriate.

 

Required Qualifications and Experience:

•  4-5+ years of related information technology experience like cloud architecture/ Senior   Developer, AWS, IBM DataStage.

•  4+ years of proficiency and experience with AWS cloud environment for best practices

•                4+ years’ Experience in IBM Tools like Information Analyzer, Watson Knowledge Catalog

•                5+ years of Experience on designing , developing DataStage ETLs

•                4 years of proficiency in developing scripts and scripting languages for cloud services.

•                4+ years of strong working knowledge with AWS CLI, S3,Redshift, EC2, API Gateway and Lambda, Python step functions etc.

•                4+ years of experience develop design & architect using AWS and IBM foundation services VPC/VPNe.

•                Knowledge with AWS CLI and knowledge of JSON and/or PowerShell scripting. (Preferred)

•                AWS - Solutions Architect Certification Preferred. (preferred)

•                Capability to migrate and manage on-premises workload to cloud service providers.

•                Information Server Admin experience (Preferred)

 

Skill Matrix:

Skill	Required / Desired	Amount	Experience
-5+ years of related information technology experience like cloud architecture/ Senior Developer, AWS, IBM DataStage.	Required	5
4+ years of proficiency and experience with AWS cloud environment for best practices	Required	4
• 4+ years’ Experience in IBM Tools like Information Analyzer, Watson Knowledge Catalog	Required	4
• 5+ years of Experience on designing , developing DataStage ETLs	Required	5
• 4 years of proficiency in developing scripts and scripting languages for cloud services.	Required	4
• 4+ years of strong working knowledge with AWS CLI, S3,Redshift, EC2, API Gateway and Lambda, Python step functions etc.	Required	4
• 4+ years of experience develop design & architect using AWS and IBM foundation services VPC/VPNe.	Required	4
• Knowledge with AWS CLI and knowledge of JSON and/or PowerShell scripting. (Preferred)	Required	5
• AWS - Solutions Architect Certification Preferred. (preferred)	Highly desired	4
• Capability to migrate and manage on-premises workload to cloud service providers.	Required	3
• Information Server Admin experience (Preferred)	Highly desired	3
4 year College Degree or equivalent technical Study	Required	4

 

Thanks and Best regards,

 

Urvish Rai

Ph.: 832-761-3192

Cambay Consulting LLC.

1838 Snake River Road,

Suite A, Katy, TX 77449

www.cambaycs.com

 

::DISCLAIMER::

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or CAMBAY or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of CAMBAY or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of CAMBAY is strictly prohibited. If you have received this email in error, please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.