ETL Infomatica developer
Resume:
Shiva Satya Srinivas
ETL Informatica Developer
**********@*****.***
Professional Summary:
Having 8.7 years of Software Development Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data warehouse Applications.
Experience in ETL/Informatica Power Center and Data integration, Experience in developing ETL mappings using Informatica Power Center10.x/9.x/8. x.
Having experience in designing, Implementation of Data warehousing and Business Intelligence solutions using ETL tools like Informatica Power Center, Informatica Developer (IDQ), Informatica Power Exchange and Informatica Intelligent Cloud Services (IICS).
Creating Mappings, Replication tasks and Synchronization tasks in IICS.
Effectively using IICS Data integration console to create mapping templates to bring data into staging layer from different source systems like SQL Server, Oracle, Flat Files, and Excel Files.
Experience working with IICS transformations like Expression, joiner, union, lookup, sorter, filter, normalizer, and various concepts like macro fields to templatize column logic, smart match fields, renaming bulk fields and more.
Experience working with Custom Built Query to load dimensions and Facts in IICS.
Having clear understanding of Data Warehousing and BI concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snowflake Schema).
Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data staging for operational sources using ETL and data mining features for Data warehouses.
Good understanding of relational database management systems like Oracle, DB2, SQL Server and worked on Data integration using Informatica for the Extraction transformation and loading of data from various database source systems.
Extensively created Mapplets, common functions, reusable transformations, look-ups for better usability.
Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
Experience in UNIX shell scripting, job scheduling and server communication.
Involved in Unit testing, System testing to check whether the data loads into target are accurate.
Extensive database experience and good working experience in SQL Server, Oracle, DB2, Sybase, XML Files, Flat Files, and MS Access.
Excellent communication skills and result-oriented with minimum supervision, problem solving skills and team player.
Technical skills
ETL Tools and databases: Informatica 10.4/10.2/9.6/9.1, IICS, SSIS, Oracle, IBM-DB2, MS SQL Server
Data modeling & Other Tools: Erwin, Toad, SQL Developer, Crystal Reports, SQL Assistant
Programming Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting
Job scheduling: Autosys, Tidal, Control-M, MJS
Environment: MS Windows 2012/2008/2005, UNIX
Professional Experience
Client: Anthem, Remote Jan 2022 – Present
Role: ETL/Informatica Developer
Responsibilities:
Responsible for business analysis and requirements collection.
Worked on Informatica Power Center tools - Designer, Repository manager, Workflow manager, and Workflow Monitor.
Desired and customized data models for date warehouse supporting data from multiple sources on real time.
Involved in building the ETL architecture and source to target mappings to load data into Data warehouse.
Creating mapping documents to outline data flow from sources to targets.
Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
Maintained store definitions transformation rules and targets definition using informatics repository manager.
Worked on ETL production sundown activity for legacy workflows
Worked on workflows, sessions, mappings, source, and target objects by checking dependency of each object
Collaborated with business on ETL clean-up and purge activities by querying audit tables
Involved in Performance tuning at source, target mappings, sessions, and system levels
Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
Environment: Informatica Power Center 10.4, Oracle 12C, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel, Putty, CONTROL-M
Client: Cigna, Bloomfield, Connecticut Mar 2020 – Dec 2021
Role: ETL/Informatica Developer
Responsibilities:
Experience working with Informatica IICS tool effectively using it for Data integration and Data Migration from multiple source systems.
Migrating all the mappings from Power Center to IICS.
Experience working with IICS concepts relating to data integration, Monitor, Administrator, schedules.
Created Good experience in designing, Implementation of Data warehousing and Business Intelligence solutions using ETL tools like Informatica Power Center, Informatica Developer (IDQ), Informatica Power Exchange and Informatica Intelligent Cloud Services (IICS).
Experience working with IICS concepts relating to data integration, Monitor, Administrator, deployments, permissions, schedules.
Worked in different phases of the projects involving Requirements Gathering and Analysis, Design, Development, Testing, Deployment and Support.
Worked with wide variety of sources like Relational Databases, Flat Files, XML files, Mainframes, Salesforce Objects, Unstructured data files and Scheduling tools like Control-M and Informatica Scheduler.
Experience working with various Informatica concepts like partitioning, Performance tuning, identifying bottlenecks, deployment groups, Informatica Scheduler and more.
Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes), UNIX Shell scripting and Windows Batch scripting.
Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
Experience working with Custom Built Query to load dimensions and Facts in IICS.
Experience working with IICS monitoring, administrator concepts.
Experience working with Key Range Partitioning in IICS, handling File loads with concept of File list option, creating fixed with file format and more, file listener and more.
Experience integrating data using IICS for reporting needs.
Provided day to day Data warehouse support by debugging, maintaining, problem solving, data discrepancy resolutions and validation of procedures, implementing new strategies, daily schedule jobs or processes Actively worked and coordinated with team to develop quality code, meeting the deadlines and a daily standup meeting to clear off any roadblocks in development.
Environment: Informatica Power Center 10.4, Oracle 12C, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel, Putty, CONTROL-M
Client: Care Source, Dayton OH, Jan 2019 – Feb 2020
Role: ETL/Informatica Developer
Responsibilities:
Experienced in analyzing the sources, transforming, mapping, loading into targets using Informatica Power Center Designer.
Involved in creating new Informatica mappings, transition of PL/SQL packages to a new Informatica mappings or medication of existing mappings using Power Centre Designer.
Experienced in using Informatica for Data integration between source & Target which includes development of Joiner, Aggregator, Lookup, Expression, Update Strategy, Router and Sorter transformations.
Experience working with Informatica IICS tool effectively using it for Data integration and Data Migration from multiple source systems.
Experience working with IICS concepts relating to data integration, Monitor, Administrator, schedules.
Created Workflows and use various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the Workflow Manager and Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and rectify them.
Deployed PL-SQL packages to other environments with configurations such as XML and SQL table. Utilized PL-SQL packages on the production server with the help of DBA.
Scheduled ETL workflows for the parallel run comparison and batch jobs using Master Job Scheduler to run the workflows.
Involved in debugging and fixing the ETL processes (Extract, Transform & Load) while migrating data from legacy systems like Microsoft Access, Microsoft Excel into newer databases using Informatica Power Center.
Created SQL scripts to analyze historical data, extracted required data to support management decisions.
Created data sets and load pipelines to more data to Azure cloud based on business requirements.
Worked on loading data from Oracle onto Azure data storage using as your data factory.
Implement error handling in PL-SQL packages with check points, and loggings to debug issues in the business processes.
Experienced in debugging PL-SQL packages with features such as exceptions, cursors, collections, triggers, and custom loggings.
Created Objects - Schemas, Tables, Indexes (clustered and non-clustered), Views, User defined functions (UDFs), Cursors, Triggers, Stored Procedure, Constraints and Roles for complex shared systems.
Involved in creating and monitoring Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
Used Informatica Transformation designer tasks such as Mappings and Mapplets to implement Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
Used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Workflow Manager for loading/retrieving data.
Involved in conducting Unit, Integration, User Acceptance testing for ETL/SQL/UNIX script codes and validate the data.
Document all associated mappings by creating Low Level Design documents and run books for Production Support which help ETL process flow for better maintenance and analyzing.
Environment: Informatica Power Center 10.1, Oracle 12C, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel, Putty, Control-M
Client: Team Health, Knoxville, Tennessee Dec 2017 – Dec 2018
Role: ETL/Informatica Developer
Responsibilities:
Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise Data warehouse.
Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Normalizer, Aggregator, Sequence Generator.
Created workflows and sessions for each mapping that we are extracting from source systems to staging area and from staging area to target.
Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
Responsibilities include creating the sessions and scheduling the sessions.
Translated Business specifications into PL/SQL code. Designed, Developed, and fine-tuned Oracle Stored Procedures and triggers.
Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
Prepared SQL Queries to validate the data in both source and target databases.
Designed and developed the ETL processes using Informatica to load data from Oracle, Flat files and XML files to target Oracle Data warehouse.
Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
Created Control-M jobs and scheduled them.
Supported during QA/UAT/PROD deployments and bug fixes.
Worked on creating the deployment groups for the code migration between the environments.
Environment: Informatica Power Center 10.1, Oracle 12C, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel, Putty, Control-M
Client: A3 IT Solutions, India Jun 2014 – Jul 2016
Role: ETL/Informatica Developer
Responsibilities:
Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
Developed rules and Mapplets that are commonly used in different mappings.
Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
Parsed high-level design specification to simple ETL coding and mapping standards.
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 and other RDBMS databases into staging area and populated onto Data warehouse.
Maintained Source definitions, transformation rules and targets definitions using Informatica repository Manager
Worked on Data Quality checks for data feeds and performance tuning.
Experience in scheduling of ETL jobs using Autosys.
Worked with the developers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project and fixed the defects before moving the jobs into production.
Extensive knowledge in promoting code across Development, test, preproduction, and production environments following the standards.
Interacting with Product manager and Data quality analyst for gathering the business report requirements and various cross departmental users for the report requirements, clarifications, and tableau end user report trainings
Developed UNIX Shell scripts to archive files after extracting and loading data to Warehouse.
Written UNIX shell scripts to automate manual tasks.
Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
Environment: Informatica Power Center 9.6, Oracle 11g, UNIX, PL/SQL, IDQ, SQL* PLUS, TOAD, Tableau, MS Excel
Client: Smart Software Tech. Dev. Pvt. Ltd., India Jun 2012 – May 2014
Role: Informatica Developer
Responsibilities:
Effective Communication with data architects, designers, application developers and senior management to collaborate on projects that involve multiple teams in a vitally time-sensitive environment.
Effectively involved in allocation & review of various development activities / task with onshore counter apart.
Understanding the business logic behind every piece of code and documenting requirements in a reverse engineering fashion
Optimized Query Performance, Session Performance and Reliability, did performance tuning of Informatica components for daily and monthly incremental loading tables.
Designed ETL process to translate the business requirements into Mappings using Informatica Power Center - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager/Monitor.
Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Workflow Manager.
Used Workflow Manager for creating validating, testing, and running sequential batches.
Involved in design, development, and implementation of the Enterprise Data warehouse (EDW) and Data Mart.
Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
Designed mappings using Source qualifier, Joiner, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy transformations and Mapplets load data into the target involving slowly changing dimensions.
Used Workflow Manager for creating and maintaining the Sessions and Workflow Monitor to monitor workflows.
Enhanced existing UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
Carried out unit and integration testing for Informatica mappings, sessions, and workflows.
Used Autosys as a scheduling tool for triggering jobs.
Using Perforce as a versioning tool for maintaining revision history for code.
Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.
Environment: Informatica Power Center 9.x, Oracle10g/9i, MS SQL server 2005, Business Objects, Autosys, Toad 7.6, SQL, PL/SQL, UNIX Shell Scripting, Windows.
Education Details:
Bachelors in Electronics and Communications Engineering from Gitam University.
Masters in Computer Science Engineering from Campbellsville University, KY.
Contact this candidate