PROFILE SUMMARY:

• 9.5 Years of experience in development of Data warehousing solutions using Informatica 10.1,8.6.1, DataStage 8.5, Ab - Initio.
• Over 3 years of experience as architect and 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 Centre 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 Oracle/DB2 Architecture and developed Utilities.
• Good knowledge on Informatica Power Exchange, IDQ, IDE, Data Profiling with Informatica Data Quality.
• 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.
• 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
• Experience on Performance Tuning of Mappings and Sessions and Batches and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Used for Agile methodologies and involved in Scrum meetings, Daily stand up's, Huddle's.

SKILLS:

Technologies: Informatica 9.6, 10.1, DataStage, Ab - Initio

Databases: Netezza, Teradata, Oracle, SQL server

Operating Systems: UNIX, UNIX Scripting

Scheduling Tools: Control-M

Methodologies: Agile (Scrum)

Programming: Python

WORK EXPERIENCE:

Confidential, Columbus, OH

Senior ETL Developer

Responsibilities:

• The objective of this initiative is to build a Business Intelligence with analytical and reporting capabilities to facilitate the needs for SNAP/TANF reports.
• Design, development, testing of data warehousing solutions using ETL tools - Informatica 10.1.
• 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.
• Design the data modelling and relation b/w entities/relationships.
• 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.
• Designed and developed several Unix scripts to execute Informatica jobs.
• Worked on informatica scheduling and modified the scripts to test the new Control-M job cycles.
• 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 PowerCenter 9.6, Teradata, Oracle, UNIX, Toad, Control-M

Confidential, Columbus, OH

ETL Lead Developer

Responsibilities:

• Gathered customer requirements and involved in business meetings with analysts, architects, and business users.
• Designed the data warehousing 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 tuned Mappings/Sessions, developed complex database SQL and PL/SQL to validate ETL & Report testing.
• Worked on incident management tools.

Environment: Informatica PowerCenter 9.6, Teradata, Oracle, UNIX, Toad, Control-M

Confidential, San-Antonio, TX

Sr. ETL Developer

Responsibilities:

• Financial profits and losses of the Auto Mobile & Property insurance and other lines of business for each member of USAA. Helped to analyse the internal profits and losses of the organization.
• Involved in the business discussions and implementing the business dataflow and data relation.
• Prepared high-level design documents.
• Created STM (source to target mapping), Conceptual data models and SRS (software requirement specification) documents.
• Worked on different transformations, slowly changing dimensions.
• Worked with Connected and Unconnected Lookups.
• Performed integrated testing for various mappings and tested the data and data integrity among various sources and targets.
• Designed and developed mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Monitored transformation processes using Informatica Workflow Monitor.
• Designed the data modelling.
• Extraction, Transformation and Loading (ETL) of data by using Informatica PowerCenter.
• 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 Work flow 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.

Environment: Informatica PowerCenter 9.1, Oracle, DB2, UNIX, Control-M

Confidential

ETL Developer

Responsibilities:

• Integrated Avaya source system with upgraded Cisco source system. With the help of integrated source system, we will generate reports to the Business manager for every 30 mins interval.
• Implemented SCD-Type2 to keep track of history.
• Integrated Avaya CMS and Cisco data.
• 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, Lookup, Filter, 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 Teradata in accordance with requirements and specifications.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Created Sessions and Workflows.
• Analysed business requirements and worked closely with the various application teams and business teams to understand business requirements and the source data.
• Involved in designing logical models for staging, production warehouses using Erwin.
• Designed and developed several ETL scripts using Informatica, UNIX Shell scripts.
• Extensively used all the features of Informatica including Designer, Workflow Manager, Repository Manager, Workflow Monitor.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Created users in Informatica, assigned them various permissions.
• Backup/Restoration of repositories.
• Worked on defect fix. Code Deployment to QA.
• Created the jobs in Control-M.
• Involved in Analysis phase and Data modelling.
• Met 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 Oracle, Teradata 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 PowerCenter 9.1, Oracle 11g, PL/SQL, Teradata, UNIX