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. • Develop the ETL mappings for XML, .CSV, .TXT sources and loading the data from these sources into relational tables with Talend ETL Developed Joblets for reusability and to improve performance. • Created UNIX script to automate the process for long running jobs and failure jobs status reporting. • Developed high level data dictionary of ETL data mapping and transformations from a series of complex Talend data integration jobs. • Expertise in interaction with end-users and functional analysts to identify and develop Business Requirement Documents (BRD) and Functional Specification documents (FSD). • Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment. • Created context variables and groups to run Talend jobs against different environments. • Used Talend components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator. • Performed requirement gathering, Data Analysis using Data Profiling scripts, Data Quality (DQ) scripts and unit testing of ETL jobs. • Created triggers for a Talend job to run automatically on server.

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.• Designed and customized data models for Data warehouse supporting data from multiple sources on real time• Involved in building the Data Ingestion architecture and Source to Target mapping to load data into Data warehouse• Extensively leveraged the Talend Big Data components (tHDFSOutput, tPigmap, tHive, tHDFSCon) for Data Ingestion and Data Curation from several heterogeneous data sources• Worked with Data mapping team to understand the source to target mapping rules.• Prepared both High level and Low level mapping documents.• Analyzed the requirements and framed the business logic and implemented it using Talend.• Involved in ETL design and documentation.• Developed Talend jobs from the mapping documents and loaded the data into the warehouse.• Involved in end-to-end Testing of Talend jobs.• Analyzed and performed data integration using Talend Cloud hybrid integration suite.• Experience in working with large data warehouses, mapping and extracting data from legacy systems, Redshift/SQL Server UDB databases

• 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.• Extensively used components like tWaitForFile, tIterate, tFlow, tFlowToIterate, tHashoutput, tHashInput, tMap, tRunjob, tJava, tNormalize and tfile components to create Talend jobs.• Used tXmlMap to create xml's based on XSD and created nested loop xml's using tAdvancedXml component as part of development.• Developed optimal strategies for distributing the web log data over the cluster, importing and exporting the stored web log data into HDFS and Hive using Scoop.• Collected and aggregated large amounts of web log data from different sources such as webservers, mobile and network devices using Apache Flume and stored the data into HDFS for analysis.• Implemented Change Data Capture technology in Talend in order to load deltas to a DataWarehouse.• Experienced in using Talend database components, File components and processing components based up on requirements.• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.• Implemented Change Data Capture technology in Talend in order to load deltas to a DataWarehouse.• We must design jobs using Bigdata Talend and Pick files from AWS S3 Buckets and Load into AWS Redshift database

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.• Developed jobs to expose HDFS files to Hive tables and Views depending up on the schema versions.• Created Hive tables, partitions and implemented incremental imports to perform ad-hoc queries on • Structured data. Developed jobs to move inbound files to HDFS file location based on monthly, weekly, daily and hourly partitioning.• Worked extensively on design, development and deployment of talend jobs to extract data filter the data and load them into datalake.• Manage and Review Hadoop log files and hands on with executing Linux and HDFS Commands• Responsible for writing Talend Routines in Java.• Developed ODS/OLAP data model in Erwin and also created source to target mapping documents.• Experience working with web services using tSOAP components for sending XML requests and receiving response XML files. Expertized in reading XMLs files on a loop and sending to webservice end point for generating output XML files. And also used Advanced XML mappers for parsing multiple loop elements.• Responsible for digging into PL/SQL code for investigating data issues.• Involved in the development of Talend Jobs and preparation of design documents, technical specification documents.

• 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• Worked on the project documentation and prepared the Source Target mapping specs with the business logic and also involved in data modeling• Worked on migrating data warehouses from existing SQL Server to Oracle database.• Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scans.• Used Command line Shell to run the Informatica jobs.• Used debugger and breakpoints to view transformations output and debug mappings.• Implemented Performance tuning in Mappings/Jobs by identifying the bottlenecks and Implemented effective transformation Logic.• Created Workflows using various tasks like sessions, control, decision, e-mail, command, Mapplets/Joblets and assignment and worked on scheduling of the workflows.• Verify the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.• Wrote SQL, PL/SQL, stored procedures, triggers and cursors for implementing business rules.• Migrated the code and release documents from DEV to QA (UAT) and to Production.

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.• Worked extensively on Aggregated/Summarized data.• Created Informatica Mappings for Error Handling/Audit Balance control flows.• Prototyping ETL mappings and workflows for Slowly Changing Dimensions (SDCs),• Push Down Optimization (PDO) and corresponding SQL code (Aggregations, Transformations, Rollups, Inserts, Updates, Deletes)• Performance tuning and troubleshooting various Informatica mappings.