LINKS
ABOUT
SOCIAL

info@tekletics.com

Tel: 303-332-2946

ASU Skysong

1475 N. Scottsdale Rd.

Scottsdale, AZ 85257

  • Black LinkedIn Icon

JOIN OUR TEAM

Learn valuable skills in the fast growing world of Big Data and Business Intelligence. We put you into real world projects so you can earn and learn right away.

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

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

  • 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