ETL Developer
ETL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Please contact Danish Khan at or email for more details.
Direct Client: State of New York
Job Title: ETL Developer
Duration: 30 Months Contract
Target Start Date: 03/17/2025
Location: 800 North Pearl Menands NY 12204 (Hybrid 50%)
Position Type: Full Time 40 Hours a week / 8hour days (regular business hours are 8:00am 5:00pm but can be negotiated)
Interview Type: Webcam
Ceipal ID: SNYETL846DK
Requirement ID: HBITS0613846
Department: Office of Mental Health
Description: Informatica/Rhapsody ETL Development.
Responsibilities:
- Working with large and complex Oracle data warehouses data marts and OLTP databases.
- Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing monitoring and for investigating integrity issues.
- Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Center and Rhapsody.
- Guiding the ETL team in shaping enhancing and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture.
- Investigating and resolving difficult design and build issues data loading and data integrity issues.
- Performance tuning Informatica/Rhapsody workflows.
- Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets reusable transformations and worklets.
Required Skills:
- 84 Months Experience writing complex SQL PL/SQL (stored procedures/functions) with Oracle 12c or higher including 19c to Informatica mappings
- 48 months Experience developing Rhapsody routes including Rhapsody 7 acquiring and managing millions of records of data including XML and HL7 message formats
- 84 Months Experience using Informatica 8.x or higher including 10.5 in a data warehouse environment including warehousing concepts design and development of complex mappings
- 84 Months Experience with Informatica Data Quality 8.x or higher including 10.5 processes approaches measurement techniques and business cases for data profiling data cleansing standardization match and merge
- 84 Months Experience specifying and conducting system testing (e.g. unit integration regression load performance) and user acceptance testing
- 72 Months Experience working with Health Data with HIPAA HL7 or similar standards
V Group Inc. is an IT Services company which 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: AR CA DE FL GA IL KY MD ME MI NC NJ NY OH OR PA SC TX VA and WA. If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
LinkedIn:
Facebook:
Twitter:
Employment Type
Full Time
