We provide IT Staff Augmentation Services!

Sr. Etl Developer Resume

Irvine, CA

CAREERSUMMARY

  • About 9.6 years of overall experience in the Information Technology Industry
  • Experience in data warehousing and business intelligence using various ETL tools Informatica, SQL Server SSIS and Cognos(Reporting tool)
  • 6 months of data modeling experience.
  • Extensive knowledge with Relational & dimensional data modeling, star schema/snowflakes schema, fact and dimension tables and process mapping using the top-down and bottom-up approach.
  • Training in progress for Master Data Management (MDM) methodology, strategies and governance
  • Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center,8.x/7.x.
  • Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
  • Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
  • Well Experienced in doing Error Handling and Troubleshooting using session log files.
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
  • Understanding & working knowledge of Informatica CDC (Change Data Capture) using informatica power exchange.
  • Experience in working with ORACLE tables ,XML, and Flat Files
  • Proficient working with Unix/Linux environments and writing UNIX shell scripts
  • Experienced in working with tools like TOAD,SQL Server Management studio and SQL plus for development and customization
  • Proficient working with Oracle SQL and Oracle PL/SQL
  • Strong skills in data analysis, data requirement analysis and data mapping for ETL processes
  • Ability to prioritize and execute tasks in a high pressure environment
  • Experience in mentoring and providing knowledge transfer to team members, support teams and customers.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x/7.x, SSIS

BI Tools: Cognos 8 BI Suit

Databases: SQL server, Oracle 8i

Client Side Skills: SQL, PL/SQL, UNIX shell scripting, HTML, C, C++,D2k Forms and Reports

B2B tools: Data transformation Tool

Data Model tools: Erwin data model

Tools: Toad

PROFESSIONAL EXPERIENCE

Client: Confidential, Irvine, CA

Sr. ETL Developer

The goal of the project to protect data moving from production to lower environments. So here are masking sensitive data moving to lower environments for testing and development purpose and the data maintains the business requirements and protects data.

Responsibilities:

  • Create Profile and Profile template.
  • Build workflow
  • Generate Workflow
  • Test data to ensure data is masked
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center
  • Proficient in Toad and UNIX Shell Scripting.
  • Extract data from flat files, Oracle, SQL Server 2008 and VSAM files sources and load the data into the target database.
  • Extensively used Informatica to load data from fixed width and delimited Flat files,Xml files.
  • Worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, also imported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
  • Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, sequence generator, joiner, aggregate, Data masking and expression transformations in extracting data in compliance with the business logic
  • Maintained versions of code and supporting documents in Clear Case (UNIX).
  • Handling larger database queries and applying transformations to make the business solution applicable to project.
  • Involved in Performance tuning.
  • Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Identified the errors by analyzing the session logs
  • Responsible for monitoring all the sessions that are running, completed and failed session to check the progress of data load.
  • Involved in Unit of ETL Code (Mappings and Workflows)
  • Developed Korn shell (ksh) scripts for Informatica pre-session, post session procedures
  • Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
  • Direct Coordination with Clients and engaging offshore daily basis for assignment of work.

Environment: Informatica Power Center 8.6(Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica TDM tool, Clear Case tool,SQL, PL/SQL, TOAD, MS SQL Server 2008, Oracle, UDB, Flat Files, xml files,VSAM files

Confidential

Sr. ETL Developer

SEPA credit transfer payments to be originated via Standard Payments screens and International payments screens for Republic of Ireland. There are changes to functionality delivered in earlier packages effecting data on:

  • Import file screens
  • Payment entry and detail screens
  • Template entry and detail screens
  • Bulk List entry and detail screens
  • P reference and lookup screens
  • Bank line Billing

Responsibilities:

  • Extraction, transformation and loading were performed using Informatica PowerCenter to build the data warehouse.
  • Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
  • Worked on various transformations such as Aggregator, Upgrade strategy, Router, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Joiner, etc.
  • Development and review of mappings involving extracting data from Flat Files, Oracle sources.
  • Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to improve Performance.
  • Coding on Data Transformation tool.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center
  • Proficient in Toad and UNIX Shell Scripting
  • Extracted data from xml files.
  • Worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, also imported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
  • Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic
  • Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, sequence generator, joiner, aggregate, UDT and expression transformations in extracting data in compliance with the business logic
  • Maintained versions of code and supporting documents in Clear Case (UNIX).
  • Involved in Performance tuning.
  • Involved in deployment
  • Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Identified the errors by analyzing the session logs.
  • Involved in Unit testing
  • Developed Korn shell (ksh) scripts for Informatica pre-session, post session procedures
  • Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
  • Direct Coordination with the clients

Environment: Informatica Power Center 8.6(Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor), Clear Case Tool, Xml Files and Data Transformation Informatica B2B tool

Confidential, Atlanta, GA

Technology Analyst

Confidential Bank is a US based Bank. This is a data warehousing projects involves 150 application systems .ETL Loads the data monthly basis and data is loaded in to target tables through which cognos team can fetch the data and generates reports for the business users for critical decisions.

Responsibilities:

  • Bug fix of reports
  • Server Administration Activities
  • Coordination with of Offshore Team.
  • Sharing the Project Knowledge and Design Steps to Offshore on Daily basis.
  • Having the responsibility to analyze and fix issues in production environment on priority basis.
  • Improving Performance
  • Automation of manual tasks
  • Troubleshooting
  • Job Monitoring
  • Handling Tickets
  • Handling change request from the clients.
  • Analysis
  • Documenting the processes and sharing with team
  • Direct Coordination with Clients and engaging offshore daily basis for assignment of work.

Confidential

Senior Software Engineer

Confidential provides the user with a single place data can be accessed across refineries and from many data sources and load data in to data marts. This project deals with data cleansing and data conversion processes. These converted and cleaned data is then moved to data model (Snowflake data model), which is then finally moved to Reporting Data Model. This project involves Informatica and associated tools along with database Oracle.

Responsibilities:

  • Extensively used all the features of Informatica Versions 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor
  • Created workflows and tasks in Workflow Manager and linked the database through server setup and various other connections. Created users in Informatica, assigned them various permissions.
  • Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
  • Involved in monitoring Informatica jobs/processes using Workflow Monitor
  • Development and review of mappings involving extracting data from Flat Files, Oracle sources.
  • Worked on identifying Mapping Bottlenecks in Source, Target and Mappings to improve Performance.
  • Providing the estimates to the Onsite.
  • Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
  • Coordination with onsite daily basis and working together along with the team.

Confidential

Senior Software Engineer

Confidential OMDS is the result of technologies initiative towards providing its Corporate, Institutional & Retail Finance Clients. It is to develop custom reporting suite based on various systems available within Confidential . The goal of this project is to build a customer –centric data to analyse transactions across sales, marketing and customer relations for the finance division.

Responsibilities:

  • Creation of Packages.
  • Major and Minor enhancements to D2kkForms and Reports.
  • Requirement Analysis and design of reports
  • Writing PL/SQL stored procedures and Functions for data manipulation.
  • Preparation of Detail Design.
  • Configuration controller.
  • Unit Testing
  • Documenting the processes and sharing with team
  • Customer interaction
  • Handling change request from the clients

Hire Now