Informatica ETL Developer – Data Warehouse Specialist

BlueGreen Alliance Inc; Pittsburgh (Allegheny County); On-site; USD 90,000 - 140,000; Full time

Job summary

Techstra Solutions is seeking an Informatica ETL Developer to join our Pittsburgh team. This role focuses on extracting data from multiple sources into target platforms, modifying existing mappings and building new ones.

You will collaborate with leadership and engineering teams to identify optimal data transfer solutions and to implement effective ETL and data warehouse approaches. The ideal candidate has strong Informatica expertise, experience with Oracle and PL/SQL, and a proactive,

Qualifications

• Bachelor’s degree or equivalent in Computer Science, Information Systems or related field.
• 5+ years’ experience with Informatica PowerCenter and other tools.
• Strong subject matter expertise on ETL and Informatica best practices.
• Experience in analysis, design, development into OLAP environment.
• Strong experience in Unix Shell Scripting and SQL.
• Knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, repository management and administration.
• Adept in creating complex mappings using various transformations, and developing ETL mechanisms with Informatica.
• Skilled in source systems analysis and data extraction from sources like Flat files, Oracle, and other heterogeneous sources.
• Experience in performance tuning of ETL components and workflows.
• Excellent communication, collaboration and ability to meet deadlines.

Responsibilities

• Perform data movement processes and ETL development using Informatica, PL/SQL, Oracle, SQL and related technologies.
• Analyze data structures in legacy systems to design ETL and data warehouse structures.
• Plan and conduct Informatica ETL unit and development tests.
• Design, implement, test and maintain ETL components for multiple applications.
• Develop and manage ETL artifacts (code, config files, docs).
• Provide data analysis to support new project definitions and troubleshoot issues.
• Work independently or as part of a team to deliver ETL projects.

Skills

Informatica PowerCenter

ETL best practices

Unix Shell

SQL

Data warehousing

Dimensional modeling

Oracle PL/SQL

Performance tuning

Flat files

Source analysis

Education

Bachelor’s degree in CS/IS or related

Tools

Informatica PowerCenter

Oracle

PL/SQL

Unix

Job description

Techstra Solutions is seeking an Informatica ETL Developer to join our Pittsburgh team. This role focuses on extracting data from multiple sources into target platforms, modifying existing mappings and building new ones.

You will collaborate with leadership and engineering teams to identify optimal data transfer solutions and to implement effective ETL and data warehouse approaches. The ideal candidate has strong Informatica expertise, experience with Oracle and PL/SQL, and a proactive,