Informatica ETL Developer – Hybrid

Job Title: Informatica ETL Developer
Location: Hybrid/Troy, MI
Duration: 1+ Year
Rate: $45/hr on W2 or $50/hr on C2C

We need a mid-senior ETL developer (6+ years, 10+ preferred) with extensive experience working with Oracle, Informatica, SQL, and any experience working with Salesforce is a big plus. Candidates need to be coming out of Banking, trading, or financial services companies. Candidates from large, well-known enterprises may work, but banking is preferred.

Candidates must have: Long project experience, good tenure, excellent communication skills, and a state-issued ID (not bills) showing they are local.

Candidates must be LOCAL to the TROY, MI area and COMMUTE into the office THREE TIMES A WEEK. NO RELOCATION CONSIDERED.

Candidate Must Have’s on a resume and for submittal:

1. How many years working with Informatica
2. How many years working with Oracle
3. How many years working with SQL
4. How many years working with Banking/FIS

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 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, to test code to satisfaction.
• Be available for occasional off-hours (Eastern time zone) production deployments to support the dev ops team if questions/issues arise with ETL code.
• Import/export objects using IICS and understand the impacts of all 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 of practical experience with SQL (standard query language) on relational databases
• Effectively communicate in English, both written and spoken

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 the server

Interested candidates email your resume to &