SUMMARY

• About 10+ years of professional experience in full lifecycle of Software Development including analysis, design, Configuring and installation of software applications mainly in the field of Data warehousing and Database systems in UNIX & Windows.
• Managing Power Center 8.x/9.x and 10.x instances.
• Installs and configures the Informatica Power Center and MDM.
• Managing Power exchange for CDC mechanism.
• Installing and configuration of SecureAgents for IICS.
• Install and Configuration and maintenance of tidal Job schedule tool under 6.3 and 6.5.8
• Coordinates, plans, and executes activities related to platform maintenance, disaster recovery and software release management.
• Configures Informatica components and assists infrastructure team on installation, upgrades, and hotfix patches. Performs capacity and stability monitoring.
• Experience designing and building web environments on AWS, which includes working with services like EC2, ELB, RDS, and S3
• Experience building and maintaining cloud - native applications
• A solid background in Linux/Unix and Windows server system administration
• Experience using DevOps tools in a cloud environment, such as Ansible, Artifactory, Docker, GitHub, Jenkins, Maven.
• Experience installing and configuring different application servers such as JBoss, Tomcat, and WebLogic
• Experience using monitoring solutions like CloudWatch, ELK Stack, and Prometheus
• Experience of writing Infrastructure-as-Code (IaC), using tools like CloudFormation or Terraform
• Experience in troubleshooting distributed systems
• Proficiency in script development and scripting languages
• The ability and skill to train other people in procedural and technical topics
• The theory, concepts, and real-world application of Continuous Delivery (CD), which requires familiarity with tools like AWS CodeBuild, AWS CodeDeploy, and AWS CodePipeline
• An understanding of automation way to create the AWS resources like S3, IAM roles and Lambda, Kinesis and API Gateway, WAF, Route53 and ServiceCatalog and ECS and EC2 and Fargate
• Assists with application health and server metrics collection and reporting through Splunk and Datadog.
• Assists with integration of Power Center and MDM real-time call with Enterprise Service Bus (ESB) Web services.
• Assists with integrations of MDM with PowerCenter and Oracle databases.
• Configures Power Center and MDM High Availability multi-nodes architecture, failover, and recovery functionality.
• Managing Big data TALEND platform 6.4.x and 7.1
• Conducts performance tuning on Power Center and MDM application servers and configurations for optimal performance.
• Managing Tidal Scheduler for job scheduling.
• Managing business works (TIBCO Enterprise System).
• Raises tickets with Informatica vendor for software product or functionality issues.
• Assists with Power Center and MDM code migrations and cutovers during releases and go-lives.
• Managing IICS informatica cloud.
• Installing and configuration of SecureAgents for IICS.
• Creation of monitors and alerts by using Splunk forwarder for better monitoring the server as well application health.
• Installing and Configuration of Informatica BDM platform.
• Working towards Automation for deployments.
• Experience to manage the TIDAL Schedular tool as well TIBCO BW Components.
• Well experience on Unix shell scripting for automation purpose.
• Well explorer to configure the Datadog for monitoring the services as well servers and apps.
• Experience on implementing the AWS resources through cloud formation scripts for S3, Lambda, KMS, Kinesis, API Gateway, Cognito, Fargate and ECR, WAF and route53 and ACM, ECS and EC2 and Cloudwatch and security rules.
• Experience to install and configure the AWS CloudWatch agents on prem servers for better monitoring by using cloud service.
• Experience on using bitbucket repos and its creation using script.
• Configuring Git repositories and using at Jenkins CI/CD pipeline.
• Deployments through Jenkins CI builder for talend jobs.
• Deployment the talend code through build jobs and publisher and nexus artifacts.
• Troubleshoot and configure the TAC and Job servers and Logserver, Log4J.
• User and project management at TAC.
• Configuring AMC for Talend and execution plan in TAC
• Experience on Tasks migration under IICS
• Experience on Granting permissions to users on IICS.
• Nexus repo creation for artifacts store.
• Experienced in ETL TALEND Data Fabric components and used features of Context Variables, MySQL, Oracle, Hive Database components.
• Experience in scheduling tools Tidal & Job Conductor (Talend Admin Console).
• Working under 24/7 support.
• Expertise at upgrade of Informatica and Bigdata Talend.
• Configuring Talend repositories
• Managing the server with Talend logging systems
• Good experience with Big Data, Hadoop, HDFS, Map Reduce and Hadoop Ecosystem (Pig & Hive) technologies.
• Configuring and installation and troubleshoot of Informatica application on varies operating systems.
• Configuring and troubleshooting the IDQ services on Informatica.
• Expertise to establish the connectivity with Hadoop, Salesforce, msdcrm and azure, Amazon Redshift and Vertica, Tibco…on with the help of pwx connectors.
• Configuring Git repositories for CI/CD
• Good Experience on Migration of Informatica application from one OS to another OS.
• Configuration of AD for IDQ
• Good Exposer at Windows OS to troubleshoot the Informatica Issues.
• Configuration of https protocol for informatica adminconsole as well web services.
• Good knowledge on Tidal scheduling tool to monitor the jobs.
• Working with Incident management as well problem management team to address the issue.
• Repository migration from lower version to higher version and worked on migration from one platform to another.
• Clubbing the repositories together to minimize the license cost.
• Working On Informatica Developer Tool to provide the connectivity to users
• Perform the server health check.
• Good Experience to creating the Jasper reports.
• Working on to configure and install the power exchange.
• Working on provide the connection info to user to use the developer tool.
• Expert in UNIX shell script.
• Good team coordination and used to bring all required teams to resolve the issue.
• Strong at CDC mechanism to support the PWX.
• Working on Informatica upgrades by applying the hotfixes.
• Exposer on applying the EBF’s as part of bugfix.
• Very proactive to work on issues to resolve with in SLA.
• I am very strong to create the automation processes like deletion of labels as well DG’s and inactive users and their respective folder and folder refresh and domain backup and domain repo scripts.
• Perform the Troubleshooting steps on Informatica service issues.
• Configuring and implementing the GPG keys for Data encryption process.
• Good Exposer in executing the SQL queries to troubleshoot the issues
• Working on apply the pwx connector to connect to MSDCRM and Salesforce…etc.
• Coordinate with Informatica vendor to get the product level information.
• Well explorer to execute the changes on production systems.
• Configuring and implementing the ssh keys for establish the connection between source and target and vice versa.
• Supporting the sap bw services and IMM services from Informatica.
• Good Knowledge on HVR (High Volume Real-time Replication tool).
• Coordinated with UNIX and Database Administrators.
• Carried out root-cause analysis and solution development.
• Handled users, groups, and folders.
• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and viseversa.
• Implemented the new protocol for sftp users (Proftpd)
• Creation and maintenance of Informatica users and privileges.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Strong interpersonal & organizational skills.
• Responsible to manage Development, QA and Production Environments for Informatica.
• Working on Data analyzer and Informatica analyst services.
• Capable of writing optimized SQL quires.
• Ability to work Individually, also as Versatile Team Player
• Having Good Self Learning Abilities & Problem-solving skills
• Configuring and implementing the PGP keys for Data encryption process.
• Worked on different phases of Data Warehouse development lifecycle from designing, development, testing and implementation.
• Strong at troubleshoot the backend level issues.
• Inactive users and their respective folder and folder refresh and domain backup and domain and repo scripts.
• Creation of ODBC connections and relations connections.
• Working on clean up the repo logs prior to 3months to have the good performance of the repository.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell Programming, Python, Perl

Databases: Oracle 9i/8i/10g/11g, SQL Server 2005, Teradata 13/v2r5, DB2, MS Access and Azure and Redshift DB, Hive Data base

ETL Tools: Informatica Power Center 7.1/8/9.1/9.6 and 10.x, Power Exchange, IDQ, DVO, EDC, Data Masking Bigdata Talend and IICS

Reporting Tools: Cognos 8/10.1 and TM1

DB Tools: SQL*Loader, Toad

Replication Tools: HVR replication tool

Operating systems: Windows XP/2003/7, DOS, UNIX, Macintosh, Sun Solaris and AIX and HP UX and Linux

Cloud Technologies: AWS, MS Azure

Build and Deployment tools: Jenkins, GitHub, Bitbucket, CodeCommit, CodePipeline, Docker, Kubernetes

Job Scheduling tool: SAP Batch Scheduling tool (TIDAL)

BW Tools: TIBCO BW

Monitoring Tools: Splunk forwarder and Datadog, NewRelic

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

ETL Informatica Administrator / AWS Software engineer

Responsibilities:

• Managing Power Center 8.x/9.x and 10.x instances.
• Managing IICS informatica cloud.
• Installing and configuration of SecureAgents for IICS.
• Tasks migration under IICS
• Granting permissions to users on IICS.
• Working on AWS resource creation through CloudFormation script.
• Managing Tidal Scheduler tool as well TIBCO BW.
• Installs and configures the Informatica Power Center and MDM.
• Managing Power exchange for CDC mechanism.
• Install and Configuration and maintenance of tidal Job schedule tool under 6.3 and 6.5.8
• Coordinates, plans, and executes activities related to platform maintenance, disaster recovery and software release management.
• Configures Informatica components and assists infrastructure team on installation, upgrades, and hotfix patches. Performs capacity and stability monitoring.
• Experience designing and building web environments on AWS, which includes working with services like EC2, ELB, RDS, and S3
• Experience building and maintaining cloud-native applications
• A solid background in Linux/Unix and Windows server system administration
• Experience using DevOps tools in a cloud environment, such as Ansible, Artifactory, Docker, GitHub, Jenkins, Maven.
• Experience installing and configuring different application servers such as JBoss, Tomcat, and WebLogic
• Managing to create monitors by using Splunk forwarder on all on prem servers.
• Install and configuration of AWS CloudWatch agent on all on prem servers for monitoring
• Experience in scheduling tools Tidal & Job Conductor (Talend Admin Console).
• Working under 24/7 support.
• Using Bitbucket for code checkin and checkout.
• Well experience to work on Jenkins to deploy the code.
• Well explorer at Datadog for monitoring
• Managing the server with Talend logging systems
• Good experience with Big Data, Hadoop, HDFS, Map Reduce and Hadoop Ecosystem (Pig & Hive) technologies.
• Configuring and installation and troubleshoot of Informatica application on varies operating systems.
• Configuring and troubleshooting the IDQ services on Informatica.
• Expertise to establish the connectivity with Hadoop, Salesforce, msdcrm and azure, Amazon RedShift, and Vertica, Tibco…on with the help of pwx connectors.
• Configuring Git repositories.
• Good Experience on Migration of Informatica application from one OS to another OS.
• Configuration of AD for IDQ
• Good Exposer at Windows OS to troubleshoot the Informatica Issues.
• Configuration of https protocol for informatica adminconsole as well web services.
• Good knowledge on Tidal scheduling tool to monitor the jobs.
• Working with Incident management as well problem management team to address the issue.
• Repository migration from lower version to higher version and also worked on migration from one platform to another.
• Working on Informatica Developer Tool to provide the connectivity to users
• Configuration of Datadog /Splunk Forwarder for Server and services monitoring in Realtime view.

Confidential, Austin, TX,

Informatica Administrator and Talend Administrator

Responsibilities:

• Interact with Business Users to understand - Business requirements gathering and analysis.
• Provide impact analysis, feasibility study and GAP analysis based on current reporting data model
• Creations of technical design documents for proposed solutions.
• Working with Incident management as well problem management team for RCA’s
• Preparing Project Plan for the Project.
• Managing Big data TALEND platform 6.4.x and 7.1
• Configuring Git repositories.
• Deployments through Jenkins CI builder for talend jobs.
• Troubleshoot and configure the TAC and Job servers and Logserver, Log4J.
• User and project management at TAC.
• Creating execution plan in TAC.
• Configuring AMC
• Nexus repo creation for artifacts store.
• Experienced in ETL TALEND Data Fabric components and used features of Context Variables, MySQL, Oracle, Hive Database components.
• Experience in scheduling tools Tidal & Job Conductor (Talend Admin Console).
• Working under 24/7 support.
• Expertise at upgrade of Informatica and Bigdata Talend.
• Configuring Talend repositories
• Managing the server with Talend logging system
• Good experience with Big Data, Hadoop, HDFS, Map Reduce and Hadoop Ecosystem (Pig & Hive) technologies.
• Managing Power Center 9.x and 10.x instances.
• Working under 24/7 support.
• Expertise at upgrade of Informatica.
• Configuring and installation and troubleshoot of Informatica platform.
• Configuring and troubleshooting the IDQ services on Informatica.
• Co-ordinating with different teams involved in the rollout
• Attending Weekly status call with the stakeholders
• Co-ordinate with the Business Project Team to close pre-requisites for testing
• Develop and Design websites/portals for the HP businesses.
• Providing and implementing the solutions identified as requirements.
• Analyzing and resolving functional issues and queries raised by the Business/User during different phases of Project.
• Interact with client by phone call, chat and mail whenever required to discuss issues, requirements and bug fixing.
• Communicating weekly status report of the enhancement in progress.

Confidential

Informatica Administrator

Responsibilities:

• Managing Power Center 8.x/9.x and 10.1 instances.
• Working under 24/7 support.
• Upgrade of Informatica.
• Migration of Informatica from one OS to another OS.
• Apply the EBF’s
• Managing the repositories to have the upto date data.
• Coordinating with offshore.
• Client requirements to reach the business needs.
• Implementation of automation processes for repetitive jobs.
• Provide impact analysis, feasibility study and GAP analysis based on current reporting data model
• Creations of technical design documents for proposed solutions.
• Requirement Gathering
• Preparing Project Plan for the Project
• Co-ordinating with different teams involved in the rollout
• Attending Weekly status call with the stakeholders
• Co-ordinate with the Business Project Team to close pre-requisites for testing
• Post Production Support after go-live
• Providing and implementing the solutions identified as requirements.
• Analyzing and resolving functional issues and queries raised by the Business/User during different phases of Project.
• Interact with client by phone call, chat and mail whenever required to discuss issues, requirements and bug fixing.
• Developing the code components as per the requirement captured.
• Experience in scheduling tools Tidal & Job Conductor (Talend Admin Console).
• Working under 24/7 support.
• Using Bitbucket for code checkin and checkout.
• Well experience to work on Jenkins to deploy the code.
• Well explorer at Datadog for monitoring
• Managing the server with Talend logging systems