Peoria, Arizona, United States
Molina is a managed Healthcare company focused on health insurance related services through government sponsored companies like Medicaid and Medicare. Informatica platform is used to process data across multiple systems like files, databases and Salesforce. CGDC related services to implement Governance of enterprise assets. Key Responsibilities: • Setup Runtime environments across Orgs, configure Roles, Groups, Users and Connections to cloud and On-premises systems. Configuration of MCC, CDGC, Marketplace services to source systems, Data classification and Workflows for 1-step and 3-step approval process. • Metadata assets management and Onboarding data, including Custom Catalog Source and Custom Lineage configuration • Develop integration mapping as part of the inbound and Outbound integrations. • Configured Business assets like Domina, Business Terms, Metrics, Policies, Processes and related with technical assets • Configuring Data profile, Data Quality, Data Catalog, Lineage, Marketplace and Glossary using CDGC services • Configured one-step and three step workflows • Coordinated with Lead Architect to reach business goals Environment: IDMC/IICS, MSSQL, Databricks, Azure
AMEX data is stored in multiple systems to support financial data processing. Informatica PowerCenter is used to manage the operations data store. Informatica is used to extract data from multiple sources, transform the data to business logic and load the transformed data into file and relational targets. Key RESPONSIBILITIES: · Worked with program Managers in requirement analysis, code update and deployment to production servers · Collaborated with offshore team in code development and validation · Worked on Oracle, MSSQL databases with Informatica PowerCenter 10.5 version · Data migration to lower environments to test new requirements · Analysis of PL/SQL and Informatica code to test and update code to meet the new business requirements.
A new suite of solutions that enable collaboration across healthcare and break down of data silos, bringing information together to inform and engage all healthcare stakeholders to support the transformation to value-based healthcare models. Key RESPONSIBILITIES: · Worked with IT Architect, Program managers in requirement gathering, analysis and project coordination · Developed Data Integration Platform components/processes using Informatica Cloud Platform, Azure SQL Data warehouse, Azure Data lake Store and Azure Blob technologies · Worked on Mongo, Cosmos, SQL Database configuration in multiple environments for Client SaaS product and database server maintenance. · Designed, Developed and implemented ETL processes using IICS Data integration · Installed and configured Windows Secure Agent register with IICS org · Informatica IICS using Data integration, Data Quality, Profiling, MDM and Governance. · Extensively used cloud transformations – Aggregator, Expression, Filter, Joiner, Lookup (Connected and unconnected), Rank, Router, Sequence Generator, Sorter, Update Strategy, Union Transformations · Master tenant data using Informatica Master Data Management (MDM SaaS) to master Healthcare data domains like Insurance, Patient and Practitioner. · Metadata command center to onboard metadata into the catalog, and to manage governance assets. · Data replication to take backups of OLTP databases. · Performance tuning for scalability with query writing and logic moved to meet the requirement.
Symphony Health, a leading healthcare analytics provider. Company provides products and services for professionals in the health sector to get insight into the pharmaceutical market. Key Responsibilities: · Data migration from Oracle to Hadoop · Hadoop cluster installation and configuration for performance · Informatica Big Data Edition installation and configuration to work with Hadoop cluster · Informatica code migration to run in Hadoop environment. · POC with Hadoop related technologies · Developed ETL code in Informatica to load into ODS and EDW · Offshore team management in development and QA · Coordination with Cloudera and Informatica support on technical issues · Server maintenance and upgrades to new versions · Technical documentation
Marathon Oil Corporation is engaged in the business of exploration, development and production activities in 11 countries. It has internal data warehouse projects and data marts to support different systems. Extensive system analysis is done on existing data reconciled from different OLTP sources like PeopleSoft and Oracle into single data warehouse for tactical and strategic decision support.