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:

    J36993

  • Specialized Area:

    Informatica

  • Job Title:

    Informatica Developer

  • Location:

    Terrace,IL

  • Duration:

    11 Months

  • Domain Exposure:

    Healthcare, Pharmaceuticals, Manufacturing, Banking & Finance, Utilities/ Energy, 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:

This position is responsible for the development and maintenance of data warehouse and analytical environments to support financial, management and statutory reporting requirements along with enhancing and facilitating corporate decision making capabilities.

Job Responsibilities:

  • Independently design and develop solutions to support reporting, analytic and warehouse needs using the appropriate platform, tools and programming languages on assorted system requests.
  • Using independent judgment, analyze business requirements and work with client areas to produce specifications used in creation of the reporting and analytical solutions.
  • Maintain existing warehouse, reporting and analytic solutions by providing production support for troubleshooting and regular processing needs.
  • Ensure newly designed systems run as needed, perform validity check on production output.
  • Turn functional and data mappings into reporting, analytic and warehousing solutions.
  • Conduct performance tuning on new and existing systems to insure optimal efficiency.

Required Skills:

  • Sound understanding of data warehouse best practices, relational data structures and dimensional data modeling.
  • Strong knowledge of current relational database and big data software and query concepts
  • Advanced SQL skills and proficiency with Stored Procedures
  • Prior experience with architecting complex ETL processes.
  • Experience supporting large scale Enterprise Data Warehouses
  • Expertise with Informatica Power Center, Intelligent Data Lake or MS SQL Server SSDT/SSIS.
  • Experience with modeling tools like Erwin

Apply Now
Equal Opportunity Employer

ROBOTIC PROCESS AUTOMATION 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. ROBOTIC PROCESS AUTOMATION 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 ROBOTIC PROCESS AUTOMATION 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