Badges
55 Points
9 Years
User Activity
About 6 years ago
Answered a question: Which is better, Informatica PowerCenter or SSIS?
Hands down Informatica. I've used both. Informatica is system and DB
agnostic and can run on any platform. If set up correctly like I do in my
architecture moving from the platform (Windows) to Linux or AIX would take less
than a day
Also, Informatica is highly…
About 9 years ago
Answered a question: Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?
Parameter file handling in Informatica can be automated very easily using tables and Informatica itself. I have built a process in Informatica that will build parameter files dynamically. No manual creation or movement across environments.
Experience
Following
Answers
About 9 years ago
Data Integration
About me
Experienced and highly motivated ETL Architect with over 30 years of IT experience having an expertise in all levels, types and facets of IT. Strong knowledge of Data Warehousing and Dimensional Star Schema approaches. Deep understanding of data, data profiling and data construction.
Over 10 years of experience with Informatica on an Enterprise Data Warehouse for mid-level and large Health Payor Organizations. In depth knowledge of medical and pharmacy claims processing systems.
• Proficient in ETL approaches and design using best practices.
• Skilled in Informatica PowerCenter, workflow manager and workflow monitor.
• Strong leadership and mentoring skills, having led ETL teams of upwards of 15 fulltime and contract developers.
• Advanced analytical and data profiling skills.
• In depth understanding of all types of development involving data.
• Extensive experience with multiple databases including Oracle, Sybase, DB2 and IMS Mainframe databases.
• Strong understanding of job scheduling and set up.
• Full understanding of SDLC.
• Mainframe and AIX experience.
