We provide IT Staff Augmentation Services!

Informatica Developer Resume

PROFESSIONAL SUMMARY:

  • ETL Tools with a strong background in Design, Development, Testing, Implementation and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica Power Center 9x/8.x/7.x, Oracle 9i/10g/11g.
  • Using ETL tools Informatica Power Center, Oracle SQL, SQL Server, JAVA, Unix, PL/SQL, Shell Scripting.
  • Good knowledge in Informatica data warehouse architecture.
  • Good knowledge in SQL and coding PL/SQL Packages, Stored Procedures, Views, indexes, Function and database Triggers. Experience in using SQL*Plus, Toad 7.6.
  • Extracted data from various data sources like flat files, Excel, SQL Server, DB2 and Oracle.
  • Knowledge in all aspects of Project Development Life Cycle in Data Warehousing like Requirements Gathering Analysis, Design, Implementation, Testing and Maintenance.
  • Efficient in trouble shooting, performance tuning, and optimization of ETL and reporting analysis.
  • Perform Unit testing of the developed code and do peer review for quality and validity of the code.
  • Good exposure in Data Cleansing, Transformation, Data import, Data export and use of Oracle Database.
  • Involved in creating Dimensional Data Modeling and creating Fact table and Dimensional tables.
  • Well versed in OLTP Data Modeling, Data warehousing and DataMart concepts.
  • Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse, Data marts concepts and principles (Kimball/Inmon) - Star schema, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
  • Idea on Workflow Manager Tools - Task Developer, Workflow & Work let Designer.
  • Good knowledge with mappings from various transformation logics like Unconnected and Connected lookups, Filter, Router, Aggregator, Joiner, Normalizer and re-usable transformations.
  • Quick understanding of Relational Source Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
  • Over all Knowledge and working experience on BIPM stream (Business Intelligence and Performance Management).
  • Using the Informatica command line utilities like pmcmd, pmrep server and pmrepagent to execute or control sessions, tasks and workflows in non-windows environments.
  • Using SQL Loader to load data into database by writing CONTROL files.
  • An enthusiastic and positive software engineer prepared for a challenging position in a high quality engineering environment. Possesses strong interpersonal and communication skills.
  • Experience in using version control tools like SVN, CVS and GIT.
  • Proficiency in programming with different Java IDE's like Eclipse.
  • Knowledge in designing User Interface (UI) applications and professional web applications using HTML4/5, XHTML, CSS2/3, JavaScript, JQuery, AJAX, JSON, AngularJS, reactjs and Java
  • Extensive Experience in applying the latest software development approaches including MVC, event driven applications using AJAX, Object Oriented (OO) JavaScript, JSON, Reactjs and XML.
  • Good knowledge with XML technologies including XML, XSL, XSLT, Xpath, XQuery and XML parsers like SAX, DOM.
  • Testing reducers only focus on state flow using React.
  • Good knowledge in Twitter Bootstrap, SASS and LESS.
  • Idea in using multithreading concepts and jdbc framework.
  • Good knowledge of latest version of object oriented JavaScript Libraries like Angular.js, Node.JS, Bootstrap, ExtJS 4.0, Require, Handelbars, and Dojo toolkit.
  • Idea in SPA (single page application), Custom directives, custom modules in Angular.js.
  • Knowledge in Fixing CSS Cross Browsing Compatibility issue and web application scaling.
  • Knowledge on implementing the AJAX features using JavaScript and jQuery.
  • Good idea in implementing Rest based web services using JAX-RS annotations,
  • Professional in creating Templates, Mockups and Prototypes, Web Interfaces, Layouts and Flow of Future Pages.
  • Experienced in various IDEs like Eclipse, Notepad++, Sublime Text, Adobe Dreamweaver, Microsoft Visual Studio and Webstrom
  • Comfortable with (Express, Angular and Node.js and reactjs) stack.
  • Comfortable with NPM modules like (Express, Grunt, Bower, File Sytem, HTTP).
  • Extensive knowledge in HTML/HTML5, CSS/CSS3.
  • Good knowledge of using JavaScript testing frameworks, Jasmine and Karma.
  • Experience on working with CSS Backgrounds, CSS Layouts, CSS Positioning, CSS Animations, CSS Text, CSS Borders, CSS Margin, CSS Padding, CSS Table, and Pseudo Classes.
  • I developed the Intern’d App for the internships and for entry level positions.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/9.1/8.6/7. X

Database: Oracle 11g/10g/9i, Vertica, SQL Server2008R2/2012, SQL Server 2005, MySQL.

Scripting: Shell

Operating Systems: Windows, Linux-Unix

Business Intelligence Tools: Cogon’s, Tableau

Web Technology: HTML, HTML5, XHTML, CSS, CSS3, JavaScript, JQuery, AJAX, JSON, XML, Bootstrap, Angular Js, Reactjs,Hibernate,structs, Spring.

Programming Languages: C, Java

IDE & Editors: Notepad++, Microsoft Visual Studio, Eclipse.

Application Server: Web Sphere, Apache Tomcat, Node Js, Asp.net.

Other Tools: GIT, Adobe Photoshop, MS Office, Jira, Firebug, Chrome Developers Tool, Windows Movie Maker.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

  • Knowledge in all aspects of Project Development Life Cycle in Data Warehousing like Requirements Gathering Analysis, Design, Implementation, Testing and Maintenance.
  • Efficient in trouble shooting, performance tuning, and optimization of ETL and reporting analysis.
  • Perform Unit testing of the developed code and do peer review for quality and validity of the code.
  • Good exposure in Data Cleansing, Transformation, Data import, Data export and use of Oracle Database.
  • Involved in creating Dimensional Data Modeling and creating Fact table and Dimensional tables.
  • Well versed in OLTP Data Modeling, Data warehousing and DataMart concepts.
  • Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse, Data marts concepts and principles (Kimball/Inmon) - Star schema, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
  • Idea on Workflow Manager Tools - Task Developer, Workflow & Work let Designer.
  • Good knowledge with mappings from various transformation logics like Unconnected and Connected lookups, Filter, Router, Aggregator, Joiner, Normalizer and re-usable transformations.
  • Quick understanding of Relational Source Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
  • Over all Knowledge and working experience on BIPM stream (Business Intelligence and Performance Management).
  • Using the Informatica command line utilities like pmcmd, pmrep server and pmrepagent to execute or control sessions, tasks and workflows in non-windows environments.
  • Using SQL Loader to load data into database by writing CONTROL files.
  • An enthusiastic and positive software engineer prepared for a challenging position in a high quality engineering environment. Possesses strong interpersonal and communication skills.
  • Experience in using version control tools like SVN, CVS and GIT.
  • Proficiency in programming with different Java IDE's like Eclipse.
  • Knowledge in designing User Interface (UI) applications and professional web applications using HTML4/5, XHTML, CSS2/3, JavaScript, JQuery, AJAX, JSON, AngularJS, reactjs and Java
  • Extensive Experience in applying the latest software development approaches including MVC, event driven applications using AJAX, Object Oriented (OO) JavaScript, JSON, Reactjs and XML.
  • Good knowledge with XML technologies including XML, XSL, XSLT, Xpath, XQuery and XML parsers like SAX, DOM.
  • Testing reducers only focus on state flow using React.
  • Good knowledge in Twitter Bootstrap, SASS and LESS.
  • Idea in using multithreading concepts and jdbc framework.
  • Good knowledge of latest version of object oriented JavaScript Libraries like Angular.js, Node.JS, Bootstrap, ExtJS 4.0, Require, Handelbars, and Dojo toolkit.
  • Idea in SPA (single page application), Custom directives, custom modules in Angular.js.
  • Knowledge in Fixing CSS Cross Browsing Compatibility issue and web application scaling.
  • Knowledge on implementing the AJAX features using JavaScript and jQuery.
  • Good idea in implementing Rest based web services using JAX-RS annotations,
  • Professional in creating Templates, Mockups and Prototypes, Web Interfaces, Layouts and Flow of Future Pages.
  • Experienced in various IDEs like Eclipse, Notepad++, Sublime Text, Adobe Dreamweaver, Microsoft Visual Studio and Webstrom
  • Comfortable with (Express, Angular and Node.js and reactjs) stack.
  • Comfortable with NPM modules like (Express, Grunt, Bower, File Sytem, HTTP).

Hire Now