SUMMARY

• 5+ years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 10.x/9.x/8.x/7.x.
• Have clear understanding of Data warehousing concepts with emphasis on ETL and life cycle development including requirement analysis, design, development and implementation.
• Extensive working experience in design and development of data warehouse, marts and ODS.
• Handful working experience in Data warehousing development with data migration, data conversion and extraction/transformation/loading using Informatica Power Center to extract & load data into relational databases like SQL Server, Oracle, Teradata, DB2.
• Good work experience in Informatica Data Integration Tools - Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.
• Experience in Informatica Power Center for Data integration between source & Target which includes development of Joiner, Aggregator, Lookup, Salesforce Lookup, Router and Sorter transformations.
• Extensively worked with Informatica mapping variables, mapping parameters and parameter files.
• Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
• Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.
• Expertise Informatica B2B Data Transformation, DT and DX, pre-built transformations for most versions of industry standard messages including the following EDI standards and derivatives.
• Experienced in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using T-SQL.
• Experienced inDataAnalysis,DataModeling, Development, Testing and Documentation of projects.
• Experience working with Informatica Data Quality (IDQ) for data cleansing, data matching and data conversion.
• Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Extensively worked with Informatica MDM (Master Data Management) in order to manage the high-volume data.
• Excellent Hand full working experience in running projects by using scheduling tools like AutoSys.
• Extensive knowledge in optimizing techniques such as concurrent caching, Auto memory calculations, partitioning and using push down optimization.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle12c /Oracle11g, MS SQL Server, DB2, XML files and Flat Files into the staging area, Data Warehouse and Data Mart.
• Strong experience with star and snow flake schema, dimensional data modelling, facts, dimensional and slowly changing dimensions.
• Experienced in ETL process using PL/SQL to populate the tables in OLTP and OLAPDataWarehouse Environment.
• Expertise in implementing Slowly Changing Dimensions (SCD) Type 1 and Type 2 for initial and history load using Informatica.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation experience of CDC using stored procedures, triggers and using Informatica power exchange.
• Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expertise in RDBMS, database Normalization and Denormalization concepts and principles.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Developed shell scripts for invoking Informatica workflows and for running batch process.
• Extensive experience in designing the architecture for extract, transformation, load environment and development of mapping and process using Informatica power center.
• Experienced in Performance Tuning at Mapping, Session and database level, tuning mappings, Pipeline Partitioning to speed up data processing.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, T-SQL and Oracle PL/SQL.
• Experienced in using different scheduling tools - Control-M, Auto Sys, and Maestro/TWS & Cron Job.
• Excellent analytical skills in understanding client’ Confidential organizational structure.

TECHNICAL SKILLS

ETL Tools: InformaticaPower Center 10.1/9.X/8.X/7.X, Power Exchange-Real-time, Talend

Cloud DB: Amazon Athena, Amazon Redshift, Snowflake

RDBMS: Oracle 12c/11g, SYBASE, DB2, MS Access 2000, SQL Server 2000

Reporting Tools: Tableau10

Operating Systems: Windows 98/NT/2000, Solaris 2.6, HP-UX, Red Hat Linux 9.0

Languages: Python 3.0, Java, C++, C, SQL, PL/SQL.

Other Tools & Technologies: Business Objects, Big Data (Hadoop), Spark

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL Informatica Developer

Responsibilities:

• Worked closely with data modelers, business analysts and BI developers to understand requirements, to develop theETLprocesses using Informatica PowerCenter.
• Quickly understands the business issues and data challenges of Manheim client business and industry.
• Involved in level 2 and level 3 production support processes for resolution ofETLrelated issues in production.
• Ensures issues are identified, tracked, reported on and resolved in a timely manner.
• Provides oversight of otherETLdevelopment activities and unit testing all objects and processes and performs find-tuning and UAT issue resolution.
• Extensive experience in application integration using tools like Informatica Web service Consumer.
• Data Migration (from Oracle to salesforce.com) using Data loader & SQL Server.
• Written Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse
• Developed complex Informatica mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in an efficient manner.
• Extensively worked on developing continuous Change Data (CDC) using Informatica Power Exchange.
• Tuned the mappings andETLprocedures both at mapping and session level for better performance.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned bothETLprocess as well as Databases.
• Assists in enforcement of project deadlines and schedules.
• Possesses understanding in the areas of application programming, database and system design.
• Identifies critical issues with ease.
• Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems.
• Takes input from the supervisor and appropriately and accurately applies comments/feedback.
• Seeks and participates in development opportunities above and beyond training.

Environment: Informatica PowerCenter, Power Exchange CDC, SQLDeveloper, TOAD 11g, IBM iSeries DB2 or AS/400, Oracle 11gR2, SQL, PL/SQL, Informatica Webservice Consumer, DataLoader, Visual force, Apex, Shell Scripting, Unit and System Testing.

Confidential, Birmingham, AL

ETL Informatica Developer

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica PowerCenter.
• Experienced in Parsing high-level design specs to simple ETL coding and mapping standards.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica PowerCenter/Data Quality (IDQ), peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.
• Coded Teradata BTEQ scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Worked with team to convert Trillium process into Informatica IDQ objects.
• Extensively used the DQ transformations like Address validator, Exception, Parser, Standardizer, Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Extensively worked on UNIX shell scripts for server Health Check monitoring such as Repository Backup, CPU/Disk space utilization, Informatica Server monitoring, UNIX file system maintenance/cleanup and scripts using Informatica Command line utilities.
• Extensively worked on CDC to capture the data changes into sources and for delta load. Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Proficient in System Study, Data Migration, Data integration, Data profiling, Data Cleansing / Data Scrubbing and Data quality.
• Worked on Informatica Data Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
• Coded Teradata BTEQ SQL scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Experience in creation of ETL Mappings and Transformations using Informatica PowerCenter to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, Source Qualifiers, XML generator, XML Parser, Aggregators, Filters, Joiners.
• Responsible in preparing Logical as well as Physical data models and document the same.
• Performed ETL code reviews and Migration of ETL Objects across repositories.
• Developed ETL' Confidential for masking the data when made available for the Offshore Dev. Team.
• Developed UNIX scripts for dynamic generation of Parameter Files& for FTP/SFTP transmission.
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA' Confidential .
• Integrated IDQ mappings through IDQ web service applications as cleanse functions in Informatica IDQ cleanse Adapters.
• Migrated codes from Dev to Test to Pre-Prod. Created effective Unit, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure successful execution of accurate data loading.
• Scheduled Informatica workflows using OBIEE.
• Involved in implementing change data capture (CDC) and Type I, II, III slowly changing Dimensions.
• Developed functions and stored procedures to aid complex mappings

Environment: Informatica PowerCenter 10.x/9.6, Informatica Data Quality (IDQ) 9.6, Oracle 11g, Teradata, PL SQL, SQL developer, TOAD, Putty, Unix

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle.
• Involved in analyzing source systems and designing the processes for Extracting, Transforming and Loading the data.
• Developed Teradata BTEQ scripts and Informatica Mappings in order to apply complex transformations.
• Involved in Data Model Design and used best approaches to configure Physical and Logical model.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy and Joiner while migrating data from various heterogeneous sources like Oracle, SQL Server, and Flat files to target data base.
• Extensively used Informatica PowerCenter for ETL (Extraction, Transformation and Loading), data from relational tables and flat files.
• Created the Reference tables in the SQL Server Data Base and Created SSIS Packages to Load the Data from Data Base to Data Warehouse.Worked on all phases of Data warehouse development life cycle, from gathering requirements to testing and implementation, and support.
• Made changes in mappings with data changing capture capability for sources which have data added rapidly.
• Worked extensively on bug fixing of the existing mappings, performance tuning for better performance with best performance techniques and making existing objects to adhere to standards set up for the project.
• Written and used UNIX shell scripts for scheduling and pre/post session management.
• Involved in performance tuning of the Informatica ETL mappings by using TPTconnections, pushdown optimization, and partitioning, resizing caches.
• Created mapping variables and parameters for incremental loading.
• Handled Slowly Changing Dimensions (Type I, Type II, Type III) based on the business requirements.
• Reviewed source data and recommend data acquisition and transformation strategy.
• Wrote SQL stored procedures to implement business logic.
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data mart.
• Used Informatica Powercenter workflow manager to design sessions, assignment, e-mail and command to execute mappings.
• Developed and coded applications in PL/SQL.
• Created mapplets to reuse the transformation logic in several mappings.
• Designed and setup Autosys batch jobs by Setting up autosys profile, built JIL script, UNIX script, dependency set up with other existing jobs
• Used Repository manager to create folders, which is used to organize and store all metadata in the repository.
• Responsible for developing, support and maintenance for the ETL processes using Informatica PowerCenter.
• Used power center workflow monitor to monitor the workflows.
• Optimized mappings using transformation features like aggregator, filter, joiner, expression and lookups.
• Created daily and weekly workflows and scheduled to run based on business needs.
• Involved in creating complex and custom reports using SSRSwithdrilldown features, sub reports, charts.
• Worked closelywithProduction Control team to schedule shell scripts,Informaticaworkflows and PL/SQLcode in Autosys.

Environment: Informatica PowerCenter Designer 9.1, Informatica PowerExchange 9.1, Oracle11g, DB2 6.1, MS Visio, TOAD, Teradata, Unix- SunOS, PL/SQL, SQL Developer, SSRS, DB2, Perl, Python, Autosys.