Address
Form of workPL/SQL Developer with Informatica
Location: Plano, TX
Duration: 12 months
Description:
Location: Plano, TX
Duration: 12 months
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.
- Responsible for developing Unix scripting.
- Proficiency in MuleSoft tools desired.
- Responsible to develop test cases and perform unit testing.
- 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
- 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 Unbuild/Jenkins, IBM UDeploy/Ansible)
As an equal opportunity employer, ICONMA prides itself on creating an employment environment that supports and encourages the abilities of all persons regardless of race, color, gender, age, sexual orientation, citizenship, or disability.
