| Datawarehouse Analyst || Candidates with 13+ exp || rate:$65/hr || Clinet : State of Florida at Tallahassee, Florida, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3032282&uid=426269d3e1ec400981bca1ae67c97c23 Hi, Position ID: 529221-DWA-IICS Title: On-Site Datawarehouse Analyst (Informatica IICS Cloud Data Integration tools and Snowflake) Location: Tallahassee, FL Pay Rate: DOE Length: Multi-Year Travel Required: none Telecommute: no Skills: "Datawarehouse Analyst (Informatica PowerCenter/Intelligent Data Quality/ Informatica IICS Cloud Data Integration tools/Enterprise Data Catalog/Power BI/Tableau)"; Snowflake enterprise data warehouse/data-lake-house design and development; Informatica IICS/ Snowflake Data Cloud Performance Tuning; IDMC; IICS/ Snowflake Data Cloud Administration; Test Scripts/Plan; ETL/ELT jobs; reporting and analytics; Informatica Data Catalog functionality; PowerExchange; Power BI/Tableau reports and dashboards; Data Governance; EDC, Axon, and CDGC; COBOL, JCL, DB2, SQL Server, Snowflake; Oracle; MS Office/Sharepoint; DOCUMENTATATION, Govt; Data Integration/mining/mart/population/stores/Design/management/Quality/usage/replication/ extraction/loading/cleansing/transforming; managing disk filesystems, managing wrapper and auto-startup scripts; Each staff member assigned to this project must have a background screening that is equivalent to a Level Two (2) screening standard. This is a fixed fee/hourly based project which is inclusive of travel, lodging, per diem expenses and all other costs associated with the completion of the associated tasks. Face to Face Interviews: At the hiring managers discretion, interviews may be conducted via Microsoft Teams or in person. Telecommuting: This job is to be performed onsite in Tallahassee, Monday-Friday, during business hours. Scope of Services Responsible for gathering and assessing business information needs and preparing system requirements. Performs analyses, development, and evaluation of data mining in the Snowflake cloud data warehouse environment which includes data design, database architecture, and data management utilizing Informatica PowerCenter, Intelligent Data Quality, and Enterprise Data Catalog. Uses data mining and data analysis tools including Power BI and Tableau. Reviews and validates data loaded into the data warehouse for accuracy. Interacts with user community to produce reporting requirements. Provides technical consulting to users of the various data stores and advises users on conflicts and inappropriate data usage. Responsible for prototyping solutions, building solutions, preparing test scripts, and conducting tests for Snowflake data population including data replication, extraction, loading, cleansing, and transforming the data. Responsible for enterprise data modeling. Maintains knowledge of software tools, languages, scripts, and s that effectively support the Snowflake cloud data warehouse environment. Education : Bachelors Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement. Mandatory Experience 13-15 years of professional experience in information systems engineering or another related field is required. A minimum of 10 years of IT work experience utilizing data management, business intelligence tools, and strong foundation-building data warehousing solutions. Extensive experience with Informatica IICS Cloud Data Integration tools and Snowflake is preferred. Primary Job Duties/ Tasks 1. Strong Data Integration and Data Warehousing experience with Snowflake Data Cloud and Informatica IICS Cloud Data Integration tools. 2. Strong Experience with Data Integration tasks like extraction, transformation, and load (ETL or ELT) tasks 3. Participates in strategic planning for the Snowflake enterprise data warehouse/data-lake-house design and development. 4. Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics. 5. Coaches and mentors peers in data warehousing concepts and the tools utilized to analyze data, design the warehouse models, and populate the warehouse. 6. Prototypes, builds, and tests Power BI and Tableau reports and dashboards. 7. Assists with the development and maintenance of methods and practices documentation. Job Specific Knowledge, Skills, and Abilities (KSAs) The knowledge, skills, and abilities desired for this position include, but are not limited to the following: 1. Experience designing data models for Business Intelligence tools like Power BI and Tableau. 2. Experience with Informatica on-premises products like PowerCenter and Data Quality. 3. Experience with ELT with Change Data Capture solutions like PowerExchange. 4. Experience with IBM Mainframes COBOL, JCL, and DB2 analysis. 5. Experience with IICS Cloud Administration and Snowflake Data Cloud Administration. 6. Ensures data warehouse metadata is collected and maintained. 7. Experience with Informatica IICS Cloud Performance Tuning 8. Experience with Snowflake Data Cloud Performance Tuning 9. Experience with Data Governance products, like EDC, Axon, and CDGC Keywords: business intelligence information technology microsoft mississippi Florida Idaho Datawarehouse Analyst || Candidates with 13+ exp || rate:$65/hr || Clinet : State of Florida [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3032282&uid=426269d3e1ec400981bca1ae67c97c23 |
| [email protected] View All |
| 07:47 PM 07-Jan-26 |