We provide IT Staff Augmentation Services!

Sr. Data Integration Engineer Resume

AZ

SUMMARY:

  • 8+ years of comprehensive and in - depth experience in Information Technology with a strong background in Database development and Data warehousing. I have expertise in ETL process using Informatica Power Center 10.2.0/9.6x/9.5x/8.x, Power Exchange using Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.
  • Hands on experience working with ICS, IICS and ICRT building webservices and business process to invoke SOAP/REST calls.
  • Used Address doctor webservice which call a WSConsumer connection and performs address validation and split.
  • Used Postman and SOAP UI for testing API.
  • Experience with Data integration using Informatica cloud for Oracle OCRM data and moving the data into sql server.
  • Experience in designing error and exception handling procedures to identify, record and report errors.
  • Extensive Experience in developing and performance tuning of Informatica mappings.
  • Hands on Using Pushdown Optimization and partitioning feature of Informatica.
  • Worked on Agile creating, managed and worked on stories.
  • Worked on different RDBMS management in Sql server, oracle, Teradata, Greenplum and db2.
  • Experience in writing complex queries and stored procedures.
  • Designed and supervised overall development of Data Mart and Oracle-hosted dimensional models.
  • Worked with integration with marketing cloud through web service consumer with the retrieve, insert, update and delete methods.
  • Technical expertise in Relational Databases like Teradata, DB2, SQL, PL/SQL, Stored Procedures, Functions, Packages, Indexes, Sub Queries, and Performance Tuning. Implemented Data Cleansing and necessary Test plans to ensure the successful execution of the data loading processes.
  • Has an intensive experience working on Address doctor, Matching, De-duping and Standardizing.
  • Data cleansing, standardizing and matching using IDQ and integrating with Informatica.
  • Identified and eliminated duplicates in datasets thorough IDQ 9.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, it enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
  • Performed Match and merge configurations and used Merge Manager to assign the match rules and create the data ready for the merge process.
  • Used scheduling tools CA Autosys, Goanywhere and Tidal.
  • Extensive written Unix scripts to automate job schedule, file watch and sending mail notifications.
  • Good understanding of Salesforce using Developer console, workbench for data manipulations.

TECHNICAL SKILLS:

Data warehousing: Informatica Power Center 10.2.0, 9.6/9.5/9.1.0/8.6 , Informatica Power Exchange, ICS, IICS, ICRT, Informatica Analyst,SSIS.

Data Modeling: Ralph Kimball Methodology, Bill Inmon Methodology, Snowflake, Star Schema, FACT Tables, Dimension Tables.

Databases: Greenplum, Microsoft SQL Server, Teradata, DB2, SQL, Oracle, PL/SQL.

Environment: Windows 2007/2003, Unix

Job Scheduling: Informatica Scheduler, Control M, Tidal, Goanywhere.

Others: Microsoft Word, Microsoft Excel, Outlook, XML, and HTML, Informatica Data Analyst, Informatica Data validation option (DVO), HP ALM and HP Quality Center.

Languages: SQL,PLSQL,Unix,Apex

PROFESSIONAL EXPERIENCE:

Confidential, AZ

Sr. Data Integration Engineer

  • Worked with IICS and ICRT for integration of SFDC with Datawarehouse.
  • Used address doctor process for address validation and address split.
  • Created mapping task and Data synchronization/replication task to sync up data from SFDC to DW.
  • Performed reverse engineer analysis to understand the IICS code and understand production issues.
  • Worked on JIRA production defects.
  • Designed and developed linear task flows to combine various integration tasks and run them in a specified order.
  • Used saved query and Mapplet-PC import to upload a powercenter mapplet to use its transformation logic in a synchronization task or a mapping.
  • Designed and developed views in SQL Server and performed performance tuning.
  • Create indexes, clustered and non-clustered in sql server to improve the performance of views.
  • Performed update/delete/insert using Workbench and Data loader.
  • Monitor bulk jobs in both Informatica cloud and SFDC.

Environment: IICS, ICRT, Informatica Powercenter 9.6, Informatica Cloud, Microsoft SQL Server Management Studio 11.0.2, SQL Server 12.0, Toad, Oracle SQL Developer, Unix.

Confidential, FL

Sr. Informatica Developer

  • Worked with Data migration from OCRM to SFDC using Informatica Cloud.
  • Created Data replication and synchronization tasks fro data migration from SQL server to SFDC.
  • Designed and developed linear taskflows to combine various integration tasks and run them in a specified order.
  • Used saved query and Mapplet-PC import to upload a powercenter mapplet to use its transformation logic in a synchronization task or a mapping.
  • Designed and developed views in SQL Server and performed performance tuning.
  • Create indexes, clustered and non-clustered in sql server to improve the performance of views.
  • Created views used for production fixes.
  • Used Informatica scheduler to automate powercenter jobs.
  • Develop and execute unit test cases.
  • Provide quality documentation and status updates.
  • Worked extensively on production defect and support.
  • Performed update/delete/insert using Workbench and Data loader.
  • Monitor bulk jobs in both Informatica cloud and SFDC.

Environment: Informatica Powercenter 9.6, Informatica Cloud(ICS), Microsoft SQL Server Management Studio 11.0.2, SQL Server 12.0, Oracle SQL Developer, Unix.

Confidential, Charlotte, NC

Sr. Informatica Developer

  • SFDC integration and data migration through Informatica.
  • Integration with Microsoft Dynamics.
  • Worked with integration with marketing cloud for user access management.
  • Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
  • Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
  • Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
  • Performed Match and merge configurations and used Merge Manager to assign the match rules and create the data ready for the merge process.
  • Created data backup jobs using replication task to backup entire source data.
  • Used Informatica Developer for Data standardization, data quality and data scrubbing.
  • Worked with Address validator for both Basic and advanced model for address validations.
  • Exported reusable IDQ mappings as mapplets to powercenter and deployed IDQ applications on servers.
  • Created reusable Match mapplets that can be used for multiple lob’s.
  • Used IDQ for the data load from landing to stage tables for the MDM process.
  • SFDC integration for Data migration and integrations.
  • LDAP integration sync-up with SFDC user, profiles and roles.
  • Used Java transformation for creating xml from expression transformation.
  • Used Unix shell scripts to automate the workflows using pmcmd/pmrep commands.

Environment: Informatica Powercenter 9.6, Informatica developer 10.2.0/9.6.1 , Microsoft SQL Server Management Studio 11.0.2, SQL Server 12.0, Oracle SQL Developer, Unix, CA Autosys.

Confidential, Denver, Colorado

Sr. Informatica Developer

Responsibilities:

  • Analyzed, designed and worked closely with Business Analyst for requirement gathering.
  • Created stored procedures for one-time updates.
  • Worked with Policy and Quote tables for developing SAS Mart, SAS Individual and SAS Policy.
  • Created deployment groups in Tidal and created dependencies for data load.
  • Created clustered indexes and used temporary tables to improve performance.
  • Worked with Business Analyst to identify issues and design solution.
  • Migrated historical data, which is one time and built re-platform process for ongoing data loads.
  • Applying dedupe logic for mappings based on the requirements.
  • Developed metadata mappings and also tuned for better performance.
  • Hands on experience working with SQL server database.
  • Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
  • Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
  • Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
  • Detail system defects are created to inform the project team about the status throughout the process.

Environment: Informatica 9.6, Microsoft SQL Server Management Studio 11.0.2, SQL Server 12.0, Tidal.

Confidential, Jessup, PA

ETL Informatica Developer

Responsibilities:

  • Analyzed and created technical specs documents for all the mappings.
  • Migrated historical data, which is one time and built migration process for ongoing data loads using Metadata process.
  • Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
  • Developed metadata mappings and also tuned for better performance.
  • Worked with SSIS tool for developing packages. Created metadata framework for data ingestion.
  • Hands on experience working with Greenplum database.
  • Involved in loading the data into Greenplum from SQL server database and Facets.
  • Hands on experience with external tables created using gpfdist.
  • Created generic function to create external and stage tables.
  • Worked on functions to load data into tables and create process log tables for delta.
  • Export and import data from Microsoft SQL server into Greenplum database.
  • Extensively used Tortoise SVN to check-in all the documents.
  • Extensively worked on Deployment and release procedures in SIT, UAT and Prod environment.
  • Analyzed existing system and developed business documentation on changes required.
  • Used PowerShell scripts for archiving and rename files.

Environment: Facets, GemfireXD, SQuirrel SQL Client 3.6, Microsoft SQL Server Management Studio 11.0.2, pgAdmin 1.16 Greenplum, HP ALM 12.00, Active Batch.

Confidential, South Portland, ME

ETL Informatica Developer

Responsibilities:

  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
  • Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into data mart.
  • Converted functional specifications into technical specifications (design of mapping documents).
  • Developed complex mappings to load data from multiple source systems like Teradata, DB2, flat files and XML files to Data Mart in DB2 database.
  • Used Control-M to schedule jobs.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup, Sorter, Rank and Router.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Worked on complex mapping related to Slowly Changing Dimensions.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for bulk loading.
  • Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
  • Used HP Quality center for defects.

Environment: Informatica Powercenter 9.5/9.1 (Powercenter Designer, workflow manager, workflow monitor), Informatica Data Quality 9.1, TOAD 10, 9.5 Remedy, Teradata, DB2, UNIX, Oracle.

Hire Now