Skip to main content
Tallo logoTallo logo

Find Jobs

Find Jobs Near You – Available Work in Your Location

Rainbow bridge illustration

Find your next move.

Your current job is just the starting point. See where workers like you actually went next.

Powered by real career transition data in the U.S. labor market over the past 20 years. How it works

Requires a free account

Skip to job details

Back to Results

Apply for this opportunity

To apply for this job, you'll continue to an external website or email application.

Epsilon Solutions Ltd.

PowerCenter/IICS ETL Developer

Job Description

PowerCenter/IICS ETL Developer (Plano, TX, 75024) | 10/31/23

Job Description Technical Requirements:

Designing and development of Informatica PowerCenter ETL, developing complex transformations.

Excellent skills in SQL and PL/SQL Stored procedures, packages and functions using Oracle and PostgreSQL.

Design, develop, validate and deploy the Informatica ETL processes using Informatica data integration and data quality tools.

Excellent analysis, debugging and troubleshooting skills, performance tuning and problem solving required.

Experience in creating SCD Types mappings and Datawarehouse concepts to build the Datawarehouse.

Must have ability to develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, XML, Oracle, SQL Server, Postgres, SAP Systems and Web services.

Experience in preparing test scripts and test cases to validate data and maintaining data quality

Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.

Experience in Unix shell and Python scripting.

Experience in IICS mapping task, task and task flow

Deep knowledge on installation of secure agents, configuring agent server, encryption, and authentication protocols in different Informatica cloud services, recommending optimal values for task level

Qualifications:

10+ years of experience in Informatica PowerCenter and IICS Development skills.

Extensive experience in Oracle and PostgreSQL SQL and PLSQL (PG/PLSQL) Coding.

Experience in conversion of ETL mappings from Oracle to Postgres.

Good analytical and problem-solving skills for design, creation and testing of programs.

Good communication skills to interact with team members, support personnel, and provide technical guidance and expertise to customers and management.

Good interpersonal skills to interact with customers and team members.

Ability to work in a self-directed work environment.

Ability to work in a team environment.

Required Skills :

ETL

Additional Skills :

Database DeveloperThis is a high

PRIORITY

requisition. This is a

PROACTIVE

requisition

PowerCenter/IICS ETL Developer 1etl United States

Review key factors to help you decide if the role fits your goals.
Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
72
out of 100
Average of individual scores