Skip to main content

This job has expired

Senior Informatica Developer

Employer
Assurant
Location
Chicago, Illinois
Salary
Not Specified
Closing date
Mar 21, 2019

View more

Category
IT , Sales
Job Type
Not Specified
Career Level
Not Specified

Job Details


Assurant is hiring a Senior Informatica Developer to join our team in Chicago! This position is responsible for using best practices to develop complex data integration solutions across multiple applications using Informatica PowerCenter 9.x. This work is necessary in order to connect our existing applications to our new application being developed on the Salesforce.com Platform and for general ETL applicability.

Responsibilities:

  • Prepare estimates for complex projects to allow management to accurately forecast project delivery dates and cost.
  • Work closely with Project Teams and participate in full software development life-cycle from requirements gathering, estimating, design, development, and implementation.
  • Design, develop, test, and document best practice and scalable Informatica workflows, mappings, mapplets and transformations.
  • Ensure that ETL jobs fully conform to governor limits, API batch restrictions, and all other requirements of integrating with the Salesforce.com platform.
  • Tune performance of Informatica jobs to ensure optimal efficiency and performance.
  • Analyze the legacy source systems to identify business rules around data profiling, data flows, data transformations, and data cleansing.
  • Perform validations against transactional records and make corrections to resolve data quality issues.
  • Participate in code review and recommend solutions to enhance ETL programs to project team and management.
  • Create Structured Query Language (SQL) scripts. (Stored Procs, SQL Functions,)
  • Creates deployment instructions including failure recovery procedure, and monitors successful data load of deployments.
  • Participate in multiple mock data conversion tests to validate the conversion process and reduce implementation risk.
  • Works with Quality Assurance team in developing test scripts and test plans for validating the accuracy of ETL jobs and the quality/integrity of loaded data.
  • Assist in post implementation-verification support.
  • Mentors/coaches others in Informatica, ETL and Data Warehousing by sharing knowledge, best practices and lessons learned from relevant past experiences.
  • Provide production on-call support to existing systems.
  • Assist in continuous improvement efforts and enhancing project team methodology and performance.



Basic Qualifications:

  • Bachelors degree in Computer Science or commensurate work experience required, Master's in Computer Science preferred.
  • 8+ years of relevant ETL experience
  • 5+ years working with Informatica PowerCenter / Informatica ETL jobs

Other knowledge:

  • Informatica PowerCenter integration developer.
  • Knowledge and understanding on cloud technologies used in enterprises
  • Working with highly-available, software-as-a-service platforms
  • Ability to work as part of a team.
  • Performance tuning.
  • Proactive monitoring experience.
  • ETL Developer.
  • SQL skills.
  • Data architecture: Relational Dbs

Preferred Qualifications:

  • Working knowledge of Informatica Cloud
  • Experience developing on Salesforce.com platform and familiarity with Salesforce Triggers, Validation Rules, Workflow Rules, etc
  • Experience developing integrations with SF.com platform
  • Experience working with MuleSoft integration tool
  • Certified Informatica Developer
  • Experience with Customer Relationship Management and/or Product Warranty industry practices

Advertisement

Company

At Assurant, we protect, connect and support major consumer purchases ... like homes, cars, appliances, and phones ... in partnership with industry-leading brands.

The brands people trust ... trust Assurant.

We help our clients connect and protect over 300 million consumers around the world.

We have 125 years of experience, 14,000 employees and operate in 21 countries.

Our unwavering purpose

We protect what matters most.

Our uncompromising values

Common sense, common decency, uncommon thinking and uncommon results guide the way we support our customers and work with each other. guide the way we support our customers and work with one another.

COMMON SENSE

We seek simple, straightforward solutions that keep life running smoothly for the clients and consumers we serve.

COMMON DECENCY

We act with integrity. We treat others with respect, courtesy, and kindness. We’re honest, transparent and committed to doing the right thing.

UNCOMMON THINKING

We're never satisfied with the status quo. We seek diverse perspectives and thrive on challenge. We believe there's always a way to build upon our successes.

COMMON RESULTS

We focus on actionable solutions that deliver measurable results. We approach each challenge with a sense of urgency, striving to exceed every expectation.

Company info
Website

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert