Devendra Prasad Email & Phone Number

Framingham, MA, US

• Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions (SCD) Type1, Type 2, Type 3 to capture the changes.
• Extensive experience in extraction of data from various sources like relational databases Oracle, SQL Server, and Flat Files.
• Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL.
• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designing, developing and deploying end-to-end Data Integration solution.
• Implemented custom error handling in Talend jobs and worked on different methods of logging.

Raleigh, North Carolina, US

• Developed test transactions in adherence to specifications.
• Analyzed and debugged program code for revision of programs.
• Maintained detailed documentation of program development stages and coding.
• Reviewed documents comprising of software installation and operating processes.
• Conducted technical training session regarding program use.
• Participated in Requirement gathering, Business Analysis, User meetings and translating user inputs into ETL mapping documents.

• Created Talend Mappings to populate the data into dimensions and fact tables.
• Extensively worked on creating repositories in GIT and assigning roles to developers and creating same projects in TAC.
• Broad design, development and testing experience with Talend and BigData Integration Suite and knowledge in Performance Tuning of mappings.
• Development of staging, Data warehouse scripts and deployment
• Writing specifications for ETL processes.
• Deployed, scheduled and Monitored Talend batch jobs using TAC.

Phoenix, Arizona, US

• Interacting with the clients on a regular basis to discuss day-to-day issues and matters.
• On-Call/Production Support provided during day-time and off-hours.
• Played as administrator for setting up development, QA, UAT and PROD environments for Talend, Postgres for development and documenting install plan at client locations.
• Setup ETL Framework, best practices around Talend for data integration implementation.
• Responsible for installing Talend on multiple environments, creating projects, setting up user roles, setting up job servers, configure TAC options, adding Talend jobs, job failures, on-call support and scheduling etc.
• Excellent experience working on tHDFSInput, tHDFSOutput, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tSqoopImport and tSqoopExport.

• Involved in Extraction, Transformation and Loading of data from 10 Source Systems into our data warehouse.
• Work with the offshore team for the day to day work and review the tasks done by them get the status updates in the daily meetings.
• Created Jobs for Matching and Merging to cleanse the data coming from Source system.
• Worked with different Sources such as Oracle, SQL Server and Flat files
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
• Wrote test case scenarios and unit tested the code developed in Informatica

New York, NY, US

• Involved in discussion of various business users Data Analysts from ISD team.
• Worked in an Agile project life cycle environment.
• Conduct source system and source table analysis to develop the necessary data
• Assisted the Data Architect in creating the logical/physical data models.
• Extensively worked on Teradata tables, created Teradata BTEQ procedures and used TPT Reader/Writer utilities for Bulk Loading.
• Created several Staging, Historical and Daily Incremental and ETL maps.