Description

You will lead the design, development, and implementation of a data integration hub using agile methodologies.

Responsibilities

• Lead agile development teams through the full SDLC, including the creation of Epics, User Stories, and Tasks.
• Develop complex SQL scripts to transform source data into dimensional models, Oracle views, and materialized views.
• Build automation using Informatica PowerCenter and IICS to acquire and transform data from diverse external sources.
• Collaborate with Architects and Data Engineering teams to design optimal data architectures and acquisition strategies.
• Perform cost/benefit analysis and technical studies to identify alternative solutions for automating processing or improving existing systems.
• Verify and validate SQL scripts, Informatica automation, and database views through automated testing methods.

Required Skills

• 8+ years of experience in data integration and systems analysis.
• Expertise in developing complex SQL scripts for data transformation.
• Hands-on experience with Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).
• Proficiency in Oracle database environments, including the creation of views and materialized views.
• Experience working within an Agile framework and participating in all sprint ceremonies.
• Ability to translate business requirements into detailed technical specifications and diagrams.
• Knowledge of REST and SOAP web services.
• Bachelor’s degree in Computer Science or Information Systems.

Key Skills

Education

Bachelor’s degree in Computer Science, Information Systems