SUMMARY:

• 4.2 years of professional experience in Analysis, Design, Development, Implementation, Integration and testing of n - tier Data Warehousing applications. Involved in all phases of software development life cycle (Use Case, Analysis, Design, Testing and Implementation).
• Strong analytical and problem-solving abilities, motivated self-starter with an attitude for learning new technologies. Played a role as ETL developer, or the production support and involved in Informatica version upgrades.
• Excellent skills in Informatica, Reporting tools. Had experience on SQL, PL/SQL,Unix shell scripting. Have good skills in ETL development and complex transformations involved in it. Basic Knowledge on Reporting Tools like Business objects, Cognos, Spotfire,
• Hands on experience on integrating the relational databases (Oracle, MS SQL, Teradata) with informatica. Worked on the database (Oracle/Teradata) upgrades by migrating the application data and code to the newer versions.
• Involved in the database patching and upgrade activities. Developed a mapping with all SCD types in Teradata based on business requirements.
• Experienced Functional tester skillful at investigating defects, writing test plans and developing user stories.
• Forward-thinking and determined with in-depth understanding of Functional testing and strong Agile and Scrum experience.
• Experienced to develop Test Artifacts such as Test Strategy, Test Plan, Test Cases and Test Metrics reports.
• Extensive experience in Develop/Review Test Cases in Zephyr and Maintaining Test Review Logs
• Expertise in Posting Defects in Bug Tracking Tools like TFS and in JIRA
• Experience in Mentorship to achieve highly Cross Functional Team goal and active learner with new tools, techniques, and approaches.
• Adept at preparing and managing module and regression test plans. Capable of assisting developers with diverse needs, including bug reproduction and code validation. Analytical problem-solver with a well-coordinated approach to handling routine and complex issues.
• Have good Analytical and Strong interpersonal and excellent communication skills

TECHNICAL SKILLS:

• Informatica Power center 9.x,10.x
• Oracle, MS SQL, PL/SQL, Teradata, XML Files
• Unix Shell scripts
• Design and development
• Production support
• Agile methodology
• QA testing and automation
• Testing and debugging
• Documentation and reporting

PROFESSIONAL EXPERIENCE:

Confidential

Senior Project Engineer

Responsibilities:

• Worked with Confidential as full time(40 hrs per week) and played an ETL Developer role in project with the client Confidential .
• Working on Informatica Power Center(8x,9x,10x) providing design, development and maintenance.
• Responsible for creating mapping, transformations and workflows through Informatica. Create complex SQL queries and procedures on multiple related tables to implement the complex business rules based on the requirement.
• Responsible for resolving day to day technical issues and provide optimal solutions following Confidential 's Standard Operating Procedures/Best Practices
• Liaises with Business to provide technology feasibility and solutions based on requirements, provide estimate effort, cost & timeline
• Coordinates and drives the team for development, testing and support tasks related to Informatica ETL Interfaces and also handles the interaction with the various upstream and downstream systems
• Involved in full of client meetings for the upcoming releases and get it transitioned to us for further support.
• Responsible for all stages of Software development Life cycle including business requirement analysis, data mapping, development, Unit testing, Systems integration and User acceptance testing from Onsite team.
• Worked on with Complex SQL to extract data from multiple high-volume relational databases and performed a SQL Query Performance tuning with my skills.
• Participated in all client meetings to get clear picture on the exact functionality required in the tool. Prepared a standard project related documents and managed a team to implement the functionality in Informatica.
• Gathered the user needs to accommodate to the part of requirement and derived steps to develop and modify the applications, writing detailed descriptions of user needs and functions..
• Actively involved on learning all supporting applications and started working more effectively.
• Never missed any tickets out of SLA and also first time right. Actively participated in the weekly calls to provide a status report to client. Worked on the crucial Enhancements by developing ETL with Teradata and overcome multiple challenges on performance based on business needs.
• Provided my hard work and additional efforts to bring the applications in steady state. Worked on Major releases on Prioritized applications

Confidential

Project Engineer

Responsibilities:

• Worked as a full time (40 hrs per week) with Confidential Technologies as a Functional tester skillful at investigating defects, writing test plans and developing user stories.
• Performed functional, non-functional, regression and performance tests for Informatica applications.
• Tested newly created client code for bugs and the issues to determine weaknesses.
• Involved in Understanding the business requirements and raising ambiguities for the same.
• Writing/Reviewing Test Cases and Test scenarios for the requirements in MTM tool.
• Working in Functional Testing, Pega application Testing, Account monitoring and validating the logs.
• Using Aerospike server (In memory database), a no sql DBMS.
• Using SQL queries in TOAD to extract millions of data.
• Using mainframe for placing, changing and cancelling orders for SPS project.
• Using TOSCA automation tool for creating and executing test cases.
• Identified crucial defects most often.Using Parasoft (SOA Test) tool for PAL online web service testing.
• Logging and Tracking the Defects in Defect Management tool like TFS and in JIRA.
• Tested all software prior to applications going live to alleviate bugs and troubleshoot issues.
• Preparing Daily status report and Test summary report and attending daily scrum meetings.