We provide IT Staff Augmentation Services!

Informatica Developer Resume

Warsaw, IN

SUMMARY:

  • 7+ years’ professional experience in IT industry with special emphasis on design, development and testing of Database/Data Warehousing applications using Informatica Power Center in various domains like HR, Financial, Health and Retail.
  • Strong experience in Informatica PowerCenter, PowerConnect for ETL (Extraction Transformation and Loading) of data from multiple source database systems in both UNIX/Windows environment.
  • Diversified Domain expertise implementing solutions to Data Warehousing Projects.
  • Practical understanding and experience with Data Mapping, Data Validation and Data Modeling (Dimensional & Relational) concepts such as Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Expertise in normalizing data.
  • Solid experience in Informatica Power Center (versions 10.1/9.6/8.6/ 7.1 ) including Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console and Oracle.
  • Expertise in Oracle,PL/SQL, Functions, Procedures, Packages, Triggers and Materialized Views.
  • Excellent knowledge in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Stored Procedures and Packages.
  • Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts and error record loading.
  • Experienced in RDBMS design, data modeling, data normalization and SQL tuning using Indexes and working with UTL Files.
  • Extensively worked on UNIX/Windowsscripting for creating and maintaining the parameter files, executing database procedures, calling Informatica workflows, and job scheduling.
  • Effectively communicate with business users, Business Analysts, project manager and team members.
  • Strong ability to work within a demanding and aggressive project schedules and environments.
  • Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.
  • Extensive experience in architecting, implementing, maintaining and migrating Data Warehouse projects.
  • Excellent hands of experience in monitoring bug status using Jira and maintaining project documentation using Share Point.
  • Extensively developed the complex stored procedures, functions to maintain and populate the data into the Data marts, EDWH system and OLAP database.
  • Effective, independent and team player and self-starter with high adaptability to new technologies and a penchant to learn new things.
  • Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment.
  • Excellent written and verbal communication skills blended with good analytical reasoning.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/XP,2003/2008 Server, Windows 7, UNIX

Databases: Oracle12c,11g,10g,9i,8i,MSSQLServer 7.0/2000/2005/2008/2012, MSAccess 97/2000/2003, Teradata 13.0/14.0/15.0

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star and Snow flake schema Modeling, Physical and Logical Data Modeling, Fact and Dimensions table

ETL Tools and BI tool: Informatica PowerCenter, Informatica cloud, IDQ, OBIEE 11g.

Languages: PL/SQL, HTML, XML, Shell Scripting, SQL *plus, Windows batch scripting.

PROFESIONAL EXPERIENCE:

Informatica Developer

Confidential, Warsaw, IN

Responsibilities:

  • Created mappings using Designer and extracted sales data from various sources like Flat file, relational sources, XML, Normalized data and transformed data according to the requirement.
  • Created mappings using Informatica Powercenter Designer to extract Medical sales data from various sources like power exchange tables, oracle tables,JDE,flat files,SQL Server etc and loaded to SAP BW (Hana).
  • Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of star schema and snowflake schema.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
  • Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts and error record loading.
  • Worked on the Support to solve the existing Informatica mappings issues.
  • Conducted meetings with onshore business users and business analysts to gather requirements and prepared design/Mapping specification documents for offshore team.
  • Worked extensively with offshore team to prioritize work as per requirement.
  • Wrote SQL queries, PL/SQL programming and Query Level Performance tuning.
  • Moved Mappings, Sessions, Workflows from Development to Test, UAT and Prod environment.
  • Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
  • Attended status meetings with project managers, escalated issues when necessary, attended meetings for issues resolution.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
  • Used parameters/variables for Powercenter mappings, sessions and workflows.
  • Created process documents in case of job failures, and also documented failures to fix repeat issues.
  • Worked with various teams like BSA, DBA, Business users and environment technical leads in case of job failures.
  • Worked on enhancements like adding new columns, updating column data types and lengths both at Database and Powercenter level.

Environment: Informatica Power Center 10.2/9.1.6, Oracle 11g, DT Studio, SQL Server 2008/2005, DB2, Flat Files, Tableau, Python 2, MS Visio, MS Office, PL/SQL (Stored Procedure, Trigger, Packages), UNIX, LINUX, Toad

Informatica Developer

Confidential, Cincinnati, OH

Responsibilities:

  • Created mappings using Designer and extracted HR and Payroll data from various sources like Flat file, relational sources, XML, Normalized data and transformed data according to the requirement.
  • Responsible for Business Analysis and Requirements gathering.
  • Front end used for HR and Payroll processing was Oracle Peoplesoft and Analytical database was Oracle.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Worked with heterogeneous source to Extracted data from Oracle database, XML and flat files and loading to a relational Oracle warehouse.
  • Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
  • Performed tuning of SQL queries and Stored Procedures for speedy extraction of data, to resolve and troubleshoot issues in OLTP environment.
  • Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts and error record loading.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
  • Troubleshooting of long running sessions and fixing the issues related to it. l transformation to generate Flat files dynamically for downstream users.
  • Created UNIX shell scripts to facilitate moving and archiving of files in folder. Also created shell script to dynamically create list file to load multiple flat files into a table.
  • Worked with Variables and Parameters in the mappings to pass the values between sessions.
  • Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system..
  • Developed mapping parameters and variables to support SQL override.
  • Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
  • Worked with Services and Portal teams on various occasion for data issues in OLTP system.
  • Worked with the testing team to resolve bugs in ETL mappings before migrating to production.
  • Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
  • Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
  • Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.
  • Designed Informatica Mappings and Workflows to be re-startable after a failure.
  • Designed tables required for the execution of the ETL processes using Erwin.
  • Extracted data stored in a multi-level hierarchy using Oracle Stored Procedures.
  • Loaded Customer data in multiple levels (rows) using Oracle Stored Procedures and Cursors.
  • Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
  • Loaded Dimension, Fact and Exception tables and automated email generation when exceptions occurred.
  • Provided excellent support during QA/UAT/Beta testing by working with multiple groups.
  • Optimized the SQLs and Informatica mappings which handled millions of records.
  • Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques.
  • Developed re-usable components in Informatica, Oracle and UNIX
  • On-Call/Production Support provided during day-time and off-hours.
  • Actively participated in Install/Deployment plan meetings.
  • Proved accuracy in doing sanity checks, smoke tests after the install of new scripts used by ETL.
  • Prepared Data Mapping documents, process documents, Re-startability Matrix to help on-call team reduce the turnaround time when there is an issue.
  • Efficiently handled multiple projects during resource crunch.
  • Provided Training to the team with the functional and technical knowledge.

Environment: Informatica PowerCentre 10.1/9.6, Workflow Manager, Workflow Monitor, Informatica PowerConnect/PowerExchange, Data Analyzer 8.1, Toad, PL/SQL,SQL loader, Linux, Teradata, Micro Strategy and Tableau.

Informatica Developer/Production Support Analyst

Confidential, Omaha, NE

Responsibilities:

  • Involved in gathering requirements from business users. Participated in the detailed requirement analysis for the design of data marts.
  • Actively interface with other teams to gather requirements, design, code, debug, document, implement and maintain various DB projects.
  • Worked according to the specifications and restrictions of the company by strictly maintaining data privacy.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Designed and customized data models for Data warehouse supporting data from multiple sources.
  • Worked with Informatica Data Quality (IDQ 8.6.1) for data quality measurement.
  • Involved in building the ETL Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Created mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts using existing ETL standards.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
  • Modified existing mappings for enhancements of new business requirements.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories
  • Migrated the codes from Dev to Test and Test to Prod. Wrote the migration documentation in details for system compatibility, object and parameter files for smooth transfer of code into different environments.
  • Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets (command, email, assignment, control, event wait/raise, conditional flow etc.) and configured them according to business logic & requirements to load data from different Sources to Targets.
  • Created Pre & Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on data.

Environment: Informatica PowerCentre, Workflow Manager, Workflow Monitor, Informatica Power Connect/PowerExchange, Erwin, Toad, SQL Developer, Oracle11g, SQLloader, Linux, PL/SQL, Teradata, Micro Strategy and Tableau.

Informatica Developer

Confidential, Dublin, OH

Responsibilities:

  • Extensively involved in requirements gathering, writing ETL Specs and preparing design document
  • Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts
  • Developed code to extract, transform, and load data from inbound flat files and various databases into outbound flat files and XML files using complex business logic
  • Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes
  • Expertise in handling and loading high volumes of data into data warehouse in a given load window
  • Expertise in preparing test strategy, test plan, test summary reports, test cases and test scripts for automated and manual testing based on user requirement documents and system requirement documents.
  • Extensive experience in Data warehouses with strong understanding of Logical, Physical, and Dimensional Data Modeling to Design Star and Snow flake Schemas.
  • Utilized Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
  • Used SCD (type1, type2 and type3) to Load present and Historical Data to ODS, EDW.
  • Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
  • Experience in ETL process using ETL Tools, creating and maintaining Repository, Source systems, Target Databases and developing strategies for ETL mechanisms using ETL tools, Gathering and analysis, design, development, testing, performance tuning, and production support.
  • Experience in Unix Shell scripting, scheduling cron jobs and also Job Scheduling on multiple platforms like Windows NT/2000/2003, Unix
  • Strong technical skills in Oracle, SQL, PL/SQL, MySQL.
  • Worked with architects and DBA in designing the rules engine and implementing the logical, physical and Dimensional model based on the rules and metadata.
  • Responsible for preparing the technical specifications from the business requirements

Environment: Informatica PowerCenter 9.1, Informatica PowerCenter, Workflow Manager, Workflow Monitor, Oracle11g/12c, Toad, Sun Solaris11.1, Visual SourceSafe, SQL, PL/SQL, BO, Unix, AutoSys and Tableau

Hire Now