ETL Informatica Developer

AMATUL N AHMED

872-***-****

ac0fqn@r.postjobfree.com

PROFESSIONAL SUMMARY:

•7 years of experience in IT industry and 5 years with expertise in Analysis, Design, Development, Implementation, Modeling, and Support for Data Warehouse applications

•.Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications.

•Worked with Informatica Power Center 9.5/9.1 (Designer, Repository manager, Work flow manager, workflow monitor).

•Well acquainted with Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse Designer.

•Well versed with Relational and Dimensional Modeling techniques like Star Schema, OLAP, Fact and Dimensional Tables.

•Involved in developing Mappings using transformations like Source qualifier, Aggregator, Expression, Connected & Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.

•Tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottle necks, tune and remove bottlenecks.

•Good understanding of Debugger to test the data flow and Optimized the Solution by using the performance tuning methods in the Oracle SQL queries like Indexing techniques, Hints, Partitioning and Parallel execution process.

•SCD Management including Type 1, 2, De-normalization, Cleansing, Conversion, Aggregation, and Performance Optimization.

•Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures.

•Thorough knowledge of the Data Warehouse Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center.

•Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using SQL, PL/SQL.

• database experience using Oracle 11g/ MS SQL Server 2008/2005, MySQL, SQL, PL/SQL.

•Excellent communication, analytical and interpersonal skills.

•Quick learner, adaptive to new and challenging technological environments.

Technical Skills:

Operating Systems:

Windows 2008/2007/2005/NT/XP, UNIX, MS-DOS

ETL Tools:

Informatica Power Center 9.1/9.5 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), SSIS, Microsoft word,Excel,Access

Databases

Oracle 11g/ MS SQL Server 2008/2005, DB2 Teradata.

Data Modeling tools

Erwin

Languages

SQL, PL/SQL, UNIX, Shell scripts, Java Script, HTML,

Scheduling Tools

Teradata,Bussiness object

Professional Experience: -

Farmers Insurance,Los Angeles, CA

Informatica Developer

oct 2013 to Jan 2017.

Responsibility

•Used update strategy to effectively migrate data from source to target.

•Moved the mappings from development environment to test environment.

•Designed ETL Process using Informatica to load data from Flat Files, and Excel Files to target Oracle Data Warehouse database.

•Interacted with the business community and database administrators to identify the Business requirements and data realties.

•Created various transformations according to the business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.

•Created design document Informatica mappings based on business requirement.

•Created Informatica mappings using various Transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.

•Involved in the performance improvement project.

•Involved in designing of testing plan (Unit Testing and system testing).

•Tested scripts by running workflows and assisted in debugging the failed sessions.

•Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.

•Used persistent caches whenever data from workflows were to be retained.

•Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.

•Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.

•Perform Maintenance, including managing Space, Remove Bad Files, Remove Cache Files and monitoring services.

•Set up Permissions for Groups and Users in all Development Environments.

•Migration of developed objects across different environments.

•Also involved in leading the team meetings and providing status report to project manager.

Pramati Technologies Limited,

Hyderabad, India.

Junior Informatica Developer,

feb 2011 to jan 2013

Responsibility

•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.

Nipuna Services Limited,

Hyderabad, INDIA.

Data Entry Specialist.

oct 2009 to jan 2011

Responsibility

• Ensuring report tables and listings accurately reflect data within a database.

• Data input and manipulation in Excel spreadsheets and Access database.

• Entering data accurately onto computerised databases & Excel spreadsheets.

• Locate and correct data entry errors.

• Maintain logs of activities and completed work.

• Ensuring documents meet required quality standards.

• Compiling, coding, categorizing, calculating, tabulating and auditing data.

• Handling inbound telephone queries from colleagues / clients regarding data .

• Data manipulation in Excel spreadsheets.

• Occasionally carrying out various administration tasks like, photocopying, filing.

• Reviewing validation output and performing specified manual checks on the data

• ensure consistency and completeness. .

• Presented findings and data to team to improve strategies and operations.

• Proposed solutions to improve system efficiencies and reduce total expenses.

Education

Bachelor in Accounts with computer,

year 2002.

Osmania university, Hyderabad, India.

Master in Computer Application,

year 2006.

Osmania university, Hyderabad, India

Contact this candidate