- Design and develop ETL mappings and workflows using Informatica
- Analyze, design, build, test and document complex data conversion and integration solutions
- Design and develop Extract Transfer and Load (ETL) Code to migrate and integrate data from disparate data sources into SAP for specific projects
- Work with business groups to develop and implement business rules to be used for ETL processes
- Manage team code standards, integrity of code base, enforce proper source control and re-usability of extract and load code as well as various standard transformations that will apply to all systems
- Establish policies and best practices for optimizing ETL data throughput/accessibility; create and maintain business intelligence and data migration design principles using industry best practices
Minimum 1+ years of experience working with SQL Server, Oracle, SSIS, Informatica, and/or other ETL tools is required.
Excellent skill is SQL scripting and database management.
Desired experience with Informatica v9.x / 10.x but not a must have.
Bachelor's degree in a technical area from an accredited college or university
Demonstrated ability to design and develop complex ETL mappings, sessions, workflows, and identify areas of optimizations
Ability to recognize the value of ETL Architecture Design Patterns and re-use.
Must be a critical thinker with very strong analytical and problem solving skills