There is a new requirement for a BI Developer, please find the attached JD for reference. Kindly share suitable profiles at the earliest.
KBS Request ID: 1808
Role Name: BI Developer
Koch Entity: Georgia Pacific
Years of Experience: 3-5 Years
Contract Duration (months): 8
Contract to Hire (C2H) Potential: True
1. JD
• Bachelor’s degree in computer science, or with equivalent professional experience.
• Exceptional problem-solving skills
• Self-motivated • Minimum of 3 years of hands-on MSBI & Power Bi work
• 3 + years of experience in SQL Server BI including SQL server database, SSIS, SSRS and Power BI
• Proficiency in writing Complex SQL Queries and DAX Functions
• Experience in Debugging and Optimizing SQL.
• Exposure on creating/maintaining design related artifacts like source to target Mapping documents, data flow diagrams and RCA documents.
• Understanding of BI concepts - OLTP vs OLAP
• Experience in an Agile environment
• Experience with Git and VSTS
• Excellent written and verbal communication skills
2. Questionnaire
Please use the below details to frame the questions at the time of screening
SQL
Conceptual understanding of Data Warehousing Concepts, ACID Properties, Different Types of Keys, Relationships - Table & Attributes, Joins, Constraints, Store Proc, Functions, Views, Indexes
Development exposure of writing Joins, Store Proc, Functions, Views, Temp Tables, CTE, Indexes, Data Cleansing.
Good in writing complex SQL Joins/Merge, Dynamic SQL, Order of SQL Query Executions, Ranking Functions, Windows Functions, Performance Tuning/Indexing, CTE, SP, UDF, Cursor, Trigger, Loops, Error Handling, SQL Jobs Scheduling & Monitoring.
Advance Performance Tuning (Query Analyzer, SQL Profiler, Tuning Advisor, Table Partitioning), Database Design, User Define Data Types, Transaction Isolation Level.
SSIS
Understanding of ETL Concepts, Data warehousing Concepts, Dimensional Modelling Concepts, SCD Concepts, Familiar with SSIS Work Bench (Variables, Parameters, Control flow, Data Flow, Event Handler, Precedence constraint etc.), Understand concept of Incremental vs Full data load
Implemented various Control Flow, Data Flow/ Transformations tasks, Containers (For, Foreach, Sequence), Connection Managers, Connection Provider etc.
Implemented end to end ETL solution, SCD, Parent Child Package, Checkpoint, Break Point, Basic Troubleshooting, Basic Performance Tunning, Error/Exception Handling, Package Configurations & Deployment etc.
Implemented Parameterize/Dynamic ETL Solution, MDS, Package Deployment models, Package Scheduling, Package Protection, Security and Encryption, Advance Performance Tunning, Transaction Options, Transaction Rollback etc.
Power Bi
Have conceptual understanding of dashboard Design Principles, Data Modeling, building blocks of dashboard such as slicers, filters, components, charts, reports, drill through, drill down, various data import mode etc.
implemented basic DAX functions, Bookmarks, Selection Pane, Dynamic Slicer, data modeling, append and merge, connecting to various data sources like Excel, Txt, SQL DB, SSAS, Power BI dataset etc.
Developed dashboard/report with advance DAX functions like GROUP BY, SUMMARIZE, VARIABLE AND SWITCH, IF, Aggregate functions, Counting functions, DATE functions (CALENDARAUTO, CALENDAR)
Incremental Refresh, row level security, Visual Interaction, knowledge of power query, power pivot, and power view etc.
Understand building blocks of Power BI (desktop, server, mobile).
Developed complex Dashboard, scheduling automatic dashboard refresh, Dashboard maintenance, Paginated reports, Data gateways, Parameters, writing advanced in DAX using VARIABLE, SWITCH, ALL, SELECTED ALL, EXCEPTALL, DATE FUNCTIONS, Path Function, Power Automate and PowerApps
Responsibilities
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Description
Full stack developer/Web Developer:Z2
1) Advanced proficiency in JavaScript, including TypeScript and Node.js
2) Managing Azure subscriptions, Entra ID (Azure AD), RBAC, networking, and security.
3) Deploying and configuring Node.js backends and React frontends on Azure App Services.
4) Strong knowledge in MySQL and PostgreSQL databases with backup, restore, and validation.
5) Implementing GitHub Actions or Azure DevOps pipelines for build, test, and deployment.
6) Managing Key Vault, SSL certificates, identity access, and security best practices.
7) Good experience in working with API's and D3.js library.
Responsibilities
Description
Full stack developer/Web Developer:Z2
1) Advanced proficiency in JavaScript, including TypeScript and Node.js
2) Managing Azure subscriptions, Entra ID (Azure AD), RBAC, networking, and security.
3) Deploying and configuring Node.js backends and React frontends on Azure App Services.
4) Strong knowledge in MySQL and PostgreSQL databases with backup, restore, and validation.
5) Implementing GitHub Actions or Azure DevOps pipelines for build, test, and deployment.
6) Managing Key Vault, SSL certificates, identity access, and security best practices.
7) Good experience in working with API's and D3.js library.
Salary : As per industry standard.
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Description
Primary Skill: S/4 HANA MM - Invoice verification Consultant Experience: 8 to 12 Years Budget: 40 lacs Project : Support Project Desired SAP Skills & Experience: Domain: SAP S/4HANA - MM (Materials Management) with SD, FICO integration • The candidate must be any graduate (BE/B.Tech Preferable) and he/she should have min 8-12 years’ experience in SAP S/4HANA MM and have good domain knowledge. • Experience with implementing an S4/HANA multi-tiered SAP environment • At least two implementations/roll-out Experience in S/4 HANA PTP implementation • Should have minimum two end-to-end full cycle implementation &Support projects experience in SAP MM and In-depth SAP S4 HANA knowledge, backed with a strong understanding of procurement processes • Skills must have to have o MM Enterprise structure, Master data, o Pricing , Account determination o Third party o Invoice verification o PR/PO Release strategy process o Procurement processes– Blanket ;Service , Special procurement processes, o Interfaces& integration with other SAP modules o MRP • Knowledge on SAP Ariba and integration with S/4 • Experience in procurement process and integration to other modules in SAP like FI, CO and SD • Coordinate with technical team on custom objects • Ability to multitask and manage multiple deliverables and projects at the same time • Design, customize, configure and testing of MM • Perform detailed analysis of complex business process requirements and provide appropriate system solutions; identify, interpret, validate and document customer requirements • Design, customize, configure and testing of MM • Perform detailed analysis of complex business process requirements and provide appropriate system solutions; identify, interpret, validate and document customer requirements • Handle changes or emergency transports as needed for high priority issues • Provide consulting services on both new implementations and existing support projects • Work self-directed and independently; may act as subject matter expert Desired Soft Skills: • Must have excellent analytical, troubleshooting and problem solving skills • Strong drive to execute and deliver • Excellent oral and written communication skills • Ability to work independently or in conjunction with a team • Ability to work issues through resolution • Ability to understand business processes from a customer perspective • Ability to work in a team environment, effectively interacting with others • Must be results oriented, adaptability, flexibility and resourcefulness
Responsibilities
Description
Primary Skill: S/4 HANA MM - Invoice verification Consultant Experience: 8 to 12 Years Budget: 40 lacs Project : Support Project Desired SAP Skills & Experience: Domain: SAP S/4HANA - MM (Materials Management) with SD, FICO integration • The candidate must be any graduate (BE/B.Tech Preferable) and he/she should have min 8-12 years’ experience in SAP S/4HANA MM and have good domain knowledge. • Experience with implementing an S4/HANA multi-tiered SAP environment • At least two implementations/roll-out Experience in S/4 HANA PTP implementation • Should have minimum two end-to-end full cycle implementation &Support projects experience in SAP MM and In-depth SAP S4 HANA knowledge, backed with a strong understanding of procurement processes • Skills must have to have o MM Enterprise structure, Master data, o Pricing , Account determination o Third party o Invoice verification o PR/PO Release strategy process o Procurement processes– Blanket ;Service , Special procurement processes, o Interfaces& integration with other SAP modules o MRP • Knowledge on SAP Ariba and integration with S/4 • Experience in procurement process and integration to other modules in SAP like FI, CO and SD • Coordinate with technical team on custom objects • Ability to multitask and manage multiple deliverables and projects at the same time • Design, customize, configure and testing of MM • Perform detailed analysis of complex business process requirements and provide appropriate system solutions; identify, interpret, validate and document customer requirements • Design, customize, configure and testing of MM • Perform detailed analysis of complex business process requirements and provide appropriate system solutions; identify, interpret, validate and document customer requirements • Handle changes or emergency transports as needed for high priority issues • Provide consulting services on both new implementations and existing support projects • Work self-directed and independently; may act as subject matter expert Desired Soft Skills: • Must have excellent analytical, troubleshooting and problem solving skills • Strong drive to execute and deliver • Excellent oral and written communication skills • Ability to work independently or in conjunction with a team • Ability to work issues through resolution • Ability to understand business processes from a customer perspective • Ability to work in a team environment, effectively interacting with others • Must be results oriented, adaptability, flexibility and resourcefulness
Salary : Rs. 0.0 - Rs. 40,00,000.0
Industry :IT-Software / Software Services
Functional Area : IT Software - Application Programming , Maintenance
Role Category :Programming & Design
Role :S/4 HANA MM - Invoice verification Consultant
