Matomo Code

Data Warehousing Specialist – DWS202007011

Date Posted: 07-28-2020​​, Job Code: DWS202007011

Job Responsibilities:

  • Develop and Deliver Data Infrastructure Services for two work streams under Bank BI Business Controls Management Program (Bank Key Risk Indicators (KRIs) Program & Centralized Repository for Remediations and Tax Automation – Automation)
  • Work towards the methodologies and principles of Data Warehousing and ETL processes.
  • Design, develop and performance fine tuning of IBM Infosphere DataStage jobs, Unix scripts and PL/SQL statements in RDBMS databases.
  • Interact with clients to gather the Business requirements.
  • Involve in all phases of Software Development Life Cycle (SDLC) such as Requirements analysis, Design, Development, Testing (Unit, Integration, Regression, and User Acceptance), Production Deployment for data warehousing and business intelligence projects.
  • Prepare high level design and low-level design documentation.
  • Provide Root Cause Analysis (RCA) for assigned technical issues, and to provide solid updates related to assigned issues.
  • Facilitate technical sessions to gather relevant input required to proceed with the next steps towards finalization and completion of design and development work.
  • Communicate the project risks or issues encountered during the Analysis, Design, and Development phases and bring them to the Project Core team.
  • Perform code reviews against other developers DataStage jobs.
  • Working closely with the QA team so that the bugs/enhancements are resolved in a timely manner.
  • Provide post-deployment support for the jobs once implemented in production.
  • Discussion with BBIA and Business Partners on Business Requirements.
  • Analysis on business developed and supported UDA’s (User Defined Applications) under each work stream in its current state.
  • Follow Agile methodology and create technical Stories, Tasks, To Do for the Analyze and Finalize Requirements, Solution
  • Design Review approvals, Development, Testing, Control  M jobs, Data validation Pre Implementation BARB Approvals, Production Migration, Historical data load and Production data validation and Ongoing Support activities.
  • Engage in data Validation with BBIA SME’ and receive approval for implementation
  • Strong understanding of data warehousing concepts, schemas, Slowly Changing Dimensions, Facts and Dimensions and implementation of the same.
  • Develop and support Control M scripts and jobs to support projects and DW loads.
  • Balance multiple projects and work both independently and as part of a team.
  • Facilitates root cause analysis of system issues to minimize impact and future occurrences.
  • Collaborate with various stakeholders to analyze the information, business problem and select appropriate architecture design solutions.
  • Design system components which reconcile and audit the results of the extract/transform from source system to the target system
  • Analysis and fix defects found in quality assurance environment
  • Implement automation process using scheduling tool Control M
  • Prepare Implementation plan, backups and backout plan and support the release activities.
  • Migration from Data Mart On-Premises to Cloud Based Data Marts (Snowflake Cloud Computing)

Skills Requirement:

  • Must possess a Bachelors degree in Computer Science/ Computer Engineering/Software Engineering/Computer Applications/ Information Technology/ Information Systems/ Electrical or Electronics/ Mathematics or related field or equivalent degree
  • Others: Java, J2EE, ETL, IBM datastage, RDBMS, IBM Infosphere DataStage jobs, PL/ SQL, Data Warehousing, Business Intelligence, DB2, Netezza, UNIX, Linux, Mainframe, Windows, Hadoop, MapReduce, HDFS, HBase, Hive, Pig, Sqoop, and Unix & Linux Shell scripting

Submit resume to: usitcareers@egrovesys.com

ALWAYS ON THE LOOK OUT

We’re always looking for the right people to join our team. Even if you don’t find suitable roles listed on our website at this time, please send us your details to be considered for other positions in future.

CALL US ON 603 791 4890 (or) email usitcareers@egrovesys.com with your details

APPLY NOW:

If you like us to email you when a position is available, kindly fill out the below form.

Job Alert
reCAPTCHA
Get Quote
close slider
Contact Us
Your IP Address is : 3.236.64.8
Confirm that you are not a Bot