This is 100% onsite work position based in Tallahassee,FL. Apply only if you are willing to relocate.
Education:Bachelor’s or Master’s Degree in Computer Science, Information Systems, or other related field. One year of relevant work experience may be substituted for each year of required education.
Required Experience:
- · IT work experience utilizing data management tools, business intelligence tools, and data warehousing
- · Experience in Data Warehousing and Data Integration
- · Experience designing, developing, and supporting ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and Informatica on-prem solutions
· Extensive knowledge of data warehouse and data mart concepts
· Ability to model transactional data for data warehousing usage
· Knowledge of and skill in Snowflake cloud data warehouse functionality
· Extensive knowledge of and expert skill in use of Informatica PowerCenter Cloud Platform
· Knowledge of and skill in Informatica Data Quality functionality Knowledge of and skill in Informatica Data Catalog functionality
· Knowledge of and skill in Power BI, Tableau, and other reporting tools functionality
· Knowledge of and skill in relational database platforms including DB2, SQL Server, and Oracle
Responsibilities:
· Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs
· Analyzes transactional data stores and develops data warehouse models to optimize the warehouse data stores for reporting and analytics
· Creates designs, diagrams, and documents to support data integration and data warehouse solutions
· Ensures data warehouse metadata is collected and maintained
· Coaches and mentors peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
- Assists with the development and maintenance of methods and practices documentation