Informatica ETL Developer Resume

SUMMARY:

I have 3 years of Informatica experience in the designing and implementing of Data Warehousing and Data Integration including Data gathering, Analysis, Design, Development, Testing and Production experience. Extensively used ETL processes to load data from various source systems such as Oracle, Flat Files, XML files into target system by applying business logic on transformation mapping for inserting and updating records when loaded. Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, Data modeling experience using Normalization, FACT & Dimensions tables, Physical & logical database design and modelling.

SKILL:

SQL
Informatica 10.2
Data Warehouse
Data Extraction
Data Integration
Oracle
Data migration
Data Manipulation
Information/Data Security
Data Management
Data Analysis
ETL

EXPERIENCE:

Confidential

Informatica ETL Developer

Responsibilities:

Engage with implementation partners in application testing, release management, and operations to ensure quality of code development, deployment and post - production support.
Collaborate with our Data Warehousing peers, and other stakeholders to further expand and develop the Enterprise Data Warehouse platform.
Co-ordinate Joint Application Development sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
Optimize the source queries in order to control the temp space and added delay intervals depending upon the business requirement for performance.
Create sessions, batches for incremental load into staging tables and scheduling them to run successfully daily.
Using indexing and caching to Improve performance of the ETL.
Modify existing mappings for enhancements of new business requirements.
Manages the end-to-end lifecycle for new data migration, data integration, and data services for Customer Insight dashboards.
Using Workflow manager and Workflow monitor to create and monitor workflows.
Uses debugger to identify bugs in existing mappings by analyzing data flow and evaluating transformations.
Design and Development of ETL routines, using Informatica PowerCenter within the Informatica Mappings, usage of Lookups, Ranking, Stored procedures, functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers.
Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
Develop complex Informatica Mappings, Sessions, and Workflows using Informatica Mapping Designer, Workflow Manager respectively.
Provide documentation on Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc. for all projects.
Experience in monitoring, resolving priority-based issues, and reporting to management on Daily, weekly Monthly processes.
Develop technical specifications of the ETL process flow while Analyzing computed statistics that improves response time for queries.
Design and develops various ETL / SQL stored procedures performing various calculations related to fact measures.
Develop mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading, and unit tested the mappings.
Use various transformations like Router, Filter, connected and unconnected lookups, Aggregations, Expressions, Joiners Unions to develop robust Mappings in Informatica designer.
Prepare document for Root Cause Analysis (RCA) that resulted in increased solutions.
Maintains source and target mappings, transformation logic and processes reflecting the changing business environment over time.

Confidential

SQL Developer

Responsibilities:

SQL Query Performance Tuning, System Performance Analysis, analyzing the Query Execution Plans, used SQL Profiler for optimizing the stored procedure.
Used partitioning and sub partitioning of tables to improve performance providing database coding to support business applications.
Use various transformation components in the data flow task to implement business logic to merge data from different sources.
Address the Replication Issues. Created new replications, implemented Mirroring to maintain high availability of the data between the servers.
Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
Performed performance tuning and optimized the run time.
Develops SQL queries using various joins and develops various dynamic SQL’s throughout the projects
Work with commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in a set of logic.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship