Senior Business Intelligence Specialist

Job Description:

Responsibilities:

• Develop and maintain on-premise ETL pipelines using SqlServer Integration Services, T-SQL, stored procedures.
• Develop and maintain Oracle Materialized Views as Change Data Capture (CDC) mechanism for incremental updates.
• Participate in requirements, design and implementation of Oracle GoldenGate solution as new CDC tool.
• Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL.
• zure Data Factory (expert knowledge) to maintain pipeline from Oracle to Azure Data Lake.
• zure Data bricks to build stored procedures and read data from data lake.
• Review requirements, database tables, and database relationships - Identify gaps and inefficiencies in current production reporting environment and provide recommendations address them in the new platform.
• Prepare and maintain design artifacts, such as ETL requirements, source-to-target mapping (STM), ETL workflows, data model diagrams (ERD), data lineage diagrams, error handling and logging strategy, using specialized tools.
• Work in an Agile environment, using Azure DevOps tools for code repository and defect tracking.
• Data analysis and design - physical model mapping from data source to reporting destination.
• Understand the requirements. Recommend changes to the physical model.
• Develop the scripts of physical model, and create DB.
• ccess Oracle DB environments, use SSIS, SQL Server and other development tools for developing solution.
• Proactively communicate with business analysts on any changes required to conceptual, logical and physical models, communicate and review dependencies and risks.
• Development of ETL strategy and solution for different subject areas.
• Understand the Tables and Relationships.
• Create low level design documents and unit test cases.
• Create the workflows of package design.
• Development and testing of data with Incremental and Full Load.
• Develop high quality ETL mappings/scripts/jobs.
• ETL data from Applications to Data Warehouse.
• ETL data from Data Warehouse to Data Mart.
• Perform unit tests.

Experience and Skill Set Requirements Experience:

• Experience of 7+ years of working with SQL Server, SSIS and T-SQL Development (Must Have).
• Experience working with building Databases, Data Warehouse and Data Mart and working with delta/incremental and full loads (Must Have).
• Data Warehouse concepts, Kimball and Inmon design methodologies (Must Have).
• Experience with Azure ETL tools such as Azure Data Factory and Azure Databricks (Must Have).
• Experience working with MSSQL Sever and Oracle database tools (Must Have).
• Experience configuring and using Oracle GoldenGate (Nice to have).
• Knowledge of Dimensional Data modeling, and tools - e.g. Power Designer,
• Experience with snowflake and star schema design.
• Experience in designing and implementing data warehouse solutions using slowly changing dimensions SCD Type 1, Type 2 and Type 3.
• nalyze, design, develop, test and document ETL programs from detailed and high-level specifications, and assist in troubleshooting.
• Utilize SQL to perform tasks other than data transformation (DDL, complex queries).
• Good knowledge of database performance optimization techniques.
• bility to assist in the requirements analysis and subsequent developments, assist in test preparations to ensure data integrity and conduct unit tests.
• Work closely with Data Analysts, Business Analysts, and Developers.
• Liaise with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants.
• Design and implement technical enhancements of Data Warehouse as required.

Design Documentation and Analysis Skills (35 points):

• Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
• Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.
• Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
• Work with the Client & Developer(s) assigned to refine/confirm Business Requirements.
• Participate in defect fixing, testing support and development activities for ETL tools.
• ssist with defect fixing and testing support for Power BI reports.
• nalyze and document solution complexity and interdependencies by function including providing support for data validation.

Development, Database and ETL experience (55 points):

• Demonstrated experience in Microsoft specific software development and a number of years of practical experience (minimum 7+ years).
• Proven experience in developing in Azure DevOps.
• Experience in application mapping to populate data store and dimensional data mart schemas.
• Demonstrated experience in Extract, Transform & Load and Extract, Load and Transforms software development and a number of years of practical experience (minimum 7+ years).
• Experience in providing ongoing support on Azure pipeline/configuration and SSIS development.
• Experience building data ingesting and change data capture using Golden Gate (an asset but not mandatory).
• ssist in the development of the predefined and adhoc reports and meet the coding and accessibility requirements.
• Demonstrated experience with Oracle and Microsoft interfaces.
• Proficient in SQL and Azure DevOps.
• Implementing logical and physical data models.

Knowledge Transfer (10 points):

• The Developer must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system.
• The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.
• Development of documentation and materials as part of a review and knowledge transfer to other members.
• Development and facilitation of training sessions for developers and analysts.
• Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed.