DEEPIKA SANKURU

Mobile : 314-***-**** Email : ad2bb0@r.postjobfree.com

Summary:

•12+ years of Strong experience in all phases of Design, Development, Implementation, and support of Data warehousing applications using Informatica Power Center10.x,9.x& 8.x, Informatica Power Exchange 10.x, IICS Data Integration (CDI) and IICS Realtime Application Integration (CAI).

•Full life-cycle project delivery experience from product definition to implementation including requirements and specification writing, design documentation, unit and system testing, optimization and performance analysis and release into a production environment.

•Expertise knowledge in domains like Sales, Health Care, HR, Banking, Finance, Pharma, Manufacture Systems.

•Experience in IICS data integration components like Mapping, Transformations, Task and Task flow and Data synchronization, Replication and Dynamic Data task to integrate the data from various sources like Database (SQL Server, oracle, MySQL, HANA DB), Flat file, Salesforce, SAP to/from using informatica intelligent cloud services.

•Experience in IICS application integration components like processes, Service Connectors, Process objects, App Connectors and Email Configuration and Event based processes.

•Worked with standard and Application connectors like Salesforce, Hive, SAP Table Connector, Flat file, Database, Email, Rest V2, Salesforce OAuth2 connectors to integrating the data from different source systems to applications and applications to Databases.

•Experience in invoking the APIs and creating the jobs to perform operations like (GET, POST, DELETE and PUT) though CDI and CAI methods based on the authentications provided.

•Experience in using Azure board and storing Informatica code into GitHub Repository, Build and Release the pipelines to migrate the code from all phases (DEV, QA, and PROD) of Project.

•Experience in implementing the business rules by creating transformations like (Expression, Aggregate, Lookup, Router, Rank, Update Strategy) and developing Mapplets and Mappings. Worked with different data sources like Flat Files and Relational Databases. Good Knowledge of Data Warehousing Concepts.

•Strong in using workflow tasks like Session, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-session, and Pre/Post commands.

•Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using SCD (Type1/Type2/Type3) loads.

•Well acquainted with session partitioning and Performance Tuning of sources, targets, mapping, and sessions to overcome the bottlenecks in mappings. Trouble shooting and problem-solving applications with Informatica Debugger.

•Excellent experience in understanding and following coding standards, business norms and handover, and takeover of responsibilities.

•Experienced in Data modeling (Dimensional & Relational) Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

•Experienced in data integration with informatica power center, power exchange and informatica cloud IICS with Salesforce, RMQ, SAP S4, relational DBs (SQL Server, oracle, MySQL, HANA DB), Flat files, and service central, Jira.

•Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.

•Experience in writing bat scripts using Unix and windows commands.

Work Experience:

Worked as a ETL Lead Developer from Dec'11 to Nov’21

Working as IICS ETL Developer from Nov’21 to till now.

Technical Expertise:

Data Warehousing/ETL: Informatica Power Center 9.X /10.x, Informatica Power Exchange, IICS (Data Integration (CDI), Application Integration (CAI))

Databases: Teradata, Microsoft SQL Server, Oracle 9i/10g/11g, My SQL, Snowflake, Hive.

Programming Languages: SQL, Batch scripts

Domain: Banking, Manufacturing, HR (workforce Management), Supply chain, Engineering (Jira), Sales.

IDE: SQL plus, PL/SQL Developer, Toad, SQL* Loader, SSMS, Win SCP, POSTMAN, Salesforce.

Platforms: Windows XP/Vista/7, UNIX, MS-DOS, and Linux.

Scheduling Tools: Redwood, Control-M, UC4, Autosys.

Version Control: GitHub, Informatica PowerCenter.

Application Packages: Familiarity with application and data model of SAP (ECC, CRM, HCM, APO, BPO, BW models, SQL* loader, Database import and Export.

Quality Management: JIRA

Incident/Log Tracking: Service Now.

Qualifications:

Master of Technology from JNTU, India.

Bachelor of Technology from JNTU, India.

Project Summary:

Project # 1:

Project: CLOS Project (Commercial Loan Origination System)

Client AgFirst Farm Credit Bank, USA Nov’21 – Till now

Role: IICS ETL Developer

The Commercial Loan Origination System (CLOS) has revolutionized the way financial institutions process and manage loan applications. With its advanced capabilities and intuitive interface, CLOS software is now a must-have tool for lenders looking to optimize their lending operations and enhance their Request for Proposal (RFP) responses. We will explore the various features and benefits of CLOS software and how it can help lenders effectively respond to RFPs and win more business.

Roles and Responsibilities:

Understanding the business rules from the functional specifications and converting them into technical documents to implement the ETL packages.

Created Standard OAuth and Application OAuth connections for various salesforce organizations.

Extracted the raw data from Microsoft Dynamics CRM to staging tables and loaded the data to the salesforce objects using Standard and Bulk API techniques using Informatica Cloud.

Hands on experience to feed the data to the multiple salesforce application objects like (customer, loan collaterals) based on the order of hierarchy using SCD1 techniques.

Developed the audit activity for all the cloud mappings and automated the validation reports on the daily basis and Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.

Implemented restart mechanism if any connection time out and dead lock failures in the task.

Created pipelines to migrate the code from DEV/QA/PROD environments.

Created the swagger files for Rest v2 connection to post and get the data from APIs to database.

Created the processes, sub-processes and Process objects and event-based processes, reusable service connectors and app Connectors to integrate the salesforce application.

Created the task flows to the post the data as batch using looping concept in cloud data integration to get back the data from SFDC objects.

Project # 2:

Project: IICS Integration

Infosys

Client Advanced Micro Devices (AMD), USA Jun’21 – Nov’21

Role: Sr ETL Developer

Worked as an Sr ETL Developer in EDW space and delivered critical projects.

Managing end to end development and operations for an EDW of size approx. 12TB,1250 daily Jobs,250 reports and 1250 users.

Have delivered critical projects related to salesforce integration (using SOAP) with EDW using informatica cloud (IICS). The data is kept as daily snapshots in EDW and published to users using SSAS cubes enabling analytics related to sales forecasting to top leadership team (CXO level). The project also included master data push from EDW to SFDC using IICS.

Have worked on integration of SAP modules with EDW using Informatica Power Exchange to acquire critical billing, revenue, backlog datasets in EDW and build BI solutions on top of it to enable integrated view of these datasets. Data is published to users using MS cube and reports.

Have delivered Workforce Analytics by acquiring workforce data sets from SAP HRM and performance data from Success Factor and build Datawarehouse and BI solution for HR business group - includes weekly snapshot of workforce data, employee status change, global headcount summary, weekly recruitment snapshot, employee performance reports.

Have worked in 3rd party (timesheet data) tool application integration with EDW using Informatica cloud (IICS) using REST API. The data project also included integration of employee information data to be pushed from EDW to the 3rd party tool.

worked on near real-time Integration of SAP HANA with EDW using Informatica 10.2 in finance subject area.

Responsibilities:

• End to end delivery and operations responsibility of all EDW projects and enhancements.

• Lead EDW operations – projects, enhancements, daily production support, EDW Data integrity, Informatica and database health check and improve performance

• Managing the Infosys EDW team- a team of 15 professionals including ETL engineers.

• In-Depth knowledge of different ERP systems developed data acquisition using Informatica: SAP ECC, CRM, HRM, APO, BPC, BW module, SAP HANA, salesforce, Success Factor, JIRA, Agile PLM, Service Central.

Project #3

Project: Agile Product Implementation

Infosys Oct’17 – Jun’21

Client: AMD (Advanced Micro Devices), India.

Role: Sr.ETL Informatica Developer

Roles and Responsibilities:

Understanding business rules and sourcing data from multiple source systems.

Extracted the raw data from Microsoft Dynamics CRM to staging tables using Informatica Cloud.

Developed Cloud mappings to extract the data for different regions (APAC, China, and America).

Refreshing the mappings for any changes/additions to CRM source attributes.

Developed the audit activity for all the cloud mappings.

Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.

Generated automated stats with the staging loads comparing with the present day counts to the previous day counts.

Created File watcher jobs to setup the dependency between Cloud and PowerCenter jobs.

Created and developed mappings to load the data from staging tables to EDW Data Mart tables based on Source to Staging mapping design document.

Implemented Type1, Type2, Type 6 and Incremental load strategies.

Followed ETL standards - Audit activity, Job control tables and session validations.

Used Exceptional mappings to generate dynamic parameter files after the 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 the data after loading.

Experienced in integration of Confidential with external applications by using Restful API.

Maintained and automated the production database to retain the history backup tables to 30 days.

Developed/Automated (PowerCenter/IDQ/Cloud/Sales force) jobs through Redwood.

Environment: Informatica Cloud, Informatica PowerCenter 10.2, SQL Server,Teardata, Redwood.

Project # 4–

Project: HR Workforce Analytics:

Infosys Nov’13 – Sep ‘17

Client: AMD (Advanced Micro Devices), India

ETL Informatica Developer

Roles and 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 in real time.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Created mapping documents to outline data flow from sources to targets.

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions, and measured facts.

Extracted the data from the flat files (mdb, csv, txt, xml, amdx), Application restful API and other SAP, HANA, Oracle, SQL server and databases into staging area and populated onto Data warehouse.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, HTTP, SQL, lookup, Stored Procedure, and Union to develop robust mappings in Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Created mapplets to use them in different mappings.

Developed mappings to load into staging tables and then to Dimensions and Facts.

Used existing ETL standards to develop these mappings.

Extensively worked with Agile methodologies.

Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.

Created sessions, configured workflows to extract data from various sources, transformed data, and loaded it into data warehouse.

Used Type 1 SCD and Type 2 SCD, Type 6 hybrid mappings to update slowly Changing Dimension Tables.

Extensively used SSMS client to load data from flat files to the database tables in SQL server.

Modified existing mappings for enhancements of new business requirements.

Used Debugger to test the mappings and fixed the bugs.

Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.

Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Created the SAP R3 and Process mappings to get the data from SAP through Informatica Power exchange net weaver.

Good Knowledge in Redwood Monitoring tool.

Involved in the daily and weekly meetings with the users and actively lead meetings with Clients.

Coordinating with various other teams like SQL teams, VDI Admin teams, SAP teams and network teams.

Environment: Informatica PowerCenter 9.6, Flat files, XML files, Redwood, Informatica Power exchange SAP net weaver.

Project # 5 Feb’13 to Nov'13 Project: Amazon Finance Foundation and Enigma Reporting Suite

Client: Astra Zeneca

ETL Application Developer

Client Overview:

Astra Zeneca – A premier UK based Pharmaceutical Company. AstraZeneca is a global, innovation-driven, integrated Bio-pharmaceutical company. They discover, develop, manufacture and market prescription medicines for six important areas of healthcare, which include some of the world’s most serious illnesses: cancer, cardiovascular, gastrointestinal, infection, neuroscience, and respiratory and inflammation. They are active in over 100 countries with a growing presence in emerging markets including China, Brazil, India, and Russia. They employ over 62,000 people (47% in Europe, 31% in the Americas and 22% in Asia, Africa and Australasia). They invest over $4 billion in R&D each year and have over 11,000 people in their R&D organization.

Roles and Responsibilities:

Have been handling multiple applications as a primary from the start of the project.

Created mappings for populating the data into the dimension, facts, and history tables from the multiple sources system (central and local sources).

Monitoring, Tuning and Troubleshooting the ETL code.

Developed mappings by using different Transformations like Aggregator, Lookup, Expression, Update Strategy, Joiner, Router, Sequence Generator etc to load the data into target tables.

Worked extensively on Oracle database 10g as data sources.

Developed and fine-tuned the SQLs to improve performance.

Enhancements/modifications to the Unix shell scripts used for running the Informatica jobs

Performed integrated testing for various mappings.

Code review of code developed by my team.

Tested the data and data integrity among various sources and targets.

Adherence to process followed in the project.

Gathering requirements and understanding the issues of the business or stake holders.

Timely communication on the task to the Clients.

Involved in the daily and weekly meetings with the users and actively lead meetings with Clients.

Coordinating with various other teams like oracle dB team, Admins teams, DBAs, and network teams.

Environment: Informatica Power Center, SQL Server, Control M.

Project # 6

Project: Amazon Finance global Dec'11 to Feb'13

Client: AstraZeneca UK

ETL Solution Designer

Project overview:

Amazon finance Global is a suite of Finance reports with integration of various finance source systems maintained by customer (SAP/Hyperion). These source systems maintain customer’s sales, expenses, and headcount Information at different levels of grain. This is re-writing of Amazon foundation project on EDW platform with inclusion of additional regions. This Project is developed for users spread globally.

Roles and Responsibilities

•Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.

•Develop the mappings using needed Transformations in Informatica tool according to technical specifications.

•Created complex mappings that involved implementation of Business Logic to load data in to staging area.

•Used Informatica reusability at various levels of development.

•Developed mappings/sessions using Informatica Power Center 8.6 for data loading.

•Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter, and Union.

•Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

•Building Reports according to user Requirement.

•Extracted data from Oracle and SQL Server then used MSQL for data warehousing.

•Implemented slowly changing dimension methodology for accessing the full history of accounts.

•Optimizing performance tuning at source, target, mapping, and session level

•Participated in weekly status meetings and conducted internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica Power Center, Oracle 10g, Control M.

Contact this candidate