Pentatho Developer

Pull Skil; Overbrook (SC); On-site; USD 80,000 - 120,000; Full time

Job summary

Pull Skil in Overbrook, SC is seeking a skilled Informatica Pentaho ETL Developer for a long-term contract. The role involves extensive data manipulation, implementing ETL processes, and working with large datasets from various sources, ensuring optimal performance in data warehousing scenarios.

The ideal candidate will have strong experience in data extraction, transformation, and loading using Informatica Power Center, as well as knowledge of cloud technologies. Excellent communication skills and experience with SQL, PL/SQL, and UNIX scripting are essential.

Qualifications

• Extensive work experience on data extraction and large volume data.
• Strong experience in data modeling using Star Schema and Snowflake modeling.
• Good understanding of cloud methodology and commonly used tools.

Responsibilities

• Responsible for development and support of ETL processes for large scale data warehouses.
• Experience working on data extraction, transformation, and loading from various sources.
• Hands on experience with Informatica's Data Quality Tool and SQL query development.

Skills

Data extraction

Informatica Power Center

Data modeling

PL/SQL programming

UNIX shell scripting

Cloud technology

Tools

Informatica Power Exchange

Informatica Data Quality Tool

Job description

Pull Skill Technologies Inc. is a leading software development company specializing in custom software applications.

Our creative and highly experienced software developers are able to provide solution to any software development challenges your business is faced with. By using Pull Skill Technologies Inc. you are guaranteed efficient access to the newest technology available. For your company this means cost savings, reduced risks, and flexibility. Our cutting edge team has years of development and support experience. Find out how Pull Skill Technologies Inc. can help you to grow your business more affordably.

Job Description

Informatica Pentaho ETL

Location: Spartanburg SC

Duration: Long Term Contract

Responsibilities

• Extensively worked on data extraction, transformation and loading data from various sources like databases (PostgreSQL, Oracle) and flat files.
• Experience working on large volume data.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Knowledge and experience with Informatica Power Exchange.
• Hands on experience with Informatica’s Data Quality Tool (plus).
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9.x/10.x.
• Experience in data modeling using Star Schema Modeling, Snowflake modeling, fact and dimension tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensive experience in ETL design, development and maintenance using Informatica Power Center v 9.x/10.x.
• Well versed in developing complex SQL queries, unions and multiple table joins and experience with views.
• Experience in database programming in PL/SQL (stored procedures, triggers and packages).
• Well versed in UNIX shell scripting along with Informatica CLI commands to start, schedule workflows.
• Experienced at creating effective test data and developing thorough unit test cases to ensure successful execution of the data, and used pager for notifying the alerts after successful completion.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.
• Experience with requirements gathering, understanding user requirements and coming up with effective designs and development of solution.
• Client plans to migrate from on-prem to cloud soon; so good understanding on cloud methodology, technology and commonly used tools.

Qualifications

• Extensive work experience on data extraction and large volume data.
• Experience working with Informatica Power Exchange.
• Experience in data modeling using Star Schema Modeling, and Snowflake modeling.
• UNIX shell scripting along with Informatica CLI commands.
• Good understanding of cloud methodology, technology and commonly used tools.

Additional Information

All your information will be kept confidential according to EEO guidelines.