25/11/2019
ViSight Consultancy is hiring Power BI Developer with DWH implementation experience
This is a one month project contract, based in Cairo/Egypt
If you are interested & have the needed skills below, kindly send your updated resume to
([email protected])
• 3+ years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau.
• Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access.
• Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.
• Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Experience in managing and automating control flow, data flow, events.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in Design, development of Business Intelligence Solutions using Power BI.
• Thorough understanding on connection managers, Checkpoint, Transactions, logging etc.
• Created Drill through reports, drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc. using BIDS.
• Worked on projects using Agile and Waterfall model methodologies.
• 3+ years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau.
• Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access.
• Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.
• Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Experience in managing and automating control flow, data flow, events.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in Design, development of Business Intelligence Solutions using Power BI.
• Thorough understanding on connection managers, Checkpoint, Transactions, logging etc.
• Created Drill through reports, drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc. using BIDS.
• Worked on projects using Agile and Waterfall model methodologies.