We provide IT Staff Augmentation Services!

Sr Informatica Powercenter Developer Resume

5.00/5 (Submit Your Rating)

Bloomington, IL

PROFESSIONAL SUMMARY:

  • 10 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.
  • 6 years of experience in designing and development of ETL Methodology using Informatica PowerCenter 10.0, 9.6.1/9.0.1/8. x, Informatica PowerExchange 10.0/9.6.1/9.0.1 , InformaticaData Quality 10.0/9.6.1.
  • 7+ years of experience in working with ORACLE 11g/10g, PL/SQL, MySQL, SQL Server, Netteza databases.
  • 3+ years of experience inData Quality, Profiling, Validations, reference check and exception handling using Informatica Data Quality.
  • 1+ years of working experience in AWS cloud environment using ASW s3 bucket, Snowflake, RDS(MySQL)
  • 3+ years of experience in Change Data Capture (CDC) Methodology using PowerExchange10.0/9. x
  • 3+ years of experience in Teradata 14/13 SQL and utilities like MLOAD, Fast Load, TPT.
  • Interacted 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.
  • Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
  • Moderate experience in working with Information Technology Infrastructure Library's
  • Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary etc.
  • Expert in writing optimize SQL query using ORACLE, SQL Server, Teradata, MySQL and Hive.
  • Exposure in writing SQL using analytical functions like Ranking Functions, Reporting Aggregate Functions, LAG/LEAD Functions, FIRST/LAST Functions etc.
  • Extensive knowledge of Informatica tuning and SQL/PL SQL tuning.
  • Experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.
  • Very strong knowledge on end to end process of Data Quality and MDM requirements and its implementation.
  • Experience in AWS (Amazon Web Services), S3 Bucket and Redshift (AWS Relational Database).
  • Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.
  • Created and modified UNIX Shell 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 flat files, CSV files, Relational Databases etc. into a common analytical Data Model.
  • Experience in Informatica Production support; resolved hundreds of tickets where Data issues involved.
  • Designed and developedcomplex mappings, Mapplets, tasks and workflows and tuned it.
  • Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
  • Moderate experience in Informatica Change Data Capture Management
  • 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).
  • Experience in working with MicroStrategy developed Dashboard and Scorecard Reports.
  • 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.
  • Have understanding and Knowledge about Information Technology Infrastructure Library(ITIL)
  • Working experience in Agile and Waterfall methodologies.
  • Excellent communication skills, ability to communicate effectively with executive and management team, having strong analytical, problem solving skills.
  • Having good working knowledge on JIRA, Gitlab/Github, Jenkins,Pipelines,CI/CD practices etc.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center10.x/9.x/8.x/ 7.x.,SSIS, SQL Loader

Operating Systems: Windows XP, Windows 7, UNIX, Linux

Databases: Oracle 11g/10g, DB2, MS SQL Server 2012/2008, MS Access

Reporting/ Visualization Tools: Cognos 10.x/8.x, SSRS and qilkview.

DataModeling: ERWIN,Bill: Inman Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling.

CI/CD Tools: Git,Gitlab/Github, Jenkins,Maven, Pipelines,Groovy, Code quality, Scans,UCD

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Sr Informatica Powercenter Developer

Responsibilities:

  • Develop, data integration, conversion, and export mechanisms to consolidate and distribute business information within and between enterprise data systems.
  • Develop ETL mechanisms using Informatica and scripting.
  • Worked on Informatica Upgrade project to support Informatica MDM upgrade from 9.7.1 to 10.2.
  • Worked on integration of data from multiple source systems to Client Master database. Create, Modify, Enhance, Support ETL mechanisms to support Client Master database.
  • Created reusable scripts to automate the Informatica jobs and help the Production Support team.
  • Provide Production On-Call Support for the ETL Data warehouse jobs.
  • Created/modified the scripts to send email alerts based on different frequencies and different error messages to elp the Production Support team.
  • Worked on push down optimization to load the Netezza tables and deliver efficient ETL code.
  • Design, develop, test and maintain Informatica ETL maps.
  • Worked with mapping parameters and variables to load data from different sources to corresponding database table.
  • Created and Called unix scripts from Informatica.
  • Worked with Informatica Best Practices guidelines to minimize performance issues.
  • Made substantial contributions in simplifying the development and maintenance of ETL by making the efficient use of the existing Informatica objects and by creating re-usable objects.
  • Created migration document and supported the production deployment.
  • Created the Deployment groups and deployed the objects from one environment to the other.
  • Excellent knowledge on Application Integrations and security setup for roles and responsibilities of users within UC4.
  • Responsible for creating Jobs and define Job properties for Informatica, Business Objects, FTP thru UC4, calendars, schedules, dependency and orchestrate workflows Develop requirements, user test cases, job orchestration process and related documents.
  • Setup process / procedures for batch job notifications, alerts and monitoring / escalation in UC4.
  • Investigated Special Resources, automated job tailoring, managed unplanned work using ETT and Dataset triggering in TWS.
  • Scripting knowledge for writing scripts for TWS maintenance and Tivoli Workload Scheduler job scheduling

Environment: Informatica Power Center 9.6.1,UC4,TWS, Oracle 11g, PL/SQL, Teradata, Flat files, XML, MS Access, SQL Server 2008, VSS, Erwin, UNIX, Toad 9.0.

Confidential, Bloomington, IL

Informatica PowerCenter Developer

Responsibilities:

  • Develop ETL mechanisms using Informatica and scripting to prepare and send ACH submissions files and to retrieve and parse ACH return files.
  • Develop ETL mechanisms using Informatica and scripting to retrieve, parse, and process customer payments from a bank file.
  • Develop, data integration, conversion, and export mechanisms to consolidate and distribute business information within and between enterprise data systems.
  • Develop complex queries and stored procedures using SQL to extract and maintain business information against DB2, MS SQL Server databases.
  • Design, develop, test and maintain Informatica ETL maps.
  • Design and maintain logical data models for the Data Warehouse.
  • Design, develop, and execute queries to update production data for the purpose of data cleansing or batch transaction processing.
  • Design, develop, and implement solutions for ad-hoc and enterprise reporting needs.
  • Consult with Application Development and Data Warehouse teams to develop and enhance system Data Architecture.
  • Provide operations support.
  • Provide production, on-call support for nightly data warehouse job runs.
  • Provide administrative support for the Informatica ETL environment.
  • Monitor/Run jobs using Control M.
  • Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor

Environment: Informatica Power Center 9.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, TERADATA, SQLServer2008, TOAD, SQL developer, Teradata SQL Assistant, Autosys.

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

  • Worked with various internal teams to understand the existing systems and environments
  • Understand the Mapping Specification Documents and Business Rules
  • Analyzed, documented and reviewed the Database and ETL dependencies on the core Ratings as well as on the ratings provided by external vendors. worked with Date warehouse methodology kimbal
  • Extract the Data from Source (Operational Data Store) to Staging Develop the Business logic and load into Star Schema.
  • Developed Informatica Mappings, Sessions and Workflows using transformations (reusable & standalone)
  • Modified the existing ETL mappings to load the data from Operational Data Store to Staging to Enterprise Data Warehouse.
  • Created ETL mappings including various transformations such as Source Qualifier, Lookup, Update Strategy, Expression and Stored Procedure, Filter, Router, Sequence Generator.
  • Created test cases/scenarios for QA.
  • Involved in performance tuning of SQLs using Oracle optimization, indexes, and partitions and tuning join paths.
  • Performed Unit testing and Performance Tuning testing.
  • Developed PLSQL procedures, functions, views.
  • Efficiently created migration packages for migrating the code from DEV to TST, IQA and PROD environments.

Environment: Informatica 9.6/8.6.1, Oracle 11g, Oracle PL/SQL, Informatica, Control -M, XML files, Operational Data store (ODS), Autosys, SQL Server 2008, Cognos, Data Quality (IDQ), AIX, Erwin, Flat Files, Toad.

We'd love your feedback!