ETL Developer-100% remote, preference to candidates local to Troy, MI

Published date Posted on Indeed on Aug 05, 2022 (7 d ago)

Job Title: Sr. Data Developer(ETL)

Location: 100% remote, preference to candidates local to Troy, MI

Job Overview:

  • Responsible for developing, enhancing, debugging, maintaining, documenting, and testing software applications that will support various business units using IICS (Informatica Intelligent Cloud Services).

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:

  • 3-5 years of ETL experience using Informatica IICS
  • 3-5 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

Job Type: Full-time

Salary: $55.00 - $65.00 per hour

Schedule:

  • 8 hour shift

Work Location: Remote


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Piper Companies Piper Companies |
|
Yesterday

Piper Companies is looking for an IT Manager, Data for a leading pharmaceutical organization based in the Philadelphia, PA area.THIS IS A REMOTE OPPORTUNITYResponsibilities for the IT Manager, Data:You will lead developers, data engineers, DevOps, BA’s,.

Get To Know Us!GuideWell and its family of forward-thinking companies are focused on helping people and communities achieve better health and are at the forefront in the transformation of health care. We offer competitive salaries and benefits, work-life.

NeoGenomics Laboratories NeoGenomics Laboratories |
|
Yesterday

Are you motivated to participate in a dynamic, multi-tasking environment? Do you want to join a company that invests in its employees? Are you seeking a position where you can use your skills while continuing to be challenged and learn? Then we encourage.

Origami Risk Origami Risk |
|
Yesterday

Overview:The Software Implementation Specialist/Client Executive is part of the Professional Service team at Origami Risk. You will be a hands-on generalist focused on leading both technical and functional aspects of the full software implementation.

Tista Science and Technology Corporation Tista Science and Technology... |
|
3 d ago

Overview:The Senior Database Architect must have experience creating work breakdown structures and development of program schedules and assigning software development team personnel to tasks. Must have experience in the tracking resources and expenditures.

Cloud for Good Cloud for Good |
Today

Cloud for Good, the Nonprofit and Higher Education Partner of the Year for Salesforce, is seeking Data Practice Lead to manage large data migration projects with nonprofit organizations and educational institutions. This role is responsible for driving.

BHS (formally Business Health Services) BHS (formally Business Health... |
Today

BHS optimizes organizational performance by empowering individuals to achieve their fullest potential. For over 38 years, BHS has provided comprehensive well-being solutions to thousands of corporations, agencies, institutions, associations, and organizations.

Piper Companies Piper Companies |
Today

Piper Companies is looking for a Pharma Business Analyst for a client of ours that is a leading provider of pharmaceutical support services, partnering with biopharmaceutical companies to make medicine and specialty therapies safer and more accessible.

The Identity Business Analyst (IBA) will be tasked with working with all Identity Governance customers todesign an Identity Governance solution that incorporates sound architectural principles, industrystandards and best practices, and recent product.

Spruce Technology Spruce Technology |
Today

Contract W2, Contract Corp-To-Corp, 12 MonthsDepends on ExperienceWork from home available Travel not requiredJob DescriptionTitle: Data Architect/ Data ModelerDuration: 12+ MonthsLocation: Remote JobSpruce Technology is a mid-size and rapidly-growing.