We provide IT Staff Augmentation Services!

Sr. Etl Developer Resume

4.00/5 (Submit Your Rating)

Burlington, MA

SUMMARY:

  • 8+ plus years of experience in the IT industry with Domain knowledge on Insurance, Health Care, Retail and Telecom Projects.
  • Demonstrated an analytical ability to understand the business requirements, convert the business specification to technical document, develop and integrate solutions to meet the requirement.
  • Created Business Requirements Documents (BRD), Source - to-Target or Lineage document for data warehousing applications.
  • Worked on projects using Informatica which are related to migration, development and Integration of various systems using various versions of Informatica (10x/9x/8x).
  • Proficient in Informatica Designer components such as Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Developer (Re-usable transformations), Workflow Manager, Workflow Monitor.
  • Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
  • Developed complex mappings in Informatica using different transformations such as Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union and Stored Procedure etc.
  • Hands on experience in using Business Intelligence tools such as Microstrategy and Cognos.
  • Worked on various relational databases like Oracle, SQL Server, DB2 in creation of SQL Queries required by the project.
  • Aware of concepts related to PL/SQL programming and some other scripting languages such as UNIX.
  • Extracted data from various sources like Oracle, DB2, Flat files, MS SQL SERVER, XML files and other open source databases such as Cassandra.
  • Worked closely with Data Modellers in coming up with scalable relational and dimensional data models. Good understanding of Star Schema, Snowflake Schema and 3NF data models.
  • Proficiency in Data Warehousing techniques for Data Cleaning, Slowly Changing Dimension (SCD) phenomenon, Surrogate Key assignment and Change Data Capture (CDC).
  • Worked extensively with Slowly Changing Dimensions Type1, Type2 and Type3.
  • Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.
  • Experience in Performance tuning of Informatica sources, mappings, targets and sessions and SQL queries. Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
  • Developed unit test cases for testing the ETL logic.
  • Experience in setting up batch jobs using Autosys and Control-M job schedulers.
  • Strong knowledge on Agile SCRUM methodology, Waterfall model and Test Driven Development.
  • Hands on experience in Production Support and Maintenance.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.1/9.6/9.5.1/9.1.0/8.6, ODI

Reporting Tools: Microstrategy, Tableau, Cognos, OBIEE

Databases: Oracle 8i/9i/10g/11g/12c, IBM DB2, SQL Server, Netezza, MS-Access.

Operating systems: Windows 95/2000/NT/XP/Vista, UNIX.

Data Modeling Tool: Erwin 8x

Utilities: Oracle SQL Developer, TOAD, SQL*LOADER, SQL Navigator

Job Scheduling Tools: Informatica Scheduler, Control- M, Autosys.

Production Support Tools: JIRA, Remedy, HP QualityCenter, Bugzilla

Office Application: MS Excel, MS Outlook, MS Word, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, MA

Sr. ETL Developer

Responsibilities:

  • Worked with Business Analysts to understand the requirements and convert them to technical specfications.
  • Created multiple mappings that involved implementation of Business Logic to load data into staging area.
  • Extracted data from mainframe source systems and applied the business logic to load data into target systems.
  • Implemented the ETL logic based on the mapping document to load the data from various source systems to target systems.
  • Developed mapping parameters and variables to support SQL overrides and create global parameter files for loading various source and target tables.
  • Used existing ETL standards to develop mappings.
  • Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
  • Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
  • Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
  • Developed workflows with multiple sessions and instances for same subject area.
  • Worked on Partitioning of the Sessions and Performance Tuning of Informatica.
  • Implemented Indexing, Partitioning and Parallelismstrategies to facilitate huge volume data loads.
  • Scheduled workflows using Autosys Scheduler and configured them with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
  • Loaded data into fact and dimension tables in that handled slowly changing dimensions of Type II to populate current and historical data to Dimensions tables in the data warehouse
  • For some strategies implemented the SCD TypeI.
  • Removed bottlenecks at source level, transformation level and target level for the optimum usage of sources, transformations and target loads.
  • Performed Unit testing of Informatica ETL process to ensure ETL logic.
  • Once successfully unit tested ETL mappings, workflows and worklets were successfully moved to QA environment.
  • After thorough User Acceptance Testing code was migrated to production and I provided 24x7 production support.
  • Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
  • Participated in test results document preparation for the project.

Environment: Informatica Power Center 9.6(Power Center Designer, workflow manager, workflow monitor), Oracle Data Integrator, Business Objects XI 4.1, PowerExchange, UNIX, SQL Developer, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g, Agile.

Confidential, NY

Sr. ETL Developer

Responsibilities:

  • Interacted with Business Analysts to understand and analyze the requirements.
  • Translated requirements into business rules & made recommendations for innovative IT solution.
  • Worked closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
  • Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
  • Used Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
  • Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for different types of studies for Daily, Monthly and Yearly Loading of Data.
  • Removed bottlenecks at source level, transformation level and target level for the optimum usage of sources, transformations and target loads.
  • Captured data error records corrected and loaded into target system.
  • Tuned Source System and Target System based on performance details, when source and target were optimized, sessions were run again to determine the impact of changes.
  • Experienced in troubleshooting and fix the different Development/Production environment issues.
  • Responsible for regression testing ETL jobs before test to production migration.
  • Performed Database/ETL migrations from Dev. environment to Test/Training/UAT/Staging and PROD environments.
  • Worked on Business Objects functionalities like Queries, Slice and Dice, Drill Down, Custom sorts, Cross Tab, Master Detail and Formulae.
  • Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
  • Providing 24x7 production support.
  • Worked on daily production incidents and triaging the defects.

Environment: Informatica Power Center 9.5.1(Power Center Designer, workflow manager, workflow monitor), Business Objects XI 3.3, WinSQL, UNIX, SQL Developer, Erwin, Putty, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect, VersionOne, Mingle, Sharepoint, Agile.

Confidential, Bentonville, AR

ETL Developer

Responsibilities:

  • Analyzing the source data coming from different sources and working with business users and developers to develop the Data Model.
  • Create functional specifications and work with application technical teams to create the high level and low level design documents.
  • Working closely with user decision makers to develop the transformation logic to be used in Informatica Power Center.
  • Developing mappings, workflows as per the requirement.
  • Created flat file targets and XML file targets extensively.
  • Worked with UNIX environment for maintaining parameter files.
  • Prepare the implementation plan to deploy ETL jobs and batches in Dev, Test and Production environments.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design and development changes.
  • Resolving tickets opened by users for BO Production issues as well as access related issues.
  • Performance tuning using round robin, hash auto key, Key range partitioning.
  • Implemented efficient and effective performance tuning procedures.
  • Handling High priority and criticality incidents.
  • Handling work requests and project requests.
  • Provided backup liaison with business and IT.
  • Understanding the functionality of the application from the business prospective.
  • Monitoring and maintaining the scheduled jobs.
  • Providing 24x7 production support.
  • Responsible for maintaining the Quality standards in all the phases.

Environment: Informatica Power Center 9.6.1/9.1(Power Center Designer, workflow manager, workflow monitor), WinSQL, UNIX, Business Objects, Erwin, SQL, PL/SQL, MS-Visio, MS Office, DB2, SQL Server, Oracle 10g/11g,SAP Power Connect.

Confidential, Fremont, CA

ETL Developer

Responsibilities:

  • Designed the ETL Mapping Documents for development team members for their implementations.
  • Worked on Informatica Power Center components- Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
  • Promoted Informatica mappings from development to test to production environment.
  • Used Informatica to extract, transform and load data from different input sources like flat files and XML files into Oracle 10g database.
  • Created Informatica Power Center Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
  • Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
  • Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
  • Migration between Development, Test and Production Repositories.
  • Supported the Quality Assurance team in testing and validating the Informatica workflows.
  • Did unit testing and System testing at ETL level in my mappings.
  • Configured workflows with Email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision tasks.
  • Developed robust and effective error free workflows so that only clean and good data is loaded into Oracle Database.
  • Follow-up on tickets and fixing the issues.

Environment: Informatica 8.1.2, Oracle 10g, SQL, PLSQL, Microsoft Excel, MS-Word, COBOL.

Confidential, Deerfield, IL

ETL Developer

Responsibilities:

  • Gathered the Project Requirement and Worked on System Requirement Design
  • Worked on ETL Specification and Logical & Physical Design documents
  • Understanding the existing DATA MODEL and gathered and analyzed the business requirements to develop a data warehouse model and evaluated for the ETL purpose
  • Coordination with the ETL & Reporting Development team with Design/Development approach to create a DW and Data Marts.
  • Improved the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization.
  • Extensively used Informatica Power Center as an ETL tool to integrate various sources and loaded the data into Datawarehouse.
  • Writing data extracts (equities, market data etc) to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
  • Develop complex transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, XML transformations.
  • Creating/ Building and Running / scheduling Batches and Sessions/workflow using the Server Manager/Workflow Manager and automation of ETL process using Autosys.
  • Worked on daily loads that include delta and change data capture logic and also worked with global and local variables at the workflow and the mapping levels.
  • Involved in creating the procedures and functions to support the ETL logic as required.
  • Worked on Unix Platform with respect to Informatica file transfers, generating logs etc.
  • Worked on UNIX shell scripts for scheduling sessions, pre and post session scripts for data transfer needs, GFT mechanism etc.

Environment: Informatica Power Center 8.6, Informatica PowerExchange, Oracle 10g,Siebel 8,TOAD, MS Visio, UNIX Scripting (Ksh)

We'd love your feedback!