ETL Informatica Developer

Job Description

JOB DETAIL
Summary

Location – Remote/ WFH

As a ETL Developer (Informatica) , you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable.

Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.

Your role in our mission

• Establishes and enforces data warehousing standards at the client site to meet client requirements and business needs.

• Determines data warehousing strategy; selects tools and techniques, including middleware, data cleansing tools, and/or data management systems to provide the solution to data and client issues and other matters of significance and to meet business needs.

• Conducts research into new data warehouse applications and determines viability for adoption.

• Evaluates existing subject areas stored in the data warehouse and determines where data should be stored.

• Assists in several components of the overall architecture of the data warehouse system.

• Documents tasks for end-user, technical, and managerial review to ensure high quality customer service.• Provides descriptive analyses of customer, product, and market trends and identifies and resolves data issues.

• Performs quality assurance testing of data integration and report development. Monitor’s data load operations to ensure accuracy.

What we’re looking for

• Bachelor’s degree or equivalent combination of education and experience

• Five+ years of experience in Informatica – PowerCenter 10.x, PowerExchange 10.x

• Design, develop and maintain robust Informatica PowerCenter mappings and workflows that process huge volumes of data across multiple platforms.

• Solid experience with performance tuning of Informatica processes in partitioned database environment.

• Advanced SQL, UNIX, Shell, Scripting skills and ability to write complex Stored Procedures.

• Strong knowledge and Hands-on experience in complex data transformations dealing with large volume of data.

• Experience working with COBOL/mainframe file structures using Power Exchange

• Design and develop DB2 Procedures and UNIX Shell Scripts for Data Import/Export, Data Conversions, Performance-tuning and work on migration of database jobs in between different environments.

Other Qualifications

• Strong personal computer and business solutions software skills.

• Strong communication skills to interact with team members, clients, and support personnel.

• Good analytical and problem-solving skills for selecting data tools and resolve data warehousing issues.

• Strong skills in data administration, repository management, and data warehousing.

• Ability to work independently and as part of a team.

Work Environment

Hybrid Office environment and WFH

• Fast-Paced, Challenging and rewarding work environment.

• Work life balance.

• Will require late evening work to overlap US work hours.