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
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.
- Website
- https://jobs.assurant.com/
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert