Informatica Developer

Skills

Bachelor's degree in Business Computer Science Management Information Systems or work equivalent Must have legal right to work in the US Strong written and oral communication skills required Minimum 7 years’ hands-on experience developing ETL code with Informatica’s PowerCenter software Experience with Informatica’s Data Quality software is a plus High level of SQL language proficiency with common database platforms such as SQL Server and Oracle is mandatory Knowledge and experience with other Informatica products is a plus Knowledge and experience with Erwin data modeling is a plus 4+ years of business/technology work experience preferred Working knowledge of BI architecture and data warehousing concepts is a plus Able to critically think and be solution-oriented Strong interpersonal skills and able to work easily with client personnel Works well independently and within a team Great organizational time management and problem solving skills

Description

We are seeking a Sr. ETL Informatica Developer who will work with business users and members of the technical team on the design and development of highly scalable ETL processes utilizing Informatica. The position requires an understanding of common Data Warehouse architecture, design, development, and deployment of Business Intelligence systems.

Additional responsibilities of this role will include the following:

Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities
Develop and ensure adherence to locally defined standards for all developed components
Maintain "common code" libraries, so objects can be shared for all environments (Dev, Test, and Production)
Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
Participate in requirements, design, and development reviews
Conduct or participate in meetings with owners of key system components to fully understand current data and systems environments
Assist in production support by resolving source data issues and refining transformation rules
Analyze source system data and work with technical and business representatives to determine strategies for handling data anomalies that are identified
Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes that assist in implementing enterprise-class data warehousing solutions
Use the Informatica platform to extract, transform, and load data through development, testing, and integration of ETL routines, using ETL tools and external programming/scripting languages as necessary
Assist in writing unit test cases when necessary
Provide data analysis and technical documentation for both source and target mappings
Identify problems, develop ideas, and propose solutions within differing situations requiring analytical, evaluative, or constructive thinking in daily work
Prepare and present ideas and recommendations to colleagues and management
Apply creative thinking to identify possible reporting solution alternatives
Other duties assigned as needed