Informatica ETL Developer Resume Samples

Proper data storage is highly vital for any business, and hence an Informatica ETL Developer is hired to handle this crucial task of processing, designing, and storing documents. While specific duties and responsibilities vary based on the requirements of the industry, there are several core tasks that are common and included on the Informatica ETL Developer Resume as follows – analyzing database models and requirements, reviewing data storage and access procedures; providing solutions for data issues; developing data warehousing systems using appropriate Informatica software tools; troubleshooting issues; developing technical documents for Informatica systems; and performing data cleansing procedures if needed.

While duties can vary, the required skills are common and include – solid knowledge of computer programming, coding, and various operating and database systems; the ability to quickly develop data warehousing systems, and strong creative skills. While a degree in computer science is mandatory, possessing a professional certification in Informatica will be useful.

Informatica ETL Developer Resume example

Informatica Etl Developer Resume

Objective : Over 7+years of experience in Information Technology with a strong background in Database development and Data warehousing and ETL process using Informatica Power Center, Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.

Skills : MS Office, Management.

Description :

    1. Ysed by the entire organization to manage the business and automate back office functions.
    2. Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
    3. Built the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
    4. Worked with Functional Managers / BA's / End Users to gather reporting requirements to implement business logic for successfully implementation of reporting system to satisfy the needs of Business Units and Supplier Partners.
    5. Experience with Erwin in performing data modeling on the Data warehouse.
    6. Involved in Installation, Configuration, and Deployment of whole BOXI R3.1.
    7. Created reports containing all the information regarding the publishers, distributors and retailers using BOXIR2 and Crystal Reports XIR2.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelor's


Sr. Informatica Etl Developer Resume

Summary : Ten Plus (10+) years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation. Implementation of Warehousing and Database business systems Eight Plus (8+) of strong Data Warehousing experience using Informatica PowerCenter (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart [] Power Connect, Power Connect for Siebel, IDQ, IDE, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, Star Schema, Snowflake Schema, Autosys, Control M, Maestro, Trillium 7.

Skills : Developing, Management.

Description :

    1. Serves as global institutional, corporate, government and individual clients in its role as a financial intermediary.
    2. Responsible for Data from different sources should be brought into Oracle using Informatica ETL tools like power center and power mart.
    3. Loads data used to generate reports using Business Objects.
    4. Installs and Configures of Informatica PowerCenter 6.2/5.1 in Windows environment.
    5. Configures and Implementes Security features on different domain folders by giving appropriate privileges Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
    6. Creates Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 3.5 Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
    7. Tunes performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors


Jr. Informatica Etl Developer Resume

Objective : complete intermediate end to end engineering tasks for specific system assignments including developing, Informatica Etl Developer analyzing, configuring, testing, debugging, troubleshooting, documenting, health monitoring/alerting, and implementing based on user or system design specifications, as well as participating in troubleshooting, conducting impact analysis and escalating appropriately.

Skills : Management, Organizing.

Description :

    1. Understood the requirements and data mapping documents.
    2. Prepared high-level mapping design documents from requirements.
    3. Created mappings for Initial, Daily loads, Base table and functional table loads.
    4. Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
    5. Developed mappings for Audit reconsolidation of daily loads.
    6. Worked with Informatica power center 9.5 to extract the data from IBM Mainframes DB2 sources into Teradata.
    7. Used Director Client to validate, run, schedule and monitor the jobs that are run by the IBM InfoSphere DataStage server.
    8. Configured various third-party tools, technologies with IBM Infosphere Information Server software.
    9. Used ETL methodologies and best practices to create Talend ETL jobs.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Informatica Etl Developer I Resume

Objective : Solid experience in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modelingusing Erwin 4.0 Six Plus (6+) years' experience in Relational Databases like Oracle, MS SQL Server, Sybase, MS Access, IMS Data, SQL, PL/SQL, TOAD, SQLPlus, Linux, UNIX Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.

Skills : Management, Organizing.

Description :

    1. Provides the backbone Information Technology support to the XL Capital group of companies, a leading provider of insurance and reinsurance coverage, innovative risk management and financial solutions.
    2. Provides financial solutions, XL Global Services Inc.
    3. Generates various reports for presenting a comprehensive Credit and Risk analysis for its customers.
    4. Designs to develop and maintain Data Marts.
    5. Uploads the data from various centers with the data in different systems using ETL Tools.
    6. Involves with the Business Analysis team in collecting the business requirements based on user specifications and transformed them into ETL Specs.
    7. Works on ODS/Staging environment in Data ware house projects and created Design/Technical documents.
    8. Fine Tunes the SQL queries using hints for maximum efficiency and performance.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Informatica Etl Developer II Resume

Headline : 8 years of strong Data Warehousing experience using InformaticaPowerCenter 9.x/8.x(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer). Worked with Netezza database to implement data cleanup, performance-tuning techniques. Extensive experience in Banking, Insurance, Pharmacy, Financial, Retail, Logistics and Healthcare domains.

Skills : Management, Organizing.

Description :

    1. Worked extensively with business analysis team in gathering requirements.
    2. Converted Functional specifications to Technical specifications.
    3. Used Informatica power center for extraction, transformation and loading data from heterogeneous source systems.
    4. Good knowledge in data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables Successfully sourced mainframe data into Oracle Data Warehouse using Informatica Power Center 9.1 Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
    5. Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
    6. Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, and MultiLoad).
    7. Developed and supported the extraction, transformation and load process (ETL) for a Data.
    8. Used Teradata client tools Queryman and WinDDI for running Ad-hoc query accessing tables Used loading utilities (Mload, Fast Load, Tpump) to load the data.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Informatica Etl Developer III Resume

Summary : Over 7+ years of combined Industry Experience as an ETL Developer in designing, developing and implementing ETL processes for business applications. Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.

Skills : Informatica, ETL, SQL Server.

Description :

    1. Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
    2. Developed data conversion/quality/cleansing rules and executed data cleansing activities.
    3. Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5.
    4. Involved in integration of heterogeneous data sources like, Salesforce, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
    5. Performed analysis, design, development, and configuration functions as well as define technical requirements for assignments of intermediate complexity.
    6. Participated with team to perform analysis, assessment and resolution for defects and incidents of intermediate complexity and escalate appropriately.
    7. Worked within guidelines set by team to independently tackle well-scoped problems.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor's

Asst. Informatica Etl Developer Resume

Objective : Informatica Etl Developer is responsible for leading and building data modernization and transformation solutions. Informatica Etl Developer will work with technical leads, database administrators, and database developers to provide recommendations and solutions for like-for-like data migrations at scale,

Skills : Management, Organizing.

Description :

  • Prepares trial runs of programs and software applications as directed to confirm that the desired information and instructions are produced.
  • Participates in database programming, performance tuning, relational model analysis and data migration.
  • Executes appropriate changes as directed by the application manager and recheck the program to ensure that the desired results are produced unit test and deploy ab initio components and miscellaneous technical components as directed.
  • Writes ab initio code to maintain current functionality and development and adhere to performance optimization, interoperability standards and requirements and compliance with client's governance policies.
  • Assists in the development of technical design documents, use cases, test cases, and user manuals for various projects.
  • Conducts bug fixing, code reviews, and unit, functional and integration testing. Using workflow charts and diagrams rewrite programs as directed.
  • Assists in the revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements as identified by the application manager.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Associate Informatica Etl Developer Resume

Headline : Around 8 years of professional experience in IT Industry in Development and Implementation of Data Warehouse applications. Extensive experience in design and development and testing ETL methodology for supporting data transformations and processing in a corporate wide environment using Informatica, TOAD, Erwin, Clear Case Coordinate and managed the end to end project delivery Responsible for guiding the planning, tracking and day-to-day activities Experience in Agile project.

Skills : Management, Organizing.

Description :

    1. Responsible for the data migration track that will be required to migrate GSM Data from Kolkata, Chennai and Coimbatore Centers into COTS suite of Products at Gurgaon.
    2. Responsible for the scope of the Data Migration (DM) Project is to migrate the CRM, Billing, Pre-Paid, Interconnect, Order Management and IDAM data from the existing circles into Siebel CRM, Kenan Billing, Telarix Interconnect and ODS Application Systems of Gurgaon Data Center.
    3. Identifies the primary source systems for migration into CRM, Billing (Finance).for ROTN circle.
    4. Migrates the Billing(Finance) data Attribute level mapping from source to target systems.
    5. Designs mappings in Informatica to load the target.
    6. Incorporates Filters, expression, lookup, source qualifier, union transformation etc.
    7. Handles fallout data from the upload process.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
B.Tech

Lead Informatica Etl Developer Resume

Summary : Perform various activities including requirements gathering, solution development and the project implementation throughout the phases of Agile methodology; Design and implement of ETL process which is to convert data sources into an industry standard based data repository known as OMOP

Skills : Management, Organizing.

Description :

  • Assumes primary developer role for projects as designated by supervisor.
  • Assists the project manager in the coordination of project plan activities.
  • Ensures timely and effective communication between all members of the project team regarding daily status and issues.
  • Prepares goes live and sign off documents and processes.
  • Provides daily support for existing ETL solutions, including modifying, testing, validating, and documenting system changes. Adheres to normal change control processes for these activities.
  • Responsible for Day to day system administration of various integration tools including performance tuning, system monitoring, problem investigation, and application upgrades.
  • Proactively identifies process and procedural issues and suggests potential solutions and engages teammates or other teams as required.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

Informatica Etl Developer Resume

Objective : Over 7+ years of experience in IT industry including 6 years of expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications, Informatica Master Data Management, Data Quality and Data integration. Strong DWH & ETL experience in Informatica Power Center development, design, process and best practices experience as ETL Analyst and Developer in US.

Skills : MS Office, Management.

Description :

    1. Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
    2. Used ETL (Informatica) to load data from source to Data Warehouse.
    3. Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplets Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
    4. Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
    5. Used Informatica repository manager to backup and migrate metadata in development, test and production environments.
    6. Worked with mapping wizards for slowly changing dimensions and slowly growing dimensions by using Informatica mapping designer.
    7. Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
    8. Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
    9. Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance in the existing sessions.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelors