Informatica Consultant-248

Preston-Hunter, Inc.
Taylor, TX
14 Feb 2025

Vacancy expired!

  • 1 Year Contract- Possible Extensions; 40 hrs/week

  • W2 Employee Only- NO CORP to CORP

  • Starting range $62+/hr, DOE

JOB DESCRIPTION ERCOT is looking for a hands-on Informatica consultant with prior experience in developing Star-Schema Data Marts with Type 2 Dimensions. Ideal candidate will have prior experience in working with an environment very similar to Ercot which includes (Informatica, Cognos, SQL, PL/SQL) to minimize the ramp up time so can begin working immediately on ETL development activities. Consultant will be part of a talented software team that works on multiple applications and are expected to provide solution for the problems.

RESPONSIBILITIES
  • Coordinate and deliver on tasks related to ETL and/or Business Intelligence development
  • Complete and submit deployment request documentation and support migration activities
  • Coordinate with other teams at ERCOT for Connectivity, Version/Patch Update, Upgrade and Database activities.
  • Conduct and document unit tests and support integration testing

COMPETENCIES / SKILLS
  • In depth knowledge of ERCOT business functions and processes to determine impacts to a portfolio based on upcoming changes
  • Ability to mentor team members and lead complex efforts with little supervision
  • Excellent written and verbal Communication skills
  • Demonstrated ability to work with analysts and stakeholders for requirements definition
  • Expertise in data modeling and data modeling concepts

REQUIRED TECHNICAL SKILLS
  • Informatica
  • Unix/Linux OS
  • Oracle RDBMS
  • Cognos
  • PL/SQL
  • SQL

PREFERRED EXPERIENCE
  • Requires minimum 5 years of hands-on experience with Informatica ETL Power Center
  • Requires minimum 5 years of hands-on delivery experience in PL/SQL and SQL
  • Requires minimum 3 years of hands-on delivery experience in Cognos
  • Excellent understanding of data warehousing, business intelligence, ETL, and SDLC, and Agile concepts

EDUCATION• Bachelor’s degree in Computer Science is required, or related field, or an equivalent combination of education and experience is required. Preston-Hunter, Inc. is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: Preston-Hunter, Inc. is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at Preston-Hunter, Inc. are based on business needs, job requirements and individual qualifications, without regard to race, color, religion, national, social or ethnic origin, sex (including pregnancy), age, qualified disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by applicable laws or regulations in the locations where we operate. Applicants with a disability who require a reasonable accommodation for any part of the application or hiring process can contact Human Resources at the location(s) where you are applying. Preston-Hunter, Inc. will not tolerate discrimination or harassment based on any of these characteristics. In the event you feel you have been harassed or discriminated against, immediately report the issue to Preston-Hunter, Inc. Human Resources. Preston-Hunter, Inc. encourages applicants of all ages, except for minors as federal law prohibits. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document, I-9 Form, upon hire. Preston-Hunter, Inc. participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, Preston-Hunter, Inc. is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before Preston-Hunter, Inc. can take any action against you, including terminating your employment. Preston-Hunter, Inc. can only use E-Verify once you have accepted a job offer and completed the Form I-9. At this time, Preston-Hunter, Inc. does not sponsor work Visa’s, and all candidates must be eligible to be a W-2 employee working through Preston-Hunter, Inc. All offers of employment, if any, are conditioned on the provision of satisfactory proof of the individual’s right to work in the United States, as required by law
  • ID: #49205199
  • State: Texas Taylor 76574 Taylor USA
  • City: Taylor
  • Salary: $62 - $75
  • Job type: Contract
  • Showed: 2023-02-14
  • Deadline: 2023-04-14
  • Category: Et cetera