N Raj Email and Phone Number

Currently am working as a Ta lend Big Data Developer in Mroads.-Build the ETL transformations as per the Business Requirement.-Scheduling the ETL jobs as per Business Requirement.-Experienced in ETL tools like Talend and Informatica-Experienced in BigData-Experienced in different Data bases -Experienced in Data Analysis, Data integration and Master Data Managemanet

• Responsible to build the jobs by looking to the ETL Specification documents.• Having good experience in ETL concepts and analytics.• Responsible to migrate the People soft data into Oracle system using Talend DI programs.• Having good experience in developing the master child jobs using tRunjob components.• Good experience in working all Data Integration components like tmap,tfileInput Delimiter,tfileOutputDelimiter,TflowToiterate,tunique and tjava components.• Responsible for develop the DI jobs to implement the address validations, cleans and standardization on Talend ETL with different components and used features such as context variables, parameterfiles database components.• Responsible for understanding & deriving the new requirements from Business Analysts/Stakeholders.• Responsible for Data Ingestion to inject data into Data Lake using multiple sources systems using Talend Bigdata using Hive and Hbase components.• Responsible for delivarabels as committed in the sprint planning.• Having experience in performance tuning techniques.• Having experience working with Oracle BI tools and Github management.• Good experience in troubleshooting the issues and Talend components.

• 8+ years IT experience in Design, Development, Maintenance, Enhancements and Production Support of which includes Data warehousing and Legacy applications using ETL tools like Talend /Informatica.• Experienced with Informatica PowerCenter tool 9.6.1/9.1/8.6/8.1, Power Exchange as well as Talend Data Fabric. • IT Experience in various industries like CRM-Address Standardizations (Establishing Global Customer Processes Address Cleansing and Standardized customer data), Telecom (CRM, Billing, provisioning, Order management, Inventory System), US –Healthcare (RxClaim pharmacy PBM (Integration OR Implementation OR SDLC, Claims OR Benefits OR Eligibility, Medicare &Medicaid like Rebates, Iris.• Experience in data analysis, mapping & modelling and experienced in Designing ETL models (MDM models using Talend) for the multi-platform applications.• Experienced in using Talend Data Fabric tools (Talend DI, Talend MDM, Talend DQ, Talend Data Preparation, ESB, TAC)• Experienced in using All Talend DI, MDM, DQ, DP, ESB components.• Experienced in match/merge in MDM to run match rules to check the effectiveness of MDM process on data.• Experienced in Talend Service Oriented Web Services using SOAP, REST and XML/HTTP technologies using Talend ESB components.• Experienced in scheduling Talend jobs using Talend Administration Console (TAC).• Good Knowledge and experience in performance tuning in the live systems for ETL jobs that are built on Informatica as well as Talend.• Experience and good knowledge in Designing ETL model for the multi-platform applications.• Good Knowledge and experience in performance tuning in the live systems for ETL jobs that are built on Informatica.• Experience in writing database objects like Stored Procedures, Triggers for Oracle, MYSQL Server, and Netezza databases and good knowledge in PL/ SQL, hands on experience in writing medium level SQL queries.

• Developed number of complex Informatica Mappings, Mapplets and reusable Transformations to implement the business logic and to load the data incrementally (delta load/full load)• Extracting the data from the flat files and heterogeneous Relational databases into staging area and populated into data warehouse using SCD logic to maintain the history.• Created and Used Workflow Variables, Session Parameters and Mapping Parameters, partitioning, Incremental aggregation, scheduler, Indirect method loading, Constraint Based loading, Incremental loading, Target Load Plan, SCD-Type1 and Type2, Tasks.• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.• Created Informatica Mappings to load data using transformations like Filter, Expression, Router, Sorter, Rank, Transaction Control, Source Qualifier, Stored Procedure, SQL Transformation, Normalizer, Sequence Generator, Aggregator, Union, Joiner, Update Strategy, Dynamic Lookup, and Connected and unconnected lookups, Source Qualifier• Implementing the error handling strategies whenever we required in the mappings and applying the default values• Experienced in the performance tuning part in SQL/PLSQL quires and Informatica level• Identified and resolved the bottlenecks in source, target, transformations, mappings and sessions to improve performance.• By looking into logs based on busy percentage, identify the issue whether bottleneck is at reader/writer/transformation thread and fixing the same based on that log to improve the performance.

i Started my career with Magna quest Technologies Worked as ETL Developer.• Preparation of ETL High level design document and publish and review the same with various teams like Modelling, testing and the End Users. • Created mappings using Informatica PowerCenter Designer 8.6, as per ETL specification document & Implemented Reject report for finding the reject records along with the reason for rejecting those in ETL• Developed Informatica mappings for TYPE 1, 2, 3 & Hybrid Slowly Changing Dimensions with two levels of staging to cleanse data. • Creating the Multi group sources (Multi Group Application SQ) using Informatica Power Exchange for mainframes sources. • Unit testing and System Testing