RAJ

About RAJ

• Over 7+ years of progressive hands-on experience in analysis, ETL processes, design and development of enterprise level data warehouse architectures, enterprise level large databases, designing, coding, testing, and integrating ETL. • Proficient in understanding and detailing the business requirements and had experience in interacting with business users to clarify requirements and translate the requirements into technical and user stories. • Experience in Dimensional data modelling techniques, Slow Changing Dimensions (SCD), Software Development Life Cycle (SDLC) (Requirement Analysis, Design, Development & Testing), and Data warehouse concepts - Star Schema/Snowflake Modelling, FACT & Dimensions tables, Physical & Logical Data Modelling. • Experience in integration of various data sources like Oracle 12c,11g,10g, MS SQL Server, XML files, Teradata, Netezza, DB2, Flat files, Salesforce, Mainframe sources into staging area through ETL Process and loaded data into different target Enterprise level databases. • Expertise in Master Data Management concepts, Methodologies, and ability to apply this knowledge in building MDM solutions • Experience in installation and configuration of core InformaticaMDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server, and Cleanse Adapter in Windows. • Expertise in developing large integrated complex mappings with standard transformations and complex transformations like SQL transformation, Java Transformation for calling API’s, Store-procedures, Flexible Target Key transformation (AI, BI modes) also developed complex re-usable chunk of mappings called Mapplets, and Worklets and re-usable and non-reusable transformations. • Extensively worked on ETL Automation Testing using Ruby,done unit testing and acceptance testing through Automation and captured major and minor bugs during code development and delivered highly efficient Business deliverables. • Hands on Experience in SQL, DB2 SQL, TSQL, PL/SQL code and done Perl scripting to validate the record counts in the xml’s, getting load event id to process, updating the status of events for the load event id and building informaticaparameter file and executing the informatica workflows using Perl scripts. • AlsodevelopedUNIX shell scripts to run batch jobs and Informatica workflows from Unix server and automatedtheentireETL test ruby specs through Jenkins that is integrated with the docker, so units and acceptance will run on daily basis. • Extensively worked on Informatica Data Quality (IDQ) projects and worked on Informatica Data Quality transformations like Address validator, Parser, Labeller, Match, Exception, Association, Standardizer and other significant transformations.As a Data Quality developer initiated the process of Data profiling by profiling different formats of data from different sources. • Expertise in maintaining the different Versions of the code in GitHuband expertise in maintaining Project and Feature branches and hands on experience in deploying the code from Development server to Test Region or to Production server using Urban Code Deployment tool (UCD). • Designed complex Mappings and enhanced the performance by identifying the bottle necks in Performance tuningat targetlevel,sourcelevel, mapping and session level and worked with dba to identify the bottlenecks during the transaction commits and logs. • Maintained best practice of writing tests first and developing code next a Test-Driven Development methodology TDD which is associated in writing Good Failing Tests first, Developing Code next, then Passing already written Failed Tests and finally Refactoring the code. • Hands on experience working in UNIX, LINUX and Windows environments. • With both On-site and Off-shore experience have developed skills in system analysis, troubleshooting, debugging, deployment, Team management, prioritizing tasks and customer handling. • Domainknowledge experience on Health, Finance, Insurance, Telecom Domains.