376 Informatica ETL Developer
$100,000–$120,000 year
On-sitePittsburgh, Pennsylvania, United States
Job Summary
Conduct data movement processes and advanced ETL development using Informatica, PL/SQL, and Oracle to extract data from multiple sources into various target platforms. Analyze legacy data structures to design extract, transform, and load processes, then plan and execute unit tests while maintaining high-volume, multi-terabyte 24/7 data warehouse applications. Manage ETL configurable artifacts, troubleshoot subject area issues, and collaborate with cross-functional teams to implement optimal data integration solutions. Maintain a 24/7 schedule with on-call rotation and deliver projects within tight deadlines.
Required 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 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 strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica
- Skilled in source systems analysis and data extraction from various sources such as Flat files, Oracle, and other heterogeneous data sources
- Capability in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making
- Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions, and batches
- A team player, with the ability to work individually and meet tight deadlines
- Excellent communication skills, both verbal and written, and can clearly articulate complex messages and requirements
- Collaborative, detail oriented with superior analytical, problem solving, pragmatism and organization skills
- Basic Mainframe knowledge including extracting data from flat files
- Oracle (PL/SQL)
- Query optimization
- Location: Pittsburgh, PA (relocation assistance is offered)
Desired Qualifications
- Power exchange
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.