SUMMARY

• ETL Developer with 7+ years’ Experience in IT Software field extensively worked on ETL tools IICS, Informatica (10.2 and 9.6 and 8.x) and oracle Extensively worked on Oracle, SQL and reporting tools like Tableau and Obiee 10/11g.
• Extensively worked in developing ETL for supporting Data Extraction, transformation and loading using Informatica Power Center 10.2/9.6 (Workflow Manager, Workflow Monitor, Source Analyzer, Target Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager)and Informatica Intelligent Cloud Services (IICS)
• Experience in AGILE Methodologies - Sprint Planning and Scrum.
• Experience in developing complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extract data from heterogeneous sources like Flat Files, Oracle then load into common target area such as Data warehouse.
• Worked with Scheduling tools like Robot scheduler and DAC.
• Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems in AZURE SQL Data warehouse
• Experience working with IICS concepts relating to data integration, Monitor, Administrator, deployments, permissions and schedules
• Worked on dimensional modeling (Star and Snowflake schema, Kimball methodology)
• Worked on data modeling, Data warehousing, and data migration significant expertise in the design of Conceptual, logical and physical data model using relational data modeling tools.
• Proven track record in troubleshooting of Informatica jobs and addressing production issues like performance tuning and enhancement and resolving priority tickets.
• Experience in Database Management, Data Mining, Software Development Fundamentals, Strategic Planning, Operating Systems, Requirements Analysis, Data warehousing, Data Modeling and Data Marts.
• Area of expertise encompasses Database designing, ETL phases of Data warehousing. Execution of test plans for loading the data successfully.
• Strong database skills with Oracle (performance tuning, complex SQL).
• Monitoring the jobs and fixing the jobs if any job fails in production.
• Good understanding of AZURE SQL DWH concepts relating to storage, distribution, DWH units, resource user groups, connection strings etc.
• Worked with reporting tools like tableau and obiee. Created various reports based on business requirements.
• Experience in designing repository such as business layer, physical layer and presentation layer.
• Created aliases, hierarchies and calculations and various reports such as funnel chart, pareto chart, waterfall chart, bar and line chart etc. based on requirements using tableau and obiee.
• Engaged in creating dashboards and stories using tableau and obiee.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail oriented and problem-solving skills in the technology arena.
• Ability to lead and mentor different teams across different time zones and assigning tasks and process in implementing the duties.
• Self -motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.

TECHNICAL SKILLS

ETL: IICS, Informatica Power Center 10.2/9.6

Databases: AZURE SQL Datawarehouse, Oracle 11/10g, Netezza, Sql server

Data modeling: Star schema, Snowflake schema.

Environment: Windows, UnixScheduling Tool DAC and robot job Scheduler

Reporting Tools: Tableau and Obiee

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles, CA

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Informatica Repository.
• Extensively worked on IICS DATA Integration console to create mapping templates to bring data into staging layer from different source systems like SQL Server, Oracle, Teradata, Salesforce, Flat files, Excel files and PWX CDC
• Worked on oracle change partition techniques. Oracle performance tuning.
• Used various transformations like Filter, Router, Sequence Generator, Expression, Joiner, and Update Strategy.
• Designed and developed UNIX Shell scripts for creating, dropping tables.
• Developed Mappings between source systems and Warehouse components.
• Experience working with Informatica Powerexchange Integration with IICS to read data from condense files and load into AZURE SQL Datawarehouse environment.
• Experience working with various AZURE SQL warehouse connectors including V2 and V3 connectors
• Created reusable transformations and Mapplets to use in multiple Mappings.
• Used debugger to test the data flow and fix the mappings.
• Performed Data Manipulation using basic functions and Informatica Transformation.
• Developed Mappings/Transformation/Mapplets by using Mapping Designer, Transformation Developer and Mapplet Designer in Informatica Power Center.
• Experience working with salesforce connector to read from salesforce objects into AZURE warehouse using IICS
• Created and monitored Sessions/Batches using Informatica Server Manager / Workflow Monitor to load data from Oracle, SQL Server, flat files into target Oracle database
• Experience integrating data using IICS for reporting needs.
• Used Parameter files to initialize workflow variables, mapping parameters and variables.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.

Environment: IICS, Informatica PowerCenter 10.x, AZURE SQL Data Warehouse, Oracle 10G, Flat files, SQL developer, Oracle, Netezza, Unix

Confidential - Jersey City, NJ

Sr. Informatica Developer

Responsibilities:

• Gathered Requirements from the client.
• Involved with architect in designing the project.
• Prepared technical design document.
• Prepared the source to target mapping sheet.
• Provided to technical guidance to the team.
• Worked on data profiling for null and duplicate issues.
• Tuned Informatica Mappings.
• Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Informatica Repository.
• Used various transformations like Filter, Router, Sequence Generator, Expression, Joiner, and Update Strategy.
• Developed Mappings between source systems and Warehouse components.
• Developed Mapplets, Mappings and configured sessions.
• Extensively used almost all the transformations.
• Created reusable transformations and Mapplets to use in multiple Mappings.
• Used debugger to test the data flow and fix the mappings.
• Analyzed newly converted data to establish a baseline measurement for data quality in Data Warehouse.
• Performed Data Manipulation using basic functions and Informatica Transformation.
• Developed Mappings/Transformation/Mapplets by using Mapping Designer, Transformation Developer and Mapplet Designer in Informatica Power Center.

Environment: Informatica PowerCenter 9.1, Oracle 10G, Flat files, SQL plus, UNIX, Robot job scheduler, Netezza

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Developed mapping parameters and variables to support SQL override.
• Sourced transaction data being staged by Golden Gate tool CDC (Change Data Capture) through Informatica Power center and loaded into the target.
• Created mapplets to use them in different mappings.
• Created various DOS Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows using DAC.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

Environment: Informatica PowerCenter 10.2, Oracle 10G, Flat files, SQL plus, DAC

Confidential

Informatica Developer

Responsibilities:

• Experience and created Informatica mappings to populate data into fact tables and dimension tables.
• Developed complex mappings using various transformations.
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Joiner, Stored Procedure.
• Developed mapping parameters and variables to support SQL override.
• Responsibilities included designing and developing complex mappings using Informatica power center 8.6.1, 9.1, 9.5 and 10.2.
• Created pre-session and post-session shell scripts and email notifications.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Performed incremental aggregation to load incremental data into Aggregate tables.
• Used PMCMD commands of Informatica in UNIX to schedule sessions and jobs.
• Created scripts for performing database level query joins, functions.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Tuned the session parameters to increase the efficiency of the sessions in workflow manager. · Fine-tuned Informatica jobs by optimizing all transformations.

Environment: Informatica PowerCenter 9.X, Oracle, Flat files, Oracle Developer, UNIX