Data Migration activities from SAP to SalesForce
Analysing and Profiling Data.
Making Reports/Data to synchronize different systems.
Creation of ETL Pipelines using Talend for insert/update Accounts, Leads or Opportunities.
Development of Complex SQL Queries for data analysis and reports.
Creation of Batches and Jobs for data integration and automation.
Creation of Technical Documents and Solution Manuals along with system support.
Salesforce data extraction from different instances to map the master data.
Data Migration for the countries onboarded during the Salesforce implementation.
Used Dbamp SPs to load the data into Salesforce Testing & Validation of Data.
Engaged local businesspeople to explain the data model for the data collection process.
Engaged local businesspeople to explain the data model for the data collection process.
Creation of Documentation and Solution Manuals Designing ITIL Business Processes - Change management,
Incident management, Patch Management
Jira designing - Project, Workflows, Defect types.
Jira / SharePoint Admin activities like User access, Backups
Learnt and acquired working proficiency on Leasing Application - Miles
Configuring Miles objects and handling change requests, defects.
Managing and Helping team and markets (Countries).
Understanding current system and the business requirements.
Reverse engineering, Identification, Optimization and Re-Creation of excel Dashboards.
Written/modified ETL PostgreSQL code for data transfer from source to target.
To make sure that the correct data is being loaded in the DWH and troubleshooting issues.
Performance Tuning of the Client?s existing code for business value addition.
Understanding current system and the user requirements.
Written/modified ETL Talend code for data transfer from source to target.
Extraction of data from Salesforce.
To make sure that the correct data is being loaded in the DWH.
Performance Tuning of the Client?s existing code for business value addition.
Worked as Talend ETL developer.
Analysing of requirements and understanding the current system.
Written/modified ETL mappings for source to target data transfer, used components such as joblets, tjava, tfixedflowinput, tjdbcinput, tjdbcoutput, tmap, tDie, twarn, tJavaRow, etc.
Performance Tuning of the Client?s existing code for business value addition.
Handled many of the customer issues on the product and fixed in ETL code.
Development of Informatica Jobs (Mappings, Sessions and Workflows)
Understanding requirements and the current system
To develop and implement customer requested enhancements (change requests)
To make sure that the correct data is being loaded in the DWH
Testing including Unit Test Plans and Unit Test Reviews, execution and verification of the test result
Analysing of requirements and understanding the current system to resolve the tickets. Worked on star schema & SCD type 2 architecture.
Development of Informatica Jobs (Mappings, Sessions and Workflows).
Created Stored Procedures using PL/SQL.
To address and support customer requested enhancements (change requests).
Excel reports Development by Querying Sybase Database.
To make sure that the correct data is being loaded in the Data Warehouse.
Enhancements of Informatica mappings and Unix scripts.
Monitor and support the workflows
I worked as a Manual Tester
Involved in Regression, Functional Testing, Load Testing
Working on call control, Voip call flow system and Voip call Architecture
Involved in Extracting reports from SQL database
Involved in Defect Detection, Reporting and Tracking
New test case writing & modification of old test cases
Root cause analysis of defects
Profil
A dynamic IT professional having about 9 years of experience in Development, Implementation, Support and Testing in Database, ETL and Data Warehouse applications.
Good experience in Informatica PowerCenter 8.x/9.x, Talend 5/6, Oracle, SalesForce CRM, PostgreSQL, Sybase IQ, Teradata, PL/SQL, Data Warehousing Concepts and Scripting (WINDOWS & UNIX scripting).
Familiar with Automotive, Finance (Taxation), Telecom and Workforce Management Domains.
Worked on Stored Procedures creation using PL/SQL
Worked on various transformations like Sorters, Joiners, Aggregators, Lookups and SQL transformation extensively.
Track record of managing all phases of SDLC.
Worked on both Unix and windows-based servers.
Performance tuning of mappings and DB queries.
Flexible & versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
Proactive team player with capability of handling responsibilities independently.
Exposure to Data Visualisation using Tableau.
Earned appreciation from Business Users for automating existing processes, seamless project delivery and client communications.
Data Migration activities from SAP to SalesForce
Analysing and Profiling Data.
Making Reports/Data to synchronize different systems.
Creation of ETL Pipelines using Talend for insert/update Accounts, Leads or Opportunities.
Development of Complex SQL Queries for data analysis and reports.
Creation of Batches and Jobs for data integration and automation.
Creation of Technical Documents and Solution Manuals along with system support.
Salesforce data extraction from different instances to map the master data.
Data Migration for the countries onboarded during the Salesforce implementation.
Used Dbamp SPs to load the data into Salesforce Testing & Validation of Data.
Engaged local businesspeople to explain the data model for the data collection process.
Engaged local businesspeople to explain the data model for the data collection process.
Creation of Documentation and Solution Manuals Designing ITIL Business Processes - Change management,
Incident management, Patch Management
Jira designing - Project, Workflows, Defect types.
Jira / SharePoint Admin activities like User access, Backups
Learnt and acquired working proficiency on Leasing Application - Miles
Configuring Miles objects and handling change requests, defects.
Managing and Helping team and markets (Countries).
Understanding current system and the business requirements.
Reverse engineering, Identification, Optimization and Re-Creation of excel Dashboards.
Written/modified ETL PostgreSQL code for data transfer from source to target.
To make sure that the correct data is being loaded in the DWH and troubleshooting issues.
Performance Tuning of the Client?s existing code for business value addition.
Understanding current system and the user requirements.
Written/modified ETL Talend code for data transfer from source to target.
Extraction of data from Salesforce.
To make sure that the correct data is being loaded in the DWH.
Performance Tuning of the Client?s existing code for business value addition.
Worked as Talend ETL developer.
Analysing of requirements and understanding the current system.
Written/modified ETL mappings for source to target data transfer, used components such as joblets, tjava, tfixedflowinput, tjdbcinput, tjdbcoutput, tmap, tDie, twarn, tJavaRow, etc.
Performance Tuning of the Client?s existing code for business value addition.
Handled many of the customer issues on the product and fixed in ETL code.
Development of Informatica Jobs (Mappings, Sessions and Workflows)
Understanding requirements and the current system
To develop and implement customer requested enhancements (change requests)
To make sure that the correct data is being loaded in the DWH
Testing including Unit Test Plans and Unit Test Reviews, execution and verification of the test result
Analysing of requirements and understanding the current system to resolve the tickets. Worked on star schema & SCD type 2 architecture.
Development of Informatica Jobs (Mappings, Sessions and Workflows).
Created Stored Procedures using PL/SQL.
To address and support customer requested enhancements (change requests).
Excel reports Development by Querying Sybase Database.
To make sure that the correct data is being loaded in the Data Warehouse.
Enhancements of Informatica mappings and Unix scripts.
Monitor and support the workflows
I worked as a Manual Tester
Involved in Regression, Functional Testing, Load Testing
Working on call control, Voip call flow system and Voip call Architecture
Involved in Extracting reports from SQL database
Involved in Defect Detection, Reporting and Tracking
New test case writing & modification of old test cases
Root cause analysis of defects
Profil
A dynamic IT professional having about 9 years of experience in Development, Implementation, Support and Testing in Database, ETL and Data Warehouse applications.
Good experience in Informatica PowerCenter 8.x/9.x, Talend 5/6, Oracle, SalesForce CRM, PostgreSQL, Sybase IQ, Teradata, PL/SQL, Data Warehousing Concepts and Scripting (WINDOWS & UNIX scripting).
Familiar with Automotive, Finance (Taxation), Telecom and Workforce Management Domains.
Worked on Stored Procedures creation using PL/SQL
Worked on various transformations like Sorters, Joiners, Aggregators, Lookups and SQL transformation extensively.
Track record of managing all phases of SDLC.
Worked on both Unix and windows-based servers.
Performance tuning of mappings and DB queries.
Flexible & versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
Proactive team player with capability of handling responsibilities independently.
Exposure to Data Visualisation using Tableau.
Earned appreciation from Business Users for automating existing processes, seamless project delivery and client communications.