ETL datawarehouse specialist
Resume:
MOHAMMED MOHSIN
Email: ********@*****.***
Phone: +1 5512688715Phone: +1
Profile Summary: 18 years of experience in implementing Datawarehousing/BI solutions across various domains of software Industry including Health Care, Banking, Manufacturing telecommunication and Insurance
Worked for major client companies such as Cardinal Health, Medtronics Inc., GE Money, Catalent Pharma solution, CVS caremark, Xerox, Department of Health, BNYM, Dun & Bradstreet, TheHartford, Charles Schwab, Timewarner, HBO, WB,TimeWarner, Metlife, Farmers insurance, Siliconvalley Bank, Bestbuy, USAA
• Extensive Experience in End to end Software Development Life Cycle (SDLC) including Requirement gathering Analysis, ETL Design, Development, Data Analysis and Production Support, Testing of Data warehouse BI Applications, Administration ETL
• Strong experience in Informatica PowerCenter, Informatica Data Quality(IDQ) 8.x/9.x/10.1, Test Data Management TDM,
• Experience in INFORMATICA MDM, INFORMATICA BIGDATA BMD/EDC, IICS, AWS Database Migration Service (DMS)
• Experience in INFORMATICA CLOUD IICS
• Experience with Azure Data Factory and Snowflake, Datalake, AWS Redshift
• Experience in DevOps best practices, CI/CD pipelines, cloud platforms (AWS, Azure, or GCP), and have hands-on experience working with Java-based applications
• Familiarity with scripting languages like Python, R, or JavaScript/React, Power BI, Oracle Transaction BI and Tableau, SAP BO, Oracle Financials, Oracle DI, Spark, Redshift, Snowflake, Azure Aurora, BigQuery
• Experience in Oracle 12C/11g/10g/9i, DB2, SQL Server, Teradata, Teradata Utilities, NETEZZA, SYBASE
• Experience in Data Modeling Experience with data governance tools ( Collibra, Alation, Informatica.).
• Familiarity with data privacy regulations (e.g., GDPR, CCPA, HIPAA) and compliance strategies.
• Experience in working with SQL, PL/SQL, UNIX LINUX SCRIPTING
• Experience in Flat files like fixed width /delimited, XML files
• Experience in data modeling tool such as Erwin 3.5,ER Studio 7.1, MS Visio
• Strong understanding of BI Software development life cycle (SDLC) methodologies including Waterfall and AGILE SCRUM JIRA TOOL, KANBAN, SERVICENOW, GITHUB, JENKINS
• Expertise in job monitoring scheduling tools including Maestro, Control-M, Autosys GECS
• Strong experience in ETL and SQL performance tuning, ETL QA Testing
• Experience in Data analysis and data profiling handled huge volume of source data
• Assist in Data Governance effort, mainly in the areas of Data Cataloging and Data Quality Management.
• Migrated executed TDM jobs Project, Plan, profiles policies rules for DATAMASKING
• Exposure to ERP system as a source legacy system including SAP, Oracle financials, JD Edwards, DB2 Mainframes, AS400, Postgresl SQL, DEVOps,
EMPLOYMENT HISTORY(FULL-TIME)
Working as Datawarehouse specialist for Tata consultancy services since Oct 2019 till date
Worked as Senior Technical Consultant for L&T Infotech USA since April 2016 till March 2019
Worked as Senior Associate for Cognizant technologies solutions USA from Mar 2014 – Feb 2016
Worked as Project Lead for Wipro Technologies, Bangalore from Oct 2007 – Feb 2014
Worked as Senior Software Engineer for Silverlink technologies UK from Dec 2006 to Sept 2007 TECHNICAL SKILLS
ETL Tool Informatica Power Center 8.6/9.5/9.6/10.1 Informatica TDM 9.7.1, Informatica DVO,
Informatica Dataquality IDQ
Informatica MDM/EDC
Informatica Bigdata BDM
Informatica CLOUD IIC
OLAP Tools SAP BO XI R3,Tableau
Data Modeling Tools Erwin 3X/4X, ER Studio 7.1, MS-Visio 2007, Databases Oracle 8i/9i/10g,Sybase ASE 12.0,Teradata 13/14, Load Utilities(FastLoad,MultiLoad,BTEQ),
Netezza
DB Interface Tool Toad,Winsql,SQL plus,SQL/PLSQL Developer Scheduling Tools Maestro, Autosys, Control M,ESP,GECS Programming Languages SQL, PL/SQL, Knowledge of Java, Python, C# Version Control Tools Jenkins, GitHub, Microsoft VSS, Sharepoint,Clearcase PROJECT MANAGEMENT AGILE SCRUM / KANBAN / JIRA
EDUCATIONAL QUALIFICATION:
Completed Bachelor of Engineering in Computer Science from Bangalore University in the year 2001
PROFESSIONAL EXPERIENCE
Project Title Global Data clearing warehouse application support Client Metlife insurance
Organization TCS
Duration Nov 2022- June 2025
Technology Informatica Cloud, Oracle 12, SQL Developer, Autosys Responsibilities:
• Worked with GDC application owners business teams analysts for documenting data requirement gathering sessions, feasibility studies
• Involved Agile scrum meeting session for user story creation updates task assigned planning
• Worked on development of informatica cloud mapping session to implement new business requirements for GDC
• Designed ETL pipelines using Informatica Cloud for migrating on-premise databases to GCP.
• Implemented and managed data workflows using Cloud Composer (Airflow) and Dataflow.
• Applied Liquibase for version control and automated database deployments.
• ·Collaborated with architects to ensure adherence to GCP architecture best practices
• Involved in released deployment for code from lower region to higher regions
• Updated maestro jobs job schedule stream
• Involved in informatica quarterly upgrade maintenance Project Title Datawarehouse application support
Client USAA
Organization TCS
Duration Mar 2022- Aug 2022
Technology Informatica Power Center 10.2, Oracle 12, SQL Developer, ALM, Autosys Responsibilities:
• Involved in migrating the repository objects from Development to Testing to Production systems
• Worked with DBA in order to do some performance tuning for ETL jobs/mappings.
• Administered and developed Informatica workflows, mappings and sessions to load large data volumes from multiple sources into enterprise data warehouse. Supported ETL cycles including production issue and environment quality issue.
• Prepared technical documentation of product sub systems.
• Implemented automated data solutions using Snowflake lakehouse; building workflows, developing, and scheduling ETL processes
• Resolved data problem discovered by quality QA and developed solution to the problem.
• Performance tune ETL code in a high volume environment.
• Define/improve processes for development and support functions. Project Title Creditclose Analytics Database Reporting Client Silicon Valley Bank
Organization TCS
Duration Dec 2020- Jan 2022
Technology SAP BODS, Oracle 12, SQL Developer, ALM, Autosys Responsibilities:
• Worked with creditclose CADB reporting system application owners business teams analyst for documenting data mapping requirements gathering sessions, feasibility sessions
• Worked on new KDE datamapping enhancements for CADB reporting purpose
• Worked on implementation of new KDE datamappings from source systems including Recon Miser RBS consolidation to FRDS layer and FRDS to downstream CADB
• Pariticipated in Agile working session spring planning provided data team inputs for user stories creation
• Worked with team members for mapping development testing
• Involved in deployment of code from Dev to QA and QA to prod Project Title Guidewire Claim center DataMigration Client Farmers Insurance
Organization TCS
Duration Nov 2019- Sept 2020
Technology Informatica Power Center 10.2, Oracle 12, SQL Developer, ALM, Autosys Responsibilities:
• Worked with Claim center source systems application owners business teams analysts for documenting data requirement gathering sessions, feasibility studies
• Worked on various workers compensation line of business vendor feeds including DCI, Froisroi, NCCI, ISO, Broadspire change request as part of Agile spring sessions
• Worked on fixing production support defects assigned to team within ALM tool
• Worked with offshore team members developers towards implementation of workerscomp vendor feeds change request implementation to clarify the requirements as part of offshore meeting calls
• Worked on implementation of new vendors feeds such Broadspire, mitchell attorney
• Update d the mapping documents run books IDD documents uploaded to share point
• Re viewed the code changes developed by offshore team members
• Created and Performed unit testing prior to QA testing.
• Worked towards fixing of defect raised as part of QA testing
• Migrated the code changes from DEV to QA testing environment worked with CM team admin to migrate the code to higher environment as part of release management.
• Created the autosys jil scripts and worked with Autosys admin team to configure the jobs in QA ennvironments
Project Title M2O SalesDatamart
Client Parexel International Billerica MA
Role ETL Architect
Organization L&T INFOTECH
Duration June 2018-Feb 2019
Technology Informatica Power Center 10.2, Salesforce, Hyperion, Oracle 11g, SQL Developer, Service Now, Linux
Responsibilities:
• Worked with source systems application owners business teams analysts for designing, documenting data requirement gathering sessions, feasibility studies
• Worked with salesforce admins and Hyperion admins to integrate Informatica server with source systems
• Involved in installation configuration of Informatica PWX Salesforce API plugin
• Worked with Salesforce admins to setup access to salesforce Objects in scope M2O KPI metrics
• Created salesforce application connection to configure and access objects via API 41 version
• Involved in Datamapping documentation to Map salesforce API’s to relevant field values columns to ODS and Hub tables as reverse engineer the salesforce KPI exports received from Business teams translated and transformed the business logic to implement in Informatica ETL code.
• Involved in datamodel design creation of ODS and HUB Mart tables as per the data mapping technical specifications
• Involved in documentation of High level design documents
• Designed and developed Informatica mappings sessions and workflows in Power Center to load data from salesforce system to ODS table and ODS tables to Hub tables
• Implemented SCD type1 incremental and full data load strategies to load data from source to ODS and type2 strategy to load data from ODS to Hub dimension tables
• Involved in analysis of financial data from hyperion source systems to reconcile data loaded in Hub layer sourced from other financial systems including OCB,PPF to hyperion cube
• Involved in analysis of Actual, forecast, budget data files extract from Hyperion cube and ODS tables with data loaded to Hub dimension tables to meet the business requirements as part of M2O KPI metrics
• Resolved Informatica salesforce connectivity issues
• Worked with salesforce admin to resolve to resolve API access to individual users and Informatica integration service account
• Involved in deployment of code from lower environments to deploy the code to production as part of change request forms
• Created the DB scripts and Runbooks checked in the code to SVN repository as part of deployment processs
• Worked with BRE teams to migrate the code from Dev to Stage and Stage to Prod
• Involved in Creation and testing of UC4 job to schedule the ETL workflows
• Involved in code reviews and resolving defects raised by QA team as part unit testing
• Worked with BRE team Resolved ETL jobs performance issues Project Title Managed Platform Services
Client TIME WARNER, NYC
Organization L&T INFOTECH
Duration April 2016-May 2018
Technology Informatica PowerCenter 9.6 HF3/10, Informatica TDM, Metadata Manager,ILM Dataarchive FAS, IDV, Oracle 10g/11g, Netezza, MS SQL Server Erwin, Red Hat Linux, Windows XP, PMPC, Informatica DVO, Service Now,IDQ content Accelerator, INFORMATICA CLOUD
Responsibilities:
Informatica Administration includes managing domain, grids, nodes, services, folders, installing upgrading and applying patches/HotFixes, starting and stopping of Informatica server and services.
• Installed and configured Informatica test data management TDM for Datamasking, PMPC Rule RTM
• Upgraded Informatica 9.5.1 to 9.6.1 with HotFix2.
• Recently Upgraded Informatica 961 Hf2 to version 10 in Non prod, planning to rollout in production next month
• Installed and configured the CLOUD secure agents and registered on cloud
• Configured the ODBC, Oracle, MS SQL, Netezza, Rest API, TDM connections using ODBC and Native driver support in Non and production environments provided RX access permission to users and groups
• Create support cases with informatica technical support and Helped Development Support team resolved issues
• Involved in migrating deployment groups from Development to Testing to Production systems
• Involved in providing access to security groups in Native and LDAP domains
• Involved in Administration - creation of Folders, Users, User Groups, and giving privileges.
• Worked with DBA in order to do some performance tuning for ETL jobs/mappings.
• Performed Installations/Upgradation, Setup, Maintenance & Troubleshooting of Informatica Software on Linux and Oracle platform.
• Upgraded the Metadata manager MM services to version 10
• Upgraded ILM DataArchival, Datavault FAS to 6.4 HF2
• Upgraded Powercenter, applied hotfixes/EBF, upgraded Metadata manager, loaded resources, upgrade ILM dataarchive and Datavault FAS
• Installed and configured Dataquality and dataquality services on premises and cloud
• Created TDM Projects, Plans,Rules, Policies. Generated workflows migrated the code from lower to higher environments in TDM
• Created resources in MM and loaded the metadata for Oracle,Erwin,BO,business glossary
• Installed and configured secure agents servers for Informatica CLOUD in prod and non prod
• Created and configured useraccounts and groups connections in Cloud
• Configured OKTA sign sign on SSO to enable users to access cloud
• Created Groups, roles, privileges OS Profiles and assigned them to each user group both for Native and LDAP account.
• Setup and configured power center domain, grid, repository services and Integration service in oracle and Linux platform.
• Migrated the code part of Deployment groups from DEV to stage and stage to prod
• Identifies performance bottlenecks and availability risks, manage action items to address and prevent issues, and influence peer organizations to implement improvements.
• Worked with Informatica vendor support raised tickets and resolved production issues
• Proactively monitor and apply required bug fixes, Hot Fix releases etc. on the existing Informatica environments
• Monitored and resolved Informatica repository domain backup jobs issues
• Created and configured file archival unix script job
• Installed and configured Informatica Metaquery support console SQL worksheet tool in Non and prod environments
• Created the ILM retirement jobs, archival jobs, defined entities in ILM IDV
• Created PMPC alerts rules to system resource utilization and jobs failures
• Created NTZ, Erwin, BO, Oracle, SQL, BG, XML resources in Metadata Manager
• Created Business glossaries Cataloges, Custom model, linked the resources ran the lineages liked the resources in METADATA MANAGER
• Configure Netezza,oracle, RestAPI,web service, SALESFORCE, SERVICENOW, JDBC connections in CLOUD
• Configured runtimeenvironments, Discovery ID, DIS and Process engine, Bundles, Hierarchies, Schedules in Cloud
• Created PC, DSS, Data replication, Mapping configuration tasks, Migrated the tasks in CLOUD
• Created configured Rules, Alerts in PMPC rulespoint
• Created and configured testcases in DVO
• Accepted and resolved, within defined SLA metrics, operations application and data related help desk requests to meet or exceed IT support expectations.
• Monitored the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Prepared the month load closing status and Send the daily load status as per the client requirement.
• Gathering the month load preparation and Maintain a log files, screenshot, run statistics.
• Communicated with the clients and customers and attend the calls and provide the solution on time.
• Created and scheduled UNIX script for daily backups of the Informatica repository for production environment.
• Worked on Production Support and Root Cause Analysis documentation Project Title Newyork Medicare Management Information Systems Client DOH
Organization Cognizant Technology Solutions
Duration Apr 2015-Feb 2016
Technology Informatica PowerCenter 9.6 HF2, Informatica Dataquality IDQ Oracle 10g/11g, DB2 Mainframe, SQL Server, Erwin, Red Hat Linux, Windows XP, Remedy, Control M,INFORMATICA CLOUD
Responsibilities:
• Primarily responsible for Informatica Administration including managing domain, grids, nodes, services, folders, installing and applying patches/HotFixes, starting and stopping of Informatica server and services.
• Upgraded powercenter, applied hotfixes/EBF, upgraded Metadata manager, loaded resources
• Installed and configured DATAQUALITY IDQ services applied incremental licenses
• Created configured DIS, MRS, CMS, Search, Human task, Profiles warehouse, ANALYST services in IDQ
• Tuned ETL processes inside and outside of the Informatica.
• Involved in migrating the repository objects from Development to Testing to Production systems
• Involved in Administration - creation of Folders, Users, User Groups, and giving privileges.
• Worked with DBA in order to do some performance tuning for ETL jobs/mappings.
• Performed Installations/Upgradation, Setup, Maintenance & Troubleshooting of Informatica Software on Linux and Oracle platform.
• Migrated the servers from physical machines data center to virtual data centers
• Migrated the application database connection to virtual data center
• Created the deployment groups and migrated the code from lower to higher environments
• Created Groups, roles, privileges and assigned them to each user group both for Native and LDAP account.
• Setup and configured power center domain, grid, repository services and Integration service in oracle and Linux platform.
• Identifies performance bottlenecks and availability risks, manage action items to address and prevent issues, and influence peer organizations to implement improvements.
• Worked with Informatica vendor support raised tickets and resolved production issues
• Proactively monitor and apply required bug fixes, Hot Fix releases etc. on the existing Informatica environments
• Monitored and resolved Informatica repository domain backup jobs issues
• Migrated the CODE as part of release change management request from Non prod to prod
• Accepted and resolved, within defined SLA metrics, operations application and data related help desk requests to meet or exceed IT support expectations.
• Monitored the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Prepared the month load closing status and Send the daily load status as per the client requirement.
• Gathering the month load preparation and Maintain a log files, screenshot, run statistics.
• Communicated with the clients and customers and attend the calls and provide the solution on time.
• Created and scheduled UNIX script for daily backups of the Informatica repository for production environment.
• Worked on Production Support and Root Cause Analysis documentation Project Title HIG MBM
Client TheHarford CT
Organization Cognizant Technology Solutions
Duration Mar 2014-Mar 2015
Technology Informatica PowerCenter 8.6/ 9.6, Trillium DataQuality, DataDiscovery, Sharepoint, Attensity, Oracle 12c, DB2 Mainframe Red Hat Linux, Windows XP, Remedy Responsibilities:
• Primarily responsible for Informatica Administration including managing domain, grids, nodes, services, folders, installing and applying patches/HotFixes, starting and stopping of Informatica server and services.
• Installed and configured Trillium Datadiscovery and Dataquality on Windows servers
• Migrated the trillium datadiscovery and dataquality to Linux servers
• Created user and groups assigned permission to users in Informatica, trillium and Sharepoints servers
• Involved in migrating the repository objects from Development to Testing to Production systems
• Involved in Administration - creation of Folders, Users, User Groups, and giving privileges.
• Worked with DBA in order to do some performance tuning for ETL jobs/mappings.
• Identifies performance bottlenecks and availability risks, manage action items to address and prevent issues, and influence peer organizations to implement improvements.
• Created Groups, roles, privileges OS profiles and assigned them to each user group both for Native and LDAP account synchronized the LDAP domain changes
• Setup and configured power center domain, grid, repository services and Integration service in oracle and Linux platform.
• Worked with Informatica vendor support raised tickets and resolved production issues
• Proactively monitor and apply required bug fixes, Hot Fix releases etc. on the existing Informatica environments
• Monitored and resolved Informatica repository domain backup jobs issues
• Participated in CR calls weekly and Created the change requests got approvals migrated the Deployment groups code from Non prod to prod environments
• Created symbolic links NFS share mount point in linux
• Accepted and resolved, within defined SLA metrics, operations application and data related help desk requests to meet or exceed IT support expectations.
• Created and scheduled UNIX script for daily backups of the Informatica repository for production environment.
• Worked on Production Support and Root Cause Analysis documentation
• Monitored the scheduled jobs or run the workflows and scripts which need to run as per schedule.
• Prepared the month load closing status and Send the daily load status as per the client requirement.
• Gathering the month load preparation and Maintain a log files, screenshot, run statistics.
• Communicated with the clients and customers and attend the calls and provide the solution on time. Project Title CVS Datawarehouse
Client CVS
Organization Wipro technologies
Duration Nov 2013- Feb 2014
Technology Unix, Informatica Powercenter 8.6, Oracle 11g,Autosys,ER Studio, Trillium, Remedy
Responsibilities:
• Extensively worked towards Analysis and Resolution of production job failures
• Migrated the code as part of release management CR request from lower to higher environments
• Loaded the data on monthly basis as part of Pipeline Client setup process to include newly enrolled customers
• Involved in Secondary oncall activities carry forward report updates, Aged reports resolutions, EDW cycle status updates
• Assisted in configuration, development and testing of AutoSys JIL and other scripts.
• Coordinated with the client management on a daily basis for issues and status update.
• Extracted the data from DB2 legacy sytems in the form of flat files
• Fine-tuned mappings with bottlenecks to improve the performance Maintained Document standards, processes and procedures relating to best practices, issues and resolutions
• Created Release notes, tickets and co-coordinated with Production teams admins, DBA’s to migrate the code.
• Ensure that all support requests are properly approved, documented, and communicated using the Remedy tool. Documenting common issues and resolution procedures.
• Held daily meetings with team members to resolve open issues to meet project plan deadlines.
• Redesigned existing mappings in the system to meet new functionality. Project Title Management Information Systems
Client Charles Schwab, Phoenix AZ
Organization Wipro technologies
Duration Sept 2012-Sept 2013
Technology Unix, Oracle, Informatica Powercenter 8.6, Informatica DataQuality, Pearl scripting, ESP Scheduling
Responsibilities:
• Involved in Secondary oncall activities carry forward report updates, Aged reports resolutions, EDW cycle status updates
• Assisted in configuration, development and testing of AutoSys JIL and other scripts.
• Coordinated with the client management on a daily basis for issues and status update.
• Identified slowly changing dimension tables and its impact to the overall Data Warehouse including changes to Source-Target mapping, transformation process, database, etc.
• Evaluated the level of granularity, Defined hierarchies
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ER-Studio
• Extensively worked on flat files and involved FTP and in archiving the files after the completion of loads.
• Fine-tuned mappings with bottlenecks to improve the performance Maintained Document standards, processes and procedures relating to best practices, issues and resolutions
• Created Release notes, tickets and co-coordinated with Production teams admins, DBA’s to migrate the code.
• Held daily meetings with team members to resolve open issues to meet project plan deadlines.
• Redesigned existing mappings in the system to meet new functionality. Project Title Profitability Analysis System(IBS,Longview), Client Charles Schwab
Organization Wipro technologies
Duration Dec 2011-Sept 2012
Technology Solaris, Informatica Powercenter 8.6, Teradata 13, FastLoad,MultiLoad Responsibilities:
• Involved in requirement analysis understanding
• Involved in Requirements gathering and Design documentation
• Actively involved in the meetings for data mapping and transformations with Business Analysts, data modelers, to come up with source to target mappings rules.
• Involved in Review of PAS Driver interfaces for IBS and longview Drivers
• Involved in performance optimizations of long running PAD driver jobs
• Modified incorporated new changes as part of change request and maintenance
• Provided support for User acceptance testing phase to fix the defects
• Prepared Documentation including unit test case documents, Migration checklist, Release checklist as part of deployment process
Project Title PTS Metrics System
Client Catalent pharma solutions
Organization Wipro technologies
Duration Feb 2008- Aug 2011
Technology Linux,Win 2K,Informatica Powercenter 7.1, Oracle 9i,Teradata, Toad, Putty, Business Objects XI R2
Responsibilities:
• Prepared business flow diagrams and defind the workflows.
• Co-ordinated with Offshore teams and Involved in different Team review meetings
• Handled production support issues which involve ticket resolution, root cause analysis and fixes
• Participated in daily standup meeting to discuss on project updates and deliverables.
• Conducted code walkthroughs and review peer code and documentation.
• Participated in Production support,scheduling and monitoring of reports.
• Helped business users for generating adhoc reports.
• Involved in troubleshooting of BO users requests to resolve the data discrepancy issues
• Administration of BO XI cluster servers,User account management.
• Involved in Performance optimization of BO servers
• Troubleshooting of data discrepancy issues for OLAP reports.
• Provided the permanent fix whenever the jobs get failed due to recurring issues.
• Analysis of Data related issues using Informatica, Monitoring of ETL jobs,Scheduling,ETL design changes.
• Resolved data discrepancy issues as reported by the business users Project Title FSP Migration
Client Cardinal Health,
Organization Wipro technologies
Duration Oct 2007-Jan 2008
Technology Oracle 9i Financials,SAP, Informatica Powercenter 7.1, Linux,Win 2K,Toad,Winscp Responsibilities:
• Analysis of Functional Specifications,preparation of technical specifications documents.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope.
• Performance optimization of Informatica workflows.
• Involved in Sql query tuning and ETL optimization process.
• Created and modified Informatica workflows and sessions
• Compared the data output of mapping results post migration with source data from source systems
• Involved in peer code review and preparation of code review checklist.
• Prepared migration checklist release documents as part of code release management
•
Project Title GCF Interface System
Client GE Money
Organization Wipro technologies
Duration Dec 2006-Sep 2007
Technology Unix,Win 2K,Informatica Powercenter 7.1, DB2, AS400 Oracle 9i, Toad, Putty, Oracle Financials
Responsibilities:
• Involved in planning and building servers in server migration project
• Installed and configured PowerCenter 7.1
• Creation and maintenance of Informatica users and privileges. Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Coordinated with DBA to prepare DB Schema prerequisites
• Configured domain and repository from old server to new server
• Created project folders and work folders and assigned priveleges to users
• Applied Hotfixes and patches to servers
• Worked on backing up repository and restore repository on new schema at the day of decommissioning jobs on old server.
• Worked with production support, ETL Issues and Performance tuning.
• Involved in requirement gathering and analysis of exiting GL inteface system
• Prepared technical specifications,Naming standards,mapping specification documents,handover documents to SWE project.
• Involved in analysis of present GL interface setup on oracle financials,presented the high level conceptual design with informatica
• Extraction and transformation from DB2 source files is done in AS400 environment to avoid complexity while loading target files
• Created Data source names with various driver interfaces, Created
Contact this candidate