SUMMARY:

• Experience in Analysis, Design, Coding, Development, Implementation and performance tuning in Talend Data Integration Suite 6.x/5.x, Talend BigData 5.x as part of various Data Integration, Data Migration and Data warehouse projects executed for major clients.
• Expert knowledge in using ETL methodology for supporting Data Extraction, Transformations and Loading processes in corporate - wide ETL solutions using Talend Data Integration, Talend Data Mapper and Informatica Power Center .
• Design and Build common re-usable ETL components for job initialization, reprocessing of error records, audit processes, Job monitoring and ETL logging processes.
• E xperience in all phases of the software development life cycle, including requirements analysis, project planning, development and software testing and simultaneously involved in configuration management activities and Warranty and App Support transition.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring jobs as well as performance tuning of jobs.
• Experience in using Automation Scheduling tool Talend Administration Center, Tivoli Workload Scheduler and Autosys.
• Worked in multiple onshore-offshore model based and Client facing projects exhibiting proficient communication and co-ordination skills.
• Engaged in team management activities like planning and scheduling tasks, mentoring new members, organizing knowledge transfer sessions, configuration controller and defect prevention analysis.

TECHNICAL EXPERTISE

Primary Skills: Talend, Informatica, Data warehouse, Unix

Tools: handled: Talend Data Integration 5.4-6.3, Talend Administration Center(TAC), Informatica Power Center, Tivoli Workload Scheduler, HP Service Manager tool(HPSM), Team Foundation Server(TFS), Serena Version Manager (PVCS)

Database Worked on: Oracle, SQL Server, Sybase, DB2

Scheduling: Autosys, Tivoli Workload Scheduler (TWS)

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Build dimension data model to house data from various sources.
• Development of Talend ETL jobs for loading data to the new datamart from existing Everest II data warehouse.
• Creation and load of Supplementary tables which are not part of the core data model.
• Design and develop the auditing and logging at mart level.
• Develop pre-processing and post processing jobs to set the job dependency.
• Applied SCD 2 logic in ETL jobs and creation of rollback strategy for datamart tables.
• Creation of Tivoli jobs and preprod and prod deployment.
• Created joblets and used Parameters and Variables to facilitate the reusability of code.
• Involved in Fine-tuning of Talend jobs for initial and Supplementary load.

Software and Tools: Talend Data Integration v6.3, Sql server, Tivoli Workload Scheduler, Team Foundation Server.

Confidential

Responsibilities:

• Set strategy and oversee design and development of the talend jobs.
• Interact with clients for project status, priority setting and resource allocation.
• Participate in deployment, system testing, UAT.
• Understanding business requirements and preparation of technical design build document based on business requirements.
• Created complex jobs for conversion of files to different formats acceptable by product, Client and Bank interfaces.
• Used various Talend components database components, mapping components, Flat file components, XML and WebService components.
• Worked on design and development of dimension and fact load jobs for EDW load.
• Applied SCD 1 and 2 logics in ETL jobs.
• Used Parameters and Variables to facilitate the reusability of code.
• Involved in Fine-tuning of Talend jobs to obtain optimal performance and throughput.
• Experience in deploying, scheduling and executing jobs using Talend Administrator Center.
• Involved in technical of resources in Talend for emerging accounts. Assisted members in coding issues.

Software and Tools: Talend Data Integration v5.4, Talend Data Mapper, Oracle, Talend Administrative Center, TFS

Confidential

Responsibilities:

• Analysis of existing deferral system and impact of the changes in database schema on the downstream data flow.
• Designed the development and data flow approach per the business need.
• Interacted with Business Analyst to understand and analyze the business requirements.
• Created ETLs for integration of Client’s application with external vendor by creating semi-monthly and yearly files by fetching data from EDW and updating legacy databases for enrollment and payment information received from the vendor.
• Developed and executed UNIX scripts for execution of ETL.
• Involved in analysis, creation and scheduling of Autosys jobs for complete flow.
• Involved in creation/execution of Test cases.

Software and Tools: Informatica 9.1, Rapid SQL, Unix, Autosys jobs, DB2, Sybase, TFS

Confidential

Responsibilities:

• Involved in creation of ETLs for data load from operational database to warehouse and mart for the new tables.
• Creation of UNIX scripts and testing of existing Autosys jobs to automate the process.
• Involved in analysis and changes in the existing Operation Reporting Database cycle to include the data flow to downstream databases for the changes in UI.

Software and Tools: Informatica 9.1, Rapid SQL, Unix, Autosys jobs, DB2, Sybase, TFS

Confidential

Responsibilities:

• Involved in creation of add, update and delete ETLs for load in operational database from flat file. Also created the CnB mapping.
• Creation of UNIX scripts and testing of existing Autosys jobs to automate the process.
• Prepared the Implementation Plan, overall Job Scheduling Diagram, individual Job diagrams and various other Documentations for support transition.

Software and Tools: Informatica 9.1, Rapid SQL, Unix, Autosys, DB2, Sybase, TFS

Confidential

Responsibilities:

• Involved in daily cycle monitoring and handling exceptions through incident management.
• Worked on various ideas including simplification tech project for app elimination, creation of CnB between operational database and warehouse and setting up prod like test environment.
• As part of problem management, made changes to various UNIX scripts and informatica mappings.
• Involved in monitoring, maintenance and enhancement of the applications and was part of status meetings with Onsite coordinators and Business clients.
• Performing the impact analysis and its required code changes for the valid defects logged by Independent Testing Team.
• Prepared the Implementation Plan, overall Job Scheduling Diagram, individual Job diagrams and various other Documentations.
• Involved in the checks and balances for data in operational database, warehouse and mart and to reduce the overhead on the resource by automating the business regular works.
• Responsible for all aspects of problem management including problem investigation, impact analysis, root cause identification and problem resolution using change management and release management.
• Strong monitoring and analytical skills.

Software and Tools: Informatica 9.1, Rapid SQL, UNIX scripts, Autosys, DB2, Sybase, TFS

Confidential

Responsibilities:

• Worked on data movement using Informatica 9 from backend to stage and backend to ODS.
• Actively participated in the requirements analysis and building of system design.
• Involved in peer review of mappings and creation unit test cases.

Software and Tools: Informatica 9, Rapid SQL, UNIX, Autosys, DB2, Sybase, PVCS