ETL Informatica Developer role Hybrid, Troy MI Must be Genuinely Local to MI

Title:                     ETL Informatica Developer
Location:             Hybrid, Troy , MI (Must be Genuinely Local to MI)
Duration:             6+ Months

MOI:                      IN - Person

 

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…