SUMMARY

• 8+ years of IT experience as an ETL Developer which includes Data Warehouse/Database Developer experience using Informatica Power Center 9.x/8.x/7.x/6.
• Solid experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling.
• Worked on Repository Server Administration Console, Informatica Power Center Transformations like Connected/Unconnected Lookups, Router, Filter, Expression, Aggregator, Normalizer, Joiner, XML Source Qualifier, Update Strategy, Rank, Stored Procedure, Sorter and Union.
• Expertise in developing Mappings and Mapplets, Sessions, Workflows, Worklets & Tasks, Export & Import Mappings, Workflow Manager and Backup Recovery.
• Experienced in designing and writing on - demand UNIX shell scripts.
• Experience in software development, maintenance, testing and troubleshooting on, Metadata management, data quality, data integration and Oracle database environment in various Verticals.
• Experience in Agile and Waterfall models.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, COBOL files, VSAM, Excel, Oracle, MS SQL Server and Teradata
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: Windows XP/VISTA/7, UNIX, LINUX.

ETL Tools: InformaticaPowerCenter(Designer/workflow manager/workflow monitor) 7.1/8.1/8.6/9.1/9.5.

Data Bases: Oracle11g/10g/9i/8.x, SQL Server 2012/2008/2005, MS Access 2000, MySQL, Teradata, DB2.

Software Tools: SQL*plus, SQL developer, Excel and Power point, MS ACCESS, SQL * loader, Toad.

Programming Languages: C, C++, UNIX, SQL, PL/SQL.

Data Modeling Tool: Erwin.

Scheduling Tool: Autosys, Tivoli.

Reporting Tool: COGNOS

Scripting Languages: UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

ETL Developer

Responsibilities:

• Involved in design, development and implementation of ETL process in power center.
• Extracted data from Oracle, SQL Server, Flat files and DB2 source systems.
• Involved in Dimensional modeling (star schema) of the Data warehouse and using Erwin to design the business process, dimensions and measured facts.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Joiner, Source Qualifier, Aggregator, Filter, Sorter, Update Strategy transformations.
• Designed Complex mappings for Slowly Changing Dimensions using Lookup (connected and unconnected), Update strategy and filter transformations for retaining consistent historical data.
• Worked with system Analysts to prepare detailed space from which program will be written.
• Wrote Triggers, PL/SQL Procedures, and Functions to validate the complex mappings.
• Developed Shell scripts for Job Automation.
• Responsible for managing, scheduling and monitoring the workflow sessions.
• Responsible for Error handling, bug fixing, Session monitoring, log analysis.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Responsible for migration of Informatica mappings, workflows between different environments.
• Effectively communicated with Informatica Support team on Informatica bugs & issues.

Environment: Informatica Power Center 9.6 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), SQL, PL/SQL, Oracle 11g/10g, DB2, Flat files, Shell Scripting, UNIX, Mainframes, Windows.

Confidential, Charlotte NC

ETL developer

Responsibilities:

• Involve in requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Designed and developed new maps to load data from planning apps to DM.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Worked with Informatica Power Exchange to load data maps into designer.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance.
• Supported migration of ETL code from development to QA and QA to production environments.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Involved in production deployments of the projects.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

Environment: Informatica Power Center 9.5(Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 11g, Toad, SQL Server 2012, IBM DB2, UNIX, Erwin, SQL *Plus.

Confidential, Kansas City MO

ETL developer

Responsibilities:

• Interacted with end users to get business Requirements and reporting needs. Created Business Requirement Document based on the client requirement and existing application.
• Designed and developed ETL strategies and mappings from source systems to target systems.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Designed, Developed and implemented of project from the Initial Life Phase until deployment into production.
• Informatica Power Center 8.6 was used to develop ETL mappings and transformations, and to load data.
• Modified existing mappings in accordance with the Data Model.
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Used Informatica Server manager to create Sessions and Workflows to run with the logic embedded in the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.
• Involved in Documentation regarding the ETL process.
• Coordinated with offshore site in developing and deploying mappings.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Created database tables, indexes in Oracle Database by implementing various business rules using appropriate constraints and database triggers.

Environment: Informatica Power Center 8.6(Designer, Workflow Manager, Workflow Monitor, Repository Manager), SQL server 2008, XML, Flat Files, Oracle 10g, Toad.

Confidential, Boston MA

ETL Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Worked on ETL tool Informatica to create maps and transformations.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.
• Configuring Repository Manager, created folders and managed objects in repository manager for Informatica.
• Used Filter, Router, Aggregator, Lookup, Expression, and Update Strategy transformations whenever required in the mapping.
• Involved in complete software development life cycle (SDLC) of the project.
• Developed Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Used Change Data Capture to implementincremental load.
• Used CDCmechanism to extract data which has changed at source since last extract and load it in Data marts.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.
• Involved in creation of sessions and scheduling of sessions.

Environment: Oracle8i, Informatica 8.6 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Cognos, Test Director, SQL *Plus, UNIX

Confidential, Irvine CA

ETL Developer

Responsibilities:

• Made use of the documentation prepared by Business Analyst to complete project.
• Extracted data from Teradata database and Oracle database.
• Performed data cleansing and removed unwanted data.
• Performed various transformations like Joiner transformation, Router transformation, aggregate transformation, source qualifier transformation, Filter transformation.
• Thoroughly used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Synchronization has been done between Informatica Metadata and data modeling diagrams.
• Developed and monitored Informatica mappings.
• Loaded the transformed data into the target database
• Synchronization has been done between Informatica Metadata and data modeling diagrams
• Generated the reports using Crystal Reports and made sure that the generated reports satisfies the end user requirements

Environment: Oracle 9i, Informatica Power center (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Teradata, HP Quality Center, Erwin, TOAD, UNIX.