Vamsi M

AltaMed is community health network. Find compassionate, culturally sensitive health care services that meet family's needs at every stage of life.

Responsibilities :

• Understanding business rules and sourcing data from multiple source systems using IICS.
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Implemented Type1, Type2, CDC and Incremental load strategies.
• Extracted data from flat files, Excel files and transformed data based on user requirement using Informatica Power Center.
• Performed analysis on quality of source data to determine accuracy of information being reported.
• Debugging mappings and used session log files to trace errors that occur while loading.
• Performance tuning by optimizing mappings and sessions.
• Performed Unit Testing and tuned for better performance.
• Worked closely with DBAs, admins, ETL developers and change control management team for migrating developed mappings across Dev, QA, and PROD environments.
• Provide support for deployment activities and production support activities.
• Environment: IICS/Informatica Power Center 10.4/IICS/Snowflake/Oracle /SQL Server/MongoDB

Apple provides comprehensive clinical development services, including data management, statistical analysis, clinical trial management, medical writing, and regulatory and drug development consulting.

Responsibilities

• Designed and built IICS mappings to extract data from SFDC, Oracle, SQL Server and loaded into Oracle/Designed ETL flows for generating flat file extracts as per business need.
• Worked on converting Informatica Power Center ETL code to IICS using PC to Cloud Conversion service.
• Involved in enhancements and maintenance activities of data warehouse.
• Implemented Type1, Type2 and Incremental load strategies in IICS.
• Handled configuration activities like setup run time environment and create connections, schedules, tasks, mappings, mapplets and components.
• Designed Mappings, Integration Templates, Bundles and Task flows.
• Used various transformations to extract data from different formatted files and relational source system.
• Developed and tested Informatica mappings based on specification.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance. Developed/Automated (Power Center/IICS) jobs through Scheduler.
• Environment: IICS, Informatica Power Center 10.4/10.2, SalesForce, Oracle, SQL Server, GitHub.

Wipro - Client Philips is corporate agency of United States that provides electricity for business customers and local power companies serving 10 million people in parts of seven southeastern states. As a Sr. Software Engineer I was involved in implementation of Enterprise Asset Management & P6 Data warehousing, CDC, Maximo 7.5 version upgrade, TRIRIGA, Enterprise Content Management, Portfolio optimization project, Power supply, Enterprise Material Tracking System and supported various software and database upgrades.

Responsibilities

• Involved in Requirement gathering, analysis, design and development of project.
• Worked on design and development of Informatica Power Center mappings, workflows to load data from multiple sources into staging area, data warehouse and data marts in SQL Server and Oracle on real time.
• Extensively used Informatica Power Center, IICS to create mappings, sessions and workflows for populating data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Used Change Data Capture (CDC) to capture changes in multiple environments and deliver most accurate data to business in data warehouse applications.
• Worked on Migrating Informatica Power Center code to IICS.
• Experience integrating data using IICS for reporting needs.
• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that appropriate level of application quality was maintained at all times.
• Providing architecture review for proposed projects and enhancements to aid governance process in decision making.
• Worked with Repository DB to find deviations from Company's ETL Standards for objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Integrated Data Quality routines in Informatica mappings to standardize and cleanse data.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Designed and developed UNIX scripts for scheduling jobs using PMCMD.
• Involved in providing Technical support to team members, as well as, Business.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Successfully Implemented Slowly Changing Dimensions.
• Successfully Integrated Multiple XML sources and created de-normalized, flat-structured file
• Involved in writing SQL Stored Procedures, Functions, Triggers and Views for Oracle database
• Ensure that all support requests are properly approved, documented, and communicated using Team Foundation Server(TFS).
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Estimated work hours and tracked progress using Agile methodology.
• Reviewed ETL code and worked with development teams to correct problems, run test scenarios and prepare for deployment.
• Met with stakeholders, contractor product teams and customers throughout system development life cycle.
• Delivered and sign-off of deliverables pertaining to Transactional Data warehouse.
• Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
• Environment: Informatica Power Center 10.2/10.1/9.6/9.1/8.6.1, ,IICS, Informatica Power Exchange 10.2/9.6/9.1/8.6.1, Informatica Data Quality 8.6.1,Google Big Query, Admin Console, Oracle 12c/11g/10g, SQL Server 2005 ,PL/SQL, UNIX, WindowsNT4.0, Tableau, Power BI,GIT, Team Foundation Server TFS.

Dell is one of largest commercial Data warehouse in United States, and provides Customers with full range of financial products and services. As ETL Developer at Dell services Project to design, develop, and implement ETL process to load the Products Data Mart, which helped generate Business Intelligence and Performance Management reports.

Responsibilities

• Extensively involved in gathering business requirements and translating them into technical requirements.
• Used Informatica Power Center & Ab Initio to extract data from Mainframe.
• Responsible in strictly maintaining naming standards and warehouse standards for future development.
• Coordination and Leading offshore in development activities.
• Extracted data from various sources such as Flat Files, Mainframe , SAP and Oracle using Informatica Power Exchange.
• Designed and Developed Stored Procedures in DB2.
• Achieved performance improvement by tuning SQL queries, extraction procedures between Oracle/DB2 and Power Center.
• Offered 24/7 production support for application on time-time basis.
• Developed complex Power Center mappings by using different transformations and components respectively to meet data integration and data quality requirements.
• Created and monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Performed Unit testing, Integration Testing, and User Acceptance testing to pro-actively identify data discrepancies and inaccuracies.
• Involved in performance tuning at source, target, mapping and session level.
• Prepared design documents, ETL Specifications and migration documents
• Maintained daily Tech Tracker for updates from team regarding their objects, issues and progress
• Involved in Informatica Power Center 8.1.1 Repository upgrade to Informatica Power center 8.6.1
• Involved in providing Informatica Technical support to team members, as well as, business
• Environment Ab Initio, Informatica Power Center 8.1.1/8.6.1, Teradata, Oracle.

AT&T is one of largest Telephone network in United States, and provides Customers with full range of financial products and services. As ETL Developer at&t services Project to design, develop, and implement ETL process to load the Products Data Mart, which helped generate Business Intelligence and Performance Management reports.

• Understanding business rules and sourcing data from multiple source systems
• Extracted raw data from Microsoft SQL Server to staging tables using oracle Data warehouse.
• Developed Cloud mappings to extract data for different regions.
• Refreshing mappings for any changes/additions to Microsoft SQL Server source attributes
• Developed audit activity for all cloud mappings.
• Automated/Scheduled cloud jobs to run daily with email notifications for any failures.
• Generated automated stats with staging loads comparing with present day counts to previous day counts.
• Created File watcher jobs to setup dependency between Source systems and Power Center jobs.
• Created and developed mappings to load data from staging tables to EDW DataMart tables based on Source to Staging mapping design document.
• Implemented Type1, Type2, CDC and Incremental load strategies.
• Followed ETL standards - Audit activity, Job control tables and session validations.
• Loading data to staging tables following Data Integrity rules of Interface Design Specifications
• Used source external tables to load data to staging tables.
• Created mapping documents to outline data flow from sources to targets.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test mappings and fixed bugs.
• Prepared migration document to move mappings from development to testing and then to production repositories.
• Created Pre/Post Session/SQL commands in sessions and mappings on target instance.
• Used Exceptional mappings to generate dynamic parameter files after staging loads.
• Used Shared folders to create reusable components (Source, target, email tasks)
• Developed single dynamic ETL mapping to load more than 30 reference tables.
• Used SQL Queries to validate data after loading.
• Maintained and automated production database to retain history backup tables for 30 days.
• Developed/Automated (Power Center) jobs through Control M.