We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Boston, MA

SUMMARY:

  • Over 7+ years of experience in field of I.T in Analysis, Design, development, testing, and Implementation of Business Intelligence solutions using Data Warehouse/Data mart design, OLAP, ETL, Client/Server applications, Decision Support Systems (DSS) and Metadata repositories.
  • Over 7 Years of extensive experience in ETL process using Informatica PowerCenter 8.6, 8.1/7.1/6.2/6.1 , Oracle SQL Tuning.
  • Excellent working experience on complex DSS (Decision Support Systems) applications, directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems using Informatica.
  • Experience in Dimensional data modeling, Star schema modeling, Snowflake modeling, FACT and dimensional tables, Physical and logical data modeling, and primarily used Erwin for Data modeling.
  • Proficient in understanding business processes / requirements and translating them into technical requirements and to estimate the required size of Database.
  • Excellent verbal and communication skills clear understanding of business procedures and ability to work as an individual and as a part of a team.
  • Worked extensively with complex mappings using different transformations like Router transformations, stored procedure transformations, Source qualifiers, Union, Update strategy, unconnected & connected lookups, aggregator, and SCD type2.
  • Experienced with session partitions using Informatica to increase the load performance and to meet the SLA time.
  • Good working experience in creating and executing BTEQ scripts on Teradata environment and optimizing the queries for handling billions of data records on Teradata.
  • Experienced with Informatica Power analyzer to generate the reports by accessing the metadata repositories.
  • Extensive experience in Developing, debugging Informatica mappings. .
  • Experienced in Data analysis, Data cleansing for maintaining data quality using Informatica Data quality and Data Explorer,Data Flux and trillium software.
  • Experienced in Developing and Monitoring Nightly Batch Jobs using Autosys and UNIX Shell Script.
  • Extensive experience in Performance Tuning using various techniques like Indexes, Hints, Partitioning, Data Analysis, Optimization, Tuning queries and Normalization techniques.
  • Proficient in setting up Materialized Views/Snapshots for data replication across databases.
  • Experience in data migration from legacy system to Oracle RDBMS.
  • Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
  • Knowledge of ETL tools like Sql*Loader, Erwin.
  • Proficient working experience in SQL, PL/SQL (Client and Server side Procedures, Functions, Packages, Objects, Triggers), Views, Relational Databases, MS SQL Server, MS Access and DTS (Data Transfer Services).
  • Wrote UNIX shell scripts to encrypt flat files that are created by Oracle Job’s and to upload FTP the flat files to the designated server.
  • Expertise in performance tuning using Explain Plans and Trace File methodologies (Used Toad Software for some clients).
  • Written several SQL stored procedures while integrating Oracle data into the warehouse and for updating the Job entries.
  • Worked with DBA for performance tuning of Informatica session for large data files.
  • Extensively worked with large size Databases in Production environments.
  • Experienced with Informatica versioning to maintain the different versions of mappings, sessions and workflows.
  • Prepared the UTC documents and capturing the UTC results to validate the data after loading.

TECHNICAL SUMMARY:

OLAP & Reporting Tools: Business Objects 6.5/5.1.6,Hyperion Brio, Oracle Reports 6i. Super Glue 1.5/2.x,Informatica Metadata manager

Language: Oracle PLSQL, Unix, Perl, Java, C,C++

Databases, Oracle 10g/9i, DB2, Sybase, MS SQL Server, Teradata V2R6.1, Teradata SQL Assistant 7.1, 12,13, MS Access

ETL Tools: Informatica PowerCenter 9.1,8.6, 8.1/7.1.3/6.2.2

Databases: Oracle 11g,10g/9i, DB2, Sybase, MS SQL Server, Teradata V2R6.1, Teradata SQL Assistant 7.1, 12,13, MS Access Server.

ENGAGEMENT SUMMARY:

Company: Confidential

Title: Senior ETL Developer.

Roles & Responsibilities:

  • Implement and Enhance ETL programs using Informatica Power Center and Informatica Power Exchange against the Oracle 10g Data Warehouse.
  • Contribute to technical architectural planning, data modeling, process flow documentation and the design and development of innovative solutions for the business.
  • Create technical designs and mapping specifications.
  • Work with both technical staff and business constituents to translate business requirements into technical solutions.
  • Perform unit and system test/validation tasks.
  • Maintain technical and user documentation.
  • Provide on-call support of the Data Warehouse nightly processing
  • Be an active participant in both technology and business initiatives.

Environment: Informatica Power Center 9.1, Oracle 10g/9i Erwin, Autosys, UNIX, Windows XP.

Confidential

Title: Senior ETL Developer.

  • Designed ETL processes to load data from File source and Oracle into the target Teradata.
  • Provide technical leadership to other support team members and resolution of technical issues
  • Well versed in Informatica Partitioning concepts.
  • Debugged mappings by creating Informatica Row Error Logging, sending error rows to error table so that they can be corrected and re-loaded into a target system
  • Tuned existing Complex Informatica Mappings for Performance Optimization.
  • Resoloved complex mappings/sessions issues coded using Informatica power center 7.1.3 and 8.6 for data loading.
  • Fixed the invalid mapping's and troubleshoot the technical problems of the database.
  • Good experience in creating BTEQ scripts using Teradata SQL assistant 7.1.
  • Versatile in creating Mload and Fload scripts in UNIX environment for the sources being flat files and also for generating extract files.
  • Involved in loading huge volume of data into teradata environment using T-Pump utility.
  • Have good experience in teradata tuning the queries against huge volume of tables over tera-warehouse environment.
  • As part of ETL CDE History load, loaded millions of rows from Teradata to Oracle database using Informatica Parition logic.
  • Created JIL scripts for Autosys Scheduler.
  • Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tool like Power Designer.
  • Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
  • Involved in completely in Analysis and Development of modules Employee Summary of the project.
  • Created and reviewed Logical and Conceptual Model with Business users, DBA’s and testing team.

Environment: Informatica Power Center 8.6.1, Teradata RDBMS V2R6, Oracle 10g/9i Erwin, Autosys,UNIX, Windows XP.

Company: Confidential, Boston, MA

Title: Senior Software Enigneer

Responsibilities:

  • Participated in Logical data modeling sessions and provided the inputs to data modeler about the functionality of applications
  • Involved in Source system analysis and history system analysis.
  • Prepared Technical and ETL Design documents.
  • Involved in Data profiling to maintain the data quality using Informatica Data quality tool.
  • Prepared the Error handling and Audit strategy documents.
  • Created the Informatica mappings using various transformations to maintain the history of the data.
  • Extensively used parameter files to implement Incremental logic.
  • Extensively used Test director to document test cases and Test results
  • Created the work lets and workflows to run the jobs.
  • Preparing the Deployment plan for moving the code to production environment.
  • Supported the business after went go live.
  • Created the metadata repository for managing the business terms, synonym sets product hierarchies, data sets and business rules.
  • Created the change management requests for moving new attributes to the production environment.
  • Good experience in creating BTEQ scripts using Teradata SQL assistant 7.1.
  • Versatile in creating Mload and Fload scripts in UNIX environment for the sources being flat files and also for generating extract files.
  • Involved in loading huge volume of data into teradata environment using T-Pump utility.
  • Have good experience in teradata tuning the queries against huge volume of tables over tera-warehouse environment.
  • Involved in resolving various data performance issues during development as well as in production.
  • Experienced with IDQ 8.6 to maintain the data quality before loading into datawarehouse.

Environment: Informatica PowerCenter 8.6, Informatica Data Explorer, Informatica Data quality, Oracle 10g/9i Teradata V2R6,Teradata SQL Assistant, Business Objects, Erwin 4.1.4,Toad, UNIX, Windows XP.

Company: Confidential

Role: ETL Developer

Responsibilities:

  • Participated in the data extraction from the different source legacy systems into the staging area.
  • Prepared the Technical Specification document and participated in design review with Business analysts and Data architects.
  • Creating the indexes based on the reporting requirement to speed up the query performance.
  • Involved in Data profiling using Informatica Data explorer and Trillium tools.
  • Involved in the ETL Design and testing the mappings in Test Repository.
  • Moving the mappings from Dev to Test Repository.
  • Created and loaded the summary tables using informatica for reporting users to increase the query performance.
  • Preparing the Unit test case documents.
  • Preparing the Deployment plan for moving the code to production environment.
  • Supporting the business after went to live.
  • Providing the Reporting solutions to the Business users.
  • Analyzing the tables and materialized views and doing sanity checks.
  • After Refresh from Production database, identifying the indexes created in logging mode and recreating the indexes.

Environment: Informatica7.1, Informatica Data Explorer , Data Quality, Oracle 9i, Toad, Business Objects, UNIX, Windows NT.

Company: Confidential

Role: ETL Developer

Responsibilities

  • Gathering the requirements and doing the data analysis.
  • Converting the requirements into high level design documents.
  • Preparing the low level design documents and creating column to column mapping documents.
  • Involved in Data profiling using Informatica Data explorer and Trillium tools.
  • Involved in the ETL Development and testing the mappings in Test Repository.
  • Moving the mappings from Dev to Test Repository.
  • Created and loaded the summary tables using informatica for reporting users to increase the query performance.
  • Scheduled the Informatica jobs through Informatica scheduler.
  • Preparing the Unit test case documents.
  • Preparing the Deployment plan for moving the code to production environment.
  • Supporting the business after went to live by doing job monitoring and fixing the issues on priority basis to meet the Service level agreement.
  • Creating the indexes based on the reporting requirement to speed up the query performance.
  • Providing the Reporting solutions to the Business users.
  • Creating the universes for different subject areas.
  • Creating the complex reports based on the user requirements.

Environment: Environment: Informatica 7.1, MS SQL Server, SQL Navigator, Business Objects, Windows, Unix, Toad. Client:

Confidential

Role: ETL Developer

Responsibilities:

  • Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
  • Designed and developed ETL Processes based on business rules using Informatica Power Center.
  • Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, and lookup and update strategy transformations.
  • Was part of scripting team for shell script to automate and migrate data from ODS to Data warehouse.
  • Created test cases and test scenarios and documented actual results.
  • Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: Informatica Power Center 6.2.2, MS SQL Server, Oracle 9i/8.1.7, SQL Plus, PL/SQL, UNIX Shell Scripting,

Hire Now