SUMMARY

• Overall 7+ years of experience in IT industry with strong background in Data Warehousing, Business Intelligence and ETL process using Informatica PowerCenter 10.x/9.x/8.x extracting data from Flat files, Oracle, SQL Server and DB2 databases.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Master schema using various power centre transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Reusable transformations and Mapplets are built wherever redundancy needed.
• Experience with Informatica Advanced Techniques like Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub - Queries.
• Experience in writing SQL queries and PL/SQL to implement business rules and validation.
• Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas and knowledge in designing tools like Erwin and Power Designer.
• Performed analysis in data requirements, complex source data and the data model and performed the best methods in extracting, transforming, and loading the data into the data staging, warehouse, and other system integration projects.
• Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle, SQL Server, Azure SQL Server, Netezza, Teradata, DB2 and MS Access.
• Maintenance of History retention tables.
• Experience in UNIX operating system and Shell scripting.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modelling (Star Schema, Snowflake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experience in writing SQL queries and PL/SQL to implement business rules and validation.
• Experience in AWS (Amazon Web Services) like S3 Bucket and Redshift (AWS Relational Database).
• Implemented Data Vault Modelling Concept solved the problem of dealing with change in the environment by separating the business keys and the associations between those business keys, from the descriptive attributes of those keys using HUB, LINKS tables and Satellites.
• Experience in Analysing business requirements and document ETL high level and low-level design based on requirements and ETL standards.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Automation of the business process using Control M, Autosys, Zena and Tidal.
• Working knowledge on BI tools - Tableau, OBIEE, Business Objects.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

• Operating Systems: Linux, Unix, Windows 2010/2008/2007/2005/ NT/XP.
• ETL Tools: Informatica Power Centre 10.x/9.x/8.x, Informatica cloud
• Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, Azure SQL Server, Netezza, Sybase, Teradata and DB2
• Data Modelling Tools: Erwin, MS Visio, E/R Studio.
• Languages: MS SQL, PL/SQL, UNIX, Shell scripts.
• Scheduling Tools: Zena, Autosys, Control - M, Tidal.
• Tools: Selenium, Toad.

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

Informatica Developer

Responsibilities:

• Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Developed Technical Specifications of the ETL process flow.
• Extensively used ETL to load data from Flat files, Oracle, SQL Server into Netezza Database.
• Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks.
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy
• Worked with mapping variable, Mapping parameters and variable functions like Set variable, Count variable, Setmin variable and Setmax variable
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Using Informatica Repository Manager maintained all the repositories of various applications, created users, user groups, and security access control.
• Developed shell scripts for job automation, which will generate the log file for every job.
• Created Stored Procedures for Audit and Error Balancing.
• Validated data to maintain Referential Integrity.
• Developed UNIX shell scripts to move source files to archive directory.
• Involved in Unit, Integration, system, and performance testing levels.
• Worked on back end programming such as PL/SQL procedures, functions and packages.
• Automated Scheduled jobs to run daily with email notifications for any failures using Zena tool.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Coordinated offshore and onsite team with a total of 10 ETL developers.
• Working in Agile methodologies and participating daily scrum meetings for providing status reports to team regarding project status, task and issues.
• Provided Production Support to resolve the ongoing issues and troubleshoot the problems.

Environment: Informatica Power Centre 10.4, SQL Server 2016, Netezza server, Oracle server, Zena.

Confidential

Informatica ETL Developer

Responsibilities:

• Interacted with end-users and functional analysts to identify and develop business requirements and transform them into technical requirements.
• Used Data vault model and maintained ETL (Data Extraction, Transformation and Loading) mappings accordingly as per the business requirements.
• Created a huge number of complex mappings to implement ETL throughout from Source (SQL Databases, CSV files and Flat files) to Staging (HUB’s, SAT’s, LINK’s, LINKSAT’s) and then to DataMart (Dimensions, Facts and Materialized Facts).
• Created mappings using Source Qualifier, Expression, Aggregate, Sequence Generator, Joiner, Filter, Rank and Router transformations, Union transformation, Stored procedure transformation.
• Used debugger to test the data flow and fixed the mappings.
• Created Stored Procedure, Functions and Triggers as per the business requirements
• Used Update Strategy and Lookup transformation to implement the Change Data Capture process.
• Maintained version control to keep track of the changes in the Dev.
• Worked with Push down optimization to improve performance.
• Extensively used Workflow Manager to create connections, sessions, tasks and workflows
• Created design documents and performed Unit Testing on the Mappings.
• Created complex SCD type 1 type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformation.
• Worked on identifying Mapping Bottlenecks in Source, Target and sessions to improve performance.
• Worked with Autosys Scheduler to schedule Informatica sessions on daily basis and to send an email after the completion of loading.
• Work closely with DBAs, application, database and ETL developers, change control management for migrating developed mappings to production.
• Production support for the Informatica process, troubleshoot and debug any errors.

Environment: Informatica Power Centre 10.1, SQL Server 2016, Oracle Server, SQL Server management studio, Unix, Autosys.

Confidential, Austin, Texas

Informatica IDQ Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• Created complex mappings in Power Centre Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Centre Tools like designer, workflow manager, workflow monitor and repository manager.
• Worked on multiple projects using Informatica developer tool IDQ of latest versions 9.1.0 and 9.5.1.
• Involved in migration of the mappings from IDQ to power centre
• Applied the rules and profiled the source and target table's data using IDQ.
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Worked on different environments with different source and target databases like Teradata, DB2, and SQL server.
• Developed the mapping to process multiple flat files as source and staged the data into Teradata and DB2 databases.
• Responsible for migration of the work from dev environment to testing environment
• Responsible for solving the testing issues.

Environment: Informatica Power Center 9.6, Informatica Data Quality 9.6 .1, Oracle 11g, Teradata 13.1, DB2, IBM Mainframes, UNIX, Windows NT.

Confidential, Salt Lake City, UT

Informatica ETL Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Designed ETL specification documents to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 9.6, SQLServer2008, Oracle 11g, MS Access, Windows XP, Tidal, Cognos 8.4.1, Toad .

Confidential

Informatica ETL Developer

Responsibilities:

• Interacted with Business Analysts for requirement gathering, understanding the requirements, explanation of technical probabilities and application flow.
• Developed ETL mappings using Informatica Power Center 8.6
• Extracted data from flat files and loaded the data into Oracle staging using Informatica Power Center.
• Analysed Source Data to resolve post-production issues. Used MS Access to analyse source data from flat files.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Scheduled workflow daily basis for incremental data loading
• Wrote PL/SQL Procedures for data extractions, transformation, and loading.
• Assisted in Data Modeling and Dimensional Data Modeling.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Scheduling jobs using TWS to automate the Informatica Sessions.
• Used TOAD to FTP file moving processes to and from source systems.
• Performed Unit testing for all the interfaces.
• Used Test Director to log and keep a track of the defects.
• Provided Production Support at the end of every release.

Environment: Informatica Power center 8.6.1, Oracle 10g/9i,Sql Server 2000, UNIX, Shell script, Toad, SQL *Loader, MS SQL, PL/SQL, Visio, TWS.