Home

ETL Informatica Developer role Hybrid, Troy , MI Must be Genuinely Local to MI at Troy, Michigan, USA
Email: [email protected]
Title:                     ETL Informatica Developer

Location:             Hybrid, Troy , MI (Must be Genuinely Local to MI)

Duration:             6+ Months

MOI:                      Phone then Video

Visa:                      No H1B

Job Description:

Informatica ETL Developer responsibilities: 

       Create Informatica mappings with Oracle database objects to incorporate critical business functionality to load the data into the Salesforce application. 

       Create/Use connections to retrieve data from various sources. 

       Work with relational databases like Oracle to understand the data and be able to analyze/troubleshoot data issues. 

       Actively participate in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration. 

       Provide documented operation and user procedures, when required, and perform supporting training for respective users. 

       Provide data flow diagrams describing the solution, when required. 

       Document implementation instructions for production and lower-environment deployments. 

       Run jobs and facilitate procurement of test data, when needed, in order to test code to satisfaction. 

       Be available for occasional off-hours (Eastern time zone) production deployments in order to support dev ops team if questions/issues arise with ETL code. 

       Import/export objects using IICS and knowing the impacts of all of the options.

       Troubleshoot and analyze error logs and job results that do not meet the requirements. 

       Communicate effectively and in a timely, respectful, professional manner with all teammates. 

Required experience: 

       5-7 years of ETL experience using Informatica IICS 

       5-7 years practical experience with SQL (standard query language) on relational databases

       Effectively communicate in English, both written and spoken language 

Preferred experience: 

       Using Salesforce Developer Console with SOQL (Salesforce Object Query Language)

       Maintaining production systems 

       Data modeling 

       Creating and maintaining business reports 

       Intermediate-level expertise in Microsoft Excel (vlookups, pivot tables, etc) 

       Running Salesforce Data Loader 

       Promoting code between environments 

       Working with MSDOS batch files as pre- and post-conditions for IICS jobs

       IICS server configurations 

       Analyzing and retrieving full production error

Experience Level:

       5-10 years

Thank You!

Udit Dabas|
Recruitment Lead

D:
215-278-8860

First Ring Solutions LLC | Philadelphia, PA 19102

Note: Due to high volume of calls, I may miss your call, email is the better way to reach me
,
Kindly co-operate

Keywords: Colorado Michigan Pennsylvania
ETL Informatica Developer role Hybrid, Troy , MI Must be Genuinely Local to MI
[email protected]
[email protected]
View all
Wed Oct 02 22:54:00 UTC 2024

To remove this job post send "job_kill 1806221" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 15

Location: Troy, Michigan