premier it Solutions
Direct SmartRecruiters career site

Sr. ETL Developer

Location
Tempe, AZ · On-site
Job type
Full-time
Level
Lead / Staff
Education
Bachelor's degree
Listed
Today

Skills & highlights for this role

  • Informatica PowerCenter
  • ETL mapping development
  • Teradata
  • Oracle
  • SQL
  • PL/SQL
  • T-SQL
  • Unix/Linux Shell Scripting
  • Slowly Changing Dimensions (SCD)
  • Change Data Capture (CDC)
  • ETL performance tuning

Also useful

  • Apache Spark
  • Amazon S3
  • HDFS
  • Sqoop
  • Azkaban
  • GitHub
  • Teradata Parallel Transporter (TPT)

About the role

§ Experience in using Informatica PowerCenter 9.6.1/9.5/9.1/8.6.1/8.1.1/7.1 - Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager and Admin Console.

§ Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.

  • § Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture.
  • § Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned Transformations to make them more efficient in terms of session performance.
  • § Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings.
  • § Instrumental in setting up standard ETL Naming standards & BEST Practices throughout the ETL process (Transformations, sessions, workflow names, log files, input, variable, output ports).
  • § Database experience using Teradata 14.10/14, PostgreSQL, H2 Database, Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2005/2000, AS400, DB2 and MS Access. Also used SQL Editors such as Teradata SQL Assistant, H2 Console, TOAD, SQL PLUS and SQL Analyzer.
  • § Experience on using Teradata Parallel Transporter (TPT) load protocols like LOAD, UPDATE STREAM & EXPORT.
  • § Experience in using Teradata Macros, Query banding and BTEQ Scripts on Linux/Unix.
  • § Strong experience using T-SQL, PL/SQL Procedures/Functions, Triggers and Packages.
  • § Experience in Unix/Linux Operating System and Shell scripting.
  • § Experience in integration of various data sources like Teradata, Oracle, PostgreSQL, S3, HDFS, MS SQL Server, Flat Files, and XML Definitions.
  • § Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.

Qualifications & Requirements

  • Bachelor of Engineering
  • (Computer Science)

Additional Information: All your information will be kept co

  • Informatica PowerCenter 9.6.1/9.5/9.1/8.6.1/8.1.1/7.1
  • Admin Console
  • Informatica Developer
  • OWB10g
  • Apache Spark
  • Azkaban
  • GitHub
  • PostgreSQL
  • Amazon S3
  • HDFS
  • Teradata 13.10/14/14.10/15.10
  • Oracle 11g/10g/9i/8i
  • MS SQL Server 2005/2000,
  • MS Access
  • DB2
  • AS400
  • H2 Database
  • SQL, PL/SQL
  • C, C++, Data Structures
  • Unix Shell Script
  • Teradata SQL Assistant
  • H2 Console
  • SQL plus
  • PL/SQL Developer
  • Toad
  • SQL* Loader
  • Sqoop
  • Windows Server 2003/2008 nfidential according to EEO guidelines.

About the Company

Premier IT Solutions is a leading provider of business-to-business e-commerce application implementation and integration services. Our employees are deployed in Fortune 500 companies.

We work closely with companies like IBM, Cameron International, Konica Minolta, Amcor PET Packaging, Nestle, Protein Design Labs, International Paper, Zachry Corporation, NEW Corp. to name a few, in development and implementation of complete solutions in the logistics and supply chain arenas-with a focus on e-purchasing systems for both commercial and public sector organizations.

Critical to the success of e-commerce initiatives is to fully integrate them with other mission-critical applications including Enterprise Resource Planning, Customer Relationship Management.

Read the original posting

From premier it Solutions's careers page, first listed on Rolev.ai on November 12, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Sr. ETL Developer role at premier it Solutions, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Sr. ETL Developer job at premier it Solutions located?

This Sr. ETL Developer position at premier it Solutions is located in Tempe, AZ (On-site). Always check premier it Solutions's application page for specific state eligibility or relocation policies.

What qualifications are required for Sr. ETL Developer at premier it Solutions?

For the Sr. ETL Developer role, premier it Solutions highlights a bachelor's degree; experience with Informatica PowerCenter, ETL mapping development, Teradata, Oracle, SQL, PL/SQL. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the Sr. ETL Developer position at premier it Solutions?

This listing links directly to premier it Solutions's SmartRecruiters application page. You can apply directly on premier it Solutions's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.