SUMMARY

• Overall 14+ years of IT industry experience encompassing different set of skills, roles and domains in Data Warehousing Analysis, Design, Development, Implementation, Testing and supporting of ETL(Informatica).
• Worked on several phases of project such as Requirement Analysis, Designing, Development, Testing and production support.
• Solid hands on experience in Development, Interface testing, Integration testing and functional testing.
• Strong Analytical capacity in analysis of Business, Functional, and test requirement.
• Very good understanding in various stages of Software Development Life Cycle (SDLC).
• Exposure in familiar with various Life Cycle Models like Waterfall and Agile model.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Strong database skills and Oracle knowledge.
• Hands on experience to Develop SQL Queries to validate Source & Destination Tables.
• Experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Oracle.
• Proficient in Database testing like Data Verification, Data Validation, Data Integration.
• Experience in leading and managing teams. Handled multiple roles - ETL Lead, ETL Designer, ETL Developer, ETL Tester and Production Support/Enhancements.
• Extensive experience with development, testing, debugging, implementation, documentation and production support.
• Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner and Update Strategy) from varied transformation logics in Informatica.
• Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in UNIX shell scripting, FTP, Change Management process and EFT file management in various UNIX environments.
• Experience in creating procedures, functions in PL/SQL, troubleshooting and performance tuning of PL/SQL scripts.
• Developed Perl scripts for invoking Informatica workflows and for running batch process.
• Good knowledge of Big Data tools, such as Pig, Hive, and Hbase.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Good analytical, programming, problem solving and troubleshooting skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.4.1/10.2/10.1/9.6.0/9.5/8.6/8.0 and Informatica BDM

Database: Oracle 12c, Oracle 9i/10g/11g, SQL Server 2014/2008/2005 , Big data (Hive) and MySQL.

Scheduling Tools: Tivoli Word load Scheduler (TWS) and Informatica Scheduler.

Programming: SQL, PL/SQL, SQL Plus, Transact SQL, ASP.NET,C#,ADO.NET, Visual studio 2005, HTML, C#, Unix, Korn Shell Scripting, Perl script.

O/S: Sun Solaris 2.6/2.7/2.8/8.0 , HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22Win 3.x/95/98, Win NT/ XP Professional, Red Hat Linux, Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills, MI

ETL -Tech lead

Responsibilities:

• Responsible for entire system development and enhancement team for all the issues related with event processing modules (Stage area, Operational data Store, Foundation data mart and reporting data marts).
• As a lead responsible for assigning tasks and get status on day to day work from offshore team and report status to delivery manager and client.
• Single point of contact for business, client IT manager, testing team, upstream and downstream systems for any development, testing and support related issues and deliverables.
• Mainly responsible for Warranty claim processing system where warranty claims can be adjusted, Validated, Cancelled and then paid. It is very critical Process payment system and should be available to dealers all times to submit warranty claims so that payment will be done on time. The main tools used in this system are Informatica, Unix, Web services, PLSQL,Tivoli Work Load scheduler, Perl Script. Oracle 12c, Power Center, Taxware.
• Responsible for creating Test Strategy, Test Plan, Test Scenarios, Test Cases, and Release document. The main tool used for testing data will be Toad along with MS Excel. Prepare unit test result document. These documents will be created using MS word and MS Excel and will be reused in future.
• Performed Interface testing, Integration testing, functional testing, Regression testing.
• Responsible for co-ordination of VWGoA Business team with Atos team for Function and Technical Aspects and also responsible for the requirement analysis, effort estimation, project planning, task allocation, creating Test Plan, Test Scenarios, Test Cases, Release document, facilitating issue resolution and risk identification in different development and enhancement activities in the team.
• Serving as the Center Point for the entire system development, Testing and enhancement team for all the issues related with event processing modules (Stage area, Operational data Store, Foundation data mart and reporting data marts.). Tools used for this activity are Informatica ETL (Extract, Transform, and Load) tool.
• Responsible for translating business requirements to technical requirements and creating technical design documents and test plans for the Operational and Data warehouse objects.
• Responsible for the design, architect, coding, testing, deployment activities and support of Data warehouse ETL (Extract, Transform and Load) in the application using Informatica.
• Responsible for scheduling and monitoring jobs for daily Operational data in Service & Quality and user communication for different Data Warehouse related activities.
• Playing an important role in the preparation of different administrative reports to be discussed in the status call meetings, weekly and monthly Problem and Change ticket management reports, daily operational reports, project plans, etc.
• Review and guide the developers & testers in the team for the development, Testing, enhancement and Production Support activities.

Environment: Informatica powerCenter10.4.1, Oracle 12c/11G, Tivoli workload scheduler(TWS), Perl Script, Toad, WinScp, Putty, MySQL workbench, MySql, Linux, Unix, Service Manager9, Service Center2.0, Agile, PLSQL & SQL.

Confidential, Auburn Hills, MI

ETL-Tech lead

Responsibilities:

• Responsible for co-ordination of VWGoA Business team with Atos team for Function and Technical Aspects and also responsible for the requirement analysis, effort estimation, project planning, task allocation, creating Test Plan, Test Scenarios, Test Cases, Release document, facilitating issue resolution and risk identification in different development and enhancement activities in the team.
• Responsible to get status on development and help team to resolve the technical and functional issue.
• Responsible to review code, test results and get UAT done with business before moving code to production.
• Designed and developed mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Preparation of unit test case doc and performed unit testing, Integration testing, UAT and functional testing for the developed mappings.
• Worked on data cleansing and query tuning. Involved in analyzing the source data coming from different data sources like Oracle, Flat Files, XML and SQL Server and identifying data anomalies in operational data.
• Prepared Detail design documentation thoroughly for production support and release management department to use as hand guide for future production runs before code gets migrated
• Scheduled jobs for running daily, weekly and monthly loads through TWS for each workflow in a sequence along with job and file dependencies.
• Worked with the Release Management Team for the approvals of the Change requests, Incidents using Service Manager Incident tool.
• Worked with the infrastructure team to make sure that the deployment is up to date.
• Monitoring the TWS batch jobs status and fixing the failures.
• Responsible for interacting with cross teams for fixing data issues.
• Worked in Performance Tuning of Informatica Mappings and Sessions.

Environment: Informatica powerCenter 1 10.2.0/9.6.1 , Oracle 11G, Tivoli workload scheduler(TWS), Perl Script, Toad, WinScp, Putty, MySql workbench, Unix, MySql, Service Manager9, Service Center2.0, Agile, PLSQL & SQL.

Confidential, Auburn Hills, MI

ETL - Senior Developer

Responsibilities:

• Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
• Worked on project documentation, which included the Functional, Technical and ETL Specification documents.
• Experienced in using Informatica for data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems
• Designed and implemented ETL mappings and processes as per the company standards, using Informatica PowerCenter.
• Extensively worked on complex mappings, which involved slowly changing dimensions.
• Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping.
• Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.
• Used Parameter files to specify DB Connection parameters for sources.
• Created the design and technical specifications for the ETL process of the project.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked with the Release Management Team for the approvals of the Change requests, Incidents using Service Manager Incident tool.
• Worked with the infrastructure team to make sure that the deployment is up to date.
• Applied slowly changing Dimensions Type I and Type II on business requirements.
• Scheduled jobs for running daily, weekly and monthly loads through TWS for each workflow in a sequence along with job and file dependencies.
• Worked on development and production support.

Environment: Informatica powerCenter 9.5/8.6, Oracle11G, Tivoli workload scheduler(TWS), Perl Script, Toad, WinScp, Putty, MySql workbench, Unix, MySql,Service Manager9/7,PLSQL & SQL.

Confidential

ETL-Developer

Responsibilities:

• Served as the Focal Point for the entire system enhancement team for all the issues related with event processing modules (Stage area, Operational data Store, Foundation data mart and reporting data marts.)
• Prepared unit test, integration test cases, performed unit test, UAT, integration testing and created result documents.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Developed mappings by extensively using Informatica Transformations like Lookup, Filter, Expression, Aggregator, joiner, and stored Procedures etc.
• Created and scheduled Workflows and Sessions using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules Optimized/Tuned mappings for better performance and efficiency.
• Used slowly changing dimensions concept to load data into dimensions tables.
• Migrating the Mappings and sessions into the Test Environment and Monitoring scheduled workflows in Production Environment and resolving the issues if any.
• Interacting with the client regarding data and functional requirements
• Production Support, Major enhancements, Testing and maintenance of existing Data warehouse.

Environment: Informatica powerCenter 8.6, Oracle11G, Toad, WinScp, Putty, MySql workbench, MySql, Service Manager 7, PLSQL & SQL.

Confidential 

Application Developer

Responsibilities:

• Involved in all Phases of software life cycle like Requirement analysis and design and coding and testing application.
• Involved in Database design, requirements gathering from business and all requirement related meetings.
• Involved in UAT with business.
• Created requirement specifications documents, user interface guides, and functional specification documents and test cases.
• Written stored procedure to gather and calculate data for Reports generation

Environment: ASP.NET, C#, ADO.NET, SQLserver2000/2005, Visual studio2000/2005, Oracle.