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).