Job Description
Primary Job Duties/ Tasks
- Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools.
- Strong Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks
- Participates in strategic planning for the Snowflake enterprise Data Warehouse/data-lake-house design and development.
- Analyzes transactional data stores and develops Data Warehouse models to optimize the warehouse for reporting and analytics.
- Coaches and mentors' peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
- Prototypes, builds, and tests Power BI and Tableau reports and dashboards.
- Assists with the development and maintenance of methods and practices documentation.
A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing. Extensive experience with Informatica PowerCenter and Snowflake is preferred.
Key Knowledge, Skills and Abilities
- Experience designing data models for Business Intelligence tools like Power BI and Tableau.
- Experience with Informatica on-premises products like PowerCenter and Data Quality.
- Experience with ELT with Change Data Capture solutions like PowerExchange
- Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.
- Experience with IICS Cloud Administration and Snowflake Data Cloud Administration.
- Ensures Data Warehouse metadata is collected and maintained
- Experience with Informatica IICS Cloud Performance Tuning
- Experience with Snowflake Data Cloud Performance Tuning
- Experience with Data Governance products, like EDC, Axon, and CDGC