Description

You will be a member of the agile development team building and supporting a data integration hub.

Responsibilities

• Implement and configure the infrastructure for the data integration hub.
• Design, develop, and implement the data integration hub using agile methodology through all SDLC phases.
• Develop complex SQL scripts to transform source data into a dimensional model, including creating views and materialized views in Oracle.
• Develop automation using Informatica IICS or Power Center to pull and transform data from external sources.
• Enhance and maintain the Java web site that provides Tableau dashboards.

Required Skills

• 8+ years experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC or Power Center.
• 8+ years experience acquiring and integrating data from multiple sources (Snowflake, Oracle, SQL Server, Excel, Access, Adobe PDF) using Informatica for Tableau visualization.
• 8+ years experience designing and developing complex, efficient SQL scripts.
• 8+ years experience as a system analyst on data analytics, performance management, or data warehousing projects.
• Proficiency in technical writing and diagramming tools (e.g., Visio, Erwin) and Microsoft Office Suite.
• Experience interpreting business requirements and proposing necessary enhancements.
• Familiarity with data acquisition strategies and implementation designs.
• Knowledge of HTML, CSS, Javascript, Jquery, APIs, Python.
• Experience working within an agile development framework.

Key Skills

Education

Any Graduate