DON’T PAY TO LEARN…WORK AND LEARN!

Start a Career in Information Technology Today!

Join our team and learn valuable skills in the fast growing world of Big Data and Business Intelligence. We have internships and full time jobs that put you into real world projects so you can earn and learn right away. Positions are NOW OPEN for experienced data management executives and smart motivated people who are new to IT but want to be a part of one of the most innovative cloud services companies in the market.

Take a look at our current openings and let us know if you are interested by sending a cover letter and resume to us at info@hotfix2.com.

Junior Developer – Business Intelligence (ETL)

Job Responsibilities

The successful candidate will work with high level BI-ETL developers to convert legacy Teradata BTEQ scripts into Informatica mappings/workflows that will populate a new Hadoop/SQL Server Data Warehouse. Primary duties include, but are not limited to:

  • Building/interpreting design documents
  • Building/interpreting mapping documents
  • Building/completing test documents
  • Participate in technical design reviews and code reviews
  • Understand and adhere to ETL best practices
  • Develop and troubleshoot Informatica code
  • Participate in peer review sessions

Required Skills

  • Prior experience using MS Office (word, excel, outlook)
  • Excellent oral/written communication

Preferred Skills

  • Fundamental understanding of database concepts
  • Experience with UNIX scripting
  • Experience with large-scale data warehouses
  • ETL experience
  • Hadoop Experience
  • Java background
  • Background in transportation industry

Developer – Business Intelligence (ETL)

Job Responsibilities

The successful candidate will assist a senior level developer in coordinating junior level developers to convert legacy Teradata scripts to Informatica mappings utilizing Hadoop and MSSQL. The candidate will also have experience mentoring junior resources. The position requires a developer with experience in developing code and troubleshooting in multiple database environments. Primary duties include, but are not limited to:

  • Participates in all phases of the development lifecycle, with significant participation in the data integration design and development, advocating for standardization, reviewing performance results, and preparing for implementations.
  • Applies broad knowledge of data integration functions to accurately anticipate system or project impacts.
  • Enforces and maintains ETL best practices.
  • Performs technical design reviews and code reviews.
  • Ensures unit test is completed and meets the test plan requirements
  • Responsible for delivery of application technology solutions

Required Skills

  • BA/BS in related field, 5+ years of equivalent work experience in IT, or any combination of education and experience, which would provide an equivalent background
  • Multi database and/or multi programming language
  • Advanced skills in performance tuning, monitoring, and troubleshooting data integration solutions
  • Solid communication, interpersonal, and collaborative skills and a demonstrated ability for creative problem solving of business and technical challenges

Preferred Skills

  • Java background
  • Background in transportation industry
  • Experience moving data to/from the following: Teradata, DB2, Hadoop, SQL Server, Flat Files, DB2, SQL Server
  • UNIX operating systems
  • Experience with ETL tools (Informatica, Talend, etc.)

Technical Lead – Business Intelligence (ETL)

Job Responsibilities

The successful candidate will coordinate a team of mid and junior level developers to convert legacy Teradata scripts to Informatica mappings utilizing Hadoop and MSSQL. The candidate will also have experience mentoring junior resources. The position requires a proven leader in large-scale Data Integration and Date Warehousing environments. The candidate will work closely with customers’ internal development team to ensure project deliverables are met. Primary duties include, but are not limited to:

  • Maintains active relationships with customers to determine business requirements, leads requirements gathering meetings and reviews designs with the business.
  • Participates in all phases of the development lifecycle, with significant participation in the data integration design and development, advocating for standardization, reviewing performance results, and preparing for implementations.
  • Applies broad knowledge of data integration functions to accurately anticipate system or project impacts.
  • Establishes, enhances, implements, enforces, and maintains ETL best practices.
  • Owns the change request process and coordinates with other teams as necessary.
  • Develops and owns list of final enhancements.
  • Develops and defines application scope and objectives and supervises the preparation of technical and/or functional specifications
  • Performs technical design reviews and code reviews.
  • Ensures unit test is completed and meets the test plan requirements
  • Responsible for delivery of application technology solutions

Required Skills

  • BA/BS degree in related field, 7 or more years of experience (data warehousing and ETL) or any combination of education and experience, which would provide an equivalent background
  • at least 3 years’ experience as a project lead, team lead, etc. with the ability to mentor others, and provide troubleshooting support
  • Multi database and/or multi language (Teradata, Hadoop, DB2, MSSSQL, Flat Files, etc)
  • Expert skills in performance tuning, monitoring, and troubleshooting data integration solutions; solid communication, interpersonal, leadership, and collaborative skills and a demonstrated ability for creative problem solving of business and technical challenges
  • 2+ years’ experience in designing Data Integration solutions
  • UNIX operating systems

Preferred Skills

  • Java background
  • Background in transportation industry