SUMMARY:

• Over 6+ years of Professional experience as ETL Developer including experience in development of Data warehouse/Data Migration/ Data Integration on projects asInformaticaETL consultant.
• Looking for an opportunity that utilizes my business analysis, technical expertise, and skills in design, development, and testing usingInformatica
• Strong knowledge of data warehouse methodologies like ODS, Star Schema, Snowflake Schema and SDLC process.
• Proficient in implementing complex business rules throughInformaticatransformations, Workflows/Worklets and Mappings/Mapplets.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Experience withInformaticaServer Manager to create sessions and workflows to run with the logic embedded in the mappings.
• Extensive experience in using tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
• Good working skills in writing PL/SQL, SQL, Database Triggers, stored procedures and Oracle SQL query tuning concepts.
• Experience with writing daily batch jobs using UNIX shell scripts, and developing complex UNIX Shell Scripts for automation of ETL.
• Experienced in developing applications in Oracle and writing Stored Procedures, Triggers, functions, Views and creating Partitions for better performance.
• Involved in SQL tuning andInformaticaperformance tuning. Tuned performance ofInformatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Expert in Unit Testing, Integration testing and Performance Testing.
• Worked with different SDLC Environments Agile, Iterative and Water Fall Methodologies.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.5/8.6/8.1(Designer, Workflow Manager, Workflow Monitor, Rep. Server, Repository Manager), PowerConnect for SAP, Power Exchange etc

Programming Languages: C, C++, Core JAVA, XML, SQL, PL/SQL, UNIX Shell Scripting etc

Databases: Oracle 11g/10g, Teradata, Sybase ASE 15/12.x/11.x, MS SQL Server 2005, DB2 UDB 8.2, SAP databases, XML Files, PL - SQL, oracle EBS

DB & other Tools: Toad, SQL* Plus, SQL*Loader, Control-M, Endevor,SFDC

Data Modeling: ERWIN 4.0/3.5.5, Rational Rose, MS Visio, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimension Modeling.

Operating Systems: Windows 10/Windows 7/XP, UNIX

BI & OLAP tools: SSRS, Microsoft BI

Other Tools: MS-Office, Visio, Java Script(Jquery), SharePoint 2013, Confidential Tidal

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. ETL Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and implement the same into a functional Data warehouse design.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Bring data feeds from various Subject Areas like Product, Customer, Calls both Dimension and Fact on a single platform.
• Extracted data from Oracle and flat files to pull it into the Staging area.
• Worked on various types of transformations like Expression, Joiner, update strategy, aggregator, Filter and Lookup.
• Implemented re-usable mapplets wherever common functionality was needed.
• Implemented re-usable scripts across Subject areas.
• Retrieved data from Oracle EBSand loaded into SQL Server data Warehouse.
• Automated theInformaticajobs using UNIX shell scripting.
• Developed mappings usingInformaticaPowerCenterDesigner to transform and load the data from source systems to target database.
• Worked onInformaticaPowerCentertools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule and monitor Workflows.
• Involved in migrating the mappings and workflows from Development to Testing.
• Involved in Unit Testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: InformaticaPowerCenter9.6.1 (PowerCenterDesigner, workflow manager, workflow monitor), Oracle 11g, TOAD, Unix, Sybase

Confidential, San Jose, CA

Sr. Informatica Developer

Responsibilities:

• Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
• Worked on project documentation which included the Functional, Technical and ETL Specification documents. Participated in all the project presentation enhancements and customer reviews.
• Experienced in usingInformaticafor data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems
• Designed and implemented ETL mappings and processes as per the company standards, usingInformaticaPower Center.
• Created PL/SQL Stored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Worked on migrating Data fromSybaseIQ to Oracle. Extensively worked on complex mappings which involved slowly changing dimensions.
• Developed several complex mappings inInformaticaa variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both theInformaticaPowerCenter and IDQ.
• Worked extensively onInformaticatransformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.
• Debugged mappings by creating a logic that assigns a severity level to each error, and sent the error rows to error table so that they can be corrected and re-loaded into a target system.
• Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.
• Worked on developing Change Data Capture (CDC) mechanism usingInformaticaPower Exchange for some of the interfaces based on the requirements and limitations of the Project.
• Implemented performance and query tuning on all the objects ofInformaticausing SQL Developer.
• Worked in the ETL Code Migration Process from DEV to ITE, QA and to PRODUCTION.
• Created the design and technical specifications for the ETL process of the project.
• UsedInformaticaas an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked onInformaticaPower center tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Worked with the Release Management Team for the approvals of the Change requests, Incidents using BMC Remedy Incident tool.
• Worked with the infrastructure team to make sure that the deployment is up-to-date.
• Provided 24x7 production support when necessary.

Environment: InformaticaPower Center 9.0.x/9.1,InformaticaIDQ 9.x, Oracle 11g, Oracle, SQL Developer, SQL, Erwin, SFDC, Sybase, UNIX CRONTAB, Tidal scheduler, Ultra Edit

Confidential, Grand Rapids, MI

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Involved in all phases of SDLC from requirement gathering, design, development, testing and roll out to the field user and support for production environment.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Extensively worked withInformaticaPower Center client tools like Source Analyzer, Warehouse Designer and Mapping Designer to develop mappings for implementing the transformation logic to implement the business rules and requirements.
• Worked with the DBA to build the fact and dimension tables.
• Extensively developed source to target mappings and schedulingInformaticasessions.
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure.
• Implemented PL/SQL Programming using Dynamic SQL, Collections, Bulking techniques, Ref Cursors, Object types, Record types to improve performance. Very good expertise in using Exception Handling in PL/SQL programming.
• Designed and Developed the workflows, validated the dependencies in between the workflows which involved various tasks like even-wait, command, session tasks.
• Monitored production jobs on a daily basis and worked on issues relating to the jobs failure and restarted failed jobs after correcting the errors.
• Developed reusable transformations and mapplets.
• Used pmcmd command to runInformaticaWorkflows in Scripts.
• Involved in Performance Tuning of the mappings, usedInformaticaDebugger.
• Used Incremental Loading and Slowly Changing Dimension type 2 to maintain history data.
• Proven experience in working waterfall methodology environment.

Environment: InformaticaPowerCenter 8.6.1, Oracle 9i, UNIX, Teradata, Netezza, Windows Server 2008

Confidential, St. Louis, MO

Etl Developer

Responsibilities:

• Studied and Analyzed the Business requirement and prepared scope document, ETL specification documents according to the business requirements.
• Designed Sources to Targets mapping using Informatica PowerCenter for their Revenue Department.
• Source and Target databases resided on Oracle.
• All Submission files were designed according to HIPPA standards.
• Worked on Proprietary files and also Non-Proprietary files.
• Conducted design review meetings with the architect for any new requirement to get the approval and designed the mappings according to the company standards.
• Used MS-Visio to populate the Informatica design flows.
• Assisted in Informatica Administration using Repository manager.
• Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformations.
• Worked with Informatica Labels in labeling the designed components for deployment of code to TEST and PROD.
• Used Team Track to access all the CR's (Change Request's).
• Well versed with Informatica Team based development (Versioning).
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Worked with workflow System variables like SYSDATE and WORKFLOWSTARTTIME.
• Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, DECODE, SUBSTR, INSTR, and IIF functions in Expression Transformation.
• Worked with Shortcuts across shared and non-shared folders.
• Responsible for migrate the code using export and Import utilities across various Instances
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Wrote complex SQL queries to test the data generated by ETL process against target data base.
• Used Golden and also Toad to access the Oracle tables execute Sql queries.
• Designed complex mappings involving target load order and constraint based loading.
• Performance tuning, bug fixing and error handling.
• Created parameter files for the all the designed mappings and used parameter files for defining all the connection values(Source, Target, Lookup) and mapping parameters used in the Informatica sessions.
• Used Delta loading to extract New Remittance records in Informatica and processed the data and loaded the target data to Oracle tables.
• Used Business Objects for reporting purposes.
• Designed Technical documents, ETL Unit test plan document, Migration Check list document.

Environment: Informatica Power Center 7.x, (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Business Objects XI, Oracle 9i, Erwin 4.5, MS Visio, Windows.

Confidential

ETL Developer

Responsibilities:

• Extensively used Informatica to extract data from Central Database, which is SQL Server database.
• Used Informatica to load data into Data warehouse, which is Oracle Data base.
• Created mappings andreusable mapplets using ETL tool Informatica Power Center to transform data from multiple sources to target.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Created Informatica mappings to build business rules to load data.
• Improved integrity by identifying and creating relationship between tables.
• Loaded the consolidated data using the SQL Loader.
• Creating source definitions from the operational sources and target definitions.
• Designed Sources to Targets mappings from different databases to flat files using Informatica.
• Involved extensively when working on the Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Implement Data warehouse processes like Data Extraction/Transformation and Load ETL.
• Developed Transformation logic and designed various complex Mappings in the Designer.
• Worked with various transformations such as Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.
• Used Workflow manager to schedule, execute and monitor the session.
• Involved in creating tasks, worklets, and workflows, Scheduled the workflows using shell scripts to run automatically.
• Done Unit Testing for the mappings developed according to the specifications.
• Involved with the testing team to build the test plans.

Environment: Informatica Power Center, Oracle, MS SQL Server, SQL plus, PL/SQL, UNIX, Shell Scripting, MS Access, Windows NT/2000.