Home

Sukumar - Informatica Developer

[email protected]

Location: Chicago, Illinois, USA

Relocation: Yes

Visa: H1B

Sukumar Informatica Developer 678-430-8029 [email protected] Chicago, IL Yes H1B Professional Summary: 6+ of experience in Datawarehouse in analysis, design, development of software applications. Expertise in Data warehousing solutions using Informatica Power Center. Possess complete domain and development Life Cycle knowledge of Data Warehousing. Currently Working on ETL tool Informatica PowerCenter 10.x Solid experience in Informatica Power Center (10.x/9.x) including Designer, Workflow Manager, Workflow Monitor, Repository Manager. Optimizing Informatica Mappings and Sessions to improve the performance. Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, and sessions. Proficient in using Informatica PowerCenter Designer Tool Transformation Developer, Mapplet Designer, Mapping designer and Workflow Manager Tools Task Developer, Workflow and Worklet Designer. Experience in designing and developing mappings from varied transformations like Sorter Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Unconnected and connected lookups, Experience on Mapping Parameters and Mapping Variables in mapping. Extensively Designed SCD 1, SCD 2 mappings to load Dimension tables. Extensively on Incremental Loading and Fact Loading. Experience on working on Dynamic and Un-connected lookup. Extensively worked on Re-usable objects like Mapplets and Re-usable Transformations. Extensively worked on Different Tasks like Session, Command, Email and Event-wait Tasks using Informatica PowerCenter Workflow manager. Extensively worked on Versioning Concepts like Check-in and Check-out Experience in Deployment of the Code from Dev to Test Environments. Experience in writing Join queries and other SQL queries in SQL override and Lookup Transformations. Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Worked on UNIX Commands. Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions. Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents Good communication skills, interpersonal skills, self-motivated, quick learner, team player. Education: Bachelor of Technology from Jawaharlal Nehru Technological University, Anantapur, Andhra Pradesh in the year of 2011. Technical Skills: ETL Tools : Informatica Power Center 10.x/9.x Database : Oracle 11g. Operating Systems : Windows 8/10/11 and UNIX. Tools : SQL Developer, PUTTY, Winscp Applications : M.S.Office Experience: ProCurve, USA, India 2018 to till date Role: Informatica Developer Description: ProCurve BI is the enterprise data warehousing platform catering to business needs of ProCurve Supply Chain, Finance and Sales departments. Oracle/Unix, Informatica, Several HPIT application instances feed ProCurve warehouse. In order to provide for more cost effective development, ProCurve will utilize offshore development capabilities in Informatica to support BI projects. IT will supply resources to perform services for ProCurve to reach this objective. The resources and services to be supplied are described herein. Responsibilities: Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts. Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager. Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Filter , Lookup, Union and Router etc to load the data into staging tables and then to target. Created informatica mappings for Stage, Dimensions and Fact table loads. Created SCD type-1 and Type-2 mappings for loading the dimension tables. Data migration from one environment to another environment using ETL Infomatica tool . Extensively worked in the performance tuning ETL mappings. Extensively Worked on mapping logic Fact loading. Extensively Worked on Dynamic and Un-Connected lookups. Experience in handing workflows which includes n number sessions and worklets. Used SQL tools like SQL Developer to run SQL queries and validate the data loaded into the target tables. Created parameter files for respective sessions and workflows. Worked on different tasks like Assignment, Event-wait, email, control and decision task available in workflows manager, Informatica PowerCenter. Strongly involved in monitoring, scheduling the informatica jobs using Informatica Scheduler. Worked extensively on Oracle database 11g and flat files as data sources. Strongly involved in daily calls and onshore offshore handshakes to understand the business requirements from onsite. Prepared Unit test cases for the mappings. Environment: Informatica Power Center 10.x/9.x (ETL), Oracle 10g, UNIX Shutter fly, India April 2018 - Jan 2020 Role: Informatica Developer Description: This project deals with the products and sales. Data Mart for products and sale for Arena Ltd the source data from oracle 10g, Flat file as extracting the data. Using ETL mappings, data populated into Facts and Dimensions. This Data Mart contains various product types and their competitors. The system allows marketing and sales users to maintain targets for various products. A forecast is made for the potential that can be achieved by users from current year and next five years. The invoices are fed into the system via the Data warehouse Responsibilities: Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer. Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica. Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Filter, Union, Aggregator and Sequence generator. Used Session parameters, Mapping variable/parameters and created Parameter files. Performed Mapping Optimizations to ensure maximum Efficiency. Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level. Developed jobs for incremental loading. Used Parameter files. Developer SCD type-1 and type-2 mappings. Created Connected, Un-Connected & Dynamic lookups (Cache) Developed workflows and tasks using Informatica Power Center Work flow Manager. Involved in creating Sessions & Mapplets. Configuring the Databases connections in Informatica. Worked with different sources such as Oracle and flat files. Environment: Informatica Power Center 10.x/9.x (ETL), Oracle 10g, UNIX. Merck & Co., Inc. April 2016 - Mar 2018 Role : Specialist Responsibilities: Experience in CA s(computer associates) UAJM Job Scheduler AUTOSYS r11.0 which is used in Installing, Scheduling and monitoring of batch jobs. Experience in working with and supporting CA Technologies Workload Automation AE Autosys r11.3.6 in both UNIX and Windows environment. Worked on migration of Autosys Jobs from UAJM Autosys r11.0 to WAAE Autosys r11.3.6. Install/Configure the Remote agents in UAJM r11.0, Testing and Production/Application Support. Extensive knowledge of Job Information Language (JIL) and capabilities to recommend suggestions that will comply with internal standards and CA best practices. Creation/Modification of New/old jobs as per the client requirement and Updating Variants for SAP jobs as and when needed in SAP especially for Billing jobs. Schedule adhoc request batch jobs that require immediate execution - Update attributes, Holiday Schedules in the SAP instance. Creating and updating the calendars and archiving the old files. Granting User access to the web portal using WCC and updating the roles with EEM. Participated in COMET maintenance activities for Production and Non-Production (attending meetings as well as performing the tasks). Engaging and coordinating with vendors (CA) to identify the root cause of the major issues Knowledge on ITIL process Good Knowledge on Remedy ticketing system. Keywords: business intelligence information technology California Colorado Illinois