SUMMARY:

• Over 8+ years of Experience in Data warehousing Analyst, Quality Assurance and 6+ years of ETL /BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experienced in handling the data for warehousing in E - commerce, Security systems and financial domains.
• As an ETL developer have strong experience in data analysis, design, development and implementation of data warehousing and data integration applications using SQL Server Integration Services, Informatica PowerCenter, SQL Server and Oracle
• Hands on experience in developing and delivering data warehousing and Business Intelligence solutions using Oracle, SQL Server, Informatica PowerCenter
• Participated in design sessions where decisions are made involving the transformations from source to target.
• Experienced in developing various data extracts and loading routine using Informatica, Oracle stored procedures.
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica PowerCenter
• Extensively used ETL methodologies for supporting data extraction, transformation and loading process using Informatica Power Center.
• Worked extensively with mappings using Expressions, Joiners, Routers, Lookup and Update strategy, Source Qualifiers, Aggregators to develop and load data in to different target types.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets and Sessions.
• Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling
• Strong experience in Data Warehousing (ETL & OLAP) environment and acquired excellent analytical, co-ordination, interpersonal skills, have immense leadership potential.
• Skilled in the development of Informatica mappings and mapplets and tuning them for optimum performance
• Experience is End to end testing for Informatica mappings, workflows and outputs based on the specification
• Experience in using Automation Scheduling tools like Automation engine, Autopsy and Control-M.
• Managed and complied documentation for all ETL processes like Consulting manuals, periodicals and technical reports to learn new ways to develop programs and maintain existing skills and knowledge
• Establishing a detailed program specification through discussion with clients. Experience working in an agile development environment.
• Experience in coordination with offshore teammates in assigning the tasks, taking daily update calls and sprint planning & closing meetings.

TECHNICAL SKILLS:

Tools: Informatica Power Center 9.6.1/10.1, Informatica cloud,UNIX

Databases: Oracle 11g/10g, Netezza Aginity, SQL Server 2012/2008

Documentation Tools: MS Word, MS Excel, MS Access, MS Outlook

Operating Systems: Linux, Windows 10/8/7/XP

Methodologies: SDLC, Agile

Schedulers: Control-M, Automic Engine

PROFESSIONAL EXPERIENCE:

ETL Informatica Developer

Confidential, Germantown, MD

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Extensively used ETL processes to load data from various source systems such as Oracle and Flat Files, XML files into target system Oracle by applying business logic on
• Experience in monitoring and managing varying workload of data warehousing
• Hands on experience in Informatica cloud setup
• Performed data loading from source to target using Informatica Cloud
• Developed the audit activity for all the cloud mappings.
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Used Informatica PowerCenter- Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformation
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Wrote UNIX shell scripts to schedule Informatica workflows and oracle database scripts to populate data in to data warehouse and database.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Used Informatica PowerCenter Workflow manager to create sessions and batches to run with logic embedded in the mappings
• Created folders, users, repositories, and deployment group using Repository Manager
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer
• Imported various heterogeneous files using Informatica Power Center 9.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Implemented various Performance Tuning techniques.

Environment: Informatica Power Center 9.6/10.1,Informatica cloud, Oracle 11g, Natezza Aginity, Automic Engine

Informatica developer

Confidential

Responsibilities:

• Presented all work in design review and code review sessions to senior team members and explain and support decisions made, and actions taken.
• Developed ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.
• Generated automated stats with the staging loads comparing with the present day counts to the previous day counts.
• Performed data loading from source to target using Informatica cloud
• Developed Informatica mappings, reusable transformations and created PL/SQL Stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.
• Performance tuned Informatica mappings by adopting explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Performed Error Handling and Debugging of bugs in PL/SQL programs.
• Used Informatica PowerCenter- Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformation.
• Interfaced with business analysts, project managers and clients to clarify requirements.
• Assisted other team members with their assignments (e.g., onboarding new team members).
• Tested own work and contribute to the development of test plans.
• Prepared documentation that describes installation and operating procedures, including application user guides, with limited guidance.
• Provided first/second level troubleshooting, technical and operational support with limited guidance.
• Participated in technical design. Can develop from specifications, under limited guidance.
• Involved in troubleshoot of applications problems, with limited support.
• Effectively identified and escalated issues as appropriate.
• Worked under Agile methodology and used version one to track the tasks

Environment: Informatica PC 9.6.1, SQL Server Management Studio

Informatica Developer

Confidential

Responsibilities:

• Responsible for designing and developing of mappings, mapplets, sessions and work flows for loading the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Performed Informatica Admin role by creating new repositories, users and maintaining TEST and PROD environments.
• Developed the Informatica Mappings, sessions and workflows required to load the data into oracle application from flat files and staging tables.
• Involved in ETL process from development to testing and production environments.
• Extracted date from various sources like Flat files, Oracle and loaded it into Target systems using Informatica PC.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Created Informatica tasks and workflows to execute ETL processes and Wrote complex SQL Query as per business requirement to fetch the data from relational tables
• Optimized complex SQL query to improve performance and Created Slowly Changing Dimension SCD type1, type2, Slowly Growing Targets, and Simple Pass through Informatica mappings to meet business requirements.
• Performed Unit testing, Integration testing/User Acceptance testing for ETL/SQL/Unix script codes
• Developed UNIX shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process automation.
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created tables and partitions in database Oracle and Written stored procedures in Oracle.

Environment: Informatica PC 9.5.x/9.6, Oracle SQL * PLUS, Windows XP.

ETL Developer

Confidential, CHICAGO, IL

Responsibilities:

• Mainly involved in ETL developing Creating the mappings and transformations using Informatica.
• The data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool.
• Extensively worked on developing Informatica Designer, Workflow manager and Workflow monitor for data loads.
• Responsible for the development of Meta data transformations and establishing load schedule.
• Created different changes, for example, Expression, Lookup, Joiner, Router, Filter, Aggregator and Sequence Generators.
• Optimizing/Tuning mappings for better performance and efficiency.
• Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, and Update Strategy.
• Developed map, reusable objects, transformation, and Mapplets using Mapping Designer, Transformation Developer and Mapplets Designer
• Created reusable transformations and mapplets and used them in mappings
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Managed enhancements and coordinated with every release with in Informatica objects
• Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting.
• Involved in designing the Mapplet and reusable transformation according to the business needs.
• Wrote UNIX shell scripts to schedule Informatica workflows and oracle database scripts to populate data in to data warehouse and database.
• Knowledge of slowly changing dimension tables and fact tables.
• Used the mapping parameter to make the mapping more flexible and Involved in Unit testing.

Environment: Informatica 9.1, Oracle SQL developer, MS Office Products - MS Excel, Word, MS Project.

ETL Developer

Confidential

Responsibilities:

• Initial analysis of Raw Data received from business Users. Data use to differs from County to county an State to state.
• Worked on SQL * Loader to load the data from flat files obtained from various vendors. Wrote SQL and PL/SQL programs to retrieve required information from the database.
• Created Indexes on the table for faster retrieval of the data to improve database performance.
• Created database objects like tables, views, materialized views, procedures and packages using oracle tools like TOAD, SQL Developer and SQL*Plus.
• Involved in ETL in order to meet the requirements for extraction, transformation, cleansing, and loading from source to target.
• Involved in ETL process from development to testing and production environments.
• Extracted data from various sources and loaded it into target database using Informatica Power Center7.1.
• Tuned mapping and SQL queries for better performance and efficiency. Performed unit testing and validated the Data.
• Provided Weekly status report to manager on the process and timeliness. Performed A performance tuning of the process at the mapping level, session level, source level and the target level.

Environment: Informatica 7.1/8.6, Oracle, SQL, PLSQL, Unix, SQL Developer, SQL*Loader.