We provide IT Staff Augmentation Services!

Sr. Etl Developer Resume

Irvine, Ca

SUMMARY:

  • 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 and IDQ , 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 andTroubleshooting 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) usinginformatica 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

Confidential, Irvine, CA

Sr. ETL Developer

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

Responsibilities:

  • Extraction, transformation and loading were performed using InformaticaPowerCenter 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, alsoimported and created Source Definitions using Source Analyzerand Target Definitions using Warehouse Designer.
  • Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stFored 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 andMappings 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

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

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

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