We provide IT Staff Augmentation Services!

Senior Etl Informatica Developer Resume

New Jersey, NJ

PROFILE:

  • Seasoned IT professional with proven technical skills. More than 13 years of experience in information technology, with specific focus on Data Architecture, Data Modeling, Data Conversion, Testing, design & implementation of large scale data warehouse, creation of data marts on various databases & operating systems.
  • Proficient in Informatica PowerCenter 9x/8x security, general administration & upgrades. Extensive exposure to Informatica client/server installation procedure, updates and performance tuning.
  • Extensive exposure to data extraction, conversion & loading from various sources including flat files, Oracle & SQL Server, DB2, Syndicated File System (IMS) and, SWIFT, HL 7 and EDI-X12 flat files. Adherence to and compliance of Business rules like HIPAA and SOX.
  • Data warehousing concepts, star-schema & snowflake design (Inmon and Kimball), ETL & BI processes.
  • Hands on experience in all aspects of software development life cycle (SDLC), including process flow diagram and process designing experience with UML. Well versed in testing (like Unit, Integration, System and Performance testing).Excellent communication and interpersonal skills, ability to coordinate and motivate team members. Ability to conceptualize, document and communicate project ideas and plans.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9x/8xPower Connect and Power Exchange, Power Mart 6.x/5.1, PowerCenter Data Analyzer Mart 6.x/5.1, SQL Server 2005 Integration Services (SSIS).SSRS

Data modeling Tools: Erwin 4.2, Dimensional Data Modeling, Star Schema Modeling, snow-Flake Modeling, Fact and Dimensions Tables.

RDBMS: Oracle 10g/9i/8i, SQL Server 2005, Teradata,DB2, Flat files, XML and MQ COBOL Files

Web Technologies: HTML, Java, JavaScript, Oracle MapViewer,JDBC, XML, XHTML,Web services, Dataflux

Programming Languages: SQL, PL/SQL and Shell Scripting.

Data Warehousing Methodologies: Dimensional modeling - Star schema, snow flake schema

Reporting Tools: COGNOS, Crystal Reports2008/XI R2, OBIEE 10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Oracle BI Services, Oracle CRM on Demand.

Other Tools & Utilities: SQL * plus, Toad , SQL Server2005 SSIS, MS SQL Server Reporting Services (SSRS), AutoSys, Microsoft Visio, Clear case, Text Pad

Languages: SQL, PL/SQL, TSQL

Scripting Languages: Shell Scripting, Perl Scripting

Operating Systems: Windows 2008R2/XP/NT, UNIX (Sun Solaris, Linux, HP-UX), AIX

WORK EXPERIENCE:

New Jersey Confidential

Senior Informatica Admin/Architect

  • Setup of Informatica Environment and its upgrade.
  • Sandbox testing of the tool
  • Keep the Informatica service up and running for Dev., TEST and Production environments.
  • Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
  • In case of a job failure on the Informatica side, notify the user groups and work with them to rerun the job and ensure the completion of the load.
  • Coordinate with different administrative services (like DBAs) for the upkeep of the environment.
  • Create and maintain user accounts and folders for all the new projects who want to use the services of the group.
  • Help projects in setting up the Informatica environment with us.
  • Help the project in their design documents for the ETL process.
  • Consult the project for the ETL Best Practices.
  • Coordinate with different business groups for their resource needs and help them in design & development of the project.
  • Work with the project group to identify the process bottlenecks and helping the Project to an amicable solution.

Environment: Informatica Power Center 9x Informatica Power Exchange 9.1HF4, Oracle 11g, PL/SQL, AIX 6.1, CA DATACOM, OZ/390.

Confidential
Wilmington, DE
Senior Informatica Admin/Architect
  • Involved in gathering and reviewing business requirements. Involved in Designing the specifications, Design Documents, Data modeling and design of data warehouse.
  • Resolved the issues Remedy Tickets on Priority basis.
  • Creating SR to Informatica Inc- related to any Power center Suite product issues.
  • Performed Upgrading Informatica Power center Version 8.x to Informatica Power center 9.X and moving to different MetLife Data Centers. Created SOPs, SLA and IQ/OQ process and documentations.
  • Setup of B2B Environment for the processing of HIPAA, SWIFT, HL 7 and EDI-X12 type of files.
  • Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
  • As per Fulfillment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain systems.
  • Maintain all necessary updates and patches for the ETL environments.
  • Creates and maintains all databases required for development, testing, education and production usage.
  • Involved in the capacity planning requirement to create and maintain the databases.
  • Monitoring the Jobs and sever space availability and CPU Process.
  • Preparing Procedures for related Informatica issues.
  • Created Logical & Physical models and used ERwin for data modeling and Dimensional Data Modeling.
  • Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
  • Modeling and populating the business rules using mappings into the Repository for Meta Data management.
  • Involved in the development of Informatica mappings and also performed tuning for better performance. Schedules Informatica B2B Data Transformation.
  • Designed and developed sophisticated workflows and data transformations involving Informatica B2B components DX (Data Exchange) and DT (Data Transformation).
  • Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools.
  • Converting unstructured data into an XML format. Used DTs to build platforms, scheduled the workflows with DT tool.
  • Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
  • Developed the production support technical documents.
  • Conduct status meetings with project managers, escalate issues when necessary, conducting meetings for issues resolution
  • Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and developers to analyze system requirements, design and develop software applications.
  • Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
  • Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
  • Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns. New development and support task responsibilities.
  • Environment: Informatica Power Center 9x/8.6, Power Exchange, B2B ,MFT ,DT,AS400, SQL 2008 R2, SQL 2005, Erwin 4.0, SQL, PL/SQL, T SQL ,TOAD, Active Batch, Power Shell, COGNOS 8.5.
Confidential
Rochester, NY
Senior ETL Informatica Developer

Responsibilities:

  • Responsible for gathering Business requirements and translate into technical requirements.
  • Involved in translating the functional requirements into technical mapping specifications and leveraged Informatica Power Center 8.6.1 to extract the data from AS/400 DB2 files, Oracle tables and flat files to populate billing, service order and plant interface files, which are then loaded into the inhouse DPI Billing system.
  • SQL*Loader scripts for bulk data loads to Oracle tables and extracting Oracle dumps from Verizon.
  • Experienced in writing Queries against DB2 on AS400 Environment.
  • Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
  • Expertise in debugging and production support.
  • Experience in writing Shell scripts for file manipulation, extraction and execution of Workflows
  • Extensive use of the STRSQL, AS/400 Query facilities in AS/400 and execution of SQL queries using PL/SQL Developer 7.1.0 and also used SQL Loader efficiently to load large volumes of flat file data.
  • Developed mappings/sessions using Informatica Power Center 8.6.1 / Power exchange 8.5.1 for data loading.
  • FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Perl/Shell Scripts. XML/flat file formats also extracted successfully.
  • Responsible for managing Informatica Services like Repository Service, Integration Services, etc.
  • Designed and developed error handling and rekey mechanism in Informatica
  • Monitored daily loads and provided on call production support (L2) during data Loads.
  • Creating Change Control Requests as required by assigned projects and ensuring end to end extensive support as Data Analyst and address overall data quality, including the design of ETL strategies to source, match a Merge from various disparate systems.
  • Installation & configuration of Informatica services for 64 bit OS.
  • Created repository & assigned grants to users to access the repository.
  • Experienced in creating xsds and landing XML extracts.

Environment: ETL/Informatica PowerCenter 8.6.1/8.5.1 , Informatica Power Exchange 8.6, Oracle 11g, PL/SQL, Telecordia,XML,Flat files, UNIX, Toad, SQL Developer, VSAM, CSV, XML files,AS400, DB2, Perl,Shell Scripting.

Confidential
Frazer, PA.
Job Title: Administrator / Lead Informatica Developer

Responsibilities:

  • Setup of Informatica Environment and its upgrade.
  • Sandbox testing of the tool.
  • Setup of Best Practices & Standards in line with Cephalon, Inc. and Velocity methodology
  • Keep the Informatica service up and running for Dev., TEST and Production environments.
  • Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
  • In case of a job failure on the Informatica side, notify the user groups and work with them to rerun the job and ensure the completion of the load.
  • Coordinate with different administrative services (like DBAs) for the upkeep of the environment.
  • Create and maintain user accounts and folders for all the new projects who want to use the services of the group.
  • Help projects in setting up the Informatica environment with us.
  • Help the project in their design documents for the ETL process.
  • Consult the project for the ETL Best Practices.
  • Coordinate with different business groups for their resource needs and help them in design & development of the project.
  • Work with the project group to identify the process bottlenecks and helping the Project to a amicable solution.
  • Developing Informatica codes for different business groups within the company.
  • Unit and Integration testing of the Informatica workflows, jobs/processes.
  • Working in different Projects (ASRS, CCO, CONCUR,ACR) from the scratch and was involved in the SDLC Process.
  • Worked ODS and moved data to Oracle data marts.
  • Conversion process by extracting data from SQL Server and loading it into Oracle tables according to business logic and FDA regulations/guidelines.
  • Involved with DBA in discussing building tables and schemas according to the technical and functional requirements.
  • Created mapplets for Audit fields so that they could be used in all the conversion mappings for row inserts and row updates.
  • Converted stored procedures and triggers which were used in the SQL Server into ongoing ETL codes/processes.
Confidential

West Point, PA.

Job Title: ETL Administrator/ Team Lead

Responsibilities:

  • Keep the Informatica service up and running for Dev., QA, IT and Production environments.
  • Monitor the production jobs at regular intervals to ensure smooth running and proper completion of the jobs.
  • In case of a job failure on the Informatica side, notify the user groups and work with them to rerun the job and ensure the completion of the load.
  • Maintain the Informatica environment and support the project groups in moving their jobs to Production after the development and testing are completed.
  • Coordinate with different administrative services (like DBAs, Mainframe Admins, and Unix Admins) for the upkeep of the environment.
  • Install and implement the upgrades available for the environment as needed for things like Oracle upgrade, UNIX O/S upgrade or Informatica version upgrade and Detail Driver upgrades after proper testing.
  • Create and maintain user accounts and folders for all the new projects who want to use the services of the group.
  • Help projects in setting up the Informatica environment with us.
  • Help the project in their design documents for the ETL process.
  • Consult the project for the ETL Best Practices.
  • Coordinate with the projects for their resource needs and help them in recruitment and development of an ETL Developer.
  • Work with the project group to identify the process bottlenecks and helping up the Project to a resolution.
  • Participate in the bi-weekly staff meetings to review the status of the group.
  • Help the management in the initial technical talks with the prospective project groups and workout a plan for the initiation of the project.
  • Participate with the DBAs in finalizing the Data Warehouse Architecture and Data Modeling.
  • Preparation and documentation of Merck SLC for Informatica (ETL) environment.
  • Approving of the IRDs.
  • Created On-Demand, Cached and Real-time reports.
  • Hands on experience on Dashboards, Indicators and Filters.
Confidential

Dublin, OH
System Administrator/Sr. ETL Developer

Responsibilities

  • Created custom tailored reports for our esteemed customers.
  • Extracted source from Teradata and written to flat files according to RDD and FTP’d to the customer.
  • Written SQL Overrides to filter records according to customer needs.
  • Created parameter and variable mappings to run the custom generated mappings according to the RDD.
  • Written UNIX Scripts to FTP custom reports to the customers automatically crossing the Firewall of Cardinal Health after they are scheduled to run.
  • Used Post Session commands to execute Shell Scripts and to write the output file to .CSV, .TXT according to the RDD and to create header and to append it the output file.
  • Did uniting testing on Teradata SQL Assistant to verify if the session output matches with the sql query result.
  • Did customer support work for the custom reports running in Production.

Environment: Informatica PowerCenter 6.2/6.1, Oracle 9i, Teradata 6.1, Flat Files, HP-UX, Windows XP

Confidential

Jessup, Maryland.
Job Title: System Analyst

Responsibilities:

  • Developed New Product Module. This module enables users to enter information through HTML forms, which will call Servlets to store data in database.
  • Dealt with enhancement and customization of User Authentication Module by integrating custom authentication rules with the existing application.
  • Involved with content customization. Customization is achieved through maintaining the information in properties files. JSP files will pick up the information from these files.
  • Involved in testing.
  • Involved in reporting and fixing of bugs.
  • Created Point of Sale (POS) interface using VB6.0 as front end and Access database as backend.
  • Created and maintaining Inventory Management System.

Environment: JSP, Servlets, Java Beans, Java Scripts, JRUN 3.0, MS Access 2000, ORACLE 8i, SQL Server, Windows NT 4.0, Sun Solaris.

Hire Now