Roy Kumar Email & Phone Number

Chicago, Il, Us

Zurich, Ch

Chicago, Illinois, Us

Lawrence Township, Nj, Us

St. Petersburg, Florida, Us

• Assigned all the tasks in the form of tickets and used JIRA to track them. Our primary source was vault, which needed to be pulled from HIVE and loaded into our landing area.• Delivered all the assigned tasks on time. Work had been divided into sprints, which was for two weeks.• Attended the entire business requirement meeting along with my lead and played a crucial role in building the requirements.• Worked intensively with our team and built easily accessible code without missing the standards of the client.• Prepared 301 business documents, which consisted of the entire data flow form source to target.• Built Data Integration Components using Informatica Power Center following locally DI Framework and recipes (i.e. ETL Cookbook) such as Netezza, Oracle, SQL server on Unix/Linux and Windows operating systems.• Extracted data from our cloud sources (Hive HUE). HDFS system would dump the files into our cloud known as Kafka que which was called as Hive Prod HUE.• Used Hue version- 2.6.1-2 Web interface to query the data.• Design, Development, Testing and Implementation of ETL processes using Informatica Cloud• Utilized Aginitiy AMP to generate Natural keys by the combination of multiple foreign keys

Deerfield Beach, Florida, Us

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner and XML Source Qualifier. • Analyzed, designed and implemented complex SQL stored procedures, ETL processes and Informatica mappings.• Implemented SCD1, SCD2 type maps to capture new changes and to maintain the historic data.• Provided technical assistance during production phase of project development.• Defined and developed technical standards for data movement and transformation as well as reviewed all designs to ensure those standards were met.• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.• Extracted the raw data from Microsoft Dynamics CRM to staging tables using Informatica Cloud• Handled extraction of various types of source files such as Flat files and XML standard source data of different transactions and loaded to staging area.

Philadelphia, Pa, Us

 Technical lead accountable for Enterprise customers, Third Party data Feed subject area’s and  SPOC for all technical issues related to coding, design, migration, and implementation. AGILE methodology was followed. Worked with Business team in understanding the requirement and converting to Design and  Provide expertise to offshore team in Development/testing. Used Pentaho Data Integration Designer to create ETL transformations. Developed Oracle PL/SQL procedure as maintenance routines, which retain data for specific period. Designed and Deployed UNIX Shell Scripts. Reverse engineered a project which was completely developed in Unix Shell Scripting and Perl to  Pentaho/Datastage Framework. Used Oracle SQL loader and COSORT utility to load data from flat files and performing sort  Operations and join operations. Used ELT teradata BTEQ Scripts to load data into Foundation tables Used Teradata Utilities to load data to target tables Migrated a module from Informatica to Datastage 8.5 PX framework Designed and Developed Web service routine calls in Pentaho framework. Worked on different transformations in PDI designer to cleanse and manipulate source data e.g. Database Lookup & Join, Generate rows, Calculator, Row normalizer & denormalizers, Java Script, add constant, Add Sequence, Filter, execute Shell Script, Set/Get Variables, Group by etc.

Boston, Ma, Us

• Implemented claim Data Conversion process to move claims from Claims Workbench to the CNG Navigator application.• Provided technical assistance during production phase of project development.• Defined and developed technical standards for data movement and transformation as well as reviewed all designs to ensure those standards were met.• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches and to stop the Informatica server and recover the sessions.• Designed Work Flows that used multiple sessions and command line objects (which were used to run the UNIX scripts).• Provided enterprise data warehousing solutions, including design and development of ETL processes, mappings and workflows using Informatica’s Power Center.• Accountable for migration of the work from dev environment to testing environment.• Created reports like, Reports by Department, Reports by Supplier, Reports by Period, Demographic reports and Comparative reports.• Created Universes using Business Objects Designer, applied contexts and aliases to resolve cyclic dependencies and loops

Atlanta, Georgia, Us

• Worked with Informatica PowerMart client tools such as Source Analyzer, Warehouse Designer, and Mapping.• Used Informatica tools such as Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.• Extracted data from Flat files and loaded them into EDW.• Worked on multiple inbound ASN files to create XML, created a list file with the entire Inbound ASN files list on UNIX and used indirect loading and transforming methods in Informatica.• Handled extraction of various types of source files Flat files and XML standard source data of different transactions and loaded to staging area.• Wrote data loading stored procedures and functions using PL/SQL from Source systems into operational data storage.• Used the SQL Analyzer, and Profiler for studying the SQL statements and procedures.• Engaged in and worked with DBA to build Dimension Tables and Fact Tables.• Created Complex Mapping for generating the parameter files.• Developed source and target mappings, transformation logic and processes to reflect the changing business environment over time.• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions. Implemented best practices to maintain optimal performance.

朝阳区, 北京, Cn

•Engaged in creating design document Informatica mappings based on business requirements.•Extracted data from flat files and loaded them into EDW.•Developed complex Transformations and Mapplets using Informatica to Extract, Transform and Load data into Data Marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).•Used various transformations such as Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router to implement complex logics while coding a mapping.•Worked on Informatica tools such as Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.•Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.•Implemented MS SQL Server Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) and Views using T-SQL to evaluate result for the reports.