Manjula Nagamalla

SR ETL/IICS INFORMATICA DEVELOPER

Mail: ad3834@r.postjobfree.com Ph: +1-510-***-****

PROFESSIONAL SUMMARY

Extremely skilled In ETL development with over 7 years of experience in all phases of Analysis, Design, Development, testing, and support of Data Warehouse/Data Mart applications using Informatica Power center, Oracle, SQL server, UNIX, and Windows platforms.

Extensive experience in developing ETL mappings, scripts, and data integration using Informatica PowerCenter and IICS (Cloud Data Integration).

●Developed complex mappings using Informatica Power Centre Designer to transform and load data using robust Informatica mappings and fine tunings to process millions of input records with estimated throughput.

●Implemented performance tuning in Informatica Mappings by identifying the bottlenecks and implemented effective transformation Logic.

●Developed Stored Procedures and invoked the same through Power Centre Stored Procedure Transformation.

●Created various Oracle database objects like Indexes, stored procedures, Materialized views, synonyms, and functions for Data Import/Export.

●Gathered requirements of the existing business processes using AGILE Development strategies and developed mappings. Analysed business processes and gathered core business requirements reporting any functional gaps in existing applications and suggested business process improvement.

●Worked on various types of SCDs and mostly working on SCD Type 2 to maintain History of transactions.

●Supported ETL routines required for populating the Data Warehouse for high-volume data, Tuning, and troubleshooting mapping.

●Developed Complex Oracle database objects like Stored Procedures, Functions, Packages, and Triggers using SQL.

●Created, launched & scheduled tasks/sessions at the required frequency using PowerCenter and configured email notification for session status.

●Migrating the database in toad oracle to clous schemas and extensively used SQL queries for the same.

●Ran more than 20 interfaces in putty successfully and fixed the issues, complex errors for building the interface through WinSCP.

●Developed Mappings in IICS and migrated many interfaces mapping from PowerCenter, created task flows and mapping tasks successfully.

●Created unit test plans, testing strategies, & Integration test plans, and Unit and System Integration test scripts.

●Created Indexes, Aggregate tables and implemented Cache to tackle performance issues.

●Developed complex Power Centre mappings by using different transformations and components respectively to meet the data integration and data quality requirements.

SKILL CHART

Operating Systems

Windows/Linux/Unix

ETL TOOLS

Informatica PowerCenter 10.2/9.6

Informatica Intelligence Cloud Services (IICS)

DATABASES

Oracle DB/ MS SQL

LANGUAGES

MYSQL

SCHEDULING TOOLS

Autosys

EDUCATION:

Master of commerce Osmania University 2001

Bachelor of Commerce Osmania University 1999

PROFESSIONAL EXPERIENCE:

Sogeti (Client: MEDICA) (Domine: Insurance) Minnesota Apr 2023 to Present

(Sr ETL Informatica Developer)

Description: The goal of the project is to provide an enhanced data load process and reporting capabilities for the selected Business Users for the Provider Data group repository. The components within Informatica Power Center aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.

Responsibilities:

Implemented ETL applications for Medica insurance Sales, and Claims modules.

Implemented SCD type1 and type2 mappings.

Used joiner transformation to join datasets.

Used filter transformation.

Implemented Query overrides in Source definition.

Used aggregator transformation to perform aggregations.

Used surrogate key transformation to generate the next surrogate key in target tables.

Designed a common TMP table to use multiple mappings to consume the same set of source tables, to improve the overall load times.

Wrote complex SQL for SQ override.

Developed Complex mappings with transformations like Sorter, Joiner, Router, Expression, Update strategy, Lookup and mapplets.

Worked extensively in Microsoft Excel for creating STM documents which helped in building technical document of an interface.

Defined work plans in alignment with stakeholder requirements.

Worked to support the senior creative staff with day-to-day tasks.

Utilized crucial design software skills to assist with projects.

Sogeti (Client: American Dental Association) Chicago, IL April 2022 – March 2023

Sr. Data Engineer (Informatica/IICS Developer)

Description: ADA decided to enhance its data warehouse & ETL integration process to the cloud platform along with reporting needs, Designed and implemented cloud transformations, the project involves migration of PowerCenter code into IICS, New subject areas ETL also included as part of this program to integrate with Salesforce, Experience in preparing the High-Level Design Document and Low-level design documents for mapping.

Responsibilities:

Developed mappings using Designer, Created Tasks, Sessions, and Workflows using Workflow Manager and Workflow Monitor to monitor the workflows.

Involved in Unit Testing, preparing the test cases. Involved in code reviews before delivery.

Worked on Power Center client tools like Source Analyzer, Warehousing Designer, Transformations.

Developer, Mapplet Designer and Mapping Designer.

Used transformations such as Source Qualifier, Expression, lookups, Router, Aggregator, Joiner, Update Strategy, Filter, Sequence Generator, and Sorter transformations for developing complex mappings.

Worked with Different Databases like Oracle 10g/11g, delimited files.

Worked extensively in a team-oriented environment with strong, analytical, interpersonal and communication skills.

Worked on various types of SCDs and mostly working on SCD Type 2 to maintain History of transactions.

Basic knowledge of working with UNIX operating system.

Implemented SCD Type 2, to enable customers to track the history.

Worked on transformations like Filter, Update strategy, Aggregator, Lookup etc.

Experience in Integration of various data sources into the staging area.

Worked on Reusable transformations mostly for lookup transformations for consistency and to optimize the development time.

Used Workflow manager for Workflow and Session Execution.

Imported data from various Sources transformed and loaded into Targets using Informatica.

Developing Informatica mappings and Involved in Unit Testing for developed mappings.

Documentation to describe program development, Logic, Coding, Testing, Changes, and corrections.

Maintain the root cause analysis & issues tracker sheet.

Performing analysis on scheduling jobs & resolving the fix within specified time by meeting SLA.

Monitoring the incident Management queue & take appropriate action.

Maintaining log files, screenshot, run statistics.

Worked on Connected and unconnected lookup transformations as needed.

Used PowerCenter workflow Monitor to execute and monitor the jobs.

Used PowerCenter Repository Manager to export & import the Informatica Objects.

Developed and executed the Unit Test Cases.

Designed and implemented Shared Container jobs.

Involved in the preparation of various documents such as Source-To-Target Data mappings as per the input documents and updating the Query log.

Developed Informatica Mappings to extract, transform and load the data from source to target.

Create Parallel and Sequential workflows to optimize the total time.

Environment: Informatica Power Centre, Informatica Intelligence Cloud Services (IICS), Analyst, Snowflake, Oracle, WinSCP

Optum Government solutions Richmond, VA Feb 2021 – Mar 2022

ETL / Informatica Developer (Power Centre, IICS)

Description: Working on a project where Optum is embarked to build a Medicaid Enterprise Data warehouse (EDWS) for operational reporting for DMAS. One of the core goals of the project is to provide claims and payment efficiency, revenue management, risk, and quality integration for the Virginia state government. Optum has also worked on processing professional, pharmaceutical, institutional, behavioural, and dental claims &minting electronic records, and transactions.

Responsibilities:

•Experience in preparing High-Level Design Documents and Low-Level design documents for mapping.

•Strong skills in using Informatica Power Center client tools, Metadata Manager, Informatica Analyst, Administration and Maintenance of Adding users, assigning rights to users moving objects from folder to folder using Repository Manager.

•Developed change data capture mappings for capturing the history data.

•Extensively Worked on Data warehousing with Data Marts, ODS, Data Cleansing, and ETL tool Informatica.

•Worked with heterogeneous data sources like Oracle, XML, Flat Files, VSAM, AS400, and Relational Databases.

•Worked with IICS to create various ETL objects as part of Modernization DWH.

•Proficient in using workflow tasks like Session, Control, Event wait, command tasks, Decision tasks, Email tasks, pre-sessions, and post-sessions by using pre-SQL and post-SQL.

•Extensively worked on Informatica Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, and Workflow Manager.

•Extensively Used IICS – Data Synchronization, Data Acquisition, Mapping Tasks, Task Flow.

•Created various connections using Connectors for development in IICS Administrator.

•Implemented Slowly Changing Dimensions Type-1, Type-2 approach for loading the target tables.

•Implemented Full Informatica Push Down Optimization (PDO) (source &target) for better load performance.

•Strong knowledge in creating SET and Multi-set tables, stored procedure, Index, Views, and Data marts.

•Used IICS to pull data from Snowflake Stage DB to Reporting DB.

•Extracted data from various sources and loaded them to snowflake using IICS.

•Experience integrating data using IICS for reporting needs.

•Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections, and relational connections.

•Extensively experienced in developing Business Glossary, Scorecards, Profiles, and business rules.

•Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Control-M.

Environment: Informatica Power Centre, Informatica Intelligence Cloud Services (IICS), Analyst, Snowflake, Oracle, WinSCP, Control-M

DaVita Medical Group Inc New York July 2019 – Dec 2020

ETL / Informatica Developer

Description: DaVita Medical Group Inc is part of DaVita Kidney Care. The scope of this project is to bring the data of CIM / CCMIS and build a new Data Warehouse – National Datawarehouse and Business Intelligence can pull the reports from SSRS / Cognos and create BI Reports.

Responsibilities:

Analyzed, designed, developed, implemented, and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Data Warehouse.

Created several mappings using various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner, and Expression.

Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.

Developed Conceptual Business Model, Logical Data Model, Physical Data Model, and Star-Schema design.

Researched operational data store (ODS) and Legacy systems to find qualified source data.

Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema), and maintenance.

Defined, designed, configured, and implemented a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, message queues, and spreadsheets) to Oracle 10g environment.

Worked on Informatica Power Centre 10.1 tools – Source Analyzer, Target designer, Mapping Designer, Mappings & Transformations.

Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (PowerCenter) tool.

Checked Sessions and error logs to troubleshoot problems and used a debugger for complex Problem troubleshooting.

Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.

Performed extensive debugging and performance tuning of mappings, sessions, and workflows including.

Environment: Informatica 9.6.1/10.1, SQL Server, SQL, Jira, Service Now, UNIX, Windows XP

Health Care Service Corporation (BCBS/HCSC) Richardson, TX Oct 2016 – June 2019

ETL Informatica Developer

Description: Health Care Service Corporation (HCSC) is the largest customer-owned health insurer in the nation and the fourth largest overall. Operating through our Blue Cross and Blue Shield Plans in Illinois, Montana, New Mexico, Oklahoma, and Texas.

The project is aimed at developing an integrated data mart application for Blue Cross Community Health Plans members who work with a care coordinator to help with health care needs and claims. And the main programs which help in processing these claims are Disease Management and care management which involves strategic plans, support, and solutions giving mainstream users the ability to access and analyze and help stakeholders to automate extract process for downline applications.

Responsibilities:

Actively involved in interacting with business users to record user requirements and Business Analysis.

Translated requirements into business rules & made recommendations for innovative IT solutions.

Outlined the complete process flow and documented the data conversion, integration, and load mechanisms to verify specifications for this project.

Created the design and technical specifications like ETL Specification, ETL mapping, LLD, test cases, scheduling dependency, etc. for the ETL process of the project.

Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.

Maintained warehouse metadata, naming standards, and warehouse standards in the ETL mapping.

Used Informatica as an ETL tool to create source/target definitions, mappings, and sessions to extract, transform and load data into staging tables from various sources.

Responsible for mapping and transforming existing feeds into new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.

Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.

Performance tuning of the process at the mapping level, session level, source level, and target level.

Created Workflow containing command, email, session, decision, and various tasks.

Created different parameter files and started sessions using these parameter files using the pmcmd command to change session parameters, mapping parameters, and variables at runtime.

Tuned the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of data loads.

Participated in weekly status meetings and conducted internal and external reviews as well as formal walkthroughs among various teams and documented the proceedings.

Environment: Informatica PowerCenter 10.2, Oracle, WinSCP, Notepad++, JIRA, Control-M

Contact this candidate