Tremendous opportunity within the growing healthcare industry! This is the chance to work with one of the countrys premier healthcare providers in a role where you can truly impact the quality of peoples lives!
You will plan, design, code, test, debug, configure and document ETL application systems solutions. Work with other technical team members to deploy technical solutions using design, coding and testing standards. Train and support less experienced developers and be a leader in supporting methodologies and processes as well as streamlining development (focus on reusable code) for faster delivery to end customers.
Design and develop web service mappings in Informatica PowerCenter,
Develop stored procedures using Oracle PL/SQL to extend PowerCenter functionality,
Design and develop exception and error handling,
Design and develop data verifications and validation processes,
Tune and optimize ETL jobs for performance and throughput
Interact with data modelers and DBAs on data designs optimal for ETL performance.
ANALYSIS & DESIGN
Perform data analysis on multiple source systems per project needs,
Design and develop mappings in Informatica PowerCenter to accommodate business requirements for data extraction, transformation and loading,
Design ETL workflow with job dependencies and scheduling.
Design and develop test plans for unit testing, integration testing and user acceptance testing.
Manage security in terms of developer and user access
Manage installation, configuration and upgrades of Informatica PowerCenter software,
Own activities associated with maintaining Informatica PowerCenter repository with ETL and metadata information
7+ years of experience in ETL development using Informatica PowerCenter with minimum of 2 years experience using PowerCenter 8.x required.
7+ years of experience in Data Warehousing, with thorough knowledge of star/ snowflake schemas
5+ years of experience in Oracle database development, using SQL and PL/SQL, with in-depth knowledge of analytical functions are required
4+ years of experience with Unix shell scripting required
Experience with Informatica PowerCenter administration required
Prefer experience with real time data processing and web services in Informatica PowerCenter with knowledge of its XML components
Prefer experience with Embarcadero DS-Auditor
Excellent documentation and communication skills are required