Etl Developer (Informatica / Taradata)

STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING! 

Job Title: ETL Developer (Informatica / Taradata)
Location: Scottsdale, AZ
Role Type: W2 Only
Contract Length: 10 Months w/ Possible Extension

How to Apply: Please send resume and contact information to Rene May, Sourcing Specialist, at and reference job #218368.

Job Description/Responsibilities:

• Over 5-10 years IT experience in Design ETL solutions and data conversion strategy and solutions for multiple disparate systems using Oracle and Informatica
• Create end-to-end solution for ETL transformational jobs that involve writing Informatica workflows and mappings, and creating database Packages, procedures, and functions.
• Develop, maintain, and enhance Informatica Mappings, Workflows, and processes.
• Support proper functioning and performance tuning of Informatica platform.
• Develop stored procedures and triggers using DB2 database to support ETL jobs.
• Work effectively with the DBA teams to ensure that all approved development and deployment procedures are followed.
• Provide production support from development teams for existing systems, troubleshoot data and/or system issues.
• Identify root causes and resolve data related issues.
• Review and optimize query performance.
• Writing Test Strategies, Test Plans, Test Cases, and Test Closure document.

Required Qualifications/Experience:

• Over 5-10 years IT experience in Design ETL solutions and data conversion strategy and solutions for multiple disparate systems using Oracle and Informatica.
• Expert (5 Years hands on experience) in Informatica v9.1 or higher.
• Expert (5 Years hands on experience) in Oracle database development (SQL, PLSQL, Oracle tools).
• 3+ years Quality Assurance experience- Minimum 3 years of Python development.
• Expert in Create Data mapping documents to support ETL process.
• Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies.
• Converting functional specifications into ETL technical specifications and source to target mappings.
• Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc.
• Hands on experience with database Performance tuning like Oracle, Teradata, MSSQL Server, MySQL, and strong database languages like SQL, PL/SQL, TSQL, Unix Shell, Python and Perl Scripting.
• Good Experience in tuning of Informatica mappings and Database scripts and procedures.
• Experience in implementation of BI projects in a large-scale enterprise data warehouse environment.

S³ supports and adheres to customer COVID-19 vaccination policies, which may include the disclosure of vaccination status.

The S3 Difference

The global mission of S3 is to build trusting relationships and deliver solutions that positivelyimpact our customers, our consultants, and our communities.  The four pillars of our company are to:

• Set the bar high for what a company should do
• Create jobs
• Offer people an opportunity to succeed and change their station in life
• Improve the communities where we live and work through volunteering and charitable giving

As an S3 employee, you’re eligible for a full benefits package that may include:

• Medical Insurance
• Dental Insurance
• Vision Insurance
• 401(k) Plan
• Vacation Package
• Life & Disability Insurance Plans
• Flexible Spending Accounts
• Tuition Reimbursement