Hello Associates!
I have a Senior Certified Informatica Lead Consultant, if you have any open requirements please send it to sam@zuventech.com
Below I am mentioning his Background Summary and Technical Skills
Consultant Name | Technical Skills | Current Location | Visa Status | Availability |
MJNTH | Certified Lead Informatica Consultant | Columbus, OH | H-1B | Immediate |
IT Professional with strong Data warehousing and ETL Design, Administration, Development Skills
Key Skills: Informatica PowerCenter 9.x/8.x/7.x/6.x, Oracle 11, 10g, 9i, 8i, UDB, Teradata, Data Analyzer, Metadata Manager, Power Exchange, SQL Server, Admin Console, Netezza, Informix, Multiple other Informatica Product tools
Professional Summary:
· Overall 9 years of IT experience in Data warehousing and Data Migration projects, primarily as specialist in performing Analysis, Design, Development, Testing, Implementation , Migration, Deployment, Enhancement and Maintenance of Informatica ETL solutions in Production and Non-Production Environments.
· Extensive experience with Informatica PowerCenter 9.x, 8.6, 8.5, 7.x, and 6.x hosted on UNIX, Linux, Solaris, AIX and Windows platforms. Worked extensively on Data Warehouse applications development using ETL Tools Informatica, DB2, Teradata, Oracle and UNIX Shell Scripts.
· Extensively worked on multiple Informatica versions & installed multiple versions on the same servers (due to business requirement) without impacting performance, availability.
· Performed Informatica administrative tasks using Informatica Repository manager and Admin console.
· Strong experience in designing, developing and testing large scaled applications as per functional requirements using Informatica , DB2/Teradata/Oracle and Unix Shell
· Worked extensively with Data migration, Data Cleansing, ETL Processes and Web reporting.
· Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments and warranty Support.
· Extensively used different utilities of Teradata such as BTEQ, Fast export, Fast load, Multiload, SQL Assistant, DDL and DML commands
· Experienced with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, Multi Load, SQL Assistant
· Defined, documented and implemented development standards, best practices, Configuration and change management mechanisms.
· Gathering functional specifications and business requirements and performing source system analysis, Data profiling.
· Strong experience in designing and developing complex ETL (extract, transform, and load) mappings, reusable components and performing power center administrative tasks.
· Extensive experience in implementing error handling, auditing and reconciliation and balancing mechanisms in ETL process
· Experience in defining testing strategies, creating test cases for unit, functional and integration testing, documenting test results.
· Proven experience working with various source systems Oracle, Teradata, SQL Server, DB2 UDB/OS 390, Microsoft Access, Sales Force, Power Exchange for Main Frames and Flat Files in Informatica
· Expertise in trouble-shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
· Experience in identifying performance bottle necks and fine tuning informatica jobs.
· Experience in writing UNIX Shell scripting.
· Involved in Review meetings during Design & Development to identify, reduce/mitigate risk at every stage.
· Supervised the Offshore activities.
· Created Standard migration checklist & promotional checklist document template
· Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerCenter Server.
· Imported Sources and Targets, Created Mappings and developed Transformations using Informatica PowerCenter designer.
· Used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator, Joiner and Sequence generator.
· Used Type 2 SCD Mapping to insert new Dimensions and update Dimensions in the Target and maintain the history.
· Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
· Wrote UNIX and PL/SQL scripts for pre & post session processes and to automate daily loads.
· Experience in using third party tools like Toad, PL/SQL developer, Win SQL, Lotus notes, WinSCP.
· Experience in 24X7 support and provided immediate solutions to Customer
· Experience in reconciling the data, Data profiling and Data Validation.
TECHNICAL EXPERTISE
ETL Tools | Informatica Power Center 8.x/7.x/6.x, Informatica Power Exchange for Mainframe & SalesForce, Informatica Admin Console, Admin Support Tool, DataAnalyzer |
BI/OLAP Tools | Business Objects 5.1,BO XI |
Modeling | Erwin |
Programming Languages | C, C++, COBOL, JAVA,PL/SQL, HTML, UNIX Scripting and XML |
Databases | Oracle, Teradata 12, SQL Server, DB2 UDB/OS 390, Microsoft Access |
Operating System: | Windows NT/2000, UNIX, Linux, Solaris, AIX |
Tools & Utilities | Toad, Sql*plus, PL/SQL developer, Win SQL, Lotus notes, Tivoli, Control-M |
Version Control Tools | VSS,CVS |
Other | MS Visio, MS Power Point, MS word, MS Excel |
Thanks and Regards
SAM
Operations Manager
Zuven Technologies Inc.
2222 Spring Creek Drive, Ste 102 || PLANO, TX 75023
Direct: 469-361-2179' Fax: 469-718-0405
Mail to: sam@zuventech.com
http://www.linkedin.com/in/samevens
We respect your on-line privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line with the e-mail address this message was received. I am sorry for the inconvenience caused to you.
No comments:
Post a Comment