T+S
No h1
hybrid day1
local
Please Complete In This Format Below (required)
IF NOT IN THIS FORMAT I WILL REJECT
Candidate Full Name: - - Legal
PICTURE ID DL or Passport picture
Legal First
Legal Middle
Last Name
Candidate phone#
Candidate E-mail Address
Location / Living:
Local to Michigan and will be Hybrid 2-3 days onsite Michigan?
Visa Status
Last 4 digits of SSN#
Month/Day Of Birth
Available for Interview:
Availability To Start
Bachelors, University/ location Month /Year
Masters University/ location Month /Year
REVIEW JD MAKE SURE REQUIRED SKILLS (highlighted red) ARE ON THE RESUME, IF NOT, DON’T SEND.
Sr. Data Developer #1004948
Job Description
Skills & Job Responsibilities:
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