Data Warehouse Analyst Job at MDA Edge, Tallahassee, FL

  • MDA Edge
  • Tallahassee, FL

Job Description

Job TitleEstimated Duration: 12+ months with possible extensions Work Setting: This job is to be performed onsite Monday-Friday, during business hours. Flexibility for occasional remote work for specific reasons is at the discretion of the hiring manager.Required:IT work experience utilizing data management tools, business intelligence tools, and data warehousing (7+ years).Data Integration and Data Warehousing experience with Informatica IDMC tools (IDMC tools like IDMC CDI, MI, CAI, etc.) (7+ years).Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT).Experience designing, developing, and supporting ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and Informatica on-prem solutions (4+ years).Experience with data warehouse and data mart concepts.Experience with model transactional data for data warehousing.Experience administering IDMC platform, Secure Agent Infrastructure and Snowflake Data Cloud platform for statewide adoption.Experience in relational database platforms including DB2, SQL Server, Snowflake and Oracle.Experience with Redhat Linux application administration like security patching applications, managing disk filesystems, managing wrapper and auto-startup scripts.Experience with IDMC Connectors to perform Change Data Capture solutions like PowerExchange and other widely used connectors like relational, ServiceNow, etc..Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.Experience designing data models for Business Intelligence tools like Power BI, Tableau and Cognos and other reporting tools.Experience with Informatica on-premises products like PowerCenter and Data QualityExperience with Informatica Data Catalog functionality.Experience with Informatica IDMC Cloud Performance TuningResponsibilities include but are not limited to the following:Prototypes, builds and tests Power BI and Cognos reports/dashboards.Ensures data warehouse metadata is collected and maintained.Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics.Assists with the development and maintenance of methods and practices documentation.

Job Tags

Work experience placement, Casual work, Remote work, Monday to Friday

Similar Jobs

DeleteMe

Remote Privacy Advisor Job at DeleteMe

 ...removing exposed personal data (PII) from the open web...  ...across a wide range of online sources Investigate...  ...volumes of tickets, data entries, investigations,...  ...volume, accuracy-sensitive work ~ Clear and confident...  ...Birthday Off ~ Work From Home Stipend ~ Cell Phone... 

Farrar Corp

Administrative Team Lead Job at Farrar Corp

 ...efficient climate solutions for buildings, homes and transportation, it's our...  ...benefits designed for you to Thrive at work and at home. We boldly go. Where is...  ...skills. Annual Base Salary Range or Hourly Base Pay Range: $72,611.66 - $101,394.99 Compensation... 

CIRCUIT CHECK INC

Electronics Engineering Technician Job at CIRCUIT CHECK INC

 ...provider of automated test systems and test fixtures for complex electronic products for the automotive, military/aerospace, medical,...  ...Our design staff includes electrical, software, mechanical engineers, and project managers. Our systems are supported by staff throughout... 

BJC Healthcare

Clinical Pharmacist Specialist - Amb Care Job at BJC Healthcare

 ...specialty disease states? Barnes-Jewish Hospital is seeking a Clinical Pharmacist Specialist to support a newly developed outpatient clinical service,...  ...locations. you'll work with doctors leading their fields in ground-breaking therapies. And you'll work with state-of... 

PCC MEDICAL HOLDINGS LLC

Travel Ultrasound Tech Job at PCC MEDICAL HOLDINGS LLC

 ...Job Description Job Description Travel Ultrasound Technologist Primary Care Location: Georgia & Piedmont Region Position Type: Travel / Remote & Hybrid Schedule: 4 days clinical/travel + 1 day administrative Mileage: Paid mileage reimbursement Position...