Informatica ETL Developer - Hybrid
msysinc Troy
Title: Informatica ETL Developer - Hybrid
Location: Troy, MI, USA
Length: Long term
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.
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
Location: Troy, MI, USA
Length: Long term
Restriction: W2 or C2C
Description:
Webcam interview; *** Long term project *** Hybird - Need locals only
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:
- 7 years of ETL experience using Informatica IICS
- 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.
Wise IT IncTroy (MI)
Informatica Developer
• Refine Requirements, design and develop Informatica solutions, perform Unit and Integration Testing, and handle deployments
• Must have 1-2 years informatica Experience
• Experience with Unix Korn Shell is desired...
Pontiac (MI), 12 mi from Troy (MI)
allows our clients to succeed with industry-first applications, tools and support. You’ll also work on a summer-long project where you’ll collaborate alongside students with backgrounds & passions in software development, databases and infrastructures...
Pontiac (MI), 12 mi from Troy (MI)
allows our clients to succeed with industry-first applications, tools and support. You’ll also work on a summer-long project where you’ll collaborate alongside students with backgrounds & passions in software development, databases and infrastructures...