We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

SUMMARY:

  • 8+ Years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process, Business Intelligence using Informatica Powercenter and Siebel CRM experience working in Siebel ePharma, Siebel Call Center, Sales and Service applications.
  • Certified PowerCenter Data Integration 10 Developer Specialist.
  • Experience in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Developed mappings in Informatica to load the data from various sources into the Data warehouse different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
  • Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using Oracle PL/SQL
  • Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
  • Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
  • Experience in design and implementation of data migration and interface routines using Siebel EIM (Enterprise Integration Manager) and Informatica.
  • Strong knowledge and experience in developing Configuration (ifb) files and EIM jobs with working knowledge in SQL, PL/SQL and UNIX.
  • Worked extensively in encompassing the different phases of a project life cycle which includes the requirement analysis, design and development, testing and deployment of applications in Pharma domain.
  • Understand the customer requirements and the end to end functionality. Attend scrum calls.
  • Well Experienced in Customizing Siebel Applications using Siebel Tools.
  • Experience in doing System Integration Testing, Regression Testing, Unit Testing and involved in writing the Test Cases for the same.
  • Addressing adhoc business requests based on the priority.
  • Experience in Production Support including deployment and migration activities from Development through Testing in Production environment.
  • Analysis of production issues and providing timely resolution routed by L1 and L2.
  • Excellent verbal and written communication skills, ability to deal with people, willingness to learn more.

TECHNICAL SKILLS:

Database: Oracle 9(SQL, PL/SQL)

Tools: Remedy, TIMS

Database Tools: SQL Navigator, TOAD, SQL Developer

Prog. Languages: C, C++, Java, Visual basic6.0 and COBOL.

Scripting Languages: Vb Script, Java Script and UNIX Shell Script.

ETL Tools: Informatica 9.1, Informatica 9.6, Informatica 10

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica Developer

Responsibilities:

  • Developed Informatica workflows for Audit Trail report for Siebel Call Center application and also created Informatica workflows for Login Reporting for SCC application.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
  • Extracted data from other system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
  • Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
  • Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
  • Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
  • Performed Unit testing and maintained test logs and test cases for all the mappings.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Worked with filter transformations and flat files to identify source and target bottlenecks
  • Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation
  • Used Oracle to write SQL queries that create/alter/delete tables and to extract the necessary data
  • Used UNIX to navigate around the system and check for specific files, the files’ content, file name length, decode and encode the files.
  • Supporting two new systems Advanced quality manager (AQM) and MyPRB. AQM is the system which records the customers calls and screen navigation. MyPRB is the system where advocates create the flyers about the product. Before releasing a flyer it goes through multiple stages and each step is recorded in MyPRB system.

Confidential

ETL Informatica Developer

Responsibilities:

  • Loading Call plan data for every POA for every Fieldforce and providing the support after go live.
  • Developed the Informatica Mappings by usage of Aggregator, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Identified problems in existing production data and developed one time scripts to correct them.
  • Attending client meetings, participating in status calls, providing regular status update to the client.
  • Analysing the business requirements, impact of mentioned issues in business and communicating with client to share business knowledge, issues and data loading and testing of different modules.
  • Monitoring daily interface runs, performing impact analysis, identification of issues and resolving them as required.
  • Providing technical support for any data related change as requested by client.
  • Writing Siebel EIM Routines, IFB files for migrating data to the Siebel base tables in Siebel database. It also includes writing EIM scripts, VB, Java bean program and queries in SQL and PL/SQL.
  • Performing unit testing, regression testing and system testing of various modules, as required.
  • Preparing design document, unit testing documents for the new changes.
  • Maintaining interface agreement document for one stop shop.
  • Created and maintained the documents for call plan load process.
  • Developing new interfaces, routines and batch files for the various data tasks required during enhancements and new releases.
  • Creating test data and unit testing for different test scenarios as part of implementing change requests (CR) and/or working on Ad-hoc requests (AR).
  • Procuring approvals from client on new changes, enhancements and defect or problem solution implementations.
  • Performing analysis, designing, development and testing of the newly created interfaces. It concerned designing and developing mappings in Informatica, writing codes, batch files, .IFB files and SQL routines, creating test data and unit testing of the new interfaces.
  • Prepare and provide reverse knowledge transfer session to application development team to confirm understanding of newly developed section.
  • Working on tickets to ensure support to end users.
  • Coordinating between onshore and offshore teams.
  • Mentoring new team members, guiding them on their jobs and conducting knowledge transfer sessions.

Confidential

Siebel Backend and ETL Informatica Developer

Responsibilities:

  • Developed ETL programs using Informatica to implement the business requirements.
  • Communicated with business customers to discuss the issues and requirements.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Used Informatica file watch events to pole the FTP sites for the external mainframe files.
  • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
  • Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Effectively worked on Onsite and Offshore work model.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
  • Developed scripts to qualify and validate (Pre Processing) the data and move data from staging tables to Siebel EIM tables. Involved in Scripting IFB files, CTL files and SQL scripts for data migration. Involved in Post Import analysis for errors, rejects and re-importing.
  • Created Unix jobs to insert data to Siebel EIM tables. FTP the flat file to Dialer location using unix shell script. Worked on the entities like service request, opportunity, Acitivity, invoices and revenues.
  • Used explicit cursors to fetch the data and perform data manipulations before inserting to EIM tables.
  • Prepared the EIM jobs integrating with the external system for bulk import of data.
  • Implementing Change Requests (CR). Performing application testing in SIT and UAT during the releases. Attending the scrum calls with the business.
  • Worked with production services and operations team to schedule the jobs. Prepared the documents for scheduling the job with the frequency, duration, table details are mentioned.

Confidential

Informatica & Siebel Developer/ Production support analyst

Responsibilities:

  • Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
  • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
  • Involved in extracting the data from the Flat Files and Relational databases into staging area.
  • Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
  • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Prepared Technical Design documents and Test cases.
  • Involved in Unit Testing and Resolution of various Bottlenecks came across.
  • Implemented various Performance Tuning techniques.
  • Used Teradata as a source system
  • Creation and modification of the control files to load the data to EIM and staging tables in Siebel database. Worked on entities like opportunity, product, asset and revenue.
  • Worked on complex SQL queries using inner and outer joins to extract data from Siebel database and move it to SFDC.
  • Providing technical support for any data related change as requested by the client. Executing all data related tasks into Test and Production Environment.
  • Preparing IFB files for migrating data to the Siebel base tables in Siebel database.
  • Experience in taking spool files and tuning the Sqls. Monitoring and fixing the bugs in the existing interfaces to ensure proper loading of data.
  • Monitoring the Remedy Tickets on regular basis. Analyse and provide the resolutions for the tickets raised by the customer in Remedy.

Hire Now