Resume

Sign in

Informatica ETL Developer

Location:
San Jose, CA
Posted:
March 26, 2018

Contact this candidate

Resume:

Name: Shraddha Pakhale

Skills: INFORMATICA

Phone No 619-***-****

Email: ac4xsr@r.postjobfree.com

EXPERIENCE SUMMARY

Over 6 years of experience in Information Technology with a strong background in Data Warehousing.

Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using data integration ETL tools Informatica Power Center 9.1.

Extensive work in ETL process consisting of data transformation, data sourcing, mapping conversion and loading.

Strong in Data warehousing concepts, Dimensional Star Schema and Snowflakes Schema methodologies.

Extensively used Flat files to load data from source systems to targets using direct and indirect methods.

Proficient in understanding business processes / requirements and translating them into Technical requirements.

Extensively worked on Informatica Tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.

Excellent knowledge of ORACLE 10g/11g, SQL Server 2000/2005.

Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML files into the data warehouse.

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.

Experienced in the use of agile approaches.

Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.

Well-developed interpersonal and communication skills.

Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6 (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets).

Methodologies: Star Schema, Snow Flake Schema, FACT and Dimension Tables, Agile

RDBMS: Oracle 11g/10g, SQL Server 2005/2000

Operating System: Windows 7, Windows Vista/XP/2000, UNIX/Linux.

Development tools: SQL Developer, SQL *PLUS, TOAD

Programming/Languages: SQL, PL/SQL, UNIX shell scripting.

PROFESSIONAL EXPERIENCE:

Client: Motorola, CA April 2016 – February 2018

Role: Informatica Developer

Responsibilities:

Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited and fixed width Flat files.

Development of ETL using Informatica 9.1.

Applied slowly changing dimensions like Type I and II effectively to handle the Loads.

Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.

Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy, Designing and optimizing the Mapping.

Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

Created various tasks like Session, Command, Timer and Event wait.

Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

Tuned the performance of mappings by following Informatica best practices and applied several methods to get best performance by decreasing the run time of workflows.

Prepared SQL Queries to validate the data in both source and target databases.

Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.

Created Test cases for the mappings developed and then created integration Testing Document.

Automated the Informatica jobs using UNIX shell scripting.

Closely worked with the reporting team to ensure correct data is presented in the reports.

Interaction with the offshore team on daily basis on the development activities.

Environment:

Informatica Power Center 9.1, Oracle 10g, PL/SQL Developer, UNIX, Windows XP, TOAD, MS Office and Flat files.

Client: PAREXEL International, CA. September 2015- March 2016

Role: Informatica Developer

Responsibilities

Responsible for development of the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.1.

Developed an ETL Informatica mapping to load data into staging area. Extracted from flat files and databases and loaded into Oracle 10g target database.

Worked with various Informatica Power Center tools –Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations.

Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence Generators and Stored Procedure.

Used Slowly Changing Dimension Mappings of type I and II.

Created reusable transformations and Mapplets and used them in complex mappings.

Wrote Stored Programs (Procedures & Functions) to do Data Transformations and integrate them with Informatica programs.

Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.

Used mapping Parameters and Variables.

Created Sessions, Worklets and Workflows for carrying out test loads.

Analysed Session log files to resolve errors in mapping and managed session configuration.

Created, configured, scheduled and monitored the sessions and workflows based on run on demand, run on time using Informatica Power Center Workflow Manager.

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Triggers and Create Indexes.

Used PLSQL developer, SQL *Plus to run SQL queries and validate the data.

Environment:

Informatica Power Center 9.1, Oracle10g, SQL Server 2008, Flat Files, Windows XP.

Client: HSBC Bank, India May 2011 – Sep 2014

Role: ETL Developer.

Responsibilities:

Developed and implemented ETL processes using Informatica to move data from different sources into Data mart.

Knowledge of Repository, Folders, Users, and user privileges using Repository Manager.

Developed various Mappings, Transformations and Mapplets for migration of data using Informatica Designer.

Worked with complex mappings using expressions, aggregators, filters, lookups, Update strategy, router, joiner, rank, sequence generator transformations in Informatica.

Increased the cache size of transformations depending upon the requirements.

Done data migration, data cleansing and aggregation while transformation.

Done Performance tuning in Informatica understanding the need of indexes after having complete note of the Explain Plan.

Prepared SQL Queries to validate the data in both source and target databases.

Worked on Oracle SQL Developer to develop queries and create procedures and packages in Oracle.

Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.

Done Error Handling and debugging using Informatica debugger.

Applied slowly changing dimensions Type I and II effectively to handle the Loads.

Environment:

Informatica 8.6 Power Center, SQL, PL/SQL, Oracle, Flat File and WINDOWS XP

EDUCATION

B.Tech in Electronics and Communications Engineering.



Contact this candidate