We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

4.00/5 (Submit Your Rating)

Chevy Chase, MD

SUMMARY

  • Overall 7+ years of IT experience in the Business Analysis, Design, Data Modeling, Coding, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Sales, & Distribution, Retail and Finance Industries.
  • Experienced in analysis of different systems for system study and data warehouse implementations.
  • Experienced in Data Analysis, Data modeling, ETL, Data Warehousing, Reporting, Development, Maintenance, Testing and Documentation.
  • Experienced in OLTP/OLAP Systems, Analysis, and Data model Schemas like Star schema, Snowflake schema and multidimensional modeling.
  • Well versed in Normalization (1NF, 2NF and 3NF) and Denormalization techniques for optimum performance in relational and dimensional database environments.
  • Extensive experience in implementation of Informatica Power Center components like Source Analyzer, Target Designer, Mapping/Mapplet/ Transformation Designer, Workflow Manager/ Workflow Monitor.
  • Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations.
  • Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
  • Good Knowledge on Java
  • Data warehousing experience using Informatica Power Center, Informatica Power Exchange and extracting data from Db2, Oracle, MS SQL Server, MS Access, AS400.
  • Good understanding and working experience in Logical and Physical data models dat capture current/future state data elements and data flows.
  • Experience in writing complex SQL queries, stored procedures and functions using PL/SQL programming.
  • Supervises a collection of activities and resources across data governance, quality, and lineage subject areas
  • Facilitates and delivers subject matter expertise (SME) within data governance working groups and management committee.
  • Proven ability in middleware integration components preferably in iPaaS ( Integration platform as a service ) platforms such as IICS (Informatica Intelligent Cloud Services).
  • Hands - on expertise with Cloud, including Informatica IICS and Salesforce.
  • Created and configured all kinds of cloud connections and runtime environments with Informatica IICS
  • Experience in UNIX shell scripting and using PMCMD commands to run Informatica workflows.
  • Experienced in handling SCDs (Slowly Changing Dimensions) and change data capture (CDC) using Informatica PowerCenter.
  • Converted hundreds of Teradata syntax macros to Greenplum/Postgres syntax functions using SQL & PL/PGSQL.
  • Using Informatica Power Center for extraction, transformation, and load (ETL) of data in the data warehouse.
  • Using Informatica Power Centre tools developed workflows using task developer, worklets designer, and workflow designer in workflow manager and monitored the results using workflow monitor.
  • Experience in Test Deployment of Informatica objects using Informatica deployment groups, and non Informatica objects using Eclipse and UNIX deployment process.
  • Having Exposure in AWK Scripts and Worked on Autosys, Crontab and Control + M to schedule the jobs.
  • Experience in understanding the requirements and preparing data mapping documents.
  • Experience in debugging mappings; Identified bugs in existing mappings by analyzing the data flow and evaluating transformations
  • Hands on experience in Performance Tuning of sources, targets, transformations and sessions
  • Experience in UNIX shell scripting, FTP and file management in various UNIX environments.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 10.x,9.x,8.x,7.x,IICS, SSIS, Power Exchange.

Databases/RDBMS/Others: MS SQL Server 2008/2005/2000 , Oracle 8i/9i/10g/11g/12c,DB2, Teradata V12, V14, V15, XML, Flat files and Excel files

Data Modeling: MS Visio, Star Schema, Snow Flake Schema, Physical and Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables.

Programming Languages: Java, Python, SQL, PL/SQL, T-SQL, MY-SQL

Job Control and Other Tools: Informatica Scheduler, Putty, SQL*Plus, TOAD, PL/SQL Developer tool, Autosys, Crontab and Control + M

Reporting Tools: BI/BW and SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Chevy Chase, MD

ETL Informatica Developer

Responsibilities:

  • Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
  • Worked on converting technical specifications into Informatica Mappings.
  • Created Filewatcher jobs to setup the dependency between Cloud and PowerCenter jobs.
  • Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
  • Has used NORMALIZER Transformation heavily to convert the data in flat file RDBMS structures.
  • Worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations.
  • Worked with Reporting team to get to an agreement on wat level of complexity to be handled by ETL and reporting side.
  • Worked on Informatica tuning at mapping and sessions level.
  • Extensively used Informatica Power Center 8.6/9.5 and created mappings using transformations like Source Qualifier, Joiner, Normalizer, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica PowerCenter 9.6Designer.
  • Involved inData Center Migration,up gradation ofInformatica DIH and Control-M.
  • Responsible for setting up jobs in environment complete on a daily basis.
  • Documented the various development JIRA's I has worked on and created TDD (technical design document) incorporating the changes done.
  • Creating and monitoring batches and sessions using informatica Powercenter server.
  • Identified the bottlenecks in the sources, targets, mappings, sessions and resolve performance issues.
  • Implemented the Push down Optimization process in informatica TEMPeffectively.
  • Created the deployment groups for promoting the code for higher environment.
  • Develop the mappings using wide range of transformations like Joiner, Java Aggregator, Sorter, Union, Router, SQL transformations
  • Has used NORMALIZER Transformation heavily to convert the data in flat file RDBMS structures.
  • Used Mapplets, Parameters and Variables to facilitate the reusability of code.
  • Worked on Pre and Post SQL queries on target.
  • 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.
  • Extracted data from different databases like Oracle and external source systems using ETL tool.
  • Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica.
  • Responsible for configuring the workflow tasks like email task, Command task and make it reusable for other team members.
  • Design and build Teradata SQL,TPT, BTEQ and UNIX shell script
  • Developed mappings to load into staging tables and tan to Dimensions and Facts.
  • Involved in monitoring of production ETL applications, Production Support through tickets, executing Scripts / managing scheduled activities based on business requirements.
  • Configure the Sessions & Workflows for recovery and with High availability.
  • 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.

Environment: Informatica Power Center IICS 10.2, PL/SQL Developer, JIRA, Python, Unix-Putty, Oracle, HP lifecycle management tool.

Confidential, NJ

ETL Informatica Developer

Responsibilities:

  • Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
  • Worked on converting technical specifications into Informatica Mappings.
  • Created Filewatcher jobs to setup the dependency between Cloud and PowerCenter jobs.
  • Developed Cloud mappings to extract the data for different regions (NAPAC, UK and America)
  • Developed the audit activity for all the cloud mappings.
  • Proven ability in middleware integration components preferably in iPaaS ( Integration platform as a service ) platforms such as IICS (Informatica Intelligent Cloud Services).
  • Implemented Salesforce business process with Informatica IICS data Integration
  • Hands-on expertise with Cloud, including Informatica IICS and Salesforce
  • Created and configured all kinds of cloud connections and runtime environments with Informatica IICS.
  • Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
  • Experienced in implementing Organization DevOps strategy in various operating environments of Linux and windows servers along with cloud strategies of Amazon Web Services.
  • Has used NORMALIZER Transformation heavily to convert the data in flat file RDBMS structures.
  • Loaded data from different source systems like Flat files, Excel, Oracle, .txt files.
  • Worked with Reporting team to get to an agreement on wat level of complexity to be handled by ETL and reporting side.
  • Using Informatica Power Center for extraction, transformation, and load (ETL) of data in the data warehouse.
  • Using Informatica Power Centre tools developed workflows using task developer, worklets designer, and workflow designer in workflow manager and monitored the results using workflow monitor.
  • Created and Imported/Exported various Sources, Targets, and Transformations using Informatica PowerCenter 9.6Designer.
  • Worked on Informatica tuning at mapping and sessions level.
  • Extensively used Informatica Power Center 8.6/9.5 and created mappings using transformations like Source Qualifier, Joiner, Normalizer, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator.
  • Responsible for setting up jobs inEDW/EDH/ETL Integrationenvironment complete on a daily basis.
  • Documented the various development JIRA's I has worked on and created TDD (technical design document) incorporating the changes done.
  • Has used NORMALIZER Transformation heavily to convert the data in flat file RDBMS structures.
  • Used Mapplets, Parameters and Variables to facilitate the reusability of code.
  • Worked on Pre and Post SQL queries on target.
  • Responsible for configuring the workflow tasks like email task, Command task and make it reusable for other team members.
  • Developed mappings to load into staging tables and tan to Dimensions and Facts.
  • Involved in monitoring of production ETL applications, Production Support through tickets, executing Scripts / managing scheduled activities based on business requirements.
  • Configure the Sessions & Workflows for recovery and with High availability.
  • 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.

Environment: Informatica Power Center 9.6/10.2, IICS, PL/SQL Developer, JIRA, Unix-Putty, Oracle, HP lifecycle management tool.

Confidential, GA

ETL Developer

Responsibilities:

  • Worked with Data Architect in designing the data mart, defining, designing and building FACTS and DIMENSIONS using Star Schema model.
  • Developed Informatica workflows/worklets/sessions associated with the mappings across various sources likeXML, flat files, Webservices.
  • Worked with SCD Type1, Type 2, Type3 to maintain history in Dimension tables.
  • Worked with cleanse, parse,standardization,validation, scorecardtransformations.
  • Worked with transformations Source Qualifier, Update Strategy, XML transformation, SQL Transformation, Webservices, Java transformation, Lookup Connected and Unconnected.
  • Worked extensively on shell scripting for file management.
  • Created re-usable transformations/mapplets and used across various mappings
  • Worked withPush down optimizationto improve performance.
  • Worked on UNIX shell scripting for file processing to third party vendorthrough SFTP, encryption and decryption process.
  • Extensively used Informatica Power Center 8.6/9.5 and created mappings using transformations like Source Qualifier, Joiner, Normalizer, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator.
  • Created complex Informatica mappings using transformations Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, Lookup and Router transformations to extract, transform and loaded data mart area.
  • Worked with differentscheduling toolslike Tidal, Tivoli, Control M, Autosys
  • Documentation of ETL process for each project and KT to Offshore and team.
  • Work closely with DBAs, application, database and ETL developers, change control management formigrating developed mappingsacross Dev, QA, and PROD environments.

Environment: Informatica Power Center 10.1, Teradata V14, Oracle 12c, SQL Developer, Teradata, Sql Assistant, UNIX Shell Scripting, Flat Files, XML Files, Agile Methodology.

Confidential, Boston, MA

ETL Informatica Developer

Responsibilities:

  • Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
  • Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
  • Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
  • Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
  • Using Informatica Power Exchange for loading/retrieving data from the mainframe system.
  • Automating the ETL process through scheduling the exception-handing routines as well as source to target mapping development, support and maintenance.
  • Loading Data to the Interface tables from multiple data sources such as SQL server, Text files and Excel Spreadsheets using SQL Loader, Informatica and ODBC connections.
  • Extracted data from different databases like Oracle and external source systems using ETL tool.
  • Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
  • Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica.
  • Extensively used Informatica Power Center 8.6/9.5 and created mappings using transformations like Source Qualifier, Joiner, Normalizer, Aggregator, Expression, Filter, Router, Normalizer, Lookup, Update Strategy, and Sequence Generator.talend
  • Involved in Performance Tuning of mappings in Informatica.
  • Good understanding of source to target data mapping and Business rules associated with the ETL processes.
  • Developed PL/SQL programming dat included writing Stored Procedures, Packages, Functions and Database Triggers.
  • Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator using Informatica in ETL to transform the data.
  • Preparation of test data for regression testing and Validating the target data with the source data.
  • Understanding of Meta Data and Data Quality needs on ETL and Data Warehouse processes

Environment: Informatica Power Center 9.6.1, Oracle 11g, Sql Server, Flat Files, Agile Methodology.

We'd love your feedback!