Informatica ETL Developer TROY, MI (Hybrid 3 days a week) 12+ Months Web Cam Interview
$50/Hr on W2 or $55/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 out of Huge, well-known Enterprises may work but banking is really preferred.
Candidate Must Have's on a resume and for submittal:
How many years working with: Informatica
How many years working with: Oracle
How many years working with: SQL
How many years working with: Banking/FIS
How many years working with:
Job Description:
Sr. Data Developer Experience Level5-10 years
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
Numbers & Facts
Location
TROY, MI
Skills
Analysis Skillsunmatched
Architectural Designunmatched
Banking Servicesunmatched
Communication Skillsunmatched
Data Analysisunmatched
Data Migrationunmatched
Data Modelingunmatched
Database Extract Transform and Load (ETL)unmatched
Database Programming Languagesunmatched
English Languageunmatched
Financial Servicesunmatched
Identify Issuesunmatched
Import/Exportunmatched
Informaticaunmatched
Microsoft DOSunmatched
Microsoft Excelunmatched
Operations Processesunmatched
Oracleunmatched
Oracle Databaseunmatched
Pivot Tablesunmatched
Production Systemsunmatched
Purchasing/Procurementunmatched
Relational Databases (RDBMS)unmatched
Requirements Managementunmatched
SQL (Structured Query Language)unmatched
Salesforce.comunmatched
Software Development Lifecycle (SDLC)unmatched
Systems Administration/Managementunmatched
Systems Maintenanceunmatched
Test Dataunmatched
Test Plan/Scheduleunmatched
Testingunmatched
Time Managementunmatched
Vlookupsunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.