Demo

ETL Developer

VGroup Inc
Albany, NY Full Time
POSTED ON 2/15/2025
AVAILABLE BEFORE 5/13/2025

Job Description

Job Description

Please contact Danish Khan at 614-612-1888 or email danishk@vgroupinc.com 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 / 8-hour days (regular business hours are 8 : 00am - 5 : 00pm but can be negotiated)

Interview Type : Webcam

Ceipal ID : SNY_ETL846_DK

Requirement ID : HBITS-06-13846

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 : www.vgroupinc.com

    LinkedIn : www.linkedin.com / company / v -group /

    Facebook : www.facebook.com / VGroupIT

    Twitter : www.twitter.com / vgroupinc

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a ETL Developer?

    Sign up to receive alerts about other jobs on the ETL Developer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at VGroup Inc

    VGroup Inc
    Hired Organization Address Lansing, MI Full Time
    For more details please connect with Omair Khan atEXT 327 or email him at Client : State of Michigan Job Title : Data Wa...
    VGroup Inc
    Hired Organization Address Chesterfield, VA Full Time
    For more details, please connect with Ibad Ullah Khan at 971-431-1753 or email at ibadk@vgroupinc.com Client : State of ...
    VGroup Inc
    Hired Organization Address New York, NY Full Time
    Job Description Job Description or more details, please connect with Ibad Ullah Khan at 971-431-1753 or email at ibadk@v...
    VGroup Inc
    Hired Organization Address Nashville, TN Full Time
    For more details, please connect with me at 615-680-7247 or email me at Brijt@vgroupinc.com Client: State of Tennessee J...

    Not the job you're looking for? Here are some other ETL Developer jobs in the Albany, NY area that may be a better fit.

    ETL Developer

    Lams Technology LLC, Hybrid work in Menands, NY

    ETL Developer

    Versant Health, Albany, NY

    AI Assistant is available now!

    Feel free to start your new journey!