We provide IT Staff Augmentation Services!

Etl/informatica Developer Resume

Nebraska, NE

SUMMARY:

  • About 7+ years of IT experience in Software Analysis, Design, and Development for various software applications in client - server environment in providing Business Intelligence Solutions in Data Warehousing for Decision Support Systems, OLAP and OLTP Application Development and worked on the Database Application Development.
  • Six years plus experience in the Implementation of full lifecycle in Data warehouse, ODS and Data marts with Dimensional modeling techniques Star Schema and Snow Flake Schema using Kimball and Inmon.
  • Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse and DSS using Informatica Power Center 10.1/9.6/9.1.0/8.6.1/8.1.1 - Designer, IDQ (Informatica Data Quality), IDE (Informatica Data Explorer), Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
  • Hands on experience in handling data from various source systems such as Flat Files, XML Source, Oracle, MS SQL Server, IBM DB2, Teradata and Excel Files.
  • Expert Developer skills in TeradataRDBMS, initial TeradataDBMS environment setup, development and production DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.
  • Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings.
  • Good experience in creating and using Stored Procedures, Functions, Triggers, Views, and packages in Different databases.
  • Experience in creating Tables, Procedures, Functions, Views, and other database objects using SQL and PL/SQL.
  • Experience in writing Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
  • Experience in tuning the performance of Stored Procedures and long running queries.
  • Experience in Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
  • Expertise in Production migration of new releases and Enhancements. Experience in coordinating the work with offshore team.
  • Extensively worked on Monitoring and Scheduling of Jobs using UNIX Shell Script and BTEQ Scripts.
  • Expertise on tools like Toad, SQL*Plus and SQL Server Management Studio. Involved in Manual and Automation Testing of applications in UNIX and Windows environment.
  • Good knowledge on ER Data Modeling tools like Erwin, MS Office Suite and Visio. Good exposure to the Software Development Life Cycle (SDLC) and OOAD Techniques.
  • Have a clear understanding of Business Intelligence and Data Warehousing Concepts. Worked with various clients in the Banking, Financial, HealthCare and Insurance industries.
  • Experience in integrating data from various databases Oracle, SQL, DB2UDB and Teradata.
  • Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.1, 9.1.0/8.6.0/8.1.1

Databases: Oracle10g/9i/8i, Teradata, MS SQL Server 2014, 2008/2005

Languages: SQL, PL/SQL, SQL*Plus, HTML, UNIX, DBMS

Tools: SQL plus, TOAD, Autosys

Operating Systems: UNIX, Windows (XP, NT/95/98/2000)

PROFESSIONAL EXPERIENCE:

Confidential, Nebraska, NE

ETL/Informatica Developer

Responsibilities:

  • Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the DataMart with only required information.
  • Created reusable transformations, which were used in several mappings.
  • Developed and tested stored procedures, functions, and packages in SQL Server.
  • Extracted data from various sources like MS SQL Server 2008, flat files, Oracle and XML files and loaded into the data warehouse.
  • Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads, and Monthly loads.
  • Designed and implemented stored procedures and triggers for automating tasks in SQL Server 2008/ Oracle 10g.
  • Developed flowcharts for complex stored procedures.
  • Created and Executed workflows and Worklets using Workflow Manager to load the data into the integrated data store.
  • Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging mappings and developing error-handling methods.
  • Wrote UNIX Shell Scripts for Informatica Pre-Session and Post-Session tasks
  • Designed scripts for scheduling the Informatica and SQL jobs in Tidal.
  • Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
  • Performed migration of mappings and workflows from Development to Test and to Production Servers.
  • Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
  • Worked on IDQ file configuration at user’s machines and resolved the issues.

Environment: Informatica Power Center 10.1, Oracle 11g, SQL Server 2014, PL/SQL, SQL, UNIX Shell scriptsTidal

Confidential, Columbus, OH

ETL/Informatica Developer

Responsibilities:

  • Worked heavily with Business Analyst to understand the business and to design the HLD'S and LLD'S.
  • Worked on IDQ file configuration at user’s machines and resolved the issues.
  • Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs & Populating the DataMart with only required information.
  • Created reusable transformations to clean the data, which were used in several mappings.
  • Developed and tested stored procedures, functions, and packages in PL/SQL
  • Extracted data from various sources like MS SQL Server 2008, flat files, Oracle and XML files and loaded into the oracle database.
  • Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads, and Monthly loads.
  • Designed and implemented stored procedures and triggers for automating tasks in SQL Server 2008/ Oracle 10g.
  • Developed flowcharts for complex stored procedures.
  • Created and Executed workflows and Worklets using Workflow Manager to load the data into the Oracle Database.
  • Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
  • Worked with Informatica Administrator to setup project folders in development, test, and production environments.
  • Wrote UNIX Shell Scripts for InformaticaPre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows)
  • Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
  • Performed migration of mappings and workflows from Development to Test and to Production Servers.
  • Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Informatica Power Center 10.1/9.6, Oracle 11g, SQL Server 2008, PL/SQL, SQL, UNIX, Shell scripts

Confidential, Providence, RI

Informatic Developer

Responsibilities:

  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions, and Aggregator transformations to pipeline data to Data Warehouse.
  • Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
  • Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
  • Developed strategies for Incremental data extractions as well data migration to load into the Teradata. And, assisted in designing Logical/Physical Data Models.
  • Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the Power Center, Power exchange.
  • Created SSIS Packages to migrate slowly changing dimensions. Expert knowledge SQL Queries, Triggers, PL/SQL Procedures, Packages to apply and maintain the Business Rules.
  • Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, created testing metrics using MS-Excel
  • Used IBM I series tool to extract the data from DB2.
  • Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
  • Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
  • Designed and developed UNIX shell scripts to schedule jobs. Also, wrote pre-session and post-session shell scripts, Wrote PL/SQL scripts for dropping, rebuilding indexes.
  • Performed Configuration Management to Migrate Informatica mappings/sessions/workflows from Development to Test to production environment.
  • Wrote UNIX shell scripts to automate the process of renaming the Flat files with a timestamp extension, Compressing, Archiving, the Workflows, File Manipulations, and automatic email notifications to the data owners (Success / Failure) and FTP to the desired locations.
  • Worked as Teradata developer, implementation and usage of tools and utilities such as Fast load, Fast Export, Multi load, TPump, Teradata Parallel Transporter (TPT)
  • Collaborated with Informatica Admin in process of Informatica Upgradation from Power Center 8.1 to Power Center 8.6.
  • Worked closely with the business analyst’s team to solve the Problem Tickets, Service Requests.

Environment: Informatica Power Center 9.1/8.6/8.1, SQL Server 2005/2008, DB2, IDQ, Teradata, Oracle 10g, SQL, PL/SQL, T-SQL, TOAD 9.0, Mainframes, Autosys.

Confidential, NJ

ETL/Data warehousing Developer

Responsibilities:

  • Major involvement in creating and tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in Work flow monitor
  • Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
  • Created update strategy and stored procedure transformations to populate targets based on business requirements.
  • Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
  • Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values
  • Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
  • Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
  • Loaded operational data from Oracle, Sql server, flat files, Excel Worksheets into various data marts.
  • Created Tasks and Workflows using Task Manager and Workflow Designer
  • Also, developed numerous Stored Procedures, Triggers and common functions using PL/SQL.

Environment: Informatica Power Center 8.1, Work Flow Manager, Oracle 8i/9i, SQL Server 2005, DB2, Erwin, TOAD, UNIX Shell script.

Confidential

ETL / Informatica Developer

Responsibilities:

  • Good Business and System analysis skills to understand the requirements and customize client applications.
  • Excellent Transact-SQL/ T-SQL, PL/SQL (DDL/DML) programming skills using complex Stored Procedures, effective functions, Views, Indexes, appropriate Triggers with optimized Performance Tuning etc.
  • Good Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in using new SQL Server 2014 features like In Memory Tables, natively compiled Stored procedures etc.
  • Extensively used Informatica Power center for extracting, transforming, and loading data from relational sources and non-relational sources.
  • Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
  • Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
  • Designed complex UNIX scripts and automated it to run the workflows daily, weekly, and Monthly.
  • Developed mapping parameters and variables to support SQL override.
  • Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
  • Created sessions, database connections and batches using Informatica Workflow Manager. Developed mappings to load data in slowly changing dimension.
  • Created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting.
  • Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL
  • Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle database
  • Provided reliable, timely support of integration, performance, and user acceptance testing processes.
  • Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.

Environment: Informatica Power Center 8.1, Oracle 8i/9i, MS SQL Server 2005/2000, XML,

Hire Now