ETL Informatica Developer - Data Warehouse Specialist

SmartRecruiters, Inc.; Fort Worth (TX); On-site; USD 75,000 - 110,000; Full time

Job summary

Career Guidant in the United States seeks an experienced Informatica ETL Developer to join our data warehousing team in Fort Worth. You will design, develop, test, and deploy ETL solutions, collaborate with business analysts, and ensure data quality across enterprise systems.

The ideal candidate has 2+ years in ETL and BI lifecycle, hands-on UNIX scripting, and a strong grasp of data modeling, performance tuning, and cross-functional delivery in a global environment.

Qualifications

• 2+ years of experience in ETL, reporting technologies and BI project lifecycle.
• Should have worked extensively in development projects involving Informatica.
• Experience in Enterprise data warehousing, system Analysis, Design, Development, Testing and Implementation of Data warehouse.
• Experience in all the phases of Data warehouse life cycle (SDLC).
• Experience in translating requirements into ETL code and building mappings/workflows in Informatica.
• Experience in Informatica performance tuning/partitions and bottleneck identification.
• Ability to work in a diverse, multi-stakeholder environment.
• Experience in Retail, CPG and Logistics Domain.
• Hands on UNIX/Shell scripting, Putty.

Responsibilities

• Collaborate with business analysts to translate requirements into ETL code.
• Develop mappings and workflows in Informatica using sessions and transformations.
• Tune Informatica performance and optimize mappings.
• Contribute to all phases of the data warehouse SDLC from requirements to deployment.
• Participate in a global delivery environment with cross-functional teams.

Skills

Informatica

ETL

Data warehousing

UNIX/Shell scripting

SDLC

Business analysis

Team collaboration

Retail/CPG/Logistics domain

Education

Bachelor’s degree or foreign equivalent

Tools

Informatica

PowerExchange

IDQ

Cognos

Job description

Career Guidant in the United States seeks an experienced Informatica ETL Developer to join our data warehousing team in Fort Worth. You will design, develop, test, and deploy ETL solutions, collaborate with business analysts, and ensure data quality across enterprise systems.

The ideal candidate has 2+ years in ETL and BI lifecycle, hands-on UNIX scripting, and a strong grasp of data modeling, performance tuning, and cross-functional delivery in a global environment.