Urgent need for Informatica Developer (with Strong Oracle PL/SQL) - Plano,TX

Nascent Global - Plano, TX

Full-time - Mid Level

Plano, TX

Professional, Scientific, and Technical Services

About the position

The Informatica Developer position in Plano, TX, is a hybrid role requiring expertise in developing complex ETL workflows using Informatica Powercenter. The role involves creating data mappings from various data sources and developing Unix scripts, with a focus on performance tuning and SQL proficiency. The candidate will work independently and coordinate with a distributed team, providing regular updates to management.

Responsibilities

• Develop complex ETL workflows using Informatica Powercenter.
• Create data mapping to ingest data from various sources including flat files, RDMS, Hive, and REST APIs.
• Develop Unix scripting for data processing tasks.
• Perform unit testing and develop test cases for ETL processes.
• Interact and coordinate with a distributed team to ensure project success.
• Provide regular task status updates to management.

Requirements

• Strong experience with Informatica Powercenter for ETL development.
• Proficiency in Oracle PL/SQL, including writing complex SQL queries and creating views/materialized views.
• Strong skills in performance tuning of targets, sources, mappings, and SQL queries.
• Experience with Unix commands and scripting.
• Familiarity with MuleSoft tools for integration.

Nice-to-haves

• Experience with data ingestion from REST APIs.
• Knowledge of Hive for data processing.