Senior BI & ETL Developer

We are seeking a highly skilled Power Platform Developer with deep expertise in designing, developing, and deploying solutions using Microsoft Power Platform. The ideal candidate will have strong knowledge of Power Apps, Power Automate, Power BI, Power Pages, and Dataverse, along with integration capabilities across Microsoft 365, Azure, and third-party systems.

Key Responsibilities

• Solution Development:
• Design and build custom applications using Power Apps (Canvas & Model-Driven).
• Develop automated workflows using Power Automate for business process optimization.
• Create interactive dashboards and reports using Power BI for data visualization and analytics.
• Configure and manage Dataverse for secure data storage and modelling.
• Develop and maintain Power Pages for external-facing portals.
• Integration & Customization:
• Integrate Power Platform solutions with Microsoft 365, Dynamics 365, Azure services, and external APIs.
• Implement custom connectors and leverage Power Platform SDK for advanced scenarios.
• Utilize Azure Functions, Logic Apps, and REST APIs for extended functionality.
• Governance & Security:
• Apply best practices for environment management, ALM (Application Lifecycle Management), and solution deployment.
• Ensure compliance with security, data governance, and licensing guidelines.
• Implement role-based access control and manage user permissions.
• Performance & Optimization:
• Monitor and optimize app performance, workflow efficiency, and data refresh strategies.
• Troubleshoot and resolve technical issues promptly.
• Collaboration & Documentation:
• Work closely with business stakeholders to gather requirements and translate them into technical solutions.
• Document architecture, workflows, and processes for maintainability.

Required Skills & Qualifications

• Technical Expertise:
• Strong proficiency in Power Apps (Canvas & Model-Driven), Power Automate, Power BI, Power Pages, and Dataverse.
• Experience with Microsoft 365, Dynamics 365, and Azure services.
• Knowledge of JavaScript, TypeScript, C#, .NET, and Power Fx for custom development.
• Familiarity with SQL, DAX, and data modeling.
• Additional Skills:
• Understanding of ALM practices, solution packaging, and deployment pipelines.
• Experience with Git, Azure DevOps, or similar tools for version control and CI/CD.
• Strong problem-solving and analytical skills.
• Certifications (Preferred):
• Microsoft Certified: Power Platform Developer Associate.
• Microsoft Certified: Power Platform Solution Architect Expert.

Soft Skills

• Excellent communication and collaboration skills.
• Ability to work in agile environments and manage multiple priorities.
• Strong documentation and presentation abilities.

Position: Lead Software Engineer 

Job Overview:

Lead ETL Engineer with SSIS (SQL Server Integration Services) knowledge is primarily responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) workflows and data integration processes to support enterprise data solutions. 

Key Responsibilities and Duties  

Lead the software development team: 

• Lead a team of software engineers in designing, developing, and maintaining ETL Framework. 
• Set and communicate clear expectations for the clients regarding project timelines, quality standards, and deliverables. 
• Experience with Microsoft SQL Server Database, 
• Hands-on experience in writing, optimizing and maintaining complex SQL queries, stored procedures and functions. 
• Design and develop robust, scalable, and efficient database structures based on the organization's requirements. 

SSIS: 

• Design, develop, test, deploy, and maintain SSIS packages for data migration, ETL processes, reporting and to integrate data between various systems. 
• Develop complex SQL queries to extract data from various sources such as Oracle or SQL databases. 
• Troubleshoot issues related to package execution failures and optimize performance of existing packages. 
• Collaborate with stakeholders to understand business requirements and design solutions using SQL Server Integration Services (SSIS). 
• Work closely with the team to ensure timely delivery of projects. 
• Optimize existing integrations for improved performance and scalability. 
• Design and implement complex SSIS packages for extracting, transforming, and loading data from various sources such as relational databases (SQL Server, Oracle, DB2), flat files, and XML files. 
• Develop ETL best practices, including error handling, logging, checkpoints, and data quality assurance. 
• Write efficient SQL queries, stored procedures, functions, and triggers to support ETL processes. 
• Optimize SSIS packages and SQL queries for maximum performance using techniques such as parallelization, lookup caching, and bulk loading. 
• Create and maintain design documentation such as data models, mapping documents, data flow diagrams, and architecture diagrams. 
• Collaborate with business analysts, BI teams, and other stakeholders to understand requirements and deliver data solutions for reporting and analytics. 
• Schedule and monitor SSIS workflows using SQL Server Agent or other scheduling tools, ensuring timely and error-free data loads. 
• Troubleshoot, debug, and test SSIS packages and backend database processes to ensure data accuracy and system reliability. 
• Participate in resource planning, task estimation, and code review processes. 

Collaborate with cross-functional teams: 

• Work with other teams such as product management, quality assurance, and user experience to ensure that software applications meet business requirements and user needs. 
• Communicate effectively with team members and stakeholders. 

Stay up to date with emerging trends and technologies: 

• Keep up to date with emerging trends and technologies in the software development industry. 
• Make recommendations for improvements to existing software applications and processes. 

Mandatory skills 

SSIS, understanding of ETL Framework, able to design and implement SSIS 

Qualifications 

• Bachelor’s degree in computer science or related field. 
• 6-9 years of experience in software development. 
• Proven leadership experience in leading ETL teams. 
• Knowledge of software development methodologies such as Agile or Scrum. 
• Ability to mentor and train junior team members. 

Job Description: Oracle BI Publisher Developer

Position Type

• Work Type: Full-time

• Employment Type: Contract

Experience Required

• Minimum 1 year of hands-on experience in:

o Oracle Database: SQL development, performance tuning, data modelling

o Oracle BI Publisher: Report design, template customization, data source integration

Technical Skills

• Mandatory:

o Oracle SQL & PL/SQL

o BI Publisher report development and deployment

o XML and XSLT for template customization

• Preferred:

o Experience with Oracle E-Business Suite or Fusion Applications

o Familiarity with data visualization principles

o Basic understanding of performance metrics and report optimization

Responsibilities

• Design, develop, and maintain BI Publisher reports based on business requirements

• Write and optimize SQL queries for data extraction and transformation

• Collaborate with stakeholders to ensure report accuracy and usability

• Troubleshoot and resolve issues related to data and report performance

• Document technical specifications and maintain version control

Responsibilities

• Manage and drive a team of Data Analysts and Sr. Data Analysts to provide logistics and supply chain solutions.
• Conduct meetings with Clients to gather the requirements and understand the scope.
• Conduct meetings with internal stake holders to walk them through the solution and handover the analysis.
• Define business problems, identify solutions, provide analysis and insights from the client's data.
• 5 Conduct scheduled progress reviews on all projects and interact with onsite team daily.
• Ensure solutions are delivered error free and submitted on time.
• Implement ETL processes using Pentaho Data Integration (Pentaho ETL)Design and implement data models in Hadoop.
• Provide end-user training and technical assistance to maximize utilization of tools.
• Deliver technical guidance to team, including hands-on development as necessary; oversee standards, change controls and documentation library for training and reuse.

Requirements

• Bachelor's degree in Engineering.
• 16+ years of experience in Supply Chain and logistics or related industry and Analytics experience.
• 3 years of experience in team handling(8+People) and interacting with the executive leadership teams.
• Strong project and time management skills with ability to multitask and prioritize workload.
• Solid expertise with MS Excel, SQL, any visualization tools like Tableau/Power BI, any ETL tools.
• Proficiency in Hadoop / Hive.
• Experience Pentaho ETL, Pentaho Visualization API, Tableau.
• Hands on experience of working with Big data sets (Data sets with millions of records).
• Strong technical and Management experience.

Desired Skills and Experience

• NET,ASP.NET

CRM Technical Developer

Country: Malaysia

Cities: Kuala Lumpur

Area of expertise: Customer Relationship Management (CRM)

Job Description

You're a problem solver, knowing the systems, applications, and processes that will make a client happy, no matter how complex the IT solution and integrating architecture. You bring expertise and creativity to designing activities and building system prototypes.

About the job

Business and IT don't always speak the same language. It can be difficult for companies to know how IT can help tackle their problems and increase profitability. They need you to understand their business and translate their needs into a software solution that will realize results. 

As a CRM Technical Developer, you will be familiar with at least one leading commercial CRM system. You will assist delivery teams with CRM solution planning, analysis, designing, building, and testing. You will be considered a product specialist that is also responsible for providing support in CRM issue, customer concern, and resolution. This role is typically focused on more complex assignments, often requiring diverse inputs, processes, and/or outcomes with room for discretion within established parameters.

Day-to-day you will:

• Assist across all phases of projects (e.g. Plan, Analyze, Design, Build, and Test)
• Demonstrate technical knowledge to design and implement CRM solutions
• Research customer issues that may be non-standard in order to offer solutions
• Support design of conceptual architecture and technical solutions
• Ensure project quality meets standards through critical metric identification and testing plan
• Identify process gaps and work cross-functionally to formulate improvement plans
• Travel as needed

Key Role Skill & Capability Requirements:

You are passionate about working with a global technology leader to solve business-critical problems for some of the top companies in the world. You are a fast learner, a self-starter, and a creative problem solver. You are passionate about software and its potential to move organizations forward through innovation.

Your technical skills may include:

• Design, develop, deploy, customize and integrate Microsoft Dynamics CRM with other systems
• Configure and customize on standard workflows, dashboards, forms, views and develop standard or custom reports
• Develop reports or dashboards using PowerBI and integrate with D365CS
• Develop web application, web API, console application, window services to integrate with D365CS
• Develop a script to migrate existing CRM to D365CS
• Complete the documentation required including the source codes, technical specification, and unit test result
• Support SIT, UAT, and production and fix the defect within the agreed SLA
• Strong understanding of Microsoft Dynamic365 CRM, with domain knowledge in Customer Service and Telco industry - this would be a plus point
• Develop Power BI reports and integration to Microsoft Dynamic 365 CRM

Your non-technical skills may include:

• Client management skills and the ability to work with customers to develop and manage an action plan
• Some consulting experience working with external clients
• Experience working with global/offshore teams
• Excellent communication skills

Preferred Education Background:

Bachelor's degree in a relevant field preferred.

Preferred Years of Work Experience:

• Minimum 3 year of Microsoft Dynamic 365 CRM and Power BI development experiences
• Minimum 3 year of experience in ASP.NET C# development, JavaScript, HTML 5, CSS and other web base technology and tools
• Experience with Microsoft Dynamics 365 Field Service is essential

• Creating, designing and developing data models
• Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
• Validating results and creating business reports
• Monitoring and tuning data loads and queries
• Develop and prepare a schedule for a new data warehouse
• Analyze large databases and recommend appropriate optimization for the same
• Administer all requirements and design various functional specifications for data
• Provide support to the Software Development Life cycle
• Prepare various code designs and ensure efficient implementation of the same
• Evaluate all codes and ensure the quality of all project deliverables
• Monitor data warehouse work and provide subject matter expertise
• Hands-on BI practices, data structures, data modeling, SQL skills

Hard Skills for a Data Warehouse Developer:

• Hands-on experience with ETL tools e.g., DataStage, Informatica, Pentaho, Talend
• Sound knowledge of https://www.freelancermap.com/it-projects/sql-1084" target="_blank">SQL
• Experience with SQL databases such as Oracle, DB2, and SQL
• Experience using Data Warehouse platforms e.g., SAP, Birst
• Experience designing, developing, and implementing Data Warehouse solutions
• Project management and system development methodology
• Ability to proactively research solutions and best practices

Soft Skills for Data Warehouse Developers:

• Excellent Analytical skills
• Excellent verbal and written communications
• Strong organization skills
• Ability to work on a team, as well as independently

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation

We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.

Requirements:

• Qualification: Engineering Graduate.
• Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
• Strong understanding of ETL/ELT concepts.
• Hands on experience on Azure Data Factory.
• Exposure of Cloud technologies, standards, and platforms.
• Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
• Strong Experience on SSIS.
• Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
• Azure Data Warehouse.
• Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
• Azure Data Migration tool.
• Well versed with RDBMS systems like Sql server, DDL, DML scripts.
• Sound knowledge of T-SQL and stored procedures.
• Strong Query writing skills, Scheduling tools.
• Ensure quality deliverable and ability to extend work hours if required.
• Azure Certification: Preferred.
• Ability to understand Customer requirements and convert the requirements into technical specifications.
• Ability to understand the overall solution and design components to fit the overall solution.
• Ability to take technical decisions and support the decisions with justifications.
• Ability to work in Agile manner.
• Ability to work independently without much guidance.
• Self-Motivated, team player, results oriented, strong Time Management skills.
• Excellent written and verbal communication skills.
• Willing to travel to outside India (Short term as well as long term)

Job Role – SDE2

Duration – 12 months

Location – HYD

Key Skills:

• 3- 5 years
• Understanding databases and building reports
• Ideal candidate should have experience in Cosmos, Kusto and powerbi
• Mandatory experience in some Database query language(such as SQL)