Start Date: ASAP Type: Temporary Project Estimated 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 Quality • Experience with Informatica Data Catalog functionality; • Experience with Informatica IDMC Cloud Performance Tuning
Responsibilities 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.
Why Apply
• Join a company that provides multiple ways to retain great skills and talent: part-time employees have opportunities to become full-time, and skilled temporary employees can become permanent;
• Work with a great team of professionals in a friendly and supportive work environment where management provides all needed direction without micromanagement;
• Work in a safe and secure location with an onsite data center and major dining options within walking distance;
• Benefit from multiple project extensions;
• Get an opportunity to work extra hours to increase your bi-weekly paycheck;
• Receive support and advice from Vitaver consultants who are already working at our Client’s site;
• Get extra cash by participating in the Vitaver Successful Completion Bonus Program;
• Always get paid in full and on time.