SUMMARY:

• Around 9 years of Experience in complete life cycle of an Enterprise Data warehouse and Informatica development.
• Expertise in implementing complex Business rules by creating mappings/mapplets, shortcuts and reusable transformations.
• Hands on experience in working with Slowly changing dimensions, Fact & Dimension tables.
• Extensive experience in using Informatica 9.x/8.x/7.x (PowerCenter) for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Extensively used Informatica PowerCenter Designer, Workflow manager, Workflow Monitor for the development of complex ETL mappings.
• Hands on experience in using Informatica Designer Components which helps in developing mappings with varied transformation logics like connected and unconnected Lookups, Router, Filter, Expression, Union, Sorter, Aggregator, Joiner, Update Strategy, Normalizer and Re - usable transformations.
• Experience in creating Complex data loading jobs using Informatica.
• Expertise in analyzing the performance bottlenecks and performance tuning.
• Conversant with database systems like Oracle, SQL Server, Teradata and DB2 using tools like Toad and Aqua Data Studio for performing SQL and PL/SQL programming.
• Monitor Jobs using Control-M, ESP and TWS.
• Well known about Informatica development standards and having experience in code reviews.
• Involved in designing and implementation of different data warehouse dimensional models like Star Schema, Snow Flake Schema.
• Worked with different Data sources ranging from flat files to Oracle tables
• Well versed with Data warehousing concepts such as Design, Development and Extraction of data
• Experience in designing and developing efficient Error handling methods for ETL mappings and workflows
• Developed workflows in IDQ and involved in end to end development and migration
• Proficient in parameterizing DB connections, file paths, error handling and interacted with Informatica server from command mode using PMCMD command.
• Proficient in designing the testing artifacts like Test cases, Test Reports, Test Summary Reports.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, coming up with data load strategies, designing and developing various mappings, unit testing, integration testing, regression testing and UAT in development.
• Used Jenkins as a packaging and deployment tool for migrating ETL & Unix components
• An Energetic, flexible, well organized, self-motivated fast learner with minimal supervision, good listener, independent and team-oriented, process focused professional in various team sizes performing cross functional roles in a fun filled, challenging environment.
• Excellent analytical, problem solving, communication and interpersonal skills, with an ability to interact with individuals at all levels.
• Mentored 5 new associates in nurturing their skills towards trending technologies and project exposure.

TECHNICAL SKILLS:

ETL tools: Informatica Power center 8.x and above

Databases: Oracle 11g/10g/9i, DB2, Teradata

Data Modeling: Relational Modeling, Dimensional Modeling (Star Schema, Snow flake schema, Fact, Dimensions)

Programming languages: SQL, PL/SQL

Reporting Tools: QlikView

Operating systems: Windows

Scripting languages: UNIX Scripting

Packages: Toad

Scheduling Tools: Tidal,Control-M, ESP and TWS

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Senior ETL Developer

Responsibilities:

• Interacted with Business Analysts to understand the requirements and the impact of the ETL on the business.
• Prepared the design document by gathering the requirements from the Business Architect.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Implemented Performance tuning for the jobs which are running long both in informatica and DB side.
• Created deployment groups and packages for code promotion.
• Involved in code reviews of the ETL s in all the aspects before migrating to the next environment.
• Involved in monitoring of the application to make sure that it is running regularly on time.
• Converted materialized views and procedures which are running slow in database to informatica mappings and optimized the performance
• Developed workflows in IDQ and involved in end to end development and migration
• Provided knowledge on transition to the support team.
• Created jobs in Tidal scheduling tool
• Used Jenkins as a packaging and deployment tool for migrating ETL & Unix components
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Worked on different data sources such as Oracle, Flat files etc
• Was Part of deployment and provides post production support and reports warranty issues.

Environment: Informatica 10.x, Oracle 11g, UNIX, Tidal, Putty, SQL Developer

Confidential, Minneapolis, MN

Senior ETL Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, also imported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Created reusable transformations and mappings by using mapping designer, transformation developer in Informatica PowerCenter and used them in mappings.
• Involved in building the ETL Source to Target mapping to load data into Data warehouse and created mapping documents to outline data flow from sources to targets.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e - mail, command, worklets, Timer and scheduling of the workflow.
• Worked on different data sources such as Oracle, Teradata, Flat files etc.
• Created deployment groups and packages for code promotion.
• Understood the Project functionally and Documented the ETL logics.
• Play gatekeeper role for CRP production environment and trap any defects in code or performance issues at early stages and make sure zerodefect code is moving to production.
• Was Part of deployment and provides post production support and reports warranty issues.
• Resolved the incidents which are raised by the business with proper solution and work around.
• Implemented Performance tuning for the jobs which are running long both in informatica and DB side.
• Coordinate with offshore team members and reporting the work progress to the manager
• Worked on Work orders and service requests related to code enhancement/new requirements to be incorporated in the design.
• Involved in code reviews of the ETL s in all the aspects before migrating to the next environment.
• Participating in war rooms to get application restored within SLA.
• Application monitoring, SPOC for availability and outage management.
• Created & modified UNIX Shell scripts.
• Involved in monitoring of the application to make sure that it is available all the time.

Environment: Informatica 9.x, Oracle 11g, UNIX, Toad, TWS, HPSM, ServiceNow, Putty, Teradata

Confidential, Minneapolis, MN

Senior ETL Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Created reusable transformations and mappings by using mapping designer, transformation developer in Informatica PowerCenter and used them in mappings
• Involved in building the ETL Source to Target mapping to load data into Data warehouse and created mapping documents to outline data flow from sources to targets.
• Worked on different data sources such as Oracle, Teradata, Flat files etc.
• Created deployment groups and packages for code promotion.
• Understood the Project functionally and Documented the ETL logics.
• Play gatekeeper role for CRP production environment and trap any defects in code or performance issues at early stages and make sure zero defect code is moving to production.
• Was Part of deployment and provides post production support and reports warranty issues.
• Resolved the incidents which are raised by the business with proper solution and work around.
• Implemented Performance tuning for the jobs which are running long both in informatica and DB side.
• Worked on Work orders and service requests related to code enhancement/new requirements to be incorporated in the design.
• Participating in war rooms to get application restored within SLA.
• Application monitoring, SPOC for availability and outage management.
• Created & modified UNIX Shell scripts.
• Involved in monitoring of the application to make sure that it is available all the time.

Environment: Informatica 9.x, Oracle 11g, UNIX, Toad, TWS, HPSM, ServiceNow, Putty, Teradata

Confidential

Senior ETL Developer

Responsibilities:

• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Designed and developed processes to support data quality issues and detection and resolutions of error conditions.
• Working with the Business Analysts and QA team for validation and verification of the development.
• Used Debugger to debug the mappings and fixed the bugs.
• Prepared migration documents to move the mappings from development to testing and then to production repositories.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions.
• Performance tuning of Informatica sessions for large data files has been done by increasing block size, data cache size and, sequence buffer length.
• Worked on Informatica - Source Analyzer, Target Analyzer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Responsible for analyzing and comparing complex data from multiple sources (Oracle, DB2 flat files).
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
• Performed Unit Testing and tuned the Informatica mappings for better performance.
• Used TOAD to run SQL queries.
• Created deployment groups and packages for code promotion.
• Perform application tuning performance monitoring.
• Re-engineer existing Informatica ETL process to improve performance and maintainability.
• Co-ordinate with team members and mentored junior developers.

Environment: Informatica 9.x, Oracle 11g, DB2, UNIX, Toad, ESP, Putty

Confidential, Denver

ETL Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of Informatica workflows.
• Production Support to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning at functional level and map level.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Implemented Slowly Changing dimension (SCD) methodology for accessing the full history of accounts and transaction information.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version - based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Reviewed and analyzed functional requirements, mapping documents Involved in problem solving and troubleshooting at development stage of mappings.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Environment: Informatica 9.x, Oracle, UNIX, Toad, Putty

Confidential

Jr Informatica Developer

Responsibilities:

• Created Informatica Mappings
• Re - engineer existing Informatica ETL process to improve performance and maintainability
• Worked on unit testing
• Prepared required documentation for Unit testing
• Extensively worked on flat file systems.
• Monitored jobs in different environments
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Worked with heterogeneous sources from channels like Oracle and flat files
• Created reusable transformations and mapplets in the designer using transformation developer and mapplets designer tools
• Analyzed long running jobs and did performance tuning.
• Worked on understanding documents of the systems.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load

Environment: Informatica 8.x, Oracle, UNIX, Toad