We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume Profile

Bloomington, IL

Professional Summary

  • 7 years of IT Experience in Data Warehousing, Database Design and ETL Processes in the Test and Production environments of various business domains like finance, Banking, and health care industries.
  • Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using Informatica Power Center.
  • Worked extensively on ETL process using Informatica Power Center 9.x/8.x/7.x.
  • SQL database experience in a high transaction and multi server production environment.
  • Experienced with Informatica Data Quality IDQ and Informatica Data Explorer IDE tools for Data Analyst / Developer.
  • Utilized Informatica IDQ Data Analyst, Developer for dataprofiling and matching/removing duplicate data, fixing the bad data and fixing NULL values.
  • Expert Knowledge of Integration Services SSIS , Analysis Services SSAS and Reporting Services SSRS .
  • Experience in Database Development, Data Warehousing, Design and Technical Management.
  • Good understanding in database and data warehousing concepts OLTP OLAP .
  • Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008.
  • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions and at database.
  • Extensive experience with data modeling techniques, logical and physical database design.
  • Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
  • SQL Server 2008/2005 RDBMS database development including T-SQL programming.
  • Extracted data from File Sources, Relational Sources, XML and COBOL sources using Informatica PowerCenter.
  • Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
  • Worked extensively on ETL process using IBM Cognos Data Manager and Pentaho Kettle.
  • Worked on OLAP Data warehouse , Model ,Design and Implementation
  • Experience in upgrading from Informatica Powercenter 8.1 to Informatica Powercenter 9.1.
  • Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server performance.
  • Used Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files.
  • Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands DBCC .
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
  • In-depth understanding of Data Warehousing and Business Intelligence concept
  • Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
  • Designed, tested, and deployed plans using IDQ 8.5
  • Good knowledge of Master Data Management concepts.
  • Responsible for interacting with business partners to identify information needs and business requirements for Reports.
  • Good Knowledge of Kimball and Inmon data warehouse design approaches and considerations
  • Good understanding of dimensional models, slowly changing dimensions, star snowflake schemas.

Professional Experience

Confidential

Role: ETL Informatica Developer

Responsibilities:

  • Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
  • Developed various Ad-hoc mappings for various business needs.
  • Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
  • Deliver new systems functionality supporting corporate business objectives.
  • Translate requirements and high-level design into detailed functional design specifications.
  • Responsible to tune ETL procedures and schemas to optimize load and query Performance.
  • Interpreted logical and physical data models for Business users to determine common data definitions.
  • Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
  • Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation.
  • Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
  • Used ERStudio to analyze and optimize database and data warehouse structure.
  • Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
  • Used Autosys scheduler to schedule and run Informatica workflows.

Environment: Informatica 9.5, Oracle 11g, UNIX, PL/SQL, Oracle 11g, Embarcadero ERStudio Data Architect, TOAD, Autosys, Putty.

Confidential

Role: ETL Developer

Responsibilities:

  • Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
  • Developed various Ad-hoc mappings for various business needs.
  • Perform Designs and Analysis on business systems applications, systems interfaces, databases, reporting, or business intelligence systems
  • Deliver new systems functionality supporting corporate business objectives.
  • Translate requirements and high-level design into detailed functional design specifications.
  • Wrote stored procedures, functions, and database triggers in SQL Server 2008.
  • Responsible to tune ETL procedures and schemas to optimize load and query Performance.
  • Interpreted logical and physical data models for Business users to determine common data definitions.
  • Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
  • Involved in Data Validating, Data integrity, Performance related to DB, Field Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
  • Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
  • Used ERStudio to analyze and optimize database and data warehouse structure.
  • Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.
  • Facilitate/lead design reviews of functional design with other members of the technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications.
  • Provide SME level guidance to Development and Application support teams during development and deployment phases.

Environment: Informatica 9.1, SSIS, SQL Server 2008, PL/SQL, Transact SQL, Oracle 11g, Embarcadero ERStudio Data Architect, TOAD.

Confidential

Role: ETL Engineer

Responsibilities:

  • Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
  • Developed various Ad-hoc mappings for various business needs.
  • Installing Informatica Powercenter 9.1 and migrating the old processes and codes from previously existent Informatica Powercenter 8.1.
  • Responsible for developing, Testing, support and maintenance for the ETL processes using Informatica Power Center 9.1.
  • Responsible for development of robust and reliable solutions requiring low maintenance, thorough testing of solutions
  • Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts using Cognos 8 BI Data Manager.
  • Delivering metadata to Cognos Framework Manager, to model the target data warehouse and data repositories used in Cognos Business Intelligence.
  • Creating and scheduling jobstreams in Cognos Data Manager to automate the Data Load processes to target Data warehouse.
  • Designed the process to write failed and rejected rows into flat files and tables using Cognos Data Manager.
  • Developed UNIX shell scripts for scheduling sessions in Informatica.
  • Wrote stored procedures, functions, and database triggers in SQL Server 2008.
  • Extensively used SSIS FTP tasks for data transfers from FTP servers to SQL Server.
  • Created SSIS packages to clean and load data to data warehouse.
  • Created SSIS package to transfer data between OLTP and OLAP databases.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
  • Assisted in documenting business requirements for data warehousing and integration needs.
  • Worked extensively with Oracle Applications R12 and Oracle Applications 11.0.3
  • Retrofitted PL/SQL scripts, functions and procedures from Oracle 11.0.3 into the R12 world.
  • Experienced in using the UTL File package in PL/SQL, to develop oracle concurrent request scripts for writing tables into MS Excel Worksheet.
  • Responsible to tune ETL procedures and schemas to optimize load and query Performance.
  • Developed stored procedures using PL/SQL.
  • Developed data transfer and transformation tasks using Pentaho Kettle.

Environment: Informatica Power Center 9.1/8.1, IBM Cognos 8 BI Data Manager, SSIS, Pentaho Kettle, SQL Server 2008, PL/SQL, Transact SQL, Oracle EBS R12, Oracle Applications 11.0.3, Windows XP.

Confidential

Role: ETL Engineer

Responsibilities:

  • Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML. Developed various Ad-hoc mappings for various business needs.
  • Designed, tested, and deployed plans using Informatica Data Quality Suite 8.5
  • Developed and tested all the backend programs, Error Handling Strategies and update processes.
  • Experience in using Normalizer transformation for normalizing the XML source data.
  • Extensively used XML transformation to generate target XML files.
  • Developed Scripts to automate the Data Load processes to target Data warehouse.
  • Worked extensively with Oracle Data Integrator ODI and Oracle Warehouse Builder OWB
  • Responsible to tune ETL procedures and schemas to optimize load and query Performance.
  • Involved with the Architecture group to develop ETL metadata strategies and Informatica objects reuse policies. Developed reusable Informatica Mapplet's and Transformations.
  • Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
  • Involved in production support activities with Installation and Configuration of Informatica Power Center 8.6.
  • Analyzed, Designed and Implemented the ETL architecture and generated OLAP reports.
  • Used Informatica Workflow Monitor to monitor and control jobs.
  • Accomplished data movement process that load data from DB2 into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, and MULTILOAD.
  • Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
  • Created BTEQ and multiload scripts to load Teradata tables.
  • Worked extensively with Teradata utilities MLOAD, TPUMP and FAST LOAD to load data.
  • Wrote stored procedures, functions, and database triggers. Created database triggers on tables to generate surrogate keys.
  • Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
  • Interpreted logical and physical data models for Business users to determine common data definitions.
  • Installation, Configuration and Deployment of Informatica 8.6 with Informatica GRID option.
  • Assisted in documenting business requirements for data warehousing and integration needs.

Environment: Informatica Power Center 8.6, Informatica Data Quality Suite 8.5, Teradata V2R6, Oracle 10g, DB2, TOAD, Erwin 3.5.2, PL/SQL, WINCVS, Windows XP, UNIX, Sun Solaris

Confidential

ETL Developer

Responsibilities:

  • Developed and supported the Extraction, Transformation, and load process ETL for data migration using Informatica power center.
  • Developed Transformation logic and created various Complex Mappings and Mapplets using the designer.
  • Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
  • Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
  • Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
  • Developed mappings, sessions for relation and flat source and targets.
  • Imported data from various sources and transformed and loaded into targets using Informatica.
  • Created and scheduled Session, jobs based on demand, run on time.
  • Monitored Workflows and Sessions.

Environment: Informatica Power center 7.1, Oracle9i, SQL and Windows XP.

Hire Now