We provide IT Staff Augmentation Services!

Etl Developer Resume

5.00 Rating

San Francisco, CA

SUMMARY:

  • 8+ years of IT experience in analysis, design, development, Data Warehouse, ETL, testing, documentation and implementation of client/server applications.
  • Experience in Data Warehouse development working with Data Migration, Data Conversion, Data Cleansing and Extraction/Transformation/Loading using Informatica PowerMart/PowerCenter with Oracle, SQL Server and Heterogeneous Sources
  • Experienced in Data Modeling, making use of Dimensional Data Modeling, Star Schema, and creating Fact and Dimension tables.
  • Expertise in implementing complex Business rules by creating robust mappings, mapplets, reusable transformations.
  • Experience in performance tuning of sources, transformations, mappings, targets, and sessions.
  • Extensively used SQL and PL/SQL to write stored procedures, functions, packages and triggers.
  • Exceptional analytical and problem solving skills.
  • Good team player with excellent interpersonal and communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 5.x/6.x/7.x/8.x/9, Power Mart 5.x/6.x

Data Modeling Tools: ERwin 4.0

Databases: ORACLE 11g/10g/9i/8i/7.x,DB2, SQL Server 2000, SFDC

Languages: SQL, PL/SQL, Shell Scripting, Java, C, C++, HTML

Operating Systems: Windows NT 4.0/98/2000, UNIX, Sun Solaris

Others: TOAD, SQL*Loader, MS Visio, AutoSys

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

ETL Developer

Responsibilities:

  • Involved in Dimensional Modeling to develop Data Mart for querying purpose of Reporting Team.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations using the Designer.
  • Worked extensively with mappings using Expression, Aggregator, Sorter, Filter, Lookup, Update, Joiner, Sequence generator, Router and Stored Procedure transformations.
  • Worked with the slowly changing dimensions.
  • Designed and developed complex mappings, mapplets and reusable transformations.
  • Designed and developed workflows, worklets and tasks.
  • Extensively used Workflow Manager for creating and scheduling various sessions.
  • Implemented shell scripts to run and control workflows using the PMCMD.
  • Responsible for monitoring all the workflows that were scheduled, running completed and failed.
  • Involved in debugging the Workflows that failed.
  • Interacting with system administrators, DBAs and other teams to troubleshoot application performance issues.
  • Accommodating the code changes and requirement changes necessary for the Reporting team.
  • Creating Views, Tables, materialized views and Lookup tables necessary for the data manipulation as per the reporting requirements.
  • Analyzing long running SQL's and tuning them using Explain plans etc.,
  • Performing requirements gathering/documentation and coordinate implementation of requested enhancements for the applications.
  • Developing test plan and scripts, conducting testing, and dealing with business partners to conduct end - user acceptance testing.
  • Ensuring that all production changes are processed according to release management policies and procedures.
  • Creating and Resolving JIRA’s for data issues, access requests and grants.
  • Ensuring that appropriate levels of quality assurance have been met for all new and existing applications / CRs.
  • Involved in performance tuning of sources, targets and sessions.
  • Mentored junior developers in understanding business requirements and internal policies of MDM

Environment: Informatica Power Center 9.0, Power Center 8.6, SQL, PL/SQL, Oracle 10g,DB 2, Informix, SQL server2008, Teradata, Excel, UNIX,Pac2000, WindowsXP

Confidential, Irvine, CA

Senior Informatica Developer

Responsibilities:

  • Extensively used Informatica to load the data stored in different databases sources (Oracle, SAP, DB2), COBOL and Flat files into Oracle.
  • Done extensive testing and wrote queries in SQL and using Apex Explorer wrote SOQL queries to ensure the loading of the data into SFDC
  • Created Informatica mappings with PL/SQL procedures and Shell Scripts to build business rules to load data.
  • Conducted unit testing of all the mappings developed and checked the data transformations.
  • Involved in the requirements definition and analysis in support of Data Warehousing efforts
  • Responsible for identifying the data transformations and cleansing of data accordingly when flow is from different databases
  • Developed reusable transformations to use them across all the mappings in a shared Environment.
  • Involved in migrating the developments from different environments like development, staging and production.
  • Creating users in SFDC in development, test and Production environments.
  • Implemented DML operations in SFDC using Apex Data Loader
  • Created Parameter Files using UNIX d by different mappings involved in the project
  • Participated in weekly Status Meetings.

Environment: Informatica 8.6.1, Excel, SQL Server 2000, Oracle 10g,DB2,SAP,TOAD, JDeveloper, Power Exchange for SFDC Sun Solaris, UNIX, Windows XP

Confidential, San Diego, CA

Data Warehouse Developer

Responsibilities:

  • Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
  • Configured ETL tools for the development environment and educated the new developers in understanding the ETL concepts and tools.
  • Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables. Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using ERwin.
  • Wrote stored procedures in PL/SQL and Unix Shell Scripts for automated execution of jobs.
  • Configured Repository set-up for Development, Testing and Production.
  • Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalizer, Filter).
  • Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
  • Improved the performance of mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases.
  • Optimized the mappings by changing the logic and reduced running time.
  • Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
  • Creation of universe in the Designer and making connection with the Oracle Database.
  • Manipulating data through various presentations styles such as; charts cross tabs, standard tables and Oracle Applications module tables.
  • Used Repository Manager to create Repository, User groups, Users and managed users by setting up their privileges and profile.
  • Executed sessions, Sequential and Concurrent Batches.

Environment: Informatica 8.6, Excel, SQL Server 2000, Oracle 10g, Terradata, Erwin4.1, TOAD, SQL * Loader, Sun Solaris, Windows XP.

Confidential, San Bruno, CA

Informatica Developer

Responsibilities:

  • Involved in developing the Data Warehouse using Star schema.
  • Involved in conducting design sessions and reviews. Communicated with the users to observe various business rules in implementing the data warehouse.
  • Assisted in creating the repositories using Informatica Repository Manager.
  • Configured the sessions to load data from various heterogeneous sources.
  • Developed the mappings using Informatica Power Center Designer.
  • Used Transformations like Aggregator, Sorter, Joiner, Expression, Rank, Filter, Lookup and Update.
  • Created, scheduled and monitored the sessions and batches using Workflow Manager.
  • Created Oracle Materialized views for complex user queries and rebuild them after every ETL load.
  • Created Oracle Materialized view that gets refreshed automatically on commits for some standalone tables to improve the overall load performance and reduced the user query contention with the base tables.
  • Wrote Data Archival scripts using Oracle’s exchange partition to archive the fact data from the fact tables to a different schema.
  • Wrote multiple database monitoring scripts that run periodically and sends out an email when there is an issue. Worked on other performance tuning techniques.
  • Developed reusable transformations to use them across all the mappings.
  • Improved loading performance both at Informatica mapping and at session level.
  • Used the Task developer in Workflow manager to define sessions.
  • Worked with pre session and post session settings and Flat files.
  • Involved in error checking and testing of ETL procedures and programs in Informatica session log.
  • Involved in Performance tuning of mappings.

Environment: Informatica Power Center v 7.1.4, Oracle 9i/10g,Terradata, Flat Files, SQL, PL/SQL, Windows NT.

Confidential, San Diego, CA

Informatica Developer

Responsibilities:

  • Extensively used ETL (Informatica) to load the data stored in different databases sources (Oracle, SAP, Teradata, Access), COBOL and Flat files into Oracle.
  • Imported the COBOL files from mainframe server using Power Connect ODBC striva.
  • Involved in the development of Informatica Mappings using various transformations like Source Qualifier, Look-up, Filter, Expression, Normalizer, Update Strategy, Sorter, Joiner, etc.
  • Worked closely with Business Analysts to find out the relationships between source systems and the business process needed in the migration process.
  • Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Session, Batches and Target Data.
  • Implemented various Dimensions that are tied to central fact table.
  • Wrote session commands to configure pre-session and post-session tasks.
  • Applied the complex business rules using Oracle functions and stored procedures, which are used as standalone procedures or used as pre/post load procedures in Informatica mappings.
  • Maintain and monitor backup and recovery procedures for databases.
  • Troubleshooting and resolving performance bottlenecks as needed.
  • Thorough understanding of Structured Query Language, ordered searches, indexes, etc.
  • Write appropriate SQL scripts to extract data efficiently and in a timely manner at the customer's request.
  • Involved in the requirements definition and analysis in support of Data Warehousing efforts
  • Wrote SQL queries to extract and join data from different sources.
  • Created and used reusable worklets, sessions and tasks in the workflow Manager and monitored them in the workflow Monitor.
  • Created Unix shell scripts to perform pre-session and post-session tasks. Used shell scripts for customized Event Waiting.

Environment: Informatica Power Center v 7.1.4, Oracle 9i, Excel files, SQL, PL/SQL, Perl scripted, Win 2003 server, Windows XP and, SQL Developer and Toad

Confidential, NY

Informatica Developer

Responsibilities:

  • Involved in Dimensional Modeling to develop Star Schema.
  • Developed various Mappings with the collection of all Sources, Targets, and Transformations using the Designer.
  • Worked extensively with mappings using Expression, Aggregator, Sorter, Filter, Lookup, Update and Stored Procedure transformations.
  • Worked with the slowly changing dimensions.
  • Designed and developed complex mappings, mapplets and reusable transformations.
  • Designed and developed workflows, worklets and tasks.
  • Extensively used Workflow Manager for creating and scheduling various sessions.
  • Implemented shell scripts to run and control workflows using the PMCMD.
  • Responsible for monitoring all the workflows that were scheduled, running completed and failed.
  • Involved in debugging the Mappings that failed.
  • Interacting with system administrators, DBAs and other teams to troubleshoot application performance issues.
  • Analyzing long running SQL's and tuning them using Explain plans etc.,
  • Performing requirements gathering/documentation and coordinate implementation of requested enhancements for the applications.
  • Developing test plan and scripts, conducting testing, and dealing with business partners to conduct end-user acceptance testing.
  • Ensuring that all production changes are processed according to release management policies and procedures.
  • Ensuring that appropriate levels of quality assurance have been met for all new and existing applications / CRs.
  • Involved in performance tuning of sources, targets and sessions.

Environment: Informatica Power Center 7.1, SQL, PL/SQL, Oracle 10g, Excel, Erwin, UNIXWindows NT

Confidential

Business Analyst/ Database Developer

Responsibilities:

  • Developed Static and Dynamic models and sequence diagrams like Logon which authenticates the entry of users, Resource Allocation where the VPP group allocates resources to each project, Add/Delete Artifact in which the addition of new Artifacts and Deletion of Existing Artifacts for a project are performed by Project Manager of the project.
  • Developed DTS Packages using SQL server DTS, created the task objects, used bulk insert, import & export features to transfer data from data source to the other.
  • Used the DTS RUN commands to run the packages from the command prompt specially when combining the packages and stored procedures using the SQL server Agent.
  • Created Data driven Queries (DDQ’s), table-to-table transformations, flower transformations, used VB script while using transformations.
  • Responsible for creating tables, users, roles, table spaces and segments.
  • Involved in database designing.
  • Involved in data loading from text file to database tables using SQL* Loader.
  • Responsible for running the converter program and get the data in text files.
  • Responsible for successful running of posting steps involved in billing system.
  • Mapped tables from the source to the Target definitions in the data source using the DTS Designer
  • Written system specifications for User Process system

Environment: Java, Web Server, SQL Server 7.0, Oracle 7.x, SQL server DTS (Data Transformation Services), XML, Erwin 3.5.2, VB Script

We'd love your feedback!