Sr. ETL IDMC Informatica - APM lead Developer - 100% Remote

Sr. ETL IDMC Informatica - APM lead Developer - 100% Remote

Posted 1 day ago by 1753881385

Negotiable
Outside
Remote
USA

Summary: The role of Technology Engineer focuses on developing and supporting technology solutions for the Broker Commissions Team, emphasizing ETL development and innovative problem-solving. The ideal candidate will possess advanced ETL expertise and the ability to mentor junior developers. This position requires collaboration with business experts to design solutions that enhance commissions payment processing. The role is classified as a lead level position, indicating a significant level of responsibility and expertise.

Key Responsibilities:

  • Define, analyze, and review business requirements, system requirements, technical requirements and prioritize tasks
  • Write clean, testable code using IDMC, Informatica, SQL, vendor integrations, and data modeling
  • Work with Azure Dev Ops, GIT and deployment pipelines
  • Document physical designs and relevant documents that help reduce longer term maintenance time
  • Implement monitoring solutions and logging practices
  • Leverage industry standards and best practices for software development including automated integration, test driven development, reusable code, object-oriented design, software configuration management, and use of emerging AI solutions
  • Hold code reviews, perform unit testing, participate in paired programming and partner with QA to test for quality
  • Test Automation

Key Skills:

  • Bachelor's degree in related field or equivalent experience
  • 8-10 years of relevant/related experience
  • Familiarity working with financially significant applications and commissions payout processes
  • Strong ETL development experience
  • Expert level knowledge & experience writing SQL queries for Oracle or SQL Server
  • Familiarity with agile software development practices
  • Troubleshooting abilities, production support experience, and good communication skills
  • Experience with SAP's APM application (preferred)
  • Experience in cloud platforms with end-to-end application building, source controlling and deployment (preferred)

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: Lead

Industry: IT

Detailed Description From Employer:


Duration: Contract to Hire
Location: Minnetonka, MN or Madison, WI (Hybrid)


Job Description:
We are seeking a talented and motivated Technology Engineer to join our Broker Commissions Team. The ideal candidate will have a strong background in Extract Transform, Load (ETL) development bringing innovative and problem-solving thought leadership.

This role is responsible for developing and supporting technology solutions to advance the Commissions business domains utilizing technologies such as Informatica, SQL, vendor integrations and data modeling. The IT Engineer IV will work with a team of developers and interact closely with business subject matter experts to design and build solutions that help sell their products.

This Commissions Tech team is focused on building solutions to support business domains around commissions payment processing utilizing SAP's product Agent Performance Management (APM), Informatica, SQL, and file transfers.

Summary of Role

  • This is a Lead level position.
  • An advanced level of ETL development expertise, can work independently and with a team, and is able to provide guidance and mentoring to junior level developers.


Responsibilities

  • Define, analyze, and review business requirements, system requirements, technical requirements and prioritize tasks
  • Write clean, testable code using IDMC, Informatica, SQL, vendor integrations, and data modeling
  • Work with Azure Dev Ops, GIT and deployment pipelines
  • Document physical designs and relevant documents that help reduce longer term maintenance time
  • Implement monitoring solutions and logging practices
  • Leverage industry standards and best practices for software development including automated integration, test driven development, reusable code, object-oriented design, software configuration management, and use of emerging AI solutions
  • Hold code reviews, perform unit testing, participate in paired programming and partner with QA to test for quality
  • Test Automation


Qualifications
Required Qualifications:

  • Bachelor's degree in related field or equivalent experience
  • 8-10 years of relevant/related experience
  • Familiarity working with financially significant applications and commissions payout processes
  • Strong ETL development experience
  • Expert level knowledge & experience writing SQL queries for Oracle or SQL Server
  • Familiarity with agile software development practices
  • Troubleshooting abilities, production support experience, and good communication skills


Preferred Qualifications

  • Experience with SAP's APM application
  • Experience in cloud platforms with end-to-end application building, source controlling and deployment

Best Regards,

Chetna

-D

-Fax

Truth Lies in Heart