Home

SANDHYA - Informatica Developer / ETL -12

[email protected]

Location: Fort Worth, Texas, USA

Relocation: On Texas

Visa: H1B

Certified Informatica ETL consultant with over 12 years of experience in the IT industry with having been extensively involved in Analysis and Design, Testing, Implementation, Maintenance and Production Support of ETL projects. Experience in using Informatica PowerCenter with Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server Manager. Experience is in Banking, Healthcare domains in developing several complex mappings in Informatica, a variety of PowerCenter transformations, Mapping Variables & Parameter files in Mapping Designer using Informatica PowerCenter. Proven experience with ETL the development, and implementation of Large-scale, Enterprise Data Warehouse and Reporting Solutions. Hands on experience in IICS informatica Cloud using CAI (Cloud Application Integration) and CDI (Cloud Data Integration). Experience in Informatica Cloud Integration platform as a service (iPaaS) solutions including Data Integration, Cloud Data Quality, Data Catalog, Data governance and CDC. Experience in all phases of development including Extraction, Transformation and Loading data from various Sources into Data warehouse and data Marts using Informatica cloud IICS and Power center (Repository Manager, Designer, Workflow Manager and Workflow Monitor). Involved in Extracting, Scrubbing, and Transforming data from various sources like Oracle, SQL Server, DB2, Teradata, and Flat files and loading the data into Oracle database using Informatica. Slowly Changing Dimensions Management including Type 1, 2, 3, De-normalization, Cleansing, Conversion, Aggregation, Performance Optimization. Design Source to Target Maps, Code Migration, Version Control, Scheduling Tools, Auditing, Shared Folders, Data Movement, and Naming in accordance with ETL Best Practices, Standards and Procedures. Responsibilities include scheduling and managing the deliverables and activities like UAT and coordinating with other groups like Data center, Production/ Change Management to implement various releases. Involved in Quality Assurance, Bug Fixing and Testing. Prepared user manuals and presentations. Strong Troubleshooting, Problem Solving, Analytical and Design skills. Experience in Dimensional Data Modeling using Star and Snowflake Schema. Extensively worked on ETL Informatica Transformations effectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings. Experience in integration of data sources like Oracle, SQL Server, and Flat Files. Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, Triggers. Automated and scheduled the Informatica jobs using UNIX Shell Scripting. Keywords: information technology procedural language Delaware