Find Jobs
Hire Freelancers

Business Intelligence/ETL Developer

₹450-850 INR / hour

Closed
Posted over 3 years ago

₹450-850 INR / hour

Requirements 5+ year Design / Develop ETL and datawarehousing components Design and develop database objects, stored procedures, views, functions, tables and triggers; ensure their stability, reliability, and performance Develop ETL processes for data warehousing, data integration and data analytics. Strong experience writing complex SQL queries. 8+ years’ Experience with SQL and non-SQL Databases ( i.e. Postgress, MySQL, SQL Server, Mongo DB) Data Analysis Data Modeling, Data Warehouse, Data Warehouse Schemas Experience/familiarity with reporting and visualization tools such as Pentaho, Tableau API, structured an un-structured databases/datastores Linux, MySQL, ORM, RDBMS, RESTful APIs Python 3.6+ Strong experience in Web Services and APIs in python Amazon Lambda development Scripting MySQL Development Linking of Excel and other reporting tools MySQL Experience MongoDB Assist with future data warehouse, ETL, and data science projects as we mature our data product offerings Ability to work with project managers, business analysts and application developers, to quickly capture the major business functions and technology underpinnings to be able to design and implement tests of system functionality that exercise all critical inter-system integration points. Nice to have: Python, Authentication, Authorization AWS Lambda Python Developer Software development Strong experience with Excel SharePoint Agile familiarity Create and maintain clear, detailed, and accurate metadata documentation. Business Intelligence Reporting Requirements Designs, develops, and maintains business intelligence applications (reports, dashboards, scorecards). Develops dashboards using tools such as Tableau, Pentaho, Power BI. Provides feedback to the data warehouse build team to alert them to data issues or opportunities to expand the data warehouse to meet client expectations. Assist DW team with building datamarts, cubes, ETL mapping or package updates in order to procure backend data sources and create efficiencies Performs extensive unit testing of BI applications before handing off to QA.
Project ID: 26693865

About the project

23 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average ₹656 INR/hour for this job
User Avatar
We are a team of Electrical and Electronics engineers and we are Excellent in the following areas: • PCB Designing-Proteus, Eagle. • Python • Embedded C Programming. • VHDL/Verilog • Microcontroller like Arduino, Raspberry Pi, FPGA, AVR, PIC and STM32. • IDEs like Keil MDK V5, ATmel studio and MPLab XC8. • PLCs / SCADA • Multisim • IOT Technologies like Ethernet, GSM GPRS. • HTTP Restful APIs connection for IOT Communications. Also we have good command over report writing, I can show you many samples of our previous reports. Kindly consider us for your project and text me so that we can further discuss specifically about your project's main goals and requirements. We can deliver your project efficiently at a time. If you choose me, I think you won't regret. Best Regards. Also we have good command over REPORT WRITING, We can show you many samples of our previous reports. We can discuss further details in the message box.
₹1,000 INR in 40 days
5.0 (3 reviews)
4.2
4.2
User Avatar
Python has been my primary language at work, I like working on Backend services and data related tasks, Some tasks I have worked with Python include Design and Implement high-performance API services using Flask, Pandas, Druid for a predictive maintenance platform. Modifications to a custom application built on top Flask-Appbuilder Implemented services for a Search service with Solr and Flask Implemented and Maintained data warehouse on Redshift using Airflow and ELT methodology instead of ETL for a high-velocity fintech start-up Created a clustered scraper using Python, Selenium, Dask, Pandas Developed and Maintained a data warehouse using Export Load Transform methodology, using Airflow Automated sharing data with partners and data quality checks Implemented click trackers using Falcon, GCP PubSub and processed the data using Google Cloud Functions, Cloud Scheduler Developed API services for food ordering system on AWS Lambda, DynamoDB using Chalice and AWS CDK Framework Built an Email Classification service using Word2Vec, Spark MLlib reducing time to respond for customer care emails for a bank Modules to pull tweets containing specified keywords form Twitter Firehose, perform sentiment analysis using Python, Kafka, MongoDB I hope my skills would be of use to you with your product/ project. Feel free to initiate a chat to discuss timelines, requirements, and budget
₹750 INR in 40 days
5.0 (1 review)
3.4
3.4
User Avatar
I am a microsoft certified BI developer with 10 + years of experience of working with ETL and BI tools such as SSIS , SSAS , Azure ETL , Pervasive , Informatica , castiron , SAP Bods , SAP BO , OBIEE etc .
₹650 INR in 40 days
4.2 (1 review)
3.1
3.1
User Avatar
Hi there, Thanks for this invitation. Hope you are doing great. I have gone through the JD and found that it perfectly suits with my expertise. I have developed and delivered several Power BI , SQL server, Data Ware housing and BI project with elegant dashboard. My primary skill sets are Power BI, SQL server( admin and strongT-SQL), MSBI (SSIS, SSAS and SSRS), Azure Analytics, PYTHON, Airflow, Power Apps, Microsoft forms and Flow. Please have a look at my portfolio and along with that I have 14 years experience in BI and data analytics field for several MNC. I am a Microsoft certified professional. Looking forward to have a discussion. Thanks, Purna.
₹944 INR in 25 days
5.0 (1 review)
2.3
2.3
User Avatar
Hi, I have been working in Python/ Django for last 5 years. I have experience of working ETL systems. I can help you with this project. Please have a discussion if possible to access more about me. Thanks, Gautam Aggarwal
₹750 INR in 40 days
4.8 (3 reviews)
2.2
2.2
User Avatar
Experienced and driven Tableau Developer with 3+years of Experience in industry. Strong expertise in Tableau reporting. Proficient in designing customized interactive dashboards in Tableau using marks, filters, parameters, table calculations and calculation measures. Commitment to providing support and essential information about trends to company in a variety of businesses.
₹400 INR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 7 plus years of experience in data warehousing domain. with experience in oracle, netezza, sql server and teradata databases. having work experience in informatica ETL development for 7 plus years
₹667 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm BI Expert and I was active in different layers of the BI projects, including: Analyzing and Designing DWH including more 5 sub-systems (Sales system, purchasing system, personnel management system, electricity consumption management, management of members of a cultural institution, patient management system) Acting as business analyst, Designing Dashboards and Reports using Tableau or Microstrategy, Analyst and developer for ETL-process, By Microsoft BI (SSIS) or (developing procedures directly in MS. SQL or Oracle) for calculate the hours , it's important to specify the scope of work
₹600 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
 Having 5 years of IT experience as Informatica Developer.  Experience in Extraction, Transformation and Loading of data directly from different heterogeneous source systems like Flat File, Oracle etc.  Worked on all phases of development lifecycle like Design, Development, Detail design document, logic, coding, testing, changes and corrections  Data modelling experience using Dimensional Data modelling, Star Schema/Snowflake modelling, FACT & Dimensions tables, Physical & logical data modelling  Have the capability to understand the Clients Business and his Translated business requirements into Informatica mappings/workflow.  Supplied mentoring on mapping design, workflow logic and scheduling  Developed mappings, sessions and workflows for the new ETL process followed with Quality standards.  Worked with different sources such as Oracle and flat files  Performed UTC according to Unit Test Plan and integration testing  Extensively worked on Informatica and SQL Performance Tuning.
₹700 INR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having 9 years of experience in Data warehousing , ETL and Business Intelligence tool. More than 5 projects End to end implementation experience within the time line.
₹700 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I had an experience of using Pentaho, I can use Data Integration create Jobs and Transformation. I am good at preparing complex SQL queries.
₹600 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager, Hi, I have gone through with the job details " Business Intelligence/ETL Developer " , I fit every category that you requested as I'm proficient in SQL (normally I use Microsoft SQL server) and Business intelligence tools like Microsoft Power BI (able to create dashboards to tell stories with data). I can do statistical analysis using python and build a prediction machine, learning models.I am very comfortable mining and working with large sets of data from a database If needed, I can provide a full and clear documentation reports on findings and insights. Please schedule a small meeting over here or over the sky-pe,? I have experience preparing power bi dashboard. Please provide the data set and the requirement. I have worked on following technology stack. Power BI, ETL, Tableau, SQL Server , SSIS , SSAS , Excel, Azure Data Factory, Azure Data lake, Azure Analysis Services, Data Warehousing, Business Intelligence, Powershell. It will be my pleasure to work for you. I am too sure about the quality and services too. I hope we will do something great over here and will be able to keep the long term relationship too. I am looking forward to your response. Kindest Regards
₹575 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Strong 8+ years of experience on Reporting and data analysis tools like Tableau desktop and tableau server, Python, SAP Business Objects, Crystal reports, SAP Dashboards (Xcelsius), SQL Server, Oracle,Teradata, Power BI, Xcelsius, MS-Excel, MS-Power Point, VBA., Cognos ,NeedScope reports.
₹575 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have total 6.5 years of Experience in implementing Dataware housing projects. My primary skills are informatica and talend. Secondary skills: unix , teradata,oracle,sql server,java
₹639 INR in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Designs, develops, and maintains ETL components using IBM Infosphere DataStage. Support dashboards using tools such as Tableau, Pentaho, Power BI. Provides feedback to the data warehouse build team to alert them to data issues or opportunities to expand the data warehouse to meet client expectations. Assist DW team with building datamarts, cubes, ETL mapping or package updates in order to procure backend data sources and create efficiencies Performs extensive unit testing of BI applications before handing off to QA.
₹700 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I've read your requirements and interested in your project. Let's have a talk in case your are interested. Here's a brief about myself - Basically I'm an ETL developer with 7 years of experience in MSBI with 15 years of total software development experience. I've extensively worked on data migration and cleansing and data modeling. I've worked on BI projects in Telecom and Realty sector in the last 7 years, mostly involved in the creation of ETL packages, used different data sources like Oracle, SQL Server, Postgresql, Ms Access, Text files, Spreadsheets, XML files etc. using Microsoft SSIS. I was always involved in writing Stored Procedures, Functions and complex ad-hoc queries and data modeling work throughout my career. Following is my skill set : Database/Datawarehouse - SQL Server, Oracle, Postgresql MSBI : (SSIS, SSRS, SSAS) Dotnet - C# (core), ASP.Net (core) I look forward to hearing from you. Thanks
₹575 INR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have got vast experience of 10 years working with datawarehouse projects and possess very sound and in depth knowledge. During this tenure, have worked on more than 8 projects and also worked directly with client in UK for 3 years. My skillset - Oracle BI,Informatica,Oracle DB ,My SQL Regards
₹650 INR in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Alpharetta, United States
5.0
1
Payment method verified
Member since Mar 19, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.