SUMMARY

• Highly motivated technology professional having around 6 years of Experience with well versed in OLTP Data Modeling, Data warehousing concepts.
• Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica and extensively worked on Data Warehouse Full Life Cycle Projects.
• Data integration experience in developing ETL mappings and scripts using Informatica Power Center 10.x/9.x Informatica Data Quality 10.x ((Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager).
• Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets. Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.
• Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica and extensively worked on Data Warehouse Full Life Cycle Projects.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE).
• Practical understanding of the Data modeling concepts and implementation of Star-Schema and Snowflake Schema Modelling, Fact and Dimension tables for Warehouse.
• Strong experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections, and Indexes in Oracle
• Strong knowledge of database Schemas, SQL Languages, querying Tools (i.e. SQL developer) using TOAD, MySQL, ORACLE and proficient at performing Database Testing, data manipulation, checking constraints etc.
• Excellent Analytical and problem-solving skills, Interpersonal and communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x/9.x Informatica Metadata Manager 10.1

BI Tool: Tableau

Scripting Language: UNIX Shell Scripting, WSDL

Databases: Oracle 11i/10g, SQL Server

Operating Systems: Windows, UNIX

Agile Tools: JIRA, Confluence

Programming Language: SQL, PL/SQL, UNIX, Shell scripts

PROFESSIONAL EXPERIENCE

Confidential, MD

Informatica Developer

Responsibilities:

• Worked on Informatica Utilities Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed ETL programs using Informatica to implement the business requirements.
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Extensively developed various Mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers, and data flow management into multiple targets using Routers.
• Created Complex mappings using Unconnected and Connected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
• Used Informatica Workflow Manager to create workflows, Validating, Testing, running the workflows, database connections, sessions and batches to run the mappings.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Worked on different tasks in Workflows like sessions, event wait, decision, e-mail, command, Timer and scheduling of the workflow.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Used Mapping Variables, Mapping Parameters and Session Parameters to increase the re-usability of the Mapping.
• Involved in designing the process flow for extracting the data across various systems interacting.
• Created Design Documents for source to target mappings
• Created Workflows, Tasks, database connections, FTP connections using Workflow Manager.
• Extensive experience in troubleshooting the issues by checking sessions and workflow logs and solving migration issues and production issues
• Migrated repository objects, services and scripts from development environment to production environment by using ServiceNow Ticket tool.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Written and used UNIX shell scripts in order to fetch the input files and archive them.
• Used UNIX shell scripts for scheduling and pre/post session management.
• Extracted Products, Accounts data from Flat Files to IBM Netezza
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Used Informatica debugger, session logs and workflow logs to test and validated the mapping and fixed the bugs.
• Performed Fine tuning of SQL overrides for performance enhancements and tuned Informatica mappings and sessions for optimum performance.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache and Dynamic Cache to improve the performance of the lookup transformations.
• Created Source definitions and Flat File Target definitions using the Informatica.
• Used UNIX commands (Vi Editor) to perform the IBM Netezza load operations.
• Actively participated in database testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Used Ultra edit tool and UNIX Commands to create access and maintain the session parameter files, data files, scripts on the server.
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.
• Extracted data from IBM Netezza and loaded into Data Warehouse using Informatica.
• Analyzed the dependencies between the jobs and scheduling them accordingly using the Work Scheduler.

Environment: Informatica Power Center 10.1, IDE/IDQ, DVO, SQL, Oracle 12c, Tableau 9.2, Confluence, TOAD, UNIX Shell Scripts

Confidential, Oaks, PA

Informatica Developer

Responsibilities:

• Responsible for Developing, support and maintenance for the ETL (Extract, Transform and load) processes Using Oracle and Informatica Power Center.
• Understand the components of a data quality plan and make informed choices between sources data cleansing and target data cleansing.
• Gathered system design requirements, design and write system specifications.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Extracted data from different data sources like SQL Server, Flat files and loaded them into staging and into ORACLE.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Helped in establishing ETL procedures and standards for the objects improving performance enhancements and migrated the objects from Development, QA, and Stage to Prod environment.
• Worked on SQL Loader for bulk load of data and used SQL tuner for tuning SQL

Environment: Informatica Power Center 9, SQL, Oracle11g, TOAD