Client: State of New York
Job Title: ETL Developer
Duration: 24 Months
Start Date: ASAP
Location: Albany, New York, 12207 Hybrid
Position Type: Contract
Interview Type: Webcam
Working Hours: 8:30 AM-5:30 PM
Job ID: HBITS-06-14074
Agency Name: Information Technology Services (ITS)
Short description
The Software Developer will be working with the product development team writing the code, designing the architecture, and ensuring the software functions correctly. They will report to Shyam Dubey at our Albany office.
Responsibilities
Daily activities will include, but are not limited to:
As part of the product development team, you will work in an agile environment and collaborate and develop solutions to solve data integration challenges.
As part of the Data Migration team, you will perform data migration activities to migrate data from legacy systems such as the mainframe, extracted data files, and databases to a modern data platform.
As part of the Data Migration team, you will perform activities such as analyzing, designing, developing, testing, and deploying Extract, Transform, and Load (ETL) solutions.
As part of the Data Migration team, you will perform data preparation activities such as data extraction, data analysis, data profiling, and data cleansing.
As part of the Data Conversion team, you will perform data conversion activities such as data mapping and data consolidation of duplicate and redundant data.
As part of the Data Management team, you will monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
As part of the Data Management team, you will create ETL design, source to target mapping documents, and implementation documentation.
Communicate and coordinate with members of the product team to work across multiple projects.
Other duties as assigned.
Requirement
60 - 84 Months: Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.
60 months of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases.
60 months of experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality.
60 months of experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
60 months of experience with Data Quality processes, approaches, measurement techniques and business cases for data analysis, data profiling, data cleansing, data standardization, match and merge functionality using Informatica Data Quality
60 months of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.
60 months of experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.
60 months of experience writing complex UNIX shell scripts to validate and ftp files, and for scheduling / automating ETL process
60 months of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.
V Group Inc. is an IT Services company that supplies IT staffing, project management, and delivery services in software, network, help desk, and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: CA, FL, GA, MD, MI, NC, NY, OH, OR, PA, SC, VA, and WA, CT, TN. If you are considering applying for a position with V Group or partnering with us on a position, please feel free to contact me with any questions you may have regarding our services and the advantages we can offer you as a consultant.
Website:
LinkedIn:
Facebook:
Twitter:
USRC's greatest strength in being a leader in the dialysis industry is our ability to recognize and celebrate the differences in our... ...culture at all levels of our organization. The Biomedical Technician is responsible for overseeing the overall operational condition...
...Katalyst Healthcares & Life Sciences is hiring entry level candidates for several positions for contract research in Clinical trials... ...Clinical Research field. We work with University hospitals, pharmaceutical companies and recruiting partners. Job Description...
...Job Title: Technical Writer Location: Sunnyvale, CA Duration: 6 month Description: Required qualifications... ... Ability to effectively communicate both orally and in writing Experience developing process flows, methods and...
Bottega Veneta seeks a Client Advisor in Wailea to drive sales and build client relationships within a luxury retail environment. The role requires 1-2 years of retail experience, preferably in luxury, and offers a salary of $19.00-20.00/hr plus commission. The position...
...Job Summary We are seeking a skilled and dedicated Home & Commercial Security Technician to join our team. In this role, you will be responsible for installing, maintaining, and repairing security systems and fire alarm systems for both residential and commercial clients...