Rupesh Gupta Email & Phone Number

Troy, Michigan, Us

Informatica Perform Informatica Administrator Role Add, modify & delete users, permissions & priviliges; and make changes to security configuration Work on server to start and stop services, recycle , take backups and manage overall production server health Perform Informatica upgrade as and when requested in prod and non-prod environments Add new features as per licensing functionality on client request Informatica Code deployement into prod and non-prod environments L2 Production Support Monitor Informatica Daily Batch load Troubleshoot issues in ETL process and resolve them within SLA in production Predict Process optimization in existing production processess and make changes for the same Work with source providers and target consumers of data loaded by ETL if there are any issue or delay in load Co-ordinate with teams on new development and tentative deployment assitance needs Provide as per needs weekend support for Infrastructure upgrades and testing Data Governance Perform Administrator role for EDC 10.4.1, AXON 6.2 & IDQ 10.2 tools Add, maintain and manage existing and new connections Add & Manage users and permissions Start and Stop services in production on UNIX system Perform upgrades in prod and non-prod environments Miscellaneous user queries Maintain and add new connections to all the sources for elements SQL Add user to provide access as requested Perform cleanup and other housekeeping activities as a part of KTLO Work and co-ordinate with teams, architect on new upcoming projects and database changes Windows Server Manage and maintain windows server health Maintain permission groups , active directories and other folder permissions Add user and service accounts to ensure only the requested folder are provided access and security is not compromised Timely check on health, space cleanup and other miscellaneous KTLO/house keeping activities as required

Troy, Michigan, Us

Currently working as - Informatica ETL Technical Lead at Ameriprise Financial Services, Inc.Responsibilities:  Creating Informatica ETL mapping, session, workflows & worklets.  Creating UNIX shell scripts. Creating database objects like table, views, procedure and sql scripts Creating TWS scheduling flow  Perform unit testing based on reviewed/approved unit test cases. Coordinating and working with offshore team to explain project requirements and getting the deliverable in a timely manner. Also, providing knowledge transfer to team members.  Participating in Change Advisor Board (CAB) meetings to represent changes for planned installations. Work on incidents in production application using Service Now tickets for RCA (root cause analysis), permanent resolution and SLA compliance for any issue in project code functionality.  Coordinating quality assurance efforts and helping testing team to execute test validations for project changes in various test phases i.e. SIT, UAT, regression and performance testing.  Participating in all the release management activities and providing description of project, back out plans and implementation of enhancements  In the application production environment. Involve in production support activities during warranty period after project goes live.  Documenting project related documents as per the Ameriprise standards to ensure compliance with the internal and external audits. Attending project kick-off meetings Review FRD with business stake holders Conducting impact analysis of requirements to assess and plan development efforts Reviewing project documents created by team Ensure solution follows the Ameriprise Quality Management System (AQMS) and standards Participate in review meetings of Code review (ETL Informatica, UNIX shell script, database objects, parameter files, TWS deliverables), Design review etc. and release installation activities.  Providing technical guidance as needed

Charlotte, Nc, Us

Responsibilities:Sr. Informatica/ETL Lead  Understand functional/technical document, analyzing business requirements to prepare system requirements. Creating/updating Informatica ETL mapping, session, workflows &worklets.  Creating UNIX shell scripts. Defining database objects like table, views, procedure and sql scripts Creating TWS scheduling flow  Perform unit testing based on reviewed/approved unit test cases. Coordinating quality assurance efforts and helping testing team to execute test validations for project changes in various test phases i.e. SIT, UAT, regression and performance testing.  Participating in all the release management activities and providing description of project, back out plans and implementation of enhancements  In the application production environment. Involve in production support activities during warranty period after project goes live.  Documenting project related documents as per the Ameriprise standards to ensure compliance with the internal and external audits.  To serve as a point of escalation for Informatica production issues and lead resolutionChange Control Manager I was responsible and owner of Change Management process for EDO DW production environment. In this role; I was responsible for To create a change request in Service Now tool for upcoming changes To conduct review meetings with manager, developers, stake holders and production team Approve/Deny changes related to PS Team To review documentation for each change and check for testing results To evaluate the impact in production due to new code change and mitigate the risk if any To assist developer and production team for emergency changes for break-fix To report Enterprise Change Management groups with necessary reports and statistics and share the same with leadership team Conduct Change Advisor Board (CAB) meetings to for changes with upcoming planned installations.

Paris, France, Fr

Roles: Technical Lead Senior Software Engineer Software Engineer Associate Software EngineerResponsibilities:  Onshore L2 & L3 ETL (INFORMATICA) Production Support Specialist Onshore Technical Delivery Lead for ETL (INFORMATICA) Development/Enhancement projects Senior ETL (INFORMATICA) Developer & TesterDescription1. Develop end-to-end Business Intelligence solutions using Informatica for complex business requirements2. Work with business leaders to understand functional/technical document and create/update LLD and HLD for new Informatica mappings, sessions, workflows for enhancement projects to support DW applications reporting.3. Creating, Designing and documenting database objects like tables, views, indexes, procedures, functions etc.4. Drive and create Informatica ETL workflows, mappings, UNIX Shell scripts, schedulers for automation, test cases creation, reviewing the results of testing, assisting in UAT, ensuring smooth deployment and post deployment support handover for BI data loading/transformation solution5. Document steps for deployment of Informatica processes, UNIX shell scripts and other oracle/Netezza database objects and co-ordinate with different teams – DBA, Informatica Administrators6. Provide warranty support for Informatica processes after deployment and before support handover.7. Develop/enhance Oracle-SQL blocks like Stored Procedures, pl-sql scripts for data loading/transformation8. Conduct reviews for deliverable and ensure proper error handling, job monitoring/reverse-engineering, notification rules, proactive communication (SOP) is ready and are delivered within schedule.9. Provide Level 2 & Level 3 (Incident management & Code Fix) support for minor analysis, break fix, technical issues, solutions and data issues related to Informatica jobs.10 . Conduct Root Cause Analysis and provide fixes on repetitive tickets related to Informatica jobs11. Create a knowledge base of Informatica jobs

B.Sc, Computer Science

Hsc - Science, Science - Junior College

Ssc, Ssc