Hybrid Informatica ETL Developer Troy, MI (locals only)

Title:                                   Informatica ETL Developer

Duration:                         6+ months

Interview:                        Video

Visa:                                     USC, GC, TN, OPT/EAD, CPT/EAD, EAD/GC, H4/EAD,

City:                                     Hybrid Troy, MI (locals only)

 

 

.

 

 

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 DataLoader

• 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 logs from server

 

 

Thank & Regards

Shard Phutela | Senior Techincal Recruiter

D: 267-665-2313,

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.

 

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments