+1 (415) 644 5123
+44 1253 335595
+91 9875 492266
Puspendu
Kolkata
,
India
Database & BI Developer(SSIS,SSAS,SSRS,ETL,Power BI)
12000 USD / Year
-
Notice Period: Days
4 Years
About Me
- Total experience 4 years.
- Having around 3 years of experience in Microsoft Business Intelligence (SSIS, SSAS, SSRS) Development & Maintenance data warehouse assignments.
- Having a...
- Having around 1 year of experience in Microsoft Power BI and DAX query .
- Having around 3 years of experience in Microsoft SQL server Management Studio (SSMS).
- Designed and Developed the SSIS Packages by using different data transformations to Load data into DB tables(truncate load and incremental load).
- Having good experience in data warehouse(DW) and data mart(DM) development .
- Good Experience with Package Configurations, Error Handling.
- Involved in Package Deployment for moving package to Production Server.
- Having good experience in Package Scheduling Using SQL SERVER AGENT.
- Good experienced in Creating Cubes, Partitions, Aggregations and Usage Based Optimization in SSAS.
- Experience in creating SQL Logins, Roles as a part of security policies for various categories of users.
- Experienced in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages.
- Knowledge in creation of SSRS reports like Parameterized Reports, Sub-reports, Cascading report etc.
- Having around 1 years of Experience in JAVA Operational Service.
- Strong ability to understand new concepts and applications.
Skills
Positions
Portfolio Projects
Description
- Extract the Data from Teradata EDW system to SQL Server/Teradata staging database and Application Project view
- Creating Packages on SSIS by using different data Transformations like Derived Column, Conditional Split and Execute SQL Task in Dataflow level to load data into data warehouse.
- Scheduling Jobs to execute SSIS packages using SQL SERVER AGENT.
- Involved in Incremental loading.
- Involved in Error Handling using Event Handlers, Progress Tab & Logging.
- Implemented Breakpoints and Checkpoints.
- Involved in Cube, Dimensions & Partitions processing.
- Involved in Cube, Dimensions, Aggregations, and Partitions creation using SSAS.
- Debugging the CUBE solution for issues reported by the business.
- Managing Security (Creating users, logins and roles, granting permissions).
- Daily Log checking for errors on Production Server.
- Monitoring free space of database.
- Monitoring Database performance and optimizing performance.
- Monitoring the Performance of the servers.
- Implemented automated mailing to notify long running user queries on servers.
Description
- Total experience 4 years.
- Having around 3 years of experience in Microsoft Business Intelligence (SSIS, SSAS, SSRS) Development & Maintenance data warehouse assignments.
- Having around 1 year of experience in Microsoft Power BI and DAX query .
- Having around 3 years of experience in Microsoft SQL server Management Studio (SSMS).
- Designed and Developed the SSIS Packages by using different data transformations to Load data into DB tables(truncate load and incremental load).
- Having good experience in data warehouse(DW) and data mart(DM) development .
- Good Experience with Package Configurations, Error Handling.
- Involved in Package Deployment for moving package to Production Server.
- Having good experience in Package Scheduling Using SQL SERVER AGENT.
- Good experienced in Creating Cubes, Partitions, Aggregations and Usage Based Optimization in SSAS.
- Experience in creating SQL Logins, Roles as a part of security policies for various categories of users.
- Experienced in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages.
- Knowledge in creation of SSRS reports like Parameterized Reports, Sub-reports, Cascading report etc.
- Having around 1 years of Experience in JAVA Operational Service.
- Strong ability to understand new concepts and applications.
Verifications
-
Profile Verified
-
Phone Verified
Preferred Language
-
English - Fluent
-
Hindi - Conversational
-
Bengali - Native/Bilingual
Available Timezones
BROWSE SIMILAR DEVELOPER
-
Doug O
Remote/Local | Enterprise Multi-Cloud Architect | Big Data | Hadoop | Spark | Data Lakes
-
Art F
Data Architect with Teradata, Linux, SQL, and Python experience
-
Subbarao D
Application development covering all skill set of sdlc
-
Steven T
Have coded almost everything from firmware through apps, dev to valid to customer suppport
-
Terry L
Software Developer with varied languages, specializing in SAS Data Integration Studio
-
Mark O
Web builder with React/node plus Flask python Data Science
-
John P
Expert Developer with extensive Database Experience
-
Olaf C
Senior AI, Cognitive & Automation Architect Azure/Quantum Hybrid Architect
-
Balaji I
Data Scientist and AI Solution Architect
-
Aquiles B
Expert Data Scientist, Machine Learning Algorithms, High Performance Computing, Big Data.