Etl Informatica Developer Resume
EXPERIENCE SUMMARY
- 8.5+ years’ experience of working in Oracle Applications, across multiple industries including Hi - Tech, Manufacturing and Leasing companies
- As a techno functional consultant have vast experience in delivering several successful Oracle Applications implementations in R12 and 11i - related to Projects Accounting and Financial Modules
- Associated with the top technology firms in the world, that provide IT services, business consulting and solutions
- Experience in understanding the existing business process and analyzing the 'As-Is' business scenarios, business process reengineering and end user requirements, custom designing solution, troubleshooting issues and providing complete solutions.
- Demonstrated strong capabilities in business requirement mapping and transforming these requirements into Oracle applications technical specifications and detailed test plans and custom design solutions.
- Excellent problem solving, organizational, inter-personal, and communication skills.
- Self-Motivated and great leadership skills with an ability to efficiently interact with business users,lead business projects and translate details to technical team.
- Experience in leading a team of 15 - 20 members, Onsite Offshore Coordination, planning, prioritizing and execution of major milestones and deliverables.
- Developed various documents as per AIM methodology like MD050, MD070, MD120, BR100, TE040, CV040 and CV060.
- Functional responsibilities: Requirements gathering, gap analysis, application design, configuration, AOL setups, test script, writing test cases
- Technical responsibilities: Major experience in developing RICE components in financials & project accounting modules. Excellent knowledge on SQL, PL/SQL, and excellent understanding of Oracle applications table structures across modules.
- Technical design documentation, estimation based on functional points and complexity. Designing custom solutions, Unit and Systems integration Testing. Conducting User acceptance testing and Go - live activities and providing production support.
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 9x/8x/7x Workflow manager, Workflow monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Work Designer, Task Developer, Parameter files, Gantt Chart, Task view, mappings, Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Reusable Transformation, Sessions, Work flows
RDBMS: Oracle, Tera data, DB2, MS SQL Server, Sybase, My SQL, MS Access, Toad
Programming Languages: SQL, PL/SQL, HTML, C, C++,XML
Operating Systems: Windows XP/7,UNIX, LINUX, and MS-DOS
Software Packages: MS-Office, PowerPoint, Word, Excel, Outlook
Testing Tools: AutoIt, Rational Robot
Databases: Oracle 10g
Scripting Languages: Python, Perl, TCL/Expect Unix Shell Script, SQL, HTML, XML
Microsoft Tools: MS Office (Word, excel, powerpoint
Operating Systems: Windows 98/2000/XP, LINUX (Red Hat, Centos)
Defect Tracker: Rational ClearQuest, DDTS, PVCS
Methodologies: SDLC, STLC and Agile
Tools: TOAD, Putty, Teraterm
App/Web servers: Tomcat, Apache
PROFESSIONAL EXPERIENCE
ETL Informatica Developer
Confidential
Professional Summary:
- Around 7 years of IT experience in analysis, design, development and implementation of Data warehouse, data marts using Informatica Power Center with Oracle, MS SQL server, DB2, XML Files and Teradata databases.
- Strong expertise using Informatica Power Center Client tools - Designer, Repository manager, Workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
- Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse using Informatica Power Center.
- Strong knowledge of data warehouse methodologies like Star and Snowflake Schemas, SDLC pocess.
- Proficient in implementing complex business rules by creating re-usable transformations, Workflows/Worklets and Mappings/Mapplets.
- Proficient in using Workflow Manager Tools like Task Developer, Worklet Designer.
- Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
- Experience in designing/developing complex mapping using transformations like Unconnected and Connected Lookup, Router, Filter, Expression, Aggregator, Update Strategy and SCD 1, 2 and 3.
- Experience with Informatica Server Manager to create sessions and workflows to run with the logic embedded in the mappings.
- Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident.
- Comprehensive knowledge of Software Development Life Cycle from requirement gathering, analysis/design, development and testing
- Expertise in taking backups, recovery of workflows, sessions and mappings from repositories.
- Experience in dimensional modeling to design star schema databases.
- Experience in document process and training team members by creating and maintaining technical documentation, deployment diagrams and checklists.
- Good working skills in writing PL/SQL, SQL, Database Triggers and Oracle SQL query tuning concepts.
- Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
- Involved in SQL tuning and Informatica performance tuning. Tuned performance of Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
- Expert in Unit Testing, Integration testing and Performance Testing.
- Experience in complete Software Development Life Cycle SDLC (Requirement Analysis, Design, Development and Testing).
- Worked with different SDLC Environments Iterative, Water Fall Methodologies.
- Designed Applications according to the customer requirements and specifications.
- Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.
- Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.
- More than 8.5 years of experience in Embedded applications, java based web applications and database testing in Telecom domain Good understanding of Software Development Life Cycle (SDLC) and all stages of QA and Defect Life Cycles
- Expertise in Software Test Life Cycle (STLC), which includes Risk Analysis, Planning Process, Test Design, Requirement Traceability Matrix, Performing Test, Defect Tracking and Test Reporting
- Expertise in both manual and automation testing
- Experience in Framework driven automated system testing.
- Experience in developing test plans, test cases, defect logging and deployment
- Actively involved in Functional, Integration, System, Performance, Regression, GUI Testing, End to End testing, User acceptance and Database testing
- Good experience of Scripting languages like Unix Shell Script (bash),Python, Perl, TCL and SQL queries.
- Experience in testing windows based GUI application using Autoit and Rational Robot
- Worked with RDBMS such as Oracle to query and test data for integrity
- Experience working with SQL, XML and HTML
- Experience testing on Linux and WINDOWS environments.
- Extensive knowledge on defect management Life cycle and Version control systems using Rational Clear Quest, DDTS, PVCS, ClearCase, CVS, SVN.
- Familiarity with Agile software development process.
- Familiarity of Quality Assurance standards, processes methodologies and strategies.
- Proficient in Office productivity tools such as MS Word, Excel, Outlook, and Access
- Strong in analyzing business requirements and specifications and development of test plans, test scripts, test cases and executing them.
- Experience in leading a testing team, assigning and tracking tasks provided to team members
- Involved in training/mentoring the fellow team members and trainees on the software
- Good team player with excellent technical and communication skills
- Self starter with strong problem solving abilities
Web/UI developer
Confidential
Responsibilities:
- Around 7 years experience in development, designing and integrating applications in software industry.
- Expertise in development and designing of web applications with HTML, XHTML, HTML5, DOM, CSS2, CSS3, AJAX, JavaScript.
- Experience in JavaScript frameworks like JQuery etc.
- Expertise in writing clear, well-documented, well-commented and efficient code for web development.
- Good problem solving, organizing, communication and planning skills to achieve results in corporate environment.
- Good working knowledge of HTML5, CSS3
- Transformed Web/Graphic Designers static prototypes into hand-coded HTML, specifically emphasizing accuracy, efficiency & adhering to W3C-established web standards with respect to maintaining cross-browser/cross-platform compatibility.
- Developed page layouts, Navigations and presented designs and concepts to the clients and the management review.
- Converted wireframes and Photoshop images into functional CSS2, CSS3, XHTML and JavaScript code.
- Experience with tools like Dreamweaver, Adobe Photoshop.
- Capable of performing in fast paced and result driven environment.
- Experience with browser testing, knowledge of cross-browser/cross-platform compatibility.
- Self-motivated and a team player with excellent interpersonal and communicational skills.
- Experienced in AGILE based development environment.
- Collaborated with the backend team and other groups by attending daily SCRUM meetings and
Sr QA
Confidential
Responsibilities:
- Around 7 years of experience in Software analysis, Software Quality Assurance Testing of Web, Windows, Client/Server applications in Banking, Healthcare Applications.
- Experience in all stages of the Software Development Life Cycle and QA Life Cycle and in all dimensions of Functionality, Usability & Regression etc.
- Proficient in using test automation tools such as Selenium Web Driver/IDE, TestNG, QTP and Mercury Quality Center to develop automation testing scripts for web and client server applications.
- Exposure to Data Driven & Keyword Driven Automation Frameworks, also have been involved in framework understanding/usage/debugging/maintenance/extending, testscript generation, testdata preparation, keyword generation using Selenium and QTP automation tool.
- Experience in TestNG testing frame works, Used Eclipse as an IDE for developing Java and TestNG Seleniumcode.
- Experience in various types of testing such assmoke Testing,Functional Testing,Regression,GUI,and Integration Testing.
- Broad understanding and working experience of various stages ofBug Life Cycleusing defect tracking tools (QC, CollabNet TeamForge Defect Tracking Tool).
- Good understanding and knowledge of Object Oriented Programming concepts (Java).
- Experience in creating, reviewing of Test scripts, executing, maintenance of test scripts, and generation of test reports, manual Execution of Test Cases and Generation of Defect Report. Skilled in Ad hoc Test.
- Experience of Quick Test Professional features like Descriptive programming.
- Proficient in analyzing system & functional specifications, use cases, business requirements, business rules to prepare test scripts/scenarios.
- Usedfirebugtool for finding Xpath of the WebElements. Conducted Cross Browser testing in Google Chrome and Firefox using Selenium.
- Good skills in implementing the test requirements, design test scripts, test data and execute test runs.
- Demonstrated ability to self-motivate and be flexible within a fast-paced environment
- Self-starter ability to adapt and learn new things quickly and have great attitude.
- Possess excellent Communication and Presentation skills along with verbal and written skills.
Android Developer
Confidential
Responsibilities:
- 7+ years experience in designing and implementing Java and Android Solutions
- Good knowledge of Android Application Framework and Framework APIs
- Experience in Android development using Android SDK, Android Emulator, Eclipse IDE along with android Plug in - ADT
- Expertise in developing application using Activity, Fragments, Action Bar, Animation, Notification Manager, Location Manager, MapView etc
- Experience in Android debugging tools - DDMS, LogCat, ADB
- Experience in working directly with vendors/clients on project estimation, infrastructure planning, requirement analysis and software design
- End -to- end knowledge of publishing an application in Android Market place
- Experience in Web Development, Distributed Applications, Client-Server and N-tier (Multi-tier) using Object Oriented Design(OOD), Object Oriented Analysis(OOA), Object Oriented modeling (OOM) based on Unified Modeling Language(UML) architecture using Rational Rose 2000 and Microsoft Visio.
- Proficiency in developing applications using Oracle, MySQL, SQL Server 2000, PostGres and SQLite databases
- Experience in version control tools like VSS, ClearCase, SVN, CMVC and Git
- Good understanding of Software Development Life-cycle(SDLC) and Software Test Life-cycle(STLC)
- Experienced in White box testing, Performance testing, Manual Testing and Unit Testing
- Experience in Testing tools like Quality Center(QC)
- Familiarity of Quality Assurance standards, process methodologies and strategies
- Programming with web based distributed architecture using Sun's Java technologies
- Experience in Developing Applications using core Java, WebServices, XML, HTML, UML, JDBC, JavaScript
- Experience in design patterns like MVC, DAO, Singleton
- Worked on Low level and High level Design and Documentation
- Experience in software development methodologies like Agile and WaterFall methodologies
- Experience in Media and communication, Healthcare and Finance domains
- Good Team Player with excellent Communication and interpersonal skills. Ability to learn and master new technologies and to deliver outputs in short deadlines
- Development of the android applications(Eclipse, Android 2.3/4.0 SDK, core Java)
- Android platform APIs, Android UI toolkit (basic/picker/list views, adapters, dialogs, menus, Action Bar, Fragments, web view, custom view ), layout managers, content providers and SQLite
- Android application framework: Activities, Intents, Services, Broadcast Receivers, Authentication, Camera API
- Android SDK tools: Debugger (DDMS), Device Manager (AVD), Editors
- Integration of the Android based mobile applications with RESTful web services
- Good understanding of the web related technologies, formats, and protocols (XML, REST, JSON, SyncML, WML, PHP)
- Linux, C, shell scripting, SQLite, Object oriented Design/Programming
- Experience in the development of SyncML based enterprise synchronization server, synchronization engine, sync adapters, and SyncML clients for PDAs(Palm, Pocket PC, and EPOC) and for mobile phones (Ericsson and Nokia 9210 communicator)
- Experience in working with the version control (CVS, SVN) ; Bug tracking tools
Android Developer
Confidential CA
Responsibilities:
- 7+ years experience in designing and implementing Java and Android Solutions
- Good knowledge of Android Application Framework and Framework APIs
- Experience in Android development using Android SDK, Android Emulator, Eclipse IDE along with android Plug in - ADT
- Expertise in developing application using Activity, Fragments, Action Bar, Animation, Notification Manager, Location Manager, MapView etc
- Experience in Android debugging tools - DDMS, LogCat, ADB
- Experience in working directly with vendors/clients on project estimation, infrastructure planning, requirement analysis and software design
- End -to- end knowledge of publishing an application in Android Market place
- Experience in Web Development, Distributed Applications, Client-Server and N-tier (Multi-tier) using Object Oriented Design(OOD), Object Oriented Analysis(OOA), Object Oriented modeling (OOM) based on Unified Modeling Language(UML) architecture using Rational Rose 2000 and Microsoft Visio.
- Proficiency in developing applications using Oracle, MySQL, SQL Server 2000, PostGres and SQLite databases
- Experience in version control tools like VSS, ClearCase, SVN, CMVC and Git
- Good understanding of Software Development Life-cycle(SDLC) and Software Test Life-cycle(STLC)
- Experienced in White box testing, Performance testing, Manual Testing and Unit Testing
- Experience in Testing tools like Quality Center(QC)
- Familiarity of Quality Assurance standards, process methodologies and strategies
- Programming with web based distributed architecture using Sun's Java technologies
- Experience in Developing Applications using core Java, WebServices, XML, HTML, UML, JDBC, JavaScript
- Experience in design patterns like MVC, DAO, Singleton
- Worked on Low level and High level Design and Documentation
- Experience in software development methodologies like Agile and WaterFall methodologies
- Experience in Media and communication, Healthcare and Finance domains
- Good Team Player with excellent Communication and interpersonal skills. Ability to learn and master new technologies and to deliver outputs in short deadlines
JAVA/WEB/UI Developer
Confidential CA
Responsibilities:
- Over 7 plus years of real time experience in developing applications using concepts of Core Java, JEE, JSP, Servlets, Struts 2, Hibernate, JDBC, Web Services, HTML, JavaScript, Ajax, C/C++, Data Structures .
- Proficient in using OOPs Concepts (Polymorphism, Inheritance, Encapsulation) Overloading & Overriding, Final, Finally, Finalize, Garbage collection, Synchronization, Collections, Arrays, Interfaces, Multithreading etc.
- Experienced in handling various Application Servers using JBoss.
- Proficiency in developing applications based on Model View Controller (MVC) Architecture using Struts Frameworks and also expertise in Struts Tag Libraries.
- Experience in developing applications using Struts2, JSP, AJAX, JavaScript, HTML and CSS in Front-End.
- Expertise in writing simple and complex SQL, PL/SQL Functions and Procedures.
- Efficient in creating job streams to extract data from input files, validate and load data into database (Oracle/SQL Server), developed various reports and core tables lookups utilizing Business Objects.
- Excellent knowledge and experience in PL/SQL, Oracle 10g, My SQL Server and Oracle Database.
- Efficient working experience in handling databases using Hibernate.
- Exposure in working all phases of the software development cycle (SDLC) using Agile and Waterfall models.
- Proficient in using the design patterns like MVC, Singleton, Factory, Abstract Factory etc.
- Experienced in Unit testing, System testing, Integration testing.
- Working experience in various platforms like Windows and UNIX based systems.
- Focused to provide definite solutions in solving critical business problems.
- Excellent in project documentation, logical and analytical abilities.
- Good Technical, Communication and Interpersonal Skills and strong Customer Orientation and Client Interfacing Skills.
- Strong Programming and Troubleshooting skills.
- Self-motivated, Quick-learner and Dynamic Team Player.