We provide IT Staff Augmentation Services!

Sr. Informatica Etl Developer Resume

2.00/5 (Submit Your Rating)

Armonk New, YorK

SUMMARY:

  • Having 8+ years of Professional Experience in analysis, design, development, implementation and Testing (troubleshooting) of Data Mart / Data Warehouse applications using ETL Tools like Informatica power center 9.x/8.x, OLTP and OLAP using Data Extraction, Data Transformation, Data Loading and Data Analysis.
  • Experience in Data Modeling, Data Warehouse, ETL Design Development, Ralph Kimball models with Star/Snowflake schema designs, Analysis Definition, Database Design, Testing, Implementation and Quality process.
  • Expertise in Installing and managing Informatica Power Center, Metadata Manager, Data Explorer and Data Quality.
  • Strong knowledge in Informatica Administration including Installation and up gradation, Configuration, Maintenance and Troubleshooting.
  • Strong experience in installation of Informatica on UNIX, Migration of Repositories, and up gradation of Repositories.
  • Extensively worked on Informatica tools Admin console, Repository manager, designer, Workflow manager, Workflow monitor.
  • Strong Experience in writing queries to access Informatica Repository DB.
  • Strong experience as Support for UAT, production, deployment, Informatica object Migration using Repository Manager and monitoring workflows using workflow monitor.
  • Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Java, XML, Aggregators, Type - I, Type-II, Type-III slowly changing dimensions (SCD).
  • Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, SAP COBOL files & XML Files.
  • Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect.
  • Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
  • Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
  • Design, development and coding with ORACLE 11g, 10g/9i/8i/, SQL Server 2000/2005, experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
  • Strong in UNIX Shell scripting and scheduled ETL load using utilities like Control-M, Crontab and Autosys.
  • Extensively worked with Oracle PL/SQL Stored Procedures, Functions and Triggers, involved in query optimization.
  • Good Experience with IDQ (Informatica Data Quality), in Installation and configuration of Informatica Servers and Client Environments. And good understanding of the ERWIN Tool and MDM concepts.
  • Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics. Built data quality Rules and generated dashboard using services.
  • Developed /Modified/ Executed multiple Windows Power Shell Scripts during the Migration of SharePoint Older Versions to Office 365 SharePoint.
  • Developed Unique Repository Queries on Toad/Oracle to access/retrieve the information of (Metadata) Informatica objects like Mappings, sessions, workflows, sources, Targets etc., which are stored in Informatica Repository/Manager DB.
  • Involved in writing various UNIX Shell Scripts for writing automated Scripts for scheduled queue process and PMCMD commands.
  • Tuned SQL/PL SQL Queries to improve the performance using Explain plan and creating indexes.
  • Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
  • Excellent technical and professional client interaction skills.
  • Interacted with both Technical, functional and business audiences across different phases of the project life cycle.

PROFESSIONAL EXPERIENCE:

Confidential, Armonk, New York

Sr. Informatica ETL Developer

Responsibilities:

  • Perform requirement analysis through coordination with business analysts and define business and functional specifications.
  • As a team conducted gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
  • Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
  • Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 11g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
  • Designed the ETL mappings between sources to operational staging targets, then to the data warehouse using Power center Designer.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
  • Documented Informatica mappings in Excel spread sheet.
  • Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
  • Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Used Informatica Power Center to migrate the data from different source systems.
  • Extensively used Autosys for Scheduling and monitoring.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
  • Extensively used various Performance tuning Techniques to improve the session performance.
  • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
  • Created business rules in Informatica Developer and imported them to Informatica Power center to load the standardized and good format of data to staging tables.
  • Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
  • Designed and Created data cleansing, validation and loading scripts for warehouse using Informatica Power Center 9.1.1/8.6.
  • Worked with offshore team to Develop and deliver the ETL tasks.
  • Monitored workflows and session using Power Center workflows monitor
  • Used Informatica Scheduler for scheduling the workflows
  • Developed the ETL jobs to automate the Data validation process across the systems (Web trends and In house) using Informatica and notifying the variances to stakeholders.
  • Extensively used Informatica client tools - Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
  • Created workflows and worklets for designed mappings.
  • Provide documentation of ETL design and technical specifications, high level and low level design specifications.
  • Design and build reconciliation process.

Environment: Informatica Power Center 10.0/9.1.1, Teradata 14/12, Oracle 11g, My SQL, XML, Flat Files, SQL Assistant, Autosys, Toad, PL/SQL, Erwin, Unix shell scripting, Cognos, Unix, Windows

Confidential, Jersey City, New Jersey

Sr. Informatica ETL Developer

Responsibilities:

  • Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
  • Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
  • Responsible for the debugging, creating mapping, running maps etc. by using Informatica Power Center.
  • Configured and running test session, workflow using Workflow Manager.
  • Prepared mapping documents for loading the data from legacy system, flat files to staging area.
  • Responsible for Data Warehouse Architecture, ETL and coding standards.
  • Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Mapping Parameter files.
  • Effectively made use of Hints, Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, SQL Loader, Dynamic SQL and Ref Cursor.
  • Extensively involved in both ETL Informatica & Database performance tuning.
  • Analyzed session log files in session failures to resolve errors in mapping or session configuration.
  • Used various transformations like Source Qualifier, Joiner, Lookup, SQL, router, filter, Expression and Update Strategy.
  • Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
  • Assisted DBA to Create tables and views in Teradata, Oracle database.
  • Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica Power Center
  • Created the DB tables, Views and involved in taking backup of Production tables.
  • Developed complex mappings & mapplets in Informatica to load the data using different transformations.
  • Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
  • Involved in Dimensional modeling to Design and develop STAR Schemas, used ERWIN, identifying Fact and Dimension Tables.
  • Rebuilding the Reports in Cognos Environment.
  • Involved in Migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
  • Worked with the third party scheduler Autosys for scheduling Informatica PowerCenter Workflows Involved with Scheduling team in creating and scheduling jobs in Autosys Workload Scheduler.
  • Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Environment: Informatica Power Center 9.6.1/9.5.1/9.1.1 , Teradata 14/12, Oracle 11g, My SQL, XML, Flat Files, SQL Assistant, Share point PL/SQL, Cognos, Unix, Windows.

ETL Informatica developer

Confidential -Chicago, IL

Responsibilities:

  • Actively involved in gathering requirements and acquiring application knowledge from Business Managers.
  • Involved in analyzing the requirements for designing the process flow for extracting the data across various source systems.
  • Designed efficient and optimized ETL Strategy by identifying, analyzing sources and destinations.
  • Designed Informatica Mappings to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server.
  • Optimized the performance of various SQL scripts by using Stored Procedures, Indexes, Views, User defined functions, Indexed Views for querying data faster.
  • Designed and developed mapping using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
  • Used Mapping Variables, Mapping Parameters in the Informatica Mappings to filter the daily data from the source systems.
  • Proficient in implementing complex business rules through Informatica transformations, Workflows/Worklets and Mappings/Mapplet.
  • Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes.
  • Tuned performance on Sources, targets and mappings and SQL queries in the mappings.
  • Implemented Informatica push down optimization for utilizing the data base resources for better performance.
  • Automated Unix shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables to check for the data consistency.
  • Involved in writing PL/SQL code in Oracle stored procedures, functions and packages to support applications front end and back end.
  • Developed PL/SQL procedures, functions to facilitate specific requirement.
  • Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
  • Automated the batch jobs using Unix shell scripts.
  • Scheduled jobs using Informatica and monitored automated weekly jobs.
  • Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
  • Also, involved in conducting and leading the team meetings and providing status report to project manager.
  • Resolved and closed the Production tickets generated due to failure of daily incremental production jobs.
  • Member of core ETL team involved in gathering requirements, performing source system analysis and
  • Development of ETL jobs to migrate the data from the source to the target DW.
  • Worked in Water Fall Methodology.
  • Used Erwin to reverse-engineer and refine business data models.
  • Prepared Data Architect document, Mapping Specification and Unit testing documents for ease of future maintenance and support.
  • Developed forms based on views, tables and procedures in tabular and form layouts.
  • Experience in creating master detail forms and adding alerts.
  • Extensive experience in UNIX Shell Scripting.
  • Experience in Informatica Power Center, Repository Manager, Designer, Workflow Manager and Workflow monitor.
  • Experience in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.

Environment: Informatica Power Center 8.6.1/8.1.1 , Oracle 11g, TOAD, SAP BOBJ 4.0,4.1, Tableau 9.2, UNIX, Autosys, SQL*Loader, PowerCenter Mapping Architect for Visio, Sybase Power Designer, IBM DB2, Flat files, SQL, putty, UltraEdit-32, shell Programming, Toad, Quest Central

Confidential

Informatica ETL Developer

Responsibilities:

  • Involved in gathering requirements from end users and involved in modifying data according to the requirement.
  • Worked with the end users to identify, create, and deliver reports according to requirements.
  • Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
  • Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
  • Created ETL Mappings, Sessions and Workflows using various transformations like Update Transformation, Lookups, Filters, Routers and XML etc.
  • Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
  • Actively involved in creating Oracle Stored Procedures, Packages, Functions, Triggers, Records, Arrays and Exception handling using TOAD, SQL*PLUS and PL/SQL.
  • Created Fast Load, Multi Load, and T Pump and BTEQ scripts to load data into Teradata.
  • Created Data models for data warehouse development.
  • Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.
  • Worked with UNIX scripts for automation of ETL Jobs using Control-M Scheduler and Involved in migration/conversion of ETL processes from development to production environment.
  • Working experience using Push Down Optimization.
  • Did performance tune of Informatica components for daily and monthly incremental loading.
  • Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.

Environment: Informatica PowerCenter 8.6.1, Informatica Data Quality (IDQ 8.6.1), SQL Server, Oracle 11g, Flat files, MySQL, Teradata 13, WinSCP, Notepad++, Toad, Quest Central, UNIX scripting, Windows NT.

Confidential

Informatica Developer

Responsibilities:

  • Assisted to prepare design/specifications for data Extraction, Transformation and Loading
  • Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
  • Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Prepared reusable transformations to load data from operational data source to Data Warehouse.
  • Wrote complex SQL Queries involving multiple tables with joins.
  • Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
  • Used debugger, session logs and workflow logs to test the mapping and fixed the bugs.
  • Analyzed the dependencies between the jobs and scheduling them accordingly using the Work Scheduler.
  • Improved the performance of the mappings, sessions using various optimization techniques.

Environment: Informatica 8.1, OBIEE, Erwin, Oracle 10g, SQL Server 2008, Flat files, SQL, putty, UltraEdit-32, shell Programming, Toad, SQL Developer, UNIX scripting, Windows NT.

We'd love your feedback!