SUMMARY:

• Over 7 years of IT experience in analysis, design, modeling, development, implementation and testing of Data Warehousing and Client/Server applications and also in locations like India and USA.
• Extensively worked on ETL developer using Informatica Master Data Management, Informatica Power Center (Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer, Transformation developer) Repository manager, Workflow manager & Workflow monitor.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources like Oracle, DB2, SQL Server, XML and Flat Files.
• Hands on experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL solution using Informatica Power Center Knowledge in ETL and Data warehousing with OLAP technology.
• Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Experience on Informatica designer tools - transformations, reusable transformations, mapping, and mapplets.
• Experience in RDBMS such as ORACLE 12c/11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , Teradata 12.0, DB2, SQL, T-SQL and PL/SQL.
• Good understanding and working experience in Logical and Physical data models that capture current/future state data elements and data flows using Erwin.
• Experience working in Oracle 9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes.
• Efficient in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall.
• Extensive experience in dealing with High Volume Data, Performance Tuning, Maintaining, Multiple Job. Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Designed using Informatica Power Center in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, configuring the Informatica Server and scheduling the Workflows, sessions and Experience in writing daily batch jobs using UNIX shell scripts.
• Having exposure in UNIX, worked on TWS to schedule the jobs.
• Implemented Performance Tuning Techniques and Error Handling at various levels such as sources, Target, mappings.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon and surrogate key assignment and CDC (Change Data Capture) using Informatica.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Hands-on experience with Oracle APEX 3.2/4.0/4.1 (Oracle Application Express).
• The ability to adapt and learn new technologies and proficient in learning them quickly.
• Strong oral and written communication skills to maintain productive work relationships with management, clients, team members and other groups.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, Java, HTML

Operating System: UNIX, LINUX, Windows 7/vista/2000/2003

Databases: Oracle 11g/10g/9i, TOAD, DB2, Teradata V2R4, MS SQL Server 2012/2008/2005.

ETL Tools: Informatica Power Center 10.1.1/9.6.1/9.1/8.6

BI Tools: Tableau

Web Technologies: HTML

PROFESSIONAL EXPERIENCE:

Sr. ETL Developer

Confidential, Houston, TX

Environment: Informatica, Tableau, Cognos and Oracle 11g

Responsibilities:

• Worked to transform requirements into technical design.
• Overall responsibility for requirements analysis, estimation, architecture, design and implementation of the ETL processes include defining the data quality.
• Responsible for Project Estimation, Planning and interaction with Business users and Subject matter experts.
• Designing and developing highly scalable and maintainable ETL. (high level, low level)
• Conversion of Business functionalities to Informatica flows.
• Guide and help development team with performance and other technology issues. Competency building, mentoring and providing training within the team.
• Single point of contact and close interaction with business users.
• Prepared the data integration strategy to integrate Informatica with SAP to extract the data from various SAP modules.
• Lead the team in designing the mappings, sessions, work lets and workflows in Informatica.
• Extensively involved in performance tuning of the Informatica Mappings and workflows.
• Supported the migration of Informatica components from Development to environment to QA and Production.
• Developed Stored Procedures, Packages, and Functions using PL/SQL.
• Involved in tuning the long running SQL queries and PL/SQL queries for maximum efficiency.
• Coordinated development and integration activities with DBA, Tech Architects, and other development teams.
• Established project plans, including assignment of resources and development of schedule for assigned projects.
• Tracked project delivery to established plans, ensuring on time and on delivery.
• Coordinated with counter parts end-to-end design and development of assigned Enterprise Data Warehouse solutions and subject areas.
• Guided and reviewed technical, critical issues and bug fixes.
• Developed test plans to conduct the Unit, QA, Integration, acceptance and load testing.
• Responsible for 24/7 Production support during loads. Addressed the issues/failures within the SLA. Join the bridge line to work with all the impacted downstream applications/interfaces and make sure the issues resolved and Problem Ticket has been closed properly and sign-offs from the technical counter parts of impacted interfaces.
• Prepared the Production support guideline document for the team to follow the process as per standards of GE energy

ETL Informatica Developer

Confidential, Houston, TX

Environment: Informatica, Tableau, Cognos and Oracle 11g

Responsibilities:

• Building the multiple graphs to unload all the data needed from source databases by configuring the dB file in the Input Table component.
• Developing and Uniting tested Ab Initio graphs using GDE for Extraction, Transformation and Loading of data from source to target.
• Designing and developing new ETL processes with Ab Initio graphs and Teradata BTEQ scripts to implement new business functionalities.
• Proficient in Teradata TD13.0/TD14.0 database design (conceptual and physical), Query optimization, Performance Tuning.
• Strong hands on experience using Teradata utilities (Fast Export, Multiload, Fast Load, Tpump, BTEQ and QueryMan).
• Extensively use Database and Dataset components like Input file, Input table, Output table and transform components like Join, Rollup, Scan, Filter by expression, Reformat and other components like Merge, Lookup, Dedup and Sort.
• Implementing component, pipeline and data parallelism using Ab Initio for ETL process.
• Extensively involve in performing EME dependency analysis and maintained version control using EME.
• Using Partition components like partition by expression, partition by key, etc., to run the middle layer processing parallel.
• Extensively use various inbuilt transform functions like string substring, string lrtrim, is null string lpad, string index, lookup functions, date functions, error functions.
• Effectively use Multi file system (MFS) to execute the graph parallel.
• Working on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory sort in joins and rollups to speed up various Ab Initio graphs and optimum maxcore parameter for memory optimization.
• Extensively working in the UNIX environment using Shell Scripts.
• Working on scheduling using Control-M to schedule the jobs

Informatica Developer

Confidential, San Jose, CA

Environment: Informatica, Tableau, Cognos and Oracle 11g

• Developed database objects like Stored Procedures, Functions, and Packages using PL/SQL
• Created Tables, Indexes, Views and improved database performance
• Analyze SQL statements, reorganize database objects and design indexes to improve query response time.
• Tuned stored procedures and triggers identified for better performance
• Involved tuning and applying the SQL statements and PL/SQL processes
• Experience with Data flow diagrams, Entity relation modeling and design techniques.
• Worked along with the DBA to resolve performance and tuning issues
• Gathered reporting requirements from business end users/clients
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, Flat files and loaded into target
• Designed, developed and supported ETL and business intelligence applications
• Worked on creating the Universes using Information Design tool and Universe Design Tool in BI4.
• Interacted with data analyst/QA teams on client side to get resolution/validate the issues
• Developing mappings and workflows to source data from multiple different sources like mainframe files, flat files, XML and relational tables.

Apps Developer (Informatica)

Confidential, CA

Environment: Informatica, Oracle 11g

Responsibilities:

• Production Support & Development:
• Assigned to Development and Support Project.
• Responsible for monitoring data loads and restore of failed loads.
• Responsible for changing existing design as per the requirements of the user.
• Involved in client meetings & informing them to sort out their mistakes to resolve data extraction problems especially with the invalid characters.
• Worked with basis team for database issues during data extractions.
• Expertise in tickets handling raised by users & resolving them within
• SLAs.
• Responsible for writing some small routines and enhancements.
• Responsible for monitoring of Process Chains and analyzing the errors for frequent failures of Process Chains.
• Migration of different data sources and their flows, Developed new reports as a part of CR.
• Monitoring of Daily data loads using Process Chains.

Environment : Oracle 10g/11g, PL/SQL, MS SQL Server, SQL Developer, Windows, Unix/Linux.