SUMMARY

• 8.5 Years of experience in development of Data warehousing solutions using Informatica 10.2 and 9.6.
• Over 2 years of experience as a lead in the development of Data warehousing projects.
• Good Experience in the understanding the business application, business dataflow and data relation.
• ETL Informatica: Strong experience in Informatica Power Center 9.1, 8.6.1, 8.1.1(Installation & Configuration), OLAP, OLTP concepts. Expert - level in designing and developing complex mappings to extract data from multiple sources such as flat files, XML files, RDBMS tables. Informatica Designer tools - Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Monitor.
• Quality Assurance: Good experience in Performance Tuning of Mappings/Sessions, develop complex database SQL, and PL/SQL to validate ETL & Report testing.
• Worked on ETL migration project from Ab-initio to Informatica mappings and integration projects like Avaya systems to CMS systems.
• Participated in code reviews/design meetings and optimizing the performance of mappings.
• Good understanding of Confidential /DB2 Architecture and developed Utilities.
• Good knowledge on Informatica Power Exchange, IDQ, IDE, Data Profiling with Informatica Data Quality.
• Good understanding of Data warehousing and ETL concepts.
• Good Knowledge in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements.
• Good work Experience in stored procedures and Unix Scripting.
• Very Good knowledge in Informatica Architecture and end to end design/development of project.
• Code migration to Test, UAT, Pre-PROD, PROD environments and production on call support.
• Has extensive experience in requirement analysis, database design, development, and Testing.
• Good knowledge on Informatica Power Exchange CDC, to connect to Mainframe systems and to provide access data in various formats such as VSAM, IMS, IDMS, AS400 files.
• Extensively used ETL methodology for supporting Data Extraction, Transformation, and Loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in creating Adhoc reporting ready universes using Business Objects Designer
• Data Analysis: Experience in Data Design and Analysis, User Requirements its Analysis, Data Transformations, Data Cleansing, Web Service Integration, Data extraction from ERP/SAP, Database Relationships, Source Systems Analysis and Reporting Analysis
• Databases: Good work experience on Database Systems like Confidential 10g, 9i, 8i, SQL Server 2008, Netezza, Confidential .
• Worked closely with client requirements and coordinating the offshore team.
• Worked on large OLTP, Data Warehouses, ODS (Operational Data Store).
• Experience on Performance Tuning of Mappings and Sessions and Batches and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Expertise in Data Warehouse Development, Implementation, Documentation, Data Base Testing, Data warehouse Testing, ETL Testing and Production support.
• Closely working with Dev lead, Test lead, Project Manager, Business Analysts and Developers.
• Good knowledge in using PDO and partitioning in Informatica.
• Used for Agile methodologies and also involved in Scrum meetings, Daily stand up's, Huddle's.
• Good understanding of core MDM concepts such as Data consolidation, Data Quality, master data publishing and data governance.
• Excellent presentation, written and verbal communication skills.

TECHNICAL SKILLS

Technologies: Informatica 9.6,10.2

Databases: Netezza, Confidential, Confidential, DB2, PL/SQL.

Data Model Tool: Erwin.

Reporting Tool: Business Objects.

Operating System: Unix/Linux

Scheduling Tool: Control-M, TWS

Methodologies: Agile (SCRUM)

PROFESSIONAL EXPERIENCE

Columbus, OH

Responsibilities:

• Design, development, testing of Data warehousing solutions using ETL tools - Informatica 10.2.
• Data Design and Analysis, Data Transformations, Data Cleansing, Web Service Integration, Database Relationships, Source Systems Analysis and Reporting Analysis.
• Code migration/deployment to test and production environments.
• Involved in Scrum meetings and have good knowledge of agile methodologies.
• Performance Tuning of Mappings and Sessions and Batches and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Documentation of the ETL Job Scripts and scheduling jobs.
• Designed and developed several Unix scripts to execute Informatica jobs.
• Worked on informatica scheduling (reusable scheduler and non-reusable schedulers).
• Worked on investigating and fixing the root cause of the problems that are encountered in production environments on day to day basis.
• Created pre-SQL and post SQL scripts which need to be run at Informatica level.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Have a good knowledge on RTC and Remedy.
• Optimized SQL queries for better performance.
• Worked on the loading of Facts and Dimensions to maintain the history records at any point in time.

Environment: Informatica Power center 10.2, Netezza, Confidential, UNIX, Toad, Denodo, Service Now, Jira.

Confidential, Bloomington, IL

ETL Informatica Lead Developer

Responsibilities:

• Gathering the customer requirements and involved in business meetings with Analysts, architects, and business users.
• Worked in designing the data ware housing solutions from end to end of the project.
• Worked in Agile development environment and have good knowledge of the agile methodologies.
• Involved in iteration planning meetings, epic, stories, tasks and retrospective meetings.
• Documentation of the ETL design process.
• Code Deployment to QA, Production environments.
• Good knowledge on optimization of sessions and mappings.
• Developed Batch Processing, Source, and Target Reconciliation process.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Performance Tuning of Mappings/Sessions develop complex database SQL and PL/SQL to validate ETL & Report testing.
• Worked on incident management tools.

Environment: Informatica Power center 9.6, Confidential, Confidential, UNIX, Toad, Control-M

Confidential

Sr.ETL Developer

Responsibilities:

• Involved in the business discussions and implementing the business dataflow and data relation.
• Worked on different transformations, slowly changing dimensions.
• Worked with Connected and Unconnected Lookups.
• Designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Worked with export and import utilities in Repository manager.
• Monitored transformation processes using Informatica Workflow monitor.
• Handled production support ETL operations by monitoring the scheduled Daily, Weekly and Monthly job loads
• Handled production support issues of priorities like P1, P2, P3
• Fixed the production ETL failures within the defined SLA
• Performing root cause analysis for the production issues.
• Producing daily schedule status reports to the customers

Environment: Informatica Power center 9.1, Netezza, SQL Server, UNIX, TWS, Service Now

Confidential

Responsibilities:

• Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
• Developed mappings for Call quality, Sales metrics data.
• Created many PL/ SQL batches and executed them through Unix Shell scripts.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively worked with Joiner functions like normal join, full outer joins, master outer joins, and detail outer join in the Joiner transformation.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Involved in Analysis phase and Data modeling.
• Prepared Job Scripts & Control-M jobs.

Environment: Informatica Power center 9.1, Confidential, DB2, UNIX, Autosys

Confidential

ETL Developer

Responsibilities:

• Implemented SCD-Type2 to keep track of history.
• Integrated Avaya CMS and CISCO data.
• Prepared Job Scripts
• Developed Informatica Mappings to Extract Data from Stage to Ods.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Developed new Informatica mappings and workflows based on specifications.
• Designed and developed various Informatica mappings using transformations
• Like Expression, Aggregator, External Procedure, Stored Procedure, LookupFilter, Joiner, Rank, Router, and Update Strategy.
• Developed various Ad-hoc mappings for various business needs.
• Performed extraction, transformation and loading of data from RDBMS tables,
• Flat Files into Confidential in accordance with requirements and specifications.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Created Sessions and Workflows
• Documentation of the ETL process
• Involved in Unit Testing

Environment: Informatica Power center 9.1, Confidential, SQL Server, UNIX, Control-M

Confidential

Responsibilities:

• Extensively used Informatica tools like Designer, Workflow manager, workflow monitor and the repository manager.
• Participated in meeting with Analysts, architects, and business users and prepared design documents as per business logic.
• Extensively worked on extract, transform and load the data from different source systems like Confidential, Confidential and flat files using Informatica PowerCenter tool.
• Worked on slowly changing dimensions (SCD) type I and II using lookup, filter, and update and expression transformations.
• Involved in unit testing, regression and system testing.
• Worked on performance tuning by increasing cache, override the SQL.
• Involved in peer review of the developed mappings by team members.
• Coordinated with testing team to make them understand Business and transformation rules being used throughout ETL process.
• Created Shell scripts to automate the production job runs.

Environment: Informatica Power center 9.1, Confidential 11g, PL/SQL, Confidential, UNIX