Suleman Mohammad

Experience

• 

  Genex Technologies

  Jul 2017 - Aug 2020

  Jr Informatica Developer

  • Responsible for Power Center and Power Exchange installations, configuring PowerCenter Domain, nodes and Create Different services in the Domain.• Upgraded Informatica power center 9.1 to version 9.6.1 on AIX servers and from 9.6.1 to 10.1.1 version.• Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.• Worked on various sources like SAP HANA, SQL Server, XML, Ms Access, Web Services etc.• Install and configure DVO tool for validating the data.• Configured Informatica Cloud and its secure agent to connect to external endpoints on the Cloud. Worked on various Cloud Connectors like REST, JSON, SERVICE-NOW, SALESFORCE etc.• Installed and configured Pro-Active Monitoring tool to monitor the daily data loads of various DataMart’s and communicate accordingly to the business if there were any delays. • Proficient in managing IDQ services like model repository, data integration, Analyst, Content Management Services. • Installed Metadata Manager and loaded resources from various relational databases to analyze business requirement and perform impact analysis. • Performed tuning of Informatica Mappings for optimum performance.• Manage all aspects of system disaster planning and recovery, including normal file backup and archiving Show less

• 

  UV Technology Solutions Inc

  Feb 2022 - now

  Informatica Admin

  • Responsible for upgrading Informatica Power exchange from 10.2 to 10.4.1 version.• Setting up a new UAT environment in the Power exchange.• Used Informatica Power Exchange CDC Oracle/MS SQL server for various use cases.• Developed mappings/workflows for various financial business teams according to their needs• Worked on Informatica Unstructured Data Transformations (UDT).• Worked on data ingestion to HIVE using Python scripting.• Used TIDAL scheduling tool to schedule some of the batch/CDC jobs.• Worked on PWC code promotion from DEV to TEST and TEST to PROD Environments.• Built CI/CD pipelines over GIT/Jenkins to automate some of the legacy code. In the process, used Groovy programming language.• Worked on tuning Big Data Workflows to optimize performance.• Worked extensively on Python/Shell scripting.• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.• Used Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA, and PROD).• Have deep and thorough understanding of ETL tools and how they can be applied in a GRID environment. Show less