We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

Dallas, TX

SUMMARY:

  • Oracle and Informatica certified professional with over 10 years of experience in the complete System Development Life Cycle with specialization in Business Intelligence
  • Extensive experience in various technical areas like data analysis, implementation of ETL/ELT processes, enterprise reporting including dashboard development and database performance tuning
  • Expertise in analyzing data and creating Application Implementation Methodology (AIM) documents for development of the project
  • Experience configuring Informatica PWX CDC to achieve near real time data
  • Working experience in Informatica IDQ
  • Expertise in Data Analysis: SQL, Excel (Pivot tables, macros, VLOOKUP, hlookup, statistical functions)
  • Prioritized requirements and created conceptual prototypes and mock - ups
  • Proficient in Oracle Data Integrator 11g and 12c, OBIEE 12c
  • Experience using Various ODI Knowledge modules and Journals for ELT data processing
  • Provided on-call support to business and end-users to resolve any data related issues
  • Strong experience in coding UNIX shell scripts. Extensively coded shell scripts for automating ETL processes and batch processing disparate applications
  • Expertise in multiple Relational Database Management Systems (RDBMS) like DB2, Oracle, Netezza, Teradata
  • Experience tuning Oracle SQL queries for better performance
  • Experience integrating OLTP source data and OLAP architecture
  • Working knowledge in change data capture technologies
  • Strong experience coding SQL queries to obtain maximum performance and tuning database parameters like indexes to improve performance
  • Experienced agile team player: implemented project using agile methodologies
  • Working experience with Big Data and Hadoop File System (HDFS)
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables

SKILL:

ETL Tools: Informatica 9, 10, Power Exchange (PWX), PowerCenter, IDQ, ODI 11g, 12c

Reporting Tools: OBIEE 11g, 12c

Methodologies: Data Modeling, Star Schema, Snowflake Schema

RDBMS: Oracle, Netezza, MS SQL Server 2005, SQL TOAD 7.6, Teradata 13.0

Programming: SQL, XML.

Scheduling Tools: Control m, Autosys, DAC, WLM

Big Data: Ecosystems Hadoop, HDFS, Hive

Operating Systems: SOLARIS, Win XP, 7, 10, MSDOS

Packages: MS Office (Word, Excel, Access, PowerPoint)

EXPERIENCE:

Sr. Informatica Developer

Confidential, Dallas, TX

Responsibilities:

  • Developed Informatica mappings, sessions and workflows as per the business rules and loaded requirements using mapping parameters and variable
  • Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications
  • Generated the ‘|’ delimiter Flat files by using the SFTP to transfer the files from Informatica Server to GreenPlum (Target) Landing Zone
  • Coded as per the mapping documents
  • Unit tested the mappings.
  • Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Web-Service Consumer, Joiner, Stored procedure transformations in the mapping
  • Responsible for requirement gathering analysis and end user meetings
  • Converted functional requirements into technical specifications
  • Worked with joiner functions like normal join, full outer join, master outer join, and detail outer join in the joiner transformation
  • Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell Perl scripts to automate the process
  • Implemented Persistent cache to reduce session processing time
  • Deployed Informatica jobs into testing, validation and production environments
  • Prepared deployment documents, user guides, coding standards, and other technical documents
  • Prepared ETL mapping documents for every mapping and data migration document for smooth transfer of project from development to testing environment and then to production environment
  • Developed mapplets and worklets for reusability

Environment: Informatica 9.5.1, Informatica 10.2, Informatica Power Exchange, Data Quality, PL/SQL, Oracle 10g, SQL Server 2008 R2, Flat Files, UNIX Shell Scripting, CA Autosys 11.3

Senior Informatica Developer

Confidential, Herndon, VA

Responsibilities:

  • Led design/development/implementation/testing of Oracle DWH/Data Marts
  • Processed XML files using Informatica B2B
  • Used the Data Processor transformation to process XML data and create hierarchical output
  • Validated XML hierarchy and file using Altova XML viewer
  • Developed mapping to process data including sourcing, extracting, transforming and loading as per data integration load rules
  • Created profile and load rules in IDQ
  • Implemented SCD Type1, Type2 mappings to capture data changes into target table
  • Prepared business requirement document and technical design document
  • Configured PWX CDC on the source tables and load near real time data
  • Migrated power exchange and verify PWX CDC migration
  • Performed testing and document test scripts for validation
  • Created shell scripts to validate, process and archive source files
  • Facilitated meeting to explain business requirement for code handover to SIT, UAT team for testing
  • Created Autosys job and automate to execute ETL jobs at scheduled time
  • Created business system testing test scripts for unit, system and integration testing for developed code
  • Migrated code to higher environments SIT, UAT using Jenkins for business testing purpose
  • Documented all changes for code hand over to business
  • Coordinated with business, system analyst, product owner to facilitate business requirements meetings and influence decisions

Environment: Informatica 10.1.0, PWX, IDQ, Oracle, Toad, UNIX, Autosys, Jenkins, SVN

Senior Informatica Developer

Confidential, Richmond, VA

Responsibilities:

  • Led design/development/implementation/testing of Teradata DWH/data marts
  • Led the Data Warehouse implementation, operational and strategic planning projects, organizing and allocation of resources
  • Used Power Exchange to source copybook definition and VSAM files
  • Created custom mappings for loading organization data to populate end-point reports
  • Developed extracted, transformed and loaded data
  • Extracted data from multiple Source Systems (Eg. CS90, ACES, FACETS, WMS etc.) and loaded data into EDW
  • Created UNIX shell scripts to pre-process source files for file validation, create list files for indirect data load and execute work flows from Control-M
  • Worked with business team to gather business requirements
  • Created Application Implementation Methodology document and provided to onsite and off-shore team
  • Performed testing and documented test scripts for validation
  • Developed Business User Acceptance test cases and data sets
  • Facilitated business requirements meetings and influenced decisions
  • Documented all changes during the process of implementing and migrating code and made code ready for production deployment
  • Identified bottleneck with existing Data Quality Review Process, negotiated and resolve the conflicts in the process

Environment: Informatica 10.1.0, PWX, Informatica DVO 10.0.0, Hadoop, Teradata, AIX UNIX, Control-M, WLM, Clear Case

Hire Now