We provide IT Staff Augmentation Services!

Sr. Etl Informatica Developer Resume

Atlanta, GA

SUMMARY

  • 9+ years of IT extensive experience with ETL tool Informatica Power Center /Power Mart Power Exchange in designing and developing Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
  • 8 years of Database experience using Oracle, PL/SQL, SQL Server. Strong Experience on database interfaces like SQL developer and TOAD.
  • 3 years of experience with Informatica Data Quality 9.6.1 (IDQ) toolkit, in Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities.
  • Good experience in using Python in ETL data warehousing.
  • Good exposure and experience in all phases of project SDLC( Software/Project development life cycle) like requirement gathering, analysis, design, development, testing and production support.
  • Have performed various testing activities like Unit Testing, Integration, System Testing, Regression Testing and User Acceptance Testing and ensured that the code is ideal.
  • Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
  • Experienced in automating the Informatica jobs, also experienced in Autosys, UNIX scripts for automation.
  • Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner.
  • Worked on different kinds of source and target systems like Oracle, Teradata, Flat file, DB2, Postgress, ODS.
  • Experience in various domains like Healthcare, Banking, Financial investment services and Telecom.
  • Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Powercenter Designer, Repository Manager, Workflow Manager, Workflow Monitor.
  • Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
  • Extensive experience in production support, solving various tickets within SLA's.
  • Able to finish all the assigned user stories with in the sprint including Unit testing and documenting the results.

TECHNICAL SKILLS

Data Warehousing / ETL Tools: Informatica Power center (Repository Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor, Power Exchange), Informatica IDQ.

Data Modeling: Star Schema Modelling, Snow Flake Modelling.

Databases: Oracle 12c, Oracle 11g, Db2, SQL Server.

Languages: SQL, PL/SQL, Python 3.8, core java basics, Unix Shell Scripting, Linux

Tools: Toad, SQL* plus, Putty, SVN, Autosys, Tivoli, IBM RTC, Power BI

Operating Systems: Windows& Linux

Agile: Rally, Kanban, Jira.

Testing: Quality center

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr. ETL Informatica Developer

Responsibilities:

  • Gathered requirements from Business users and created a Low level technical design documents using high level design document.
  • Participated in the Design Meetings and prepared technical and mapping documentation.
  • Designed Developed and Supported Extraction Transformation and Load ETL Processes using Informatica Power Center 9.5 for data migration from source systems into ICD - 10 Data warehouse.
  • Written Pre and Post Session SQL commands DDL DML to drop and recreate the indexes on data warehouse
  • Developed complex Informatica mappings using Unconnected Lookup Sorter and Aggregator and Router transformations for populating target table in efficient manner.
  • Extensively worked on developing Continuous Change Data CDC .
  • Developed Slowly Changing Dimension Mappings for Type 1 and Type 2.
  • Performance tuned the Mappings Tasks Sessions SQL and Scripts to optimize Data-Load performance.
  • Used data services for data profiling of sources between SQL Server and Oracle sources.
  • Involved in massive data profiling using IDQ Analyst tool prior to data staging.
  • Developed process for Teradata using Shell Scripting and RDBMS utilities such as MLoad Fast Load Teradata .
  • Extensively used pmcmd commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files.
  • Provided solution the Data Quality and Data Cleansing tracks for the MDM project.
  • Load monitoring the Support Process by failure reporting and failure handling in Teradata.
  • Worked on error handling and performance tuning in Teradata queries and utilities.
  • Experience in writing Teradata scripts and gave them to DBA s for implementing in Production database tables.
  • Worked in highly structured division across Infra developers/Data Architects data modeling team /DBAs/ Change Management etc.
  • Conformed to project standards for Unit test/UAT testing. Carried out end to end testing and supported UAT effort with immediate requirement document change/fixes/resolution for all changes/defects.

Environment: Informatica Power Center 9.5.1 Power Exchange 9.5.1 IDQ 9.5.1 Teradata V2R12 Oracle 11g SQL Server 2008 SQL UNIX Shell Scripts Windows 7.

Confidential, Newark NJ

ETL/Informatica Developer

Responsibilities:

  • Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
  • This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
  • Created Design Specification Documents including source to target mappings.
  • Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target.
  • Extracted data from various source systems like Oracle, SQLServer, XML and flat files and loaded into relational data warehouse and flat files.
  • Developed mappings in Informatica using BAPI and ABAP function calls in SAP.
  • Used the Remote functional call RFC as the SAP interface for communication between systems
  • Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more.
  • Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
  • Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger.
  • Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
  • Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings

Environment: Informatica Power Center 9.5, Oracle 11g, MS SQL Server, TOAD, SAP, PL/SQL,SQL,Oracle Exadata, Flat Files, XML, UNIX Shell Scripting, Windows 7/8, MS Office (Word, Excel, Powerpoint).

Confidential, San Francisco CA

ETL Informatica Developer

Responsibilities:

  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Designed ETL specification documents for all the projects.
  • Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
  • Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
  • Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
  • Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
  • Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
  • Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
  • Extensively used workflow variables, mapping parameters and mapping variables.
  • Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Implemented Informatica recommendations, methodologies and best practices.
  • Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Involved in Unit, Integration, System, and Performance testing levels.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Migrated the code into QA (Testing) and supported QA team and UAT (User).
  • Created detailed Unit Test Document with all possible Test cases/Scripts.
  • Conducted code reviews developed by my team mates before moving the code into QA.
  • Provided support to develop the entire warehouse architecture and plan the ETL process.
  • Modified existing mappings for enhancements of new business requirements.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Involved in production support.
  • Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica PowerCenter 9.1.0, Oracle 11g, SQLServer2008, IBM ISeries (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

Confidential, NYC NY

ETL Informatica Developer

Responsibilities:

  • Translated requirements into business rules made recommendations for innovative IT solution
  • Involved in analyzing scope of application defining relationship within between groups of data star schema etc.
  • Analysis of star schema in dimensional modeling and Identifying suitable dimensions and facts for schema.
  • Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
  • Documented data conversion integration load and verification specifications.
  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Maintained warehouse metadata naming standards and warehouse standards for future application development.
  • Extensively used ETL to load data from wide range of sources such as flat files and Oracle to XML Documents.
  • Worked with the various enterprise groups to document user requirements translate requirements into system solutions and produce development testing and implementation plan and schedule.
  • Used transformations like Joiner Expression Connected and Unconnected lookups Filter Aggregator Store Procedure Rank Update Strategy Java Transformation Router and Sequence generator.
  • Developed documented and executed unit test plans for the components
  • Involved in Informatica administrative work such as creating Informatica folders repositories and managing folder permissions.
  • Worked with ETL Developers and SQL Server DBA Team
  • Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
  • Used XML schema to extract data from Oracle Teradata into XML using Export Option in Informatica.
  • Created pre-session and post-session shell scripts and mail-notifications.
  • Developed Shell scripts using UNIX to drop and recreate indexes and key constraints.
  • Used TOAD to develop oracle PL/SQL Stored Procedures.
  • Extensively worked on the Informatica Designer Repository Manager Repository Server Workflow Manager/Server Manager and Workflow Monitor.
  • Created Workflows containing command email session decision and a wide variety of tasks to load the data into Target database.
  • Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
  • Employed performance tuning to improve the performance of the entire system.
  • Performed Pipeline partitioning to speed up mapping execution time.
  • Creating the design and technical specifications for the ETL process of the project.
  • Used Informatica as an ETL tool to create source/target definitions mappings and sessions to extract transform and load data into staging tables from various sources.
  • Maintain Development Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.

Environment: Informatica PowerCenter 7.1 Power Center Designer workflow manager workflow monitor Power connect Oracle 9i/10g XML PL/SQL Developer SQL Server 2005 UNIX Business Objects 6.5 Windows XP TOAD

Confidential, Atlanta GA

ETL Developer

Responsibilities:

  • Worked in life cycle development including Design, ETL strategy, troubleshooting and Reporting. Identifying facts and dimensions.
  • Extensively used Informatica Power Mart and created mappings using transformations like connected and flagging the record using update strategy for populating the desired slowly changing dimension tables.
  • Involved in the development of Data Mart and created mappings using Informatica.
  • Utilized the best practices for the creation of mappings and used transformations like Filter, Expression, Sequence generator and Lookup.
  • 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.
  • Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
  • Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
  • Tested data and data integrity among various sources and targets.

Environment: Informatica, Business Objects, UNIX, SQL, PL/SQL and MS VSS.

Hire Now