Subose PC

Ph: (608) 514-1859 Email; bosepa54@[Link]

Professional Summary:
 Over 13 years of extensive experience with Informatica Power Centre in all phases of Analysis, Design,
Development, Implementation, and support of Data Warehousing applications using IICS, Informatica
Power Center 10.x/9.x/8.x/7.x.
 Extensively Worked on Data warehousing marts and ODS with emphasis on ETL and life cycle development
including requirement analysis, design, development, and implementation.
 Extensive experience in Informatica Data Integration Tools - Such as Repository Manager, Designer,
Workflow Manager, Workflow Monitor, and Scheduled workflows using Workflow Manager.
 Extensively worked with Informatica mapping variables, mapping parameters, and parameter files.
 Experience in several facts of implementations including Data Profiling, Data extraction, Data validation,
Data Cleansing, Data Load, Data Migration, and Trust Score validation.
 Extensive experience in understanding data models, data taxonomy, and a deep appreciation of data
standards and data quality.
 Experience in working with business analysts to identify and understand requirements in order to create
Technical Design Documents.
 Developed ETL mappings using Informatica Intelligent Cloud Services (IICS) and Informatica Power canter
transformations using aggregator, look-up, joiner, filter, sequence generator, normalizer, sorter, router, in
Data Integration.
 Created processes that conduct service calls through APls that interface with 3rd party applications in IICS.
 Managed and configured lICS administration as per the requirement
 Created IICS Data Synchronization Jobs to load data to Snowflake.
 Optimized the performance of IICS's applications through techniques such as code refactoring, caching, and
asynchronous processing, ensuring scalability and responsiveness to handle increasing user loads
and data volumes
 Used Integration Templates to create reusable mappings in [Link] understanding of the Data
Warehousing SDLC and architecture of ETL, reporting and BI tools.
 Expertise Informatica B2B Data Transformation, DT and DX, pre-built transformations for most versions of
industry-standard messages including the following EDI standards and derivatives.
 Experience working with Informatica Data Quality (IDQ) for data cleansing, data matching and data
conversion.
 Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional,
Labeller, Standardizer, and Address Validator transformations with Informatica Developer and migrated to
Informatica Power Center.
 Extensive knowledge in optimizing techniques such as concurrent caching, Auto memory calculations,
partitioning and using push down optimization.
 Solid understanding on Hadoop Hive and HBase implementation and have Knowledge on scheduling tools
such as oozie, AutoSys.
 Experienced using Cloud Data Integration (CDI), using Cloud Integration Hub (CIH), and using in Cloud
Application Integration (CAI) of Informatica IICS components/products to integrate and design using multiple
applications and working experience of installation /Upgrading Informatica DEI and ED.
 Proficient in the Integration of various data sources with multiple relational databases like Oracle12c
/Oracle11g, MS SQL Server, DB2, XML files, and Flat Files into the staging area, Data Warehouse, and Data
Mart. Strong experience with star and snowflake schema, dimensional data modeling, facts, and
dimensional and slowly changing dimensions.
 Experience in AWS S3, RDS (MySQL) and Redshift cluster configuration. Informatica Cloud Data Integration
mapping and task flows to exact and load data between on-premises, AWS RDS, Amazon S3, Redshift, Azure
SQL Data Warehouse, and Azure Data Lake Store.
 Experienced in executing complex queries using stored procedures, Triggers, Cursors, and defined Functions
using T-SQL.
 Created ICRT and IICS jobs using Snowflake Cloud Connector V2 and REST and Soap and other APIs. V2
connector to send and receive data from third-party vendor applications.
 Experience in IICS Application Integration components like Processes, Service Connectors, and Process
Objects.
 Implemented and managed data testing processes using QuerySurge, ensuring data accuracy and quality
across multiple projects.
 Expertise in implementing Slowly Changing Dimensions (SCD) Type 1 and Type 2 for initial and history load
using Informatica.
 Extensively designed and implemented the Kimball design methodology and other Datawerehouse concepts
and other DATA models.
 Worked on Informatica CDC (Change Data Capture) Implementation experience of DATA EXCHANGE AND
DATA TRANSFORMATION.
 Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and
evaluating transformations.
 Expertise in RDBMS, database Normalization, and Denormalization concepts and principles.
 Developed shell scripts for invoking Informatica workflows and for running batch processes.
 Experience in designing the architecture for extract, transformation, load environment, and development of
mapping and process using Informatica PowerCenter and Informatica IICS
 Experienced in Performance Tuning at Mapping, Session, and database levels, tuning mappings, and Pipeline
Partitioning to speed up data processing.
 Extensive experience in developing Stored Procedures, Functions, Views and Triggers, and Complex SQL
queries using SQL Server, T-SQL, and Oracle PL/SQL.
 Experienced in using different scheduling tools - Control- M, Tidal, Auto Sys, and Maestro/TWS & Cron Job.
 Excellent analytical skills in understanding the client’s organizational structure.
 Excellent problem-solving skills with a strong technical background and result-oriented team player with
excellent communication and interpersonal skills.

Education: - Bachelor's in computers1995 from Osmania University.

Technical Skills:-
ETL Tools Informatica Power Center 10.x/9.x/8.x, IICS, Informatica Cloud, IICS Developer, Cloud
Application Integration, Talend, Cloud Data Integration, ENTERPRISE DATA
CATALOG(EDC)Master Data Management (MDM), Data Quality Tool (IDQ), Informatica
Cloud. AWS
Database Oracle 12c,Oracle 9i/10g/11g,SSIS,SQL Server SQL Server 2014/2008/2005 ,
Snowflake ,and Teradata 14.0,SAP, Query Surge
DataModelling Tools Erwin 4.1, TOAD, MS Visio, SQL *Loader, Star and Snow Fake Schema.
Scheduling Tools TWS, Auto Sys, Maestro, Cron Tab, Control – M, Informatica Scheduler, Tidal
Languages SQL, T-SQL ,PL/SQL, C, C++
Scripting Languages UNIX Shell Scripting, Korn Shell, Bash shell scripting. Python
Operating Systems Windows, MSDOS, Linux, Unix, Sun Solaris
Reporting Tools OBIEE, CLICK VIEW, COGNOS Report Studio, IBM Cognos 11.0 , Tableau
Centene,Saint Louis, MO Jun 2022 – Till date
Sr. Lead Informatica IICS ETL Developer/ DATA Engineer
Project: Encounters.
Encounter data Capturing the previous member claim interaction of Digital and paper Medicare and
Medicaid, tracking the members in MCO(such as well-care)with Provider information. Encounter Data
Capture’s used to develop cost profiles for particular group of claims and also make certain business
Intelligence decisions about provide the cost /payment adjustment incentives based on Incentive
Compensative Management data to make the Decision’s and provide states and CMS visibility into service
provided to Members and Healthcare Effectiveness Data & Information Set/HEDIS calculation price.

Project: EDI
Processing the 837,277, and 999 files and extracting the data into EDI HTR DB.
Responsibilities:
 Developed and Created ETL and Data warehouse standards documents-Naming Standards, ETL Standards,
ETL methodologies and strategies, standard input file formats, data cleansing and pre-processing strategies.
 Created and Developed the Source and Target transformation Logic, Source data column information and
target data column information.
 Designed, developed, and implemented ETL processes using Informatica PowerCenter and IICS Data
Integration.
 Created and managed IICS connections using various cloud connectors through the IICS Administrator.
 Extracted flat files from S3 buckets and loaded them into Snowflake using IICS Data Integration Services.
 Implemented ETL processes with FULL push-down optimization in IICS for efficient data transfer from
Staging to ODS at scale.
 Developed IICS Informatica Cloud mappings to extract data from Salesforce (SFDC) and created Workflow
tasks for data integration.
 Maintained custom-built queries to load dimensions and facts in IICS.
 Used Snowflake connector in IICS for loading data into Snowflake for analytics and reporting purposes.
Implemented key range partitioning and managed file loads with various file formats and options in IICS.
 Managed migration activities for Informatica tools, including upgrades from Informatica 9.5 to 10.2 and 10.2
to 10.5.
 Migrated data for reporting and reference data availability using tools such as Tidal, Oracle, VB, Teradata,
UNIX, and SSIS.
 Developed ETL processes in AWS Glue to migrate campaign data from sources like S3, ORC/Parquet/Text
Files into AWS Redshift.
 Performed data extraction, aggregation, and consolidation of Adobe data within AWS Glue using PySpark.
 Collaborated with legal and compliance teams to ensure alignment with regulations such as GDPR and
HIPAA.
 Utilized data governance tools like Collibra and Informatica Axon to automate data governance processes
and maintain a centralized repository of data policies and metadata.
 Conducted training sessions on data governance to raise awareness among employees regarding data
quality and security.
 Provided analysis, system/architectural design, project planning, and coding for data integration projects.
 Worked on IICS Task monitoring and administrator concepts, including the creation and management of IICS
connections, mapping configuration tasks, and taskflows.
 Coordinated with the production team for code migration from IICS UAT to IICS Production.
 Developed components and implemented code using Python for data retrieval and manipulation.
 Performed extensive testing and wrote SQL queries to ensure accurate data loading and transformation.
 Created Salesforce connections and implemented Salesforce business processes using Informatica IICS Data
Integration.
 Established a data movement control system to ensure correct loading of data between Salesforce and
Oracle tables through IICS.
 Designed the ETL mappings between sources to operational staging targets, then to the data warehouse
using Power center Designer.
 Used Informatica Power Center 10.4 to create mappings, sessions, and workflows for populating the data
into dimension, fact and lookup tables simultaneously from different source systems (SQL Server, Oracle,
Flat files) and Pushing the compressed and encrypted xml files and flat files generated to the external
vendor using MFT.
 Worked extensively with Enterprise architects and Project Managers and Client/Business User’s in
requirement gathering, analysis and project coordination.
 Implemented and managed data testing processes using QuerySurge, ensuring data accuracy and quality
across multiple projects.
 Developed Data Integration Platform components/processes using Informatica Cloud Platform, Azure SQL
Datawarehouse Azure DataLake store, and Azure Blob Storage Technologies.
 Extensively used Parameters(Input and IN/OUT Parameters), Expression Macros and Source Partitioning
Partitions.
 Implemented developed Datawere house using the Kimball design methodology.
 Extensively Used Push Down Optimization to Optimize processing and use limitless power of Azure
Synapse(sqlDW)
 Extracted data from Snowflake instance using Snowflake connector in IICS for a separate project to support
data analytics and insight use case for EDI claim team.
 Created PYTHON scripts which will used to start and stop cloud Tasks (the scripts use Informatica Cloud API
calls).Created PYTHON scripts to create on demand Cloud Mapping Tasks using Informatica REST API.
 Analysed existing ETL Data warehouse process and ERP/NON-ERP Applications interface and created design
specification based on new target Cloud Data warehouse(Azure Synapse) & Data Lake Store.
 Created IICS connection using various cloud connector’s in IICS administrator.
 Installed and configured windows secure agent register with IICS org.
 Extensively used performance Tuning while extracting data into Azure Synapse using IICS.
 Extensively used cloud transformations-Aggregator, Expression, Filter,Lookup(connected and Unconnected)
 Developed Cloud integration parameterized mapping templates (DB, and table object parameterization) for
stage, Dimension(SCD1 type 1,2,3,,CDC and Incremental Load ) and Fact load processes.
 Developed complex Informatica Cloud Taskflows(Parallel) with multiple mapping tasks and taskflows
 Developed Mass Ingestion tasks to Ingest large datasets from on-prem to Azure Data lake Store-File
Ingestion
 Designed Data Integration Audit framework in Azure Sql Dw to track data loads, data platform workload
management and produce automated reports.

Environment: IICS, Informatica Power Center 10.5, 10.2, 9.5, SQL, PL/SQL, Oracle SQL Developer, TOAD,
Teradata, Flat files, Facets, XML, AWS Glue, Snowflake, Salesforce, SQL Server 2012R2, Azure, Operational
Data warehouse, Green plum, Jira, Microsoft Visual Studio 2010, SVN, Kafka, Tidal. , Tableau. Sybase

Anthem Insurance Inc, Mason, OH Jan 2020 –Jun 2022

[Link] Developer
Project: ACR Reporting Acceleration..
This project involved analysing the performance and redesigning the production runs to load data
warehouse in order to improve the Performance for the run using Oracle and Sybase and Informatica.
Project: Anthem East Data Warehouse Maintenance and Production Support and CCERT:
Anthem East Data Warehouse AEDW consolidates the data in North East region for reporting and analysis.
AEDW receives data from various online transactional systems in the Connecticut, New Hampshire and Maine
regions that are consolidated under Anthem Consolidated East Systems ACS. This project involves production
support, maintenance and enhancements to the AEDW system MEDICARE and CCERT DB with MEDICLAIM.

Responsibilities:
 Worked extensively on Informatica Power Center tool - Source Analyzer, Data Warehousing designer,
Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in
tuning of mappings for better performance.
 Used Informatica Power Center 10.1 to create mappings, sessions and workflows for populating the data
into dimension, fact and lookup tables simultaneously from different source systems (SQL Server, Oracle,
Flat files).
 Experienced in Hadoop and good understanding on Hive and HBase implementation. Knowledge on
scheduling tools such as oozie, Autosys.
 Develop detailed specifications, including data conversion, interfaces, and custom reporting to ensure
business requirements are met.
 Deployed Informatica PowerCenter mapping to Informatica Cloud mapping. Implemented source qualifier,
Aggregator, Lookup, Filter, Sequence generator, Router, Update strategy in Mappings.
 Prepared Unit Test Cases and mentoring other developers.
 Used various add on-connectors in Informatica cloud like XML, XML Target, Excel.
 Developed integrations like flatfile to service now XML to JSON
 Run the Informatica cloud Data Integration tasks in application integration using service steps
 Run the data integration task in application integration.
 Spearheaded the upgrade and migration of Informatica PowerCenter from version 8.1.1 to 10.5, including
backup, installation, configuration, and verification of upgraded repositories.
 Provided detailed hardware specifications for building virtual servers for various Informatica versions,
ensuring optimal performance and compatibility.
 Installed and configured PowerCenter components, clients, and ODBC drivers on Windows 2019 and 2022
servers.
 Worked on IICS concepts relating to data integration, Monitor, Administrator, deployments,
permissions,schedules.
 Worked on Azure Sql Data Warehouse integration with IICS.
 Worked on iIICS Data integration console to create mapping templates to bring data into staging layer from
different source systems like Sql Server, Oracle, Teradata, Salesforce, Flat Files, Excel Files, Cdc
 Provide Real-time integration E2E solution using APIs and various DBs with IICS.
 Design and Develop ETL Processes in AWS Glue to migrate Campaign data from external sources like S3,
ORC/Parquet/Text Files into AWS Redshift.
 Performance tuning - Using the map cache properties, Multi-threading, and parallel components for better
performance in case of huge source data. Tuning the SQL source queries to restrict unwanted data in ETL
process.
 Created Kafka topic to process JSON files and used microservices to request payloads.
 Worked on Google Cloud Platform (GCP) services like compute engine, cloud load balancing, cloud storage,
cloud SQL stack driver monitoring, and cloud deployment manager
 Conducted thorough testing of new software versions and repositories, validating system functionality and
data integrity.
 Led the migration of repositories from production to test environments, including the incorporation of
sequence IDs and verification of migrated repositories.
 Delivered training and support to the City’s Informatica administrators and developers, enhancing their
proficiency in ETL processes and Informatica PowerCenter.
 Developed hardware specs to build virtual servers for software.
 Installed PowerCenter 10.5 Components Client and ODBC on new Windows 2019 (2022) server and Installed
PowerCenter 10.5 Repository server on new Windows 2019 (2022) server.
 Configure PowerCenter 10.5 Informatica server on new Windows 2019 (2022) server.
 Upgrade the Repository on the new Windows 2019 (2022) server.
 Verify the upgraded Repository. Run a Test with new software version and new repository.
 Incorporate all current sequence ids from Production into Test Repository
 Migrate the Repository from Production to Test. Connecting to New Repository Database.
 Verify the Migrated Repository. Uninstall old Informatica software new Windows 2019 (2022) server.
 Good Exposure on connectors to connect the third-party applications using service connector with the help
of API’s. Worked on the API’s source Data
 Involved in gathering and analysis business requirement and writing requirement specification documents
and identified data sources and targets.
 Used different sources like API’s, Json files, SQl server tables, snowflake, Workday, SAP in informatica cloud
IICS integrations.
 Designed and implemented a data reporting solution for.
 Extracted data from Snowflake to push the data into Azure warehouse instance to support reporting
requirements.
 Worked on the ETL jobs to migrate data from on premise to cloud snowflake by generating JSON and CSV
files to support Catalog API integration.
 Communicated with business customers to discuss the issues and requirements.
 Extensive knowledge in designing and developing the complex Informatica mappings by making use of Java
transformation, Connected and Unconnected Lookup transformation, Update transformation, router
transformation, expression transformation, SQL Transformation, Source Qualifier transformation.
 Used ETL tools Informatica power center to extract data from source systems, cleanse Transform, and Load
data into XML and Flat files.
 Worked with control-m tool to automate the batch process scheduling.
 Developed ETL programs using Informatica and Talend to implement the business [Link]
Python scripts to parse XML documents as well as JSON based REST Web services and load the data in
database.
 Profiling Python code for optimization and memory management and implementing multithreading
functionality.
 Experience in Dimensional Modelling in creating various data marts like Star and Snowflake Schema,
Identifying Facts and Dimensions (SCD Type I, SCD Type II), Physical and logical data modelling
 Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks,
used Informatica scheduler to schedule jobs.
 Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional, and
performance Testing.
 Developing Informatica Cloud (IICS) mappings and tasks, performing the validations of test cases.
 Effectively using IICS Data integration console to create mapping templates to bring data into Snowflake
Database from Oracle, Flat Files.
 Experience working with IICS transformations like Expression, joiner, union, lookup, sorter, filter, normalizer
and various concepts like smart match fields, renaming bulk fields and more.
 Environment: Informatica Power Center, Oracle, PL/SQL, Linux Sun Solaris, UNIX Shell Scripting, Java,
DB2, Mainframe, WinscpSQL, Oracle,AWS, AWS Glue, Talend, GCP,Azure, Snowflake, Kafka,
Microservices, Control-m.

Beatty Insurance Inc, Seymour, IN Nov 2017 - Dec 2019

Sr. Informatica ETL Developer
Project: The advisor interactions project.
The advisor interactions project goal is to capture all client interactions across the company with in associated
timeline Information in the new database will assist in creating additional interesting moments as well as business
intelligence reporting, across the new database and already existed in EIM
Responsibilities:
 Responsible for Developing, support and maintenance for the ETL (Extract, Transform and load) processes
Using Oracle and Informatica Power Center.
 Worked extensively on Informatica Power Center tool - Source Analyzer, Data Warehousing designer,
Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in
tuning of mappings for better performance.
 Extracted Data from different flat files, MS Excel, MS Access and transformed the data based on user
requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
 Experiencein Hadoop and good understanding on Hive and HBase implementation. Knowledge on
scheduling tools such as oozie, Autosys.
 Experience in using Informatica Connectors, REST, SOAP and other API’s for Integration.
 Responsible for creating and maintaining Architecture document for PL/SQL ETL Framework.
 Worked as Data modeler and created Data model for warehouse and involved in ODS and Data Mart data
models.
 Build incremental/delta ETL solution for Oracle EDW and ThoughtSpot (Data Analytics platform) using IICS.
 Explore opportunities for integrating real-time data streaming capabilities within the ETL framework.
 Setup Generic Extract Load Pipelines using Python , Azure Tools like Azure Data Factory ,Azure
Databricks ,PowerShell for different source system like Oracle, SQL server, and the RDBMS etc.,
 Installed Infrastructure for Snowflake Project. Provisioning servers, Firewalls, Setup Network, Setup
Snowflake, Setup Azure, Setup Azure Data Factory, Setup Access management etc..
 Involved in design and development of data warehouse environment, liaison to business users and technical
teams gathering requirement specification documents and presenting and identifying data sources, targets
and report generation.
 Used ETL tools Informatica 10.1 to extract data from source systems, cleanse Transform, and Load data into
XML and Flat files.
 Created DDL scripts to create database schema and database objects like tables, stored procedures, views,
functions, and triggers using T-SQL.
 Identified & documented data integration issues and other data quality issues like duplicate data, non-
conformed data, and unclean data.
 Experienced in Logical and Physical data modelling using Erwin for data warehouse database in STAR
SCHEMA. Extensively used Oracle ETL process for address data cleansing.
 Designed and developed standard re-usable mapping, transformation logic and processes in Informatica for
implementing business rules and standardization of source data from multiple systems into the data
warehouse.
 Experience in working onIICS Setup Application Integration products like Processes, Service Connectors, and
Task flow and mapping Task etc.
 Developed detailed specifications, including data conversion, interfaces, and custom reporting to ensure
business requirements are met.
 Prepared the document’s about setup and configuration parameters while follow eBO/Cognos development
best practices.
 Manage reports security, folders security, database security, report schedules and distribution.
 Created common reusable objects for the ETL team, over look coding standards and reviewed high – level
design specifications ETL coding and mapping standards.
 Optimized the performance of queries with modification in T-SQL queries, normalized tables and established
joins .
 Developed UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling
the jobs (work flows).
 Create Sessions, reusable worklets and workflows in Workflow Manager and Schedule workflows and
sessions at specified frequency.
 Created Deployment Document for Migration of code from Dev to Test and from Test to Production
environment.
Environment: Informatica Power Center 10.1,Informatica Cloud(IICS), Talend and 10.X ,OBIEE,SSIS ,SQL Server,
Oracle 11g, SQL, PL/SQL, Oracle RDBMS 12g, Autosys. Tidal

State Farm Insurance, IL Jan 2016 – Nov 2017

Sr. ETL Developer
Projects : HR Project and Property & Casualty Project
The project involved data migration and data conversion of the Purchase Order, goods receipt, Vendor
master, Expanses, Employee Organization, salary, GL balances, fixed assets, AGENT Incentives cost or
payment adjustment incentives basing on Incentive Compensative Management data and also Property
& Casualty Insurance renewals and new insurance member’s and provider data to make the Decision’s
and project balance data Report from oracle applications
Responsibilities:
 Responsible for Business Analysis and Requirements Collection.
 Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and
Workflow Monitor.
 Parsed high-level design specification to simple ETL coding and mapping standards.
 Designed and customized data models for Data warehouse supporting data from multiple sources on real
time
 Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the
business process, dimensions and measured facts.
 Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in
Development and Production environment for SQL Server 2005
 Extracted the data from the flat files and other RDBMS databases into staging area ,ods and populated onto
Data warehouse.
 Published the records to downstream applications with help of ETL power center with the help of message
queue. Created the report for the Informatica CDC workflow’s performance
 Worked with Power Center Designer tools in developing mappings to extract and load the data from XML
files into different Flat File formats.
 Using Informatica Power Center created mappings and mapplets to transform the data according to the
business rules.
 Maintained stored definitions, transformation rules and targets definitions using Informatica repository
Manager..
 Involved in development and debugging of complex batch T-SQL Procedures and functions.
 Developed mapping parameters and variables to support SQL override.
 Developed mappings to load into staging tables and then to Dimensions and Facts.
 Experienced with change data capture (CDC) by using the MD5 function of Informatica.
 Experienced with Cognos administration – Server administration (install, upgrade, troubleshoot Cognos
environments), content administration (reports/package promotion, user security),
 Experience in all aspects of development in Cognos – Modeling in Cognos Framework manager, map
rendering, performance tuning etc.
 Confer with programmers and architects to gain understanding of needed changes or modifications of
existing framework and reports.
 Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of
stored procedures for code enhancements. Involved in data modeling to identify the gaps with respect to
business requirements and transforming the business [Link] oracle PL/SQL Stored Procedures.
 Generated queries using SQL to check for consistency of the data in the tables and to update the tables as
per the Business requirements.
 Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables..
 Used Debugger to test the mappings and fixed the bugs.
 Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
 Involved in Performance tuning at source, target, mappings, sessions, and system levels.
 Developed Shell scripts using UNIX to drop and recreate indexes and key constraints.
 Working in the Agile (Scrum) software development process, for the better accurate signoff.
 Designed and developed complex procedures to handle errors and exceptions at both application and
database level using PL/SQL and shell scripts. Experienced in SQL* loader.
 Prepared migration document to move the mappings from development to testing and then to production
repositories.
Environment: ICM tool, Informatica PowerCenter 9x,SQL, PL/SQL , Data Warehouse,Snowflake, Oracle, Git
Cognos,Control-M.

AAA, Dearborn, MI June 2015–Dec 2015

Informatica Developer/Project Coordinator
Project: ODS AND CALL CENTER DATAMARTS
AAA is one of the leading Insurance providers ranging from automobile, watercraft, motorcycle and
Homeowners. AAA deals with Northern California, Nevada & Utah policies. They have wide range of legacy
systems like Auto (ADES), Home (HDES), Membership information (HUON) and Western United domain (SIS).The
purpose of the project is to build a Master Data Enterprise(MDM) Data Warehouse which has both Customer
and Product information on a certain Auto/Home/Membership products. Informatica Power exchange v 8.6.1 is
used to register the legacy tables in Power Exchange and then the tables are brought to Informatica Client
repository to load the data from Postgre sql to Oracle Database.
Responsibilities:
 Worked with business analysts for requirement gathering, business analysis, and translated the business
requirements into technical specifications to build the Enterprise data warehouse.
 Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer,
Mapping Designer, Mapplet Designer and Transformation Developer.
 Involved in gathering and analyzing the requirements and preparing business rules.
 Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup
and Router transformations for populating target table in efficient manner.
 Extensively Worked with Data Modeler, Data Analysts and Business Users to gather, verify and validate
various business requirements. Write Stored Procedures and T-SQL statements for retrieval of data and
Involved in performance tuning of T-SQL queries and Stored Procedures.
 Developed Database application to meet business need using Oracle PL/SQL features. Created Packages,
Procedures, Functions and Triggers. Involved in creating new table structures and modifying existing tables
and fit into the existing Data Model.
 Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
 Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance
and efficiency. Created the report’s for the Informatica CDC workflow’s performance
 Written PLSQL code for the data integration between Informatica and other Source systems.
 Extensively used Informatica Power centre for extracting, transforming and loading into different databases.
 Defined Target Load Order Plan and to load data correctly into different Target Tables.
 Experienced in debugging Informatica mappings, Performance testing and Unit testing of Informatica
Sessions, Batches and Target Data.
 Involved in designing the ETL testing strategies for functional, integration & system testing for Data
warehouse implementation.
 Designed Fact tables and Dimension tables for star schemas and snowflake schemas using ERWIN tool and
used them for building reports.
 Performed Unit testing and created Unix Shell Scripts and provided on call support.
 Created sessions and workflows to run with the logic embedded in the mappings.
Environment: Informatica Power canter 8x/9x, MDM Workflow Manager, Workflow Monitor, Informatica
Power Connect/ Power Exchange, Toad, Data Warehouse, SQL Developer, Oracle 11g, SQL loader, PL/SQL , SAP,
R3 connecter’s Erwin, Linux.

CIGNA, Hartford, CT Jan 2014 - June 2015

Informatica Developer
Project: ODS INTAKE /CCDR (CLINICAL CLAIMS DATA Repository) and prod support.
CIGNA provides customers with employee benefits, expertise and services that improve the health
well being and productivity of their employees. CIGNA is one of only a few health benefits companies
with comprehensive portfolio of health, pharmacy, behavioural, dental, disability, life, accident,
International businesses. The purpose of this project is to create a repository which holds both clinical
and non-clinical information of the member - Member Centric Database and Tier 1 prod support. The
data sources are Health care Economics (HCE),TBP, and CIGNA behavioural Health (CBH) and ODS, and
Providing technical support and enhancements to mission critical applications and new applications.
Responsibilities:
 Analyse the business requirements and framing the Business Logic for the ETL Process and maintained the
ETL process using Informatica Power Center.
 Created complex Informatica mappings to load the data mart and monitored them. The mappings involved
extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and
Sequence generator.
 Responsible for definition, development and testing of processes/programs necessary to extract data from
operational database and syndicated File System IMS and, SWIFT, HL 7 and EDI-X12 flat files. Worked
extensively with HL7 Data, EDI X12 Messages, HIPAA Transactions, ICD Codes.
 Responsible for the design of mapping and delivering the Business data for the data warehouse from
existing data sources.
 Worked with HIPAA Transactions and EDI transaction sets (834, 835, 837, 824, 820, 270, 276, 271, 278)
 Work on SQL coding for overriding for generated SQL query in Informatica.
 Involve in Unit testing for the validity of the data from different data sources.
 Extensively used Informatica to load data from various Data Sources like Flat files, Oracle, SQL Server, into
the Enterprise Data Warehouse.
 Design and develop PL/SQL packages, stored procedure, tables, views, indexes and functions.
 Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
 Involve in migrating the ETL application from development environment to testing environment.
Perform data validation in the target tables using complex SQLs to make sure all the modules are integrated
correctly. Create workflows and work lets for Informatica Mappings.
 Involved in Unit testing and system integration testing (SIT) of the projects.
 Assist the team members with the mappings developed as part of knowledge transfer.
Environment: Informatica Power Center 8x, Windows Server 2008, Data Warehouse, Oracle, MS-SQL
Server2005, Batch Scripting, Perl Scripting, XML Targets, Flat Files,), UNIX..

Standard &Poor’s, NYC Aug 2011 - Dec 2013

Informatica Developer
Project: "Rating request online"
(Standard & Poor’s is a diversified financial service company that provides a broad range of banking, asset
management, wealth management, and corporate and investment banking products and services.
Corporate Repository or Core is the primary data source from which data is fetched to load into various
databases that support various products. The ratings repository data warehouse is the target from which
various reports are generated. The Data Services department deals with the data conversion and data
masking/data encryption, extraction, transformation and loading of data and data modelling from the Core
(Corporate Repository) to the RRDW (Ratings Reporting Data Warehouse) and maintains all the data
involved in the process.
Responsibilities:
 Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
 Created source-to-target mappings for loading data warehouse/data marts and Created the mappings using
transformations Filter, Expression, Aggregator, Sorter, Lookup, and Update Strategy.

Environment: Informatica Power Center 8x, Oracle, SQL Server, Windows, UNIX, UNIX Shell Script.