ZipRecruiter
Job Description
Role:
Data Warehouse Systems Architect Location:
Albany, NY (Remote) Duration:
06 Months Plus Visa:
Any visa except OPT & CPT. (As per EC requirement) End Client:
Confidential till resume selection Rate:
$65 on CTC Job Description
Daily Tasks include: Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing Data marts. Participate and contribute to DW/BI projects throughout the project lifecycle. Establish written best practices, procedures, and generally provide guidance on DW/DM data model design. Create and maintain up-to-date documentation for all supported DW/DM, ETL processes. Plan, create, modify, maintain, test, and implement code in support of: Source System extraction processes for the Data Warehouse. ETL processes. BI Dashboards and reports (R, Python). Extracting business rules from existing Data Warehouse built with Information Builders software toolset: WebFOCUS, RSTAT, Data Migrator, and Performance Management Framework (PMF). Mandatory Qualifications
Expert 84+ Months: Systems Architect - Defines the architecture of a computerized system to fulfill certain requirements, including breakdown into components, interactions, interfaces, and technologies. Candidate should be able to guide large teams and has extensive industry experience, considered at the top of their field. 84-month experience in designing and implementing data warehouse solutions supporting statutory accounting/reporting, premium analysis for worker’s compensation and insurance industry. Requested Qualifications:
84-month experience in designing and implementing transactional systems supporting billing, collection, policy administration, and premium calculation for worker’s compensation and insurance industry. 84-months Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in workers Compensation Insurance and industry working with ERwin. 84-months experience with developing and maintaining predictive systems written in R and Python using TIBCO TERR and Automation services. 84-months experience with TIBCO Spotfire Analyst, Web Player, and Business Authors, using Iron Python, Java Scripts. 84-months experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, RSTAT]. 84-months experience in developing, documenting, maintaining end-to-end ETL data pipeline using IBI Data Migrator. 84-months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design, and implementation. 48-month experience in Active Batch and Visual Build Pro. 48-month experience with Innotas. Note:
Candidates with valid LinkedIn ID & genuine references will have a strong point to get an interview. Please share your resume if the above requirements match your profile. Independent Consultants Only
(as per EC). Mention your visa status & current location in the email. Kind regards, Mustafa Fouzan Resource Manager Resource Informatics Group, Inc (RIG) 400 E Royal Ln, Suite 218, Irving, TX 75039 Email:
fouzan@rigusinc.com Cell: 972-366-5085 | Fax: 972-692-8663 (F) www.RIGUSINC.com
| E-Verified Company Stay Safe Stay Indoors Break the Viral Chain
#J-18808-Ljbffr
Data Warehouse Systems Architect Location:
Albany, NY (Remote) Duration:
06 Months Plus Visa:
Any visa except OPT & CPT. (As per EC requirement) End Client:
Confidential till resume selection Rate:
$65 on CTC Job Description
Daily Tasks include: Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing Data marts. Participate and contribute to DW/BI projects throughout the project lifecycle. Establish written best practices, procedures, and generally provide guidance on DW/DM data model design. Create and maintain up-to-date documentation for all supported DW/DM, ETL processes. Plan, create, modify, maintain, test, and implement code in support of: Source System extraction processes for the Data Warehouse. ETL processes. BI Dashboards and reports (R, Python). Extracting business rules from existing Data Warehouse built with Information Builders software toolset: WebFOCUS, RSTAT, Data Migrator, and Performance Management Framework (PMF). Mandatory Qualifications
Expert 84+ Months: Systems Architect - Defines the architecture of a computerized system to fulfill certain requirements, including breakdown into components, interactions, interfaces, and technologies. Candidate should be able to guide large teams and has extensive industry experience, considered at the top of their field. 84-month experience in designing and implementing data warehouse solutions supporting statutory accounting/reporting, premium analysis for worker’s compensation and insurance industry. Requested Qualifications:
84-month experience in designing and implementing transactional systems supporting billing, collection, policy administration, and premium calculation for worker’s compensation and insurance industry. 84-months Data Modeling experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas in workers Compensation Insurance and industry working with ERwin. 84-months experience with developing and maintaining predictive systems written in R and Python using TIBCO TERR and Automation services. 84-months experience with TIBCO Spotfire Analyst, Web Player, and Business Authors, using Iron Python, Java Scripts. 84-months experience with Information Builders Software Toolset [WebFOCUS, iWay WebFOCUS Developer Studio, Data Migrator, RSTAT]. 84-months experience in developing, documenting, maintaining end-to-end ETL data pipeline using IBI Data Migrator. 84-months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design, and implementation. 48-month experience in Active Batch and Visual Build Pro. 48-month experience with Innotas. Note:
Candidates with valid LinkedIn ID & genuine references will have a strong point to get an interview. Please share your resume if the above requirements match your profile. Independent Consultants Only
(as per EC). Mention your visa status & current location in the email. Kind regards, Mustafa Fouzan Resource Manager Resource Informatics Group, Inc (RIG) 400 E Royal Ln, Suite 218, Irving, TX 75039 Email:
fouzan@rigusinc.com Cell: 972-366-5085 | Fax: 972-692-8663 (F) www.RIGUSINC.com
| E-Verified Company Stay Safe Stay Indoors Break the Viral Chain
#J-18808-Ljbffr