Top 2 SalesForce accelerator IBM cloud Jobs

Programmer Analyst/ETL
Rotech Solutions —Monmouth Junction, NJ
- Computer Science
- Writing skills
- Mid-level
CX Director - Practice Lead
McFadyen Digital —Vienna, VA
- Full-time
- Marketing
- Merchandising
- 11+ years
Quick Apply

More jobs to discover

Find similar jobs that you might be interested in.

Admin Assistant Director -Westchester-Crestwood Summer Camp
Kids in the Game —Eastchester, NY
As an Admin and Ops Assistant Director, your goal is to help families feel supported, informed, and excited about their camp experience, supporting them through…
$800 - $900 a year
Quick Apply
6d
Hospital - Oncology RN IV (Night Shift, Full Time)
UT Health Science Center at San Antonio —San Antonio, TX
Current Texas Board of Nursing (or Compact State) RN license; Or a Temporary Texas RN License (Permanent TX license within 90 days upon hire).
Quick Apply
6d

I want to receive the latest job alert for SalesForce accelerator IBM cloud

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

SalesForce accelerator IBM cloud jobs near

Director jobs in Vienna, VA

Activity Director jobs in Dallas, Tx

Marketing Director jobs in California

Social Services Director jobs in New Jersey

Choir Director jobs in New Jersey

Director Of Food Beverage jobs in Las Vegas, Nv

Executive Director jobs in Massachusetts

Programmer Analyst jobs in Hammond, La

Programmer Analyst jobs in Columbia, Sc

Programmer Analyst jobs in Plano, Tx

Entry Level Programmer jobs in Texas

Programmer Analyst jobs in Cincinnati, Oh

Programmer Analyst/ETL

Rotech Solutions
Monmouth Junction, NJ

Apply Now

Job Details

Qualifications

Bachelor's degree
Informatica

Full Job Description

Analyze the existed data related to different applications (Sales System, Fleet, Advanced Reservations, Rental History) using Informatica Analyst.
- Discuss with the Business Analyst in understanding the requirements
- Analyze the data as to the provided transformations
- Evaluate the possibility to implement in Informatica or seek for additional information.
Data Profiling and Understanding the gaps and Interaction with Data Stewards and Business SME’s and applying the Business rules.
- Understand the redundancy in data discussing with the Business/SME’s/BA
- Understanding the Business Rules/SLA’s
- Communicate with data stewards for analyzing the data and finding out the gaps.
Requirements Analysis with Business Analysts and preparation of ETL specifications and Identification of GAPS and get it reviewed by Data Architects, Business SME and proper sign off and developer handover.
- Discuss and analyze the requirements with Business Analysts which are provided through a specifications document both high/low level design documents.
- Coding according to the specifications document and seek for an architect’s approval through code review and migrate to different environments like Dev/QA/UAT/Production.
Data cleansing, Data validation, Data Standardization, Customer Address Validation Using Informatica developer tool and migrate the cleansed data to Salesforce Using Informatica Power Exchange connector to read DB2 Mainframe Sales system data and load into Salesforce using Salesforce Connector.
- Perform various transformations using different functions to remove the gaps in data like spaces, prefix/suffix, special characters etc. and validate data through Data Reconciliation.
- Use Address doctor for validating address as per the specified formats eg: USPS, FedEx etc.
- Use Informatica PC to connect to various databases like IBM DB2, SQL server, Oracle, Teradata, Salesforce etc. to extract data and perform required validations/transformations and load data into the respective database/sftp.
Understanding existed GDW Teradata BTEQ scripts and enhancements based on new requirements and providing required Salesforce objects names and its data types under change list of Salesforce Agile accelerator and interaction with Salesforce team
- Writing Unix Shell/BTEQ scripts to connect to the database to extract the data when not possible through Informatica PC to load data into the Database/sftp.
- Load Customer data of complex hierarchy into Salesforce CRM according to their customer Ids/Accounts/Contacts/Identifications (Driver license/passport numbers).
Development of ETL code, Unit testing code peer review by Data Architects and proper Hand over to QA team and then code deployment across the environments.
- Develop the slowly changing dimensions to capture legacy data, current data and develop the ETL code based on the Specifications document
- Perform unit testing and go through a code review by a Sr. Developer/ Architect
- Deployment of code to QA/UAT for quality testing.
- Deploy the code into Production once the Stakeholders approve/signoff
Defects analysis and finding proper root cause and apply the code fixes, testing and Code deployment.
- Utilizing skills such as – CRM – Sales force, Informatica Cloud, Informatica Data Quality, Informatica Analyst, Informatica Power Center, Informatica Power Exchange, Siebel CRM, DB2, Oracle, SQL Server, Teradata
- Once code is developed and moved to the higher environments and if a defect is raised, perform defect analysis and fix the issue at hand through finding out the errors in code and prepare the incident documents.
- ETL code is fixed/modified through Informatica PC/Cloud/Informatica Data Quality and load data into Salesforce CRM.
- Write SQL queries according to the requirements, apply complex functions and aggregating the data by quarterly/half yearly/annually and load the aggregated data into the respective base tables.

REQUIRED SKILLS & Education

Working knowledge of Informatica PowerCenter
Ability to function in a fast-paced environment
Required to have Bachelor’s degree in computer science or a closely related field

Apply Now

Refine Your Search

SalesForce accelerator IBM cloud jobs

Programmer Analyst/ETL

CX Director - Practice Lead

More jobs to discover

I want to receive the latest job alert for SalesForce accelerator IBM cloud

Explore jobs in more locations

REQUIRED SKILLS & Education

Job Seeker Tools

Employer Tools

Browse

Stay Connected