Kumar A. Email & Phone Number

Charlotte, Nc, Us

Richmond, Virginia, United States

1) Created Tidal jobs to automate the Informatica jobs and deployed to QA and PROD.2) Created UNIX shell scripts to execute the Informatica Workflows.3) Informatica Administration as migrating code from dev to higher environments, version testing, monitoring each status of profile jobs, workflows for each data integration services, managing users, group roles and privileges.4) Experience in Informatica performance tuning of informatica sessions using session partitioning techniques such as round robin, Pass-through and Key range partitioning.5) Created Pre SQL scripts and Post SQL scripts in the workflow sessions when needed.6) Retrieving data from archival database in case of data loss.7) Migrated data from various databases to Azure cloud.8) Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.9) Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.10) Creation of new environment and configuration and Administration and configuration of Informatica Servers.11) Used various transformations like Source Qualifier, Joiner, Lookup, SQL, Router, Filter, Expression and Update Strategy.

Lynchburg, Virginia, United States

1) Designed and customized data models for data warehouse supporting data from multiple sources on real time.2) Involved in building the ETL architecture and source to target mapping to load data into Data warehouse.3) Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.4) Perform troubleshooting analysis and resolution of critical issues.5) Escalate issues and remediation steps effectively and in a timely manner.6) Coordinate with vendors to troubleshoot and resolve issues.7) Support the client reporting production environment as a first priority and resolving on-going maintenance issues, bug fixes, monitoring informatica sessions as well as performance tuning of mappings and sessions.8) Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.9) Participated in the integration testing and Unit Testing along with the development team.10) Creating hotfixes queries and executing them through flyway to resolve production issues.11) Recovering the failed sessions, batches and preparing the documents for test data loading.

Charlotte, North Carolina, United States

1) Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.2) Experience in Informatica performance tuning of Informatica sessions using Session partitioning techniques such as Round robin, Pass-through and Key range partitioning.3) Analyzed the database to identify the key column to perform partitioning in effective way.4) Assigning work to offshore, assisting them in development, and testing.5) Work with business analysts to gather business requirements from end users and translate them into technical specifications for BEACON project.6) Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process and testing the code in all the environments.7) Created SQL scripts, back out scripts, BOIP documents for deployment process to QA and PROD.8) Created Tidal jobs to automate the Informatica jobs and deployed to QA and PROD.9) Worked on JIRA tickets to resolve issues in Prod and updated day-to-day activities as comments to help know the business users about status of the project.10) Test solutions to validate whether requirements are met and develop test plans, test scripts, and test conditions based on the business and system requirements.11) Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.

Texas, United States

Texas, United States

1) Extracted data from database, transformed it in accordance with the Business logic, and loaded data into salesforce using informatica intelligent cloud services.2) Develop Informatica workflows to collect data from data sources based on mapping specifications provided to the developer.3) Assist QA team with unit testing, develop system test plans, and perform full system testing prior to implementation.4) Work closely with technical leads, analysts and developers to design and implement technical solutions within a structured development process.5) Assist in continuous improvement efforts and enhancing project team methodology and performance.6) Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work.7) Understand, translate and create mappings using provided ETL specifications.8) Documents designs and conduct unit test.

Cary, North Carolina, United States

1) Built the Physical Data Objects and developed various mapping, mapplets/rules using the Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1.2) Effectively communicate with Business Users and Stakeholders.3) Worked on Agile Methodology, participated in daily/weekly team meetings, guided offshore developers in InformaticaData Quality (IDQ), peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.4) Designed and developed mappings by using Lookup, Expression, Update Strategy, Sequence generator, Aggregator, Router, Joiner transformations to implement the mapping. 5) Extracted data from Hive files, transformed it in accordance with the Business logic, and loaded data into Oracle tables using ETL tool. 6) Involved in creating Oracle staging table structures and modifying existing tables as per the design specifications.7) Writing ORM’s for generating the complex SQL queries and building reusable code and libraries in Python for future use.8) Profiling Python code for optimization and memory management and implementing multithreading functionality.9) Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica Data Quality (IDQ).10) Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.11) Implementation of Big Data Management (BDM) for a project using Hadoop working closely with vendor team to understand the behavior of source data and parse the XML files accordingly using Hadoop and load them into Hive for data analytics.12) Design and Develop Hadoop ETL solutions to move data to the data lake using big data management tools like Sqoop, Hive, Spark, HDFS.

San Diego, California, United States

1) Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer. 2) Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database. 3) Generated completion messages and status reports using Informatica Server manager. 4) Tuned ETL procedures and STAR schemas to optimize load and query Performance. 5) Starting Sessions and Batches and make Event based scheduling 6) Managed migration in a multi-vendor supported Server and Database environments. 7) Worked along with the QA Team and provided production support by monitoring the processes running daily. 8) Written SQL overrides in Source Qualifier and Lookups according to business requirements. 9) Responsible for Documentation of the Test cases, completed modules and the results of acceptance testing. 10) Extensively used Various Data Cleansing and Data Conversion Functions in various transformations. 11) Used Debugger to validate transformations by creating break points to analyze and monitor Data flow. 12) Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.13) Prepared migration document to move the mappings from development to testing and then to production repositories. 14) Parsed high-level design specification to simple ETL coding and mapping standards. 15) Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts.

Hyderabad, Telangana, India

1) Followed Agile-Scrum methodology to design, develop, test and deliver the code.2) Modify existing business logic in Informatica ETL flows.3) Design new ETL flows as per the mapping sheets.4) Involved in designing, creating equivalent Teradata data marts to load the required staging data. 5) Involved in ETL developing, creating required mappings for the data flow using Informatica.6) Used transformations like Source qualifier, Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.7) Starting Sessions and Batches and make Event based scheduling 8) Managed migration in a multi-vendor supported Server and Database environments. 9) Involved in designing the Mapplet and reusable transformations according to the data flow requirements.10) Validated the output according to the specifications.11) Enhancements in existing mappings according to the business logic.12) Attended daily scrum calls to post the required status update.13) Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.14) Gathering reporting requirements and making enhancements to any existing logic if required.