Datawarehouse Consultant recruitment in Bangalore - For a Client of Teamlease Digital

Hello

I have an opening for a resource on my Data Warehouse team. Below is a job description which you’ll see is technical and also provides user support. Can you review and let me know if you can help me fill this/ have any possible candidates.

I’m happy to set up a meeting if you have any questions.

Thank you,

Kathleen

Technical skills/Knowledge

·      SSIS

·      ETL processing

·      Data Warehouse

·      Cognos Reporting

·      Microsoft SQL Server 2019

·      SQL - Developer & Administrator

Responsible for:

·      System Support (overnight and weekends)

·      General admin tasks

·      Backups

·      Restores

·      Stored procedures

·      SQL Cluster management

·      TSQL

·      Performance tweaking

·      Maintenance tasks

·      User access governance

·      User support – Cognos reports

Job Description;

• Monitor the DWH and BI systems performance and integrity provide corrective and preventative maintenance as required.

·      Provide on-call support for Data warehouse daily ETL jobs and Cognos production reports.

·      Monitor, administer and tune the Cognos BI Series Servers (Remote Servers) for performance.

• Provide user support for reports in Cognos

o  Evaluate requests to add new fields to Data Warehouse. Work with requestor to gather all information needed to fulfill the request such as source, fields, and formulas necessary for reporting designs.

o  QA data additions, updates, and changes.

o  Review Cognos reports for design improvements such as utilizing correct fields and indexed fields.

o  Update Business Glossary of data fields available in Cognos.

• Develop and implement ETL routines according to the DWH design and architecture.

·      Maintain data models based on subject areas, ensure referential integrity across data warehouse.

·      Assist in data warehouse management efforts taking part in architecture, design, development, testing, debugging, and deployment tasks within the Business Intelligence area.

·      Build Meta Data Structure and Procedures for Enterprise Data Warehouse (data vault modelling)

• Support the development and validation required through the lifecycle of the DWH and Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouse.

·      Develop various SSIS packages (ETL) to extract transform data

·      Support legacy applications including IBM data manger, VB scripts etc.

·      SSIS Development - Incremental Load using For Each Loop, Sequence containers, Script Task, Conditional split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, union all and so on in Visual Studio

·      Create ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex

Transformations using SSIS/DTS packages

·      Set up SQL agent jobs and monitor them.

·      Work with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions

·      Facilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long-term needs of business customers.