W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J37826

  • Specialized Area:

    ETL

  • Job Title:

    ETL Informatica Developer

  • Location:

    Amelia,OH

  • Duration:

    12 Months

  • Domain Exposure:

    Manufacturing, Education, IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

Job Description

Title: ETL Informatica Developer

Location - Amelia, OH

Duration - 12 months

Key Skills-

8+ years of working experiences with ETL Informatica PowerCenter Tool

8+ years of experience in writing and executing PL/SQL programming

8+ years of experience with Unix Shell Scripting

Understanding of dimensional data models (STAR Schema)

Design, Code, and Test Informatica ETLs

Coding SQL Stored Procedures and Triggers in SQL Server/Oracle

Ability to performance tune SQL code and Informatica components

UNIX Shell Scripting

Ability to conform with established coding standards

Roles & Responsibilities-

Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications and Performs source system analysis as required

Creates ETL Mappings, Mapplets, Workflows, and Worklets using Informatica PowerCenter and prepare corresponding documentation.

Design and develop database objects like Tables, Procedures, Functions, Indexes and Views using SQL Server, Oracle

Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process

Provide Support for QA Testing

Assist and resolve production issues


Apply Now
Equal Opportunity Employer

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract