![]() ![]() ![]() Worked with business analysts to identify appropriate sources for data warehouse and documented business rules, functional and technical designs, test cases, and user guides. As part of the migration exercise the data ingestion pipeline was set up to onboard data on Reltio platform and consume the mastered data back for downstream usage. Genentech, South San Fransisco, CA March-2020 – Till dateĮnvironment: Informatica Power Center 10.2, sqlserver 2014, Unix, Redwood, JiraĪs part of the EPICX project, the aim was to migrate all the payer sources from the Informatica MDM ecosystem to the Reltio MDM ecosystem. SQL * loader, Quest Toad, Quality Center, Putty Oracle 10g/9i/8i, MS SQL Server 12, MS Access 7.0/2000, MySQL Scala, python, Unix Shell Scripting, SQL, PL/SQL Informatica Power Center 9x/8x, Informatica Developer, PG Diploma in Advance Computing from C-DAC, ACTS, Pune, India.īachelor of Computer Application, Sambalpur University, India. Strong Experience in designing and developing complex mappings using various transformations for implementing advanced ETL techniques such as slowly changing dimension, change data capture and incremental loading.Įxpertise in defining Workflows and Tasks, Monitoring Sessions, load scheduling and automation of Informatica workflows using shell scripting.Įxperience in performance tuning of ETL Mappings involving ETL Sources, Targets, Transformations, stored procedure and Sessions.Įxperience in upgrading Informatica Repository, making related changes to existing models, mappings to resolve upgrade issues and also responsible for Informatica server administration.Įxpertise in working on the releases, providing production, technical and onsite release support.Įxcellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels. Strong expertise in design, development and integration of complex ETL processes.Įxperience with databases like Oracle, SQL Server and My SQL and excellent in writing, testing and implementation of triggers, stored procedures, functions, packages, dimensional loading of tickets using PL/SQL. Informatica certified developer (version 8.6)ĭata modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.Įxperience in user interaction to gather and analyze the project requirements. Experience working in Healthcare, Pharmaceuticals and Retail sector.Įxpert level experience in implementing advanced ETL methodologies for corporate wide – ETL solution using Informatica Power Center 10.2,9.5.1 9.0.1/8.6/7.x. About **+ years of it experience in Analysis, Design, Development, Maintenance and Documentation for Data warehouse and related applications using ETL, BI tools, Client/Server and Web applications on UNIX and Windows platforms. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |