Title: Informatica ETL Developer (IICS)
Duration: 6+ months
Interview: Video and can be In person
Visa: USC, GC, TN, OPT/EAD, CPT/EAD, EAD/GC, H4/EAD,
Rate: $50
City: Hybrid, Troy, MI (locals only)
Informatica ETL Developer
We just got in an Informatica ETL Developer (IICS) for Flagstar. Hybrid 2 days a week in Troy, MI. Rate is $50 (let me know if this rate works)
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 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.