Informatica ETL Developer – Oracle/PLSQL Data Warehouse

Techstra Solutions; Pittsburgh (Allegheny County); On-site; USD 100,000 - 140,000; Full time

Benefits offered by this job

Relocation assistance

Job summary

Techstra Solutions in Pittsburgh, PA seeks an Informatica ETL Developer to extract data from multiple sources, modify mappings, and build new ETL processes. You will work with leadership and engineering teams to identify and implement optimal data transfer solutions.

The ideal candidate has strong Informatica PowerCenter experience, Oracle/PL-SQL skills, and a track record of delivering scalable, reliable data integration in a fast-paced environment. Relocation assistance is offered.

Qualifications

• Bachelor’s degree or equivalent experience 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 of data warehouse development lifecycle and dimensional modeling.
• Adept at creating complex mappings and ETL strategies with Informatica.
• Experience with multiple data sources (Flat files, Oracle, etc.).
• Ability to gather requirements and document metadata for business rules and design.

Responsibilities

• Perform data movement processes and advanced ETL development activities using Informatica, PL/SQL, Oracle Database, SQL, and other technologies
• Analyze data structures in existing 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, environment, configuration files, documentation)
• Provide data analysis to support project definitions and troubleshoot issues
• Work independently or as part of a team to deliver ETL projects
• Follow standards and propose improvements
• Maintain a high-volume, multi-terabyte 24/7 data warehouse application
• Communicate effectively and collaborate with stakeholders
• Demonstrate attention to detail and strong analytical skills
• Experience managing projects and meeting deadlines

Skills

Informatica PowerCenter

ETL development

SQL

Unix scripting

Oracle

Data warehouse

Performance tuning

Education

Bachelor’s degree in CS/IS

Tools

PL/SQL

Oracle Database

SQL

Unix Shell

Job description

Techstra Solutions in Pittsburgh, PA seeks an Informatica ETL Developer to extract data from multiple sources, modify mappings, and build new ETL processes. You will work with leadership and engineering teams to identify and implement optimal data transfer solutions.

The ideal candidate has strong Informatica PowerCenter experience, Oracle/PL-SQL skills, and a track record of delivering scalable, reliable data integration in a fast-paced environment. Relocation assistance is offered.