Informatica Developer
Job Title: Informatica Developer
Location: Phoenix, AZ (Hybrid)
Duration: 12 Months
Job Description:
We are seeking an experienced Informatica Developer to support the development and maintenance of enterprise data warehouse solutions. The ideal candidate will have strong expertise in ETL development, data warehousing concepts, and database programming.
Key Responsibilities:
Develop, implement, administer, and support ETL processes for large-scale data warehouse environments using Informatica PowerCenter .
Perform data analysis, requirement gathering, and data mapping for ETL workflows.
Design, develop, and maintain ETL pipelines using SQL Server, PL/SQL, and SQL Loader .
Create and optimize complex SQL queries , including joins, unions, and views.
Monitor and tune Informatica mappings and sessions to resolve performance bottlenecks across sources, targets, and transformations.
Implement database programming using PL/SQL , including stored procedures, triggers, and packages.
Work with UNIX shell scripting to support ETL processes and automation tasks.
Collaborate with data architects and business teams to support data warehouse design and deployment .
Required Skills:
Strong experience with Informatica PowerCenter .
Solid SQL development skills with complex queries and data transformations.
Hands-on experience with data warehousing concepts , including:
Dimensional Modeling
Star & Snowflake Schemas
Data Marts
Fact and Dimension Tables
Logical and Physical Data Modeling
Experience in performance tuning of ETL processes .
Knowledge of UNIX and shell scripting .
Preferred / Desirable Skills:
Experience with Netezza and Yellowbrick databases.
Prior experience in ETL design and development within large data warehouse environments.
Recommended Jobs
Senior Analyst, Credentialing Operations
Hi, we're Oscar. We're hiring a Senior Analyst, Credentialing Operations to join our Provider Operations team. Oscar is the first health insurance company built around a full stack technology plat…
District Manager
DISTRICT MANAGER JOB TITLE : District Manager REPORTS TO : Director of Sales/Operations COMPENSATION : $80,000-83,000 Base Salary + Bonus Opportunity up to $36,000 annually JOB TYPE: …
Freelancer | Corporate AV & Events
Calling freelancer's nationwide! We’re proud to work alongside a group of diverse professionals who are masters at their craft, pushing the limits of what’s possible, while remaining committed to…
Welder
CDI Custom Curb Adapters Job Posting CDI custom curb adapters is the nation's fastest curb manufacturer in the HVAC industry. We are a nation-wide company with manufacturing facilities located in …
Service Technician
Job Summary: We are looking for a Service Technician to join our growing team! The right candidate will have a strong service technician background and ASE certified. The day-to-day duties include per…
Certified Medical Assistant Float - Heartland Community Health Clinic - Peoria, Arizona, United States
Full-time Description $22-$28 an hour Full-time (40 hours per week) Varied Shifts Between 7:30am - 7:30pm (some Saturdays) 401K Employer Match Health Benefits Start Day 1 of Employment …
Retail Operations Manager (Chandler)
PetSmart does Anything for Pets – JOIN OUR TEAM! Retail Operations Manager About Life at PetSmart At PetSmart, Anything for Pets begins with our people. Every associate plays a vital role i…
Content Security Technical Program Manager
Job Summary: CONTENT SECURITY TECHNICAL PROGRAM MANAGER JOB SUMMARY The Walt Disney Studios Content Security organization is chartered with the securing and protection of all creative cont…
CDL Class A Solo OTR Truck Driver
DSL Express and partners now hiring Class A CDL Solo Truck Drivers for OTR and Teams! Company drivers with 2+ yrs of experience and a decent MVR/PSP score. Position available ASAP. Pay is perfor…
Remote Lead Data Analyst
This position is posted by Jobgether on behalf of a partner company. We are currently looking for a Lead IT Data Analyst - REMOTE. In this role, you will take charge of designing and developing analy…