Informatica IICS ETL Developer

Randstad

Plano, TX, United States

12 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$112,320.0 - $134,410.0

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Programming Interfaces (APIs) Data Analysis Unit Testing CA Workload Automation Ae Unix Continuous Delivery Extract Transform Load (ETL) Data Mapping Data Warehousing Database Design Apache Hive Python (Programming Language)

+17 more

Performance Tuning Ansible Standard Sql PL-SQL SQL Databases Subversion Tableau (Software) Unix Commands Scripting Informatica Powercenter IBM UrbanCode Deploy Integration Frameworks Bitbucket Restful APIs Software Version Control Jenkins Mulesoft

Job description

Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter. Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs.

Requirements

Responsible for developing Unix scripting. Proficiency in MuleSoft tools desired. Must be able to work independently with minimum supervision. Responsible to develop test cases and perform unit testing. Must be able to interact and co-ordinate with distributed team.

Must have good communication skills. Responsible to provide regular task status update to the management. Mandatory skills: Technically strong in Informatica Power center.

Technically strong in performance tuning of targets, sources, mappings and SQL queries. Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views. Strong in UNIX commands and Scripting. Good in MuleSoft Integration. Desired skills: Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible).

Expert in PL/SQL programming and Database design, with strong data analysis skills, Responsible for developing Unix scripting. Proficiency in MuleSoft tools desired. Must be able to work independently with minimum supervision. Responsible to develop test cases and perform unit testing. Must be able to interact and co-ordinate with distributed team., Self-managed and proactive communicator

Unix scripts

Autosys

Informatica for ETL

Previous experience of working in a data warehouse project is a plus

Python programming

Tableau/reporting experience

Experience in working with Mulesoft and other API technologies.

Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)