We provide IT Staff Augmentation Services!

Informatica Developer Resume

3.00/5 (Submit Your Rating)

New, YorK

PROFESSIONAL SUMMARY:

  • To work as an Informatica Developer for a leading technology company and preform quality ETL development and data integration responsibilities.
  • 5+ years of experience in information technology with special emphasis on the design and development of ETL Process, building Data Warehouse/EDW, performance on Data Integration Services, Database Testing.
  • 3+ years of experience utilizing Informatica Power Center using different modules like Designer, Workflow Manager, Workflow Monitor, and Repository Manager in all the phases of the Data Warehouse Life Cycle involving design, development, analysis.
  • Highly experienced in Informatica Power Center, Informatica Power Exchange.
  • Extensive experience & proficiency in the development of ETL processes with a good understanding of source to target data mapping, ability to define, capture business rules in data extraction, transformation and loading data using Informatica Power Center tool.
  • Developed Complex mappings implementing various transformation logics like Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
  • Experience in developing UNIX Shell Scripts and a strong hold with UNIX Command Line.
  • Good experience in integration of various data sources from multiple Relational Databases like Oracle, SQL Server and worked on integrating data from non - relational sources like flat files and XML Files.
  • Experience in Scheduling tools like Control-M, Autosys and Informatica Scheduler.
  • Experienced in design, development, management and support enterprise CRM applications like Microsoft Dynamics, Salesforce.
  • Practical understanding of the Data Modeling concepts like Star-Schema and Snowflakes Schema
  • Worked on highly complex projects in Healthcare, Financial and Insurance domain.
  • Expertise in Data Cleansing at staging level with utilization Informatica Power Center.
  • Experience in integration of various data sources like Oracle, SQL Server, and Flat files.
  • Experience writing and modifying ETL Design Documents and Test Results Documents.
  • Experience in SDLC process and Scrum framework and its implementation in fast-paced Agile Development environment.
  • Have good communications, management, and problem-solving skills with self-motivation and ability to work independently or cooperatively in a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (10.2/9.6/9.1/8.6 ), Informatica Power Exchange (10.2, 10.0,9.6,9.5)

Database: Oracle 11g/10g/9i/7i, MS SQL Server (2012, 2014, 2016), Teradata

BI/Reporting Tools: Tableau, POWER BI, Crystal Report, QlikView

Data Modeling Tools: ER/Studio, ERWIN

Scheduling Tools: Autosys, Control M, Informatica Job Scheduler

Operating Systems: UNIX/Linux, Windows, Windows Server

Other Applications: Microsoft Dynamics, Salesforce, SSMS, TFS, Toad, SQL Developer, JIRA, VersionOne

Languages: SQL, MySQL, UNIX Shell Scripts

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, NEW YORK

Responsibilities:

  • Created robust mapping, mapplets and reusable transformation using Informatica Power Center and its different transformation including Joiner, Look-up, Rank, Filter, Router, Expression, Aggregators, Sequence Generator, Sorter, Update Strategy.
  • Worked with connected and unconnected look-up and configured the same for implementing complex logic. Extracting data from ODS SOURCE and sending it to the target on a daily, weekly and monthly basis
  • Involved in the design, development, and testing of the stored procedures for the ETL processes.
  • Created Unix Shell Scripts for ETLjobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion.
  • Build a number of UNIX Shell scripts for PL/SQL programs to schedule them on Control M.

Environment: Informatica Power Center 10.1/9.6, Power Exchange 10.1/9.6, Oracle 11g, SQL/PLSQL, SQL Server 2014, UNIX/LINUX, Control M, Putty.

Informatica Developer

Confidential, Orlando, Florida

Responsibilities:

  • Worked with BA Team to understand business requirement in order to transform BRD into effective technology solutions. Created high-level, low-level design, ETL specification, data model, and test document.
  • Designed and developed mappings from OLTP to staging, stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Connected and Unconnected Lookup, Normalizer, Update Strategy etc.
  • Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping.
  • Performance on Informatica sessions using large data files by using partitions.
  • Created various UNIX shell scripts for Job automation of data loads.
  • Maintain, support and work on a daily basis on enterprise CRM applications Microsoft Dynamics.
  • Use TFS (Team Foundation Server) for day to day work like upload code, collect test file, bug report updates etc.
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length, and target-based commit interval.
  • Handle the migration process from Development, Test and Production Environments.

Environment: Informatica Power Center 10.2/9.6.1, Power Exchange 10.2/9.6, SQL Server 2016, Visual Studio 2015, Microsoft Dynamics, SQL, UNIX/LINUX, Tableau, Team Foundation Server, Secure FX, Secure CRT, Control M, Autosys.

ETL TESTER

Confidential

Responsibilities:

  • Analyzed the business requirements documents, functional specifications documents to prepare test cases
  • Based on the test plans and use cases.
  • Write complex SQL quires to validate loaded data in the EWD according to the implemented logic.
  • Created and executed SQL quires to fetch data from database server to validate and compare expected
  • Results with those actually obtained.
  • Devolved ETL test scripts based on technical specifications/data design documents and source to target
  • Mappings.
  • Facilitate test design and test case review sessions with SME’S.
  • Garneted bug reports and test case and coverage reports for status meetings.
  • Used Jira to plan test, manage test assets, create and run manual test.

Environment: Informatica Power Center 10.1/9.6, Power Exchange 10.1/9.6, Oracle 11g, SQL/PLSQL, SQL Server 2014, Jira.

We'd love your feedback!