Senior BI & ETL Developer

Designing, building, and automating ETL processes using AWS services like Apache Sqoop, AWS S3, AWS CLI, Amazon 

EMR, Amazon MSK, Amazon Sagemaker. 

∙Developing and maintaining data pipelines to move and transform data from diverse sources into data warehouses or 

data lakes. 

∙Ensuring data quality and integrity through validation, cleansing, and monitoring ETL processes. 

∙Optimizing ETL workflows for performance, scalability, and cost efficiency within the AWS environment. 

∙Troubleshooting and resolving issues related to data processing and ETL workflows. 

∙Implementing and maintaining security measures and compliance standards for data pipelines and infrastructure. 

∙Documenting ETL processes, data mappings, and system architecture. 

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

Job Role - Power BI Lead

9 to 12 Years Experience Required. 

Location - Pune Baner/ Vimaan Nagar 

Work Model - Hybrid (Wednesday and Thursday WFO) 12 PM to 9 PM 

Experience with Banking or GRC Domain is preferred. 

• JOB SUMMARY
• Role Overview: We are seeking a highly skilled Power BI Expert to design, develop, implement and governance of Power BI solutions. Ideal candidate will have in-depth knowledge of Power BI architecture, data modeling, governance, embedded analytics and database management. The role requires expertise Power BI Data Gateways, report deployment, and governance frameworks ensuring scalable and secure data solutions.
• PRIMARY RESPONSIBILITIES                                             
• Power BI Lead & Implementation:
•  Design, develop, and deploy interactive Power BI reports and dashboards.
•  Create efficient data models to optimize performance and scalability.
•  Develop complex DAX expressions for business logic and calculations.
•  Optimize report performance by using best practices in Power BI and SQL
• Power BI Architecture & Configuration:
•  Configure and manage Power BI Data Gateways for secure and seamless data access
•  Define and enforce Power BI workspace, dataset, and security policies.
•  Implement row-level security (RLS) and data governance best practices.
•  Establish data refresh schedules and ensure efficient data ingestion pipelines.
•  Maintain and enhance Power BI Premium and Embedded solutions.
• Embedded Analytics & Integration:
•  Integrate Power BI reports with external applications using Power BI Embedded.
•  Work with Power BI REST APIs to automate workflows.
•  Integrate Power BI with Oracle, SQL Server, MySQL, Microsoft Share point, Excel, Cloud data source etc.,
•  Database & Performance Optimization:
•  Write optimized SQL queries and stored procedures for report development.
•  Ensure high-performance data refreshes and query execution.
•  Work with ETL team to improve data integration with PowerBI
•  Governance & Security:
•  Define Power BI governance framework and best practices for standardization.
•  Monitor user access, performance, and usage analytics to drive efficiency.
•  Manage user roles, access controls, and data security.
•  PowerApps & Power Automate (Nice to Have):
•  Build PowerApps applications to extend Power BI functionality and create
• interactive business solutions
•  Automate data flows and reporting updates using Power Automate (Flows,
• Triggers, Approvals, Notifications, etc.).
•  Integrate Power BI, PowerApps, and Power Automate to create end-to-end
• business process automation.
•  Stakeholder Collaboration 
• Training:
•  Work closely with business users, data engineers, and leadership teams to understand and document reporting requirements.
•  Provide training and best practice guidance to Power BI users across the organization.
•  Develop self-service Power BI frameworks to empower business teams for reporting.
•  Troubleshoot Power BI performance and user issues.

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

 Review all job requirements and specifications required for deploying the solution into the production environment. 

 Perform various unit/tests as per the checklist on deployment steps with help of test cases and maintain documents for the same. 

 Work with Lead to resolve all issues within the required timeframe and inform for any delays. 

 Collaborate with the development team to review new programs for implementation activities and manage communication (if required) with different functions to resolve issues and assist implementation leads to manage production deployments. 

 Document all issues during the deployment phase and document all findings from logs/during actual deployment and share the analysis. 

 Review and maintain all technical and business documents.  Conduct and monitor software implementation lifecycle and assist/make appropriate customization to all software for clients as per the deployment/implementation guide 

 Train new members on product deployment, issues and identify all issues in processes and provide solutions for the same. 

 Ensure project tasks as appropriately updated in JIRA / ticket tool for in-progress/done and raise the issues. 

 Should take self-initiative to learn/understand the technologies i.e. Vertica SQL, Internal Data integration tool (Athena), Pulse Framework, Tableau. 

 Flexible to work during non-business hours in some exceptional cases (for a few days) required to meet the client time zones. 

Experience on Tools and Technologies preferred: 

ETL Tools: Talend or Informatica ,Abinitio,Datastage 

BI Tools: Tableau or Jaspersoft or Pentaho or Qlikview experience 

Database: Experience in Oracle or SS 

Methodology: Experience in SDLC and/or Agile Methodology

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)