Data Warehouse Analyst, Advanced
NOVALINK SOLUTIONS LLC
contract
Posted on:
Location Type: Hybrid
Location: Tallahassee • Florida • United States
Visit company websiteExplore more
About the role
- Support cloud-based data integration initiatives by translating business needs into system and integration requirements
- Design, develop, and manage scalable ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) capabilities
- Collaborate with business stakeholders to document reporting and analytics requirements and validate that integrated data supports decision-making needs
- Support real-time and batch data flows, conducting data modeling for cloud data warehousing
- Convert legacy mainframe code into modern IDMC data integration workflows
Requirements
- Bachelor’s Degree in Computer Science, Information Systems, or other related field
- A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing
- 7 Years experience in Data Warehousing and Data Integration
- 4 Years 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
Benefits
- Health insurance
- Flexible work arrangements
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ETLELTdata integrationdata warehousingdata modelingInformatica Intelligent Data Management CloudInformatica PowerCenterInformatica Data QualityInformatica Data CatalogSnowflake