Epicareer Might not Working Properly
Learn More
3

IT Specialist (SQL, PL/SQL, Oracle 12c,19c, Informatica mappings, Rhapsody 7, XML, Data Quality 8.x)

Salary undisclosed

Checking job availability...

Original
Simplified


Day-to-day tasks include, but are not limited to:

  • Working with large and complex Oracle data warehouses, data marts and OLTP databases.
  • Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.
  • Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Center and Rhapsody.
  • Guiding the ETL team in shaping, enhancing and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture
  • Investigating and resolving difficult design and build issues, data loading and data integrity issues.
  • Performance tuning Informatica/Rhapsody workflows.
  • Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets.

IT Specialist
Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.

Expert 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

  1. 84 Months Experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
  2. 48 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring and managing millions of records of data including XML and HL7 message formats
  3. 84 Months Experience using Informatica 8.x or higher, including 10.5, in a data warehouse environment including warehousing concepts, design and development of complex mappings
  4. 84 Months Experience with Informatica Data Quality 8.x or higher, including 10.5, processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge
  5. 84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing
  6. 72 Months Experience working with Health Data with HIPAA, HL7 or similar standards
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job