SRINIVAS

adcw7z@r.postjobfree.com 518-***-****

●Around 8 years of experience in IT Software Development Life cycle involved in Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in Manufacturing, Travel and Insurance domains.

●Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell-Scripts and SQL Loader scripts.

●Extensive experience in ETL/Informatica Power Center and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 10.1.1/9.x/8.x, IDQ 9.6.1/9.0.1/8.6, Power Mart 8.x/7.x and MDM(Master Data Management).

●Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.

●Experience in working with business analysts to identify and understand requirements and translated them into ETL code in Requirement Analysis phase.

●Experience in creating High Level Design and Detailed Design in the Design phase.

●Worked on IDQ/IDE tools for data profiling, data enrichment and standardization.

●Expertise in creating very detailed design documents and performing Proof of Concepts (POC).

●Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.

●Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.

●Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.

●Well versed in OLTP Data Modeling, Data warehousing concepts.

●Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).

●Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.

●Good understanding of Views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.

●Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.

●Experience in using Exception handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.

●Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

●Experienced in UNIX work environment, file transfers, job scheduling and error handling.

●Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

●Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).

●Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.

●Involved in Unit testing, System testing to check whether the data loads into target are accurate.

●Experience in support and knowledge transfer to the production team.

●Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.

●Experience working in Agile methodology and ability to manage change effectively.

●Responsible for Team Delivery and Participated in Design Reviews.

●Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas

Technical Summary:

ETL Tools

Informatica10.1.1/9.6/9.5/9.1/8.6.1(Power Center),IDQ 10.1/9.6.1/9.0.1/8.6, MDM 9.7.1, Informatica Cloud 10.1, DataStage 11.7

Data Modeling

Ralph Kimball Methodology, Bill Inman Methodology, Star Schema, Snow-Flake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization, SSAS Cubes

Databases

Oracle 12c/11g/10g/9i/8i/8.0/7.x, Teradata V2R12/V2R6, MS SQL Server 2014 DB2, MS Access 2000.

Others

Toad, SQL Navigator, Crystal Reports, TSA, SQL Developer

Environment

MS Windows 2010/2008/2005, LINUX, UNIX

Job Scheduling

Autosys, Control-M

Professional Experience:

ITS (State Of New York), Albany, NY Apr ’18 – Present

Role: Sr. Informatica ETL Developer

Responsibilities:

●Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

●Designing complex mapping to perform Extract/Transform/Load(ETL) of heterogeneous source applications including ORACLE and flat files using Informatica Power Center 9.10.1 HF2

●ETL lead developer for Master Data Management conversion from IBM INITIATE Master Data Service to Infosphere.

●Develop, implement and maintain ETL codes for creating monthly, quarterly and yearly file extracts from multiple patient source systems

●Coordinate with subject matter experts to analyze business requirements, develop technical specifications, and design ETL modules.

●Troubleshoot and diagnose issues related to Informatica Production MDM data loads and transformations.

●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 and other RDBMS databases into staging area and populated onto Data warehouse.

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

●Developed Informatica mappings to move data from stage to target tables.

●Wrote complex SQL queries on oracle tables to pull data for analysis purpose.

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

●Involved in implementing the Land Process of loading the Customer Data, Product Data Set into Informatica IDQ from various source systems.

●Configured, profiled and applied out of box data quality rules provided by the product and Customer Teams and helped them in understanding the process along with reference data

●Identified and eliminated duplicates in datasets thorough IDQ components.

●Integrated Informatica Data Quality (IDQ) with Informatica Power Center and Created POC data quality mappings in Informatica Data Quality tool and imported them into Informatica power center as mappings, mapplets

●Providing high quality detailed analysis, design and build processes to support specific projects with regard to Data Quality profiling and Data Quality rule coding

●Worked with technical/business analysts for Data Quality requirements, business analysis & project coordination

Environment: Informatica Power Center 10.1.1, Datastage 11.7, Informatica data Quality and MDM, PL/SQL, Oracle 12c, Erwin, Autosys, UNIX, SQL Developer, SFTP/FTP, Winscp, Putty.

John Deere, Moline, IL Jan ’16 – Mar’ 18

Role: Sr. Informatica ETL Developer

Responsibilities:

●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.

●Extracted the data from the flat files and other RDBMS 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, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

●Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.

●Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDM Data Hub and other data consumers.

●Developed MDM Hub Match and Merge rules Batch jobs and Batch groups.

●Created Queries Query Groups and packages in MDM Hub Console.

●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.

●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 loading into data warehouse.

●Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

●Involved in Analyzing / building Teradata EDW using Teradata ETL utilities and Informatica.

●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.

Environment: Informatica Power Center 9.6.1, Datastage 9.1, Informatica Power Connect / Power Exchange, IDQ 9.6.1,PL/SQL, MDM, Oracle 11g, SSAS Cubes, Erwin, Autosys, ERP, Ultra Edit, QL Server 2014, Sybase, UNIX AIX, Toad 9.0.

Truven Health, Denver, CO Sep ’14 – Dec ‘15

Role: Sr. Informatica ETL Developer

Responsibilities:

●Created analysis of source systems, business requirements and identification of business rules.

●Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.

●Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.

●Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.

●Documented Mapping and Transformation details, user requirements, implementation plan and schedule.

●Extensively used Autosys for Scheduling and monitoring.

●Designed and developed efficient Error Handling methods and implemented throughout the mappings.

● Responsible for Data quality analysis to determine cleansing requirements.

●Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.

●Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.

●Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design

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

●Responsible for team members' work assignment and tracking.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g/10g, DB2 7.1, UNIX(Sun Solaris5.8/AIX), Toad 10.0,SQL Developer 3.0, WinScp, Putty, SFTP/FTP, XML Editor, MS-Excel, Ms-Access.

Charter Communications - St. Louis -MO Dec ’13 - Aug ’14

Sr. Informatica ETL Developer

Responsibilities:

●Interacted with business analysts and translate business requirements in to technical specifications

●Using Informatica Designer, developed mappings to populate the data into target tables

●Used Source Analyzer and Target Designer to import the source and target database schemas and the mapping designer to map the sources to the targets

●Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows

●Developed complex mappings/session using Informatica power center for data loading

●Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval

●Extensively used aggregators, lookup, update strategy, router and joiner transformations

●Develop the mappings to validate the detail files with control files to load various sales data into the system

●Extensively used TOAD to analyze data and fix errors and develop

●Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes

●Developed UNIX shell scripts to automate repetitive database processes and maintained shell scripts for data conversion

●Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.

●Designed web intelligence reports for dimensional hierarchical data

●Created web reports through report template in Web Application Designer.

●Created dictionaries using Informatica Data Quality (IDQ) that was used to cleanse and standardized Data. Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.

●Extensively used IDQ which helped in debugging and also reducing development time.

●Used Match and Consolidator transformation in IDQ which helped in reducing the duplicates.

●Created several session and workflows in IDQ which we deployed in Power Center.

●Extracted data from SAP R/3 and loaded into Oracle Data Warehouse.

●Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.

●Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.

●Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.

●Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.

Environment: Informatica Power Center 9.5, IDQ 9.6.1, IDQ 8.6, MDM 9.7.1, Oracle 11g, Business objects, Power Exchange, Flat files, MS SQL server 2012, DB2 8.0, Winscp, Control-M, MS. Visio, Shell Script, UNIX.

Northwestern Mutual Milwaukee, WI May ’12 – Dec ’13

Sr. ETL/Informatica Developer

Northwestern Mutual is a mutual company that offers financial services, including life insurance, long-term care insurance, insurance annuities, mutual funds and employee benefit services. Northwestern Mutual also provides consultation on asset and income protection, personal needs, investments, financial planning, estate planning, trusts, business needs, retirement, and employee benefits.

Responsibilities:

●Created detailed Technical specifications for the ETL processes.

●Performed ILIT (Irrevocable Life Insurance Trust) implementation and replacement activities.

●Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.

●Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.

●Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.

●Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.

●Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.

●Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.

●Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.

●Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.

●Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance

●Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.

●Fixing and tracking mapping defects and implementing with enhancements.

●Managing post production issues and delivering task/projects within specific timeline.

●Involved in the mirroring of the staging environment to production.

●Worked on Modification of Actuate report to upload and run reports on servers.

●Worked on Autosys to schedule jobs, define dependencies and etc.

●Collaborated with teams for migration and Production Deployment activities.

●Scheduling Informatica jobs and implementing dependencies if necessary using Tidal Scheduler.

●Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.

●Played a Vital role in requirement gathering, preparation of engineering gathering requirement specification.

●Using Perforce as a versioning tool for maintaining revision history for code.

●Managed production issues and delivered all assignments/projects within specified time lines.

●Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.

Environment: Informatica Power Center 8.1 IBM UDB DB2, SQL server 2008, Oracle, doc Loader, Embarcadero Rapid SQL 7.7.1, Autosys, Text Exceed 14, UNIX.

Contact this candidate