ETL Informatica Developer
•6 years of experience in IT industry and 4 plus 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 10.1/9.6 (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.
•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.
database experience using Oracle 11g/ MS SQL Server 2008/2005, MySQL, SQL
•Excellent communication, analytical and interpersonal skills.
•Quick learner, adaptive to new and challenging technological environments.
Windows 2008/2007/2005, UNIX, MS-DOS
Informatica Power Center 10.1/9.6(Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server),, Microsoft word,Excel,Access
Oracle 11g/ MS SQL Server 2008/2005, DB2
Data Management Tool
SQL, UNIX, Shell scripts,
Professional Experience: -
Infosys Limited (end client CVS)
Feb 2018 to present
•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.
•Unix shell scripting experience with loading the date, update the data, manipulating the files.
•Migration of developed objects across different environments.
•Also involved in leading the team meetings and providing status report to project manager.
July 2014 to jan 2018
•Extracted data from Flat files,, 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,
Data Entry Specialist.
oct 2009 to jan 2011
• 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.
Bachelor in Accounts with computer,
Osmania university, Hyderabad, India.
Master in Computer Application,
Osmania university, Hyderabad, India