We provide IT Staff Augmentation Services!

Sr. Informatica Powercenter/data Quality Developer Resume

Morrisville, NC

SUMMARY:

  • 8 years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for Retail, Healthcare, Financial, Insurance domains.
  • 8 years of experience in designing and development of ETL Methodology using Informatica PowerCenter 9.6.1/9.0.1 /8. x, Informatica PowerExchange 9.6.1/9.0.1, Informatica DataQuality 9.6.1.
  • 8+ years of experience in working with ORACLE 11g/10g, pl/Sql and tuning.
  • 4+ years of Experience in Designing ER&Dimensional Data Models using ERWIN 7.2/4.5, ORACLE Designer.
  • 3+ years of experience in Data Quality, Profiling, Validations, reference check and exception handling using Informatica Data Quality.
  • 2+ years of experience in Bigdata technologies and integration using Hadoop and Hive.
  • 3+ years of experience in Change Data Capture (CDC) Methodology using PowerExchange 9.0/8.x.
  • 4+ years of experience in Teradata Teradata 14/13 sql and utilities like MLOAD, FastLoad, TPT.
  • I nteracted with end - users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.
  • Worked extensively in design and analysis of Requirements, Development, Testing and Production support.
  • Worked on documentation of requirements, Testdata, DatamovementschemaandMapping between applications.
  • Extensive knowledge of Informatica tuning and SQL/PL SQL tuning.
  • Experience in integration of various data sources like Oracle, SQLserver and sequentialfiles into stagingarea.
  • Conducted System, UAT and Functionality testing and investigated software bugs.
  • Created and modified UNIXShell Scripts for ETL jobs.
  • Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.
  • Worked on data integration from various source files such as flatfiles, CSV files, RelationalDatabases etc. into a common analytical DataModel.
  • Production support experience. Extensive understanding of Production issues and Data issues.
  • Excellent communicationskills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills.
  • Working experience in Agile and Waterfall methodologies.
  • Designed and developed complex mappings, mapplets, tasks and workflows and tuned it.
  • Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
  • Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
  • Extensively used Slowly Changing Dimension (SCD) technique in business application.
  • Conducted Unit tests, Integration tests and Customer Acceptance tests (UAT).
  • Expertise in OLTP/OLAP Analysis, E-R modeling and dimension modeling.
  • Developing Database Schemas like Star schema and Snowflake schema used in relational,dimensional and multidimensional modeling.

TECHNICAL SKILLS:

ETL TECHNOLOGY: Informatica PowerCenter Cloud/9.x/8.x/7.x, Informatica PowerExchange 9.x, IDQ 9.x

DATA WAREHOUSE: Star Schema, Snowflake schema and Multidimensional Modeling, Development

DATA MODELLING: MS Visio, Erwin 8/7.1

DATABASES: Oracle 11g/10g, MS SQL Server 2012/7.0/2000, MS Access, Sybase, DB2, MySQL, Teradata 14/13.

PROGRAMMING: C, C++, SQL, PL/SQL, HTML, CSS, UNIX Scripting

TOOLS: Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10gOPERATING SYSTEMS: Windows 98/NT/2000/XP, AIX, Sun Solaris, UNIX, MS-DOS

APPLICATIONS: MS Office, MS Project, FrontPage, Toad 9.2/8.6, Basecamp, Rally

MS: Office 2007, MS Project

BIG DATA: Hadoop, Scoop, Hive, Cassandra, Kafka

PROFESSIONAL EXPERIENCE:

Confidential, Morrisville, NC

Sr. Informatica PowerCenter/Data Quality Developer

Role & Responsibility:

  • Worked with business analyst for requirement gathering, business analysis and testing and project- coordination using interviews, document analysis, business process descriptions, scenarios and workflow analysis.
  • Created Technical Design Document or Minor Release Document (MRD) from business requirements document (BRD) or Functional Requirement Document (FRD) business analyst based on business objectives, facilitated joint sessions.
  • Analyzed business and system requirements to identify system impacts.
  • Created flow diagrams and charts.
  • Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, Database changes, shell scripts etc. and conducted meetings with the business analysis, clients for the Approval of the process.
  • Analyzed the existing mapping logic to determine the reusability of the code.
  • Handled versioning and dependencies in Informatica.
  • Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
  • Translated the PL/SQL logic into Informatica mappings including Database packages, stored procedures and views.
  • Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
  • Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
  • Created UNIX scripts to read/write and ftp files from and to windows servers and UNIX.
  • Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.
  • Performing ETL & database code migrations across environments using deployment groups.
  • Populating the business rules using mappings into the target tables.
  • Involved in end-to-end system testing, performance and regression testing and data validations.
  • Worked extensively on modifying and updating existing oracle code including object types, views, PL/SQL stored procedures and packages, functions and triggers based on business requirements.
  • Worked in agile minor release cycleas the designated database developer.
  • Unit test and support QA and UAT testing fordatabase changes.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production.
  • Help support Data masking projects for DRD for all Dev, QA and UAT environments via Enterprise Data Obfuscation.
  • Build creation, verification and deployment to QA and UAT using Transporter.
  • Created batch scripts for automated database build deployment.
  • Extensively worked on Teradata

Environment: Informatica PowerCenter 9.6.1/Cloud/BDE, Informatica Data Quality 9.6, Oracle 11g, pl/sql Developer, Teradata 14, Tecticia Client, Putty, SEAL, Subversion(SVN), JIRA, Transporter, ServiceNOW(SNOW), Enterprise Data Obfuscation(EDO), ALM Explorer

Confidential, Los Angeles, CA

Informatica Developer

Role & Responsibility:

  • Gathered report requirements with BusinessUsers and converted them into projectdocumentation.
  • Arrived at the dimension model of the OLAPdata marts inERwin.
  • Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQLQueries, Sources, Targets and sessions.
  • Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
  • Maintain Development, Test and Production mapping migration Using Repository Manager. Alsoused Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.
  • Worked on System Analysis & Design of process/data flow.
  • Worked on Teradata SQL and Utilities like MLOAD, FASTLOAD.
  • Populating the business rules using mappings into the target tables.
  • Translated the PL/SQL logic into Informatica mappings. Extensively Worked on Database stored procedures and views.
  • Configured Informatica Real time workflows to capture CDC.
  • Locate data rapidly with flexible object filtering techniques to reduce errors and speed development with a point-and-click interface using PowerExchange.
  • Created Informatica PowerExchange Data Map and Registration on Mainframe source files and tables and importing them to Informatica shared folder.
  • Used Workflow manager to create and configure workflow and sessiontask to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
  • Implemented optimization techniques for performance tuning and wrote Pre& Post session shell scripts.
  • Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
  • Involved in end-to-end systemtesting, performance and regressiontesting and data validations.
  • Worked on Data Extraction, Transformations, Loading, Data Conversions and Data Analysis.

Environment: Informatica PowerCenter 9.5/9.1, Power Exchange 9.5/9.1, Teradata 13, Oracle 11g, Erwin 8, Putty, Sun Solaris. Rally, Basecamp, WinSCP, and SCM, Netezza.

Confidential, Miami FL

Informatica Developer

Role & Responsibility:

  • Designed and developed mappings, mapplets and sessions from source to target database using Informatica PowerCenter.
  • Worked with various file formats like fixed length and delimited.
  • Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
  • Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
  • Extensively used Informatica to transfer data from different source system and load the data into the target database.
  • Extracted the data from the flatfiles and other RDBMS databases into stagingarea and populated onto Data Warehouse.
  • Developed number of complexInformaticamappings, mapplets and reusabletransformations to implement the business logic and load the data incrementally.
  • Used Debugger to track the path of the source data and to check the errors in mapping.
  • Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and facttables in the Data Warehouse.
  • Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter and source qualifier and data flow management into multiple targets using router transformations.
  • Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better sessionperformance.
  • Document the process for further maintenance and support. Worked on test cases and use cases.

Environment: Informatica PowerCenter 8.6, SQL Server 2008, Oracle 11g, UNIX, Sun Solaris, Harvest, Remedy, Jira, Putty, Winscp, BaseCamp, Erwin 8.5, Toad.

Confidential, MO

ETL Developer

Role & Responsibility:

  • Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
  • Designed and developed complex mappings using Mapping Designer to load data from various sources.
  • Extensively created mapplets for reusable business rules.
  • Used Pipelinepartitioning and ExternalLoader to improve Sessionperformance, createdindicatorfiles for event drivensessions.
  • Used the updatestrategy to effectively load data from source to target.
  • Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
  • Created tasks, workflows and worklets using workflowmanager.
  • Used pmcmd to run workflows and Autosys to automate their schedules.
  • Involved in identifying bugs in existingmappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
  • Handled Incrementalloading using mappingvariables and Implemented versioning of folders in the Informatica Designer tool.
  • Used Parameter files to specify DB Connection parameters for sources.

Environment: Informatica Power Center 8.1, Business Objects XI, Oracle 10g, PL/SQL, SQL*Plus, SQL Server 2000, XML files, UNIX Shell Scripting, Windows NT/2000. Teradata V2R6.

Hire Now