Informatica Developer Resume

SUMMARY:

Over 13 years of IT experience with emphasis on Data Warehousing, Business Intelligence, Migration and Integration solutions.
Hands on experience with expertise skills in Data Warehouse architecture, Informatica Power Center, Informatica Power Exchange, Oracle and PL/SQL.
Extensive experience leading and architecting end - to-end implementation involving design, analysis, development, customization, support, consulting in Data Warehousing and Migration applications.
Extensively worked on performance tuning of Informatica, Oracle and Data Warehouse processes.
Proposed and implemented new data architecture, standards and governance processes where needed.
Worked on Informatica Power Exchange for Oracle CDC and other Informatica tools like Test Data Management (ILM), IDQ.
Hands on experience in ETL administration, which involves installation and configuration of Informatica Power Center and Power Exchange in Unix and Windows environments, upgrades from 7.1 to 8.6 and 8.6 to 9.5.1.
Experience in RDBMS features, Logical & Physical database design including Snowflake and Star schema design and data modeling using ERWIN & ER/Studio.
Experience in writing Unix and Perl Shell Scripts for automation of environment builds, deployments, log archiving and scheduling processes using tools like Control M and Autosys.
Hands on working knowledge in Oracle and PL/SQL writing Store Procedures, Packages, Functions and Triggers.
Experience working with Agile - Scaled Agile Framework (SAFe) to ensure high quality work.
Design, develop, and implement interactive visualizations by analyzing large datasets.
Served as mentor and reviewer to developers in all areas of data warehousing, BI and ETL.
Excellent communications skills and quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS:

BI Tools: Informatica Power Center 7.1.4/8.6/9.5.1 , Power Exchange 8.6, OWB9i, Cognos BI.

Languages: C, C++, Java, JSP, Java Script, Unix Shell Script, PERL and PL/SQL.

Data Bases: Oracle 9i/10g/11i, DB2, DB2 UDB, SQL Server, Informix.

Other Tools: Autosys, Control M, Erwin, ER/Studio, Fitnesse, Rally, Informatica Lifecycle Management tool for Data Masking, IDQ.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

Extensively worked on performance tuning of Informatica, Oracle and Data Warehouse processes.
Proposed and implemented new data architecture, standards and governance processes where needed.
Worked on Informatica Power Exchange for Oracle CDC and other Informatica tools like Test Data Management (ILM), IDQ.
Hands on experience in ETL administration, which involves installation and configuration of Informatica Power Center and Power Exchange in Unix and Windows environments, upgrades from 7.1 to 8.6 and 8.6 to 9.5.1.
Experience in RDBMS features, Logical & Physical database design including Snowflake and Star schema design and data modeling using ERWIN & ER/Studio.
Experience in writing Unix and Perl Shell Scripts for automation of environment builds, deployments, log archiving and scheduling processes using tools like Control M and Autosys.
Hands on working knowledge in Oracle and PL/SQL writing Store Procedures, Packages, Functions and Triggers.
Experience working with Agile - Scaled Agile Framework (SAFe) to ensure high quality work.
Design, develop, and implement interactive visualizations by analyzing large datasets.
Served as mentor and reviewer to developers in all areas of data warehousing, BI and ETL.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship