SUMMARY:

• Over 9+ years of IT experience in ETL development and technical Data analysis (Data Warehouse Implementation/development) for Retail, Health care and Banking.
• Working in parallel to multiple projects and production support.
• Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP).
• Expertise on Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
• Involved in preparing ETL mapping specification documents and Transformation rules for the mapping.
• Implemented various ETL solutions as per the business requirement using Informatica 9.x /8.x
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator etc...
• Experienced in defining data quality, data modeling, data warehouse, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process.
• In-depth knowledge and understanding of dimensional modeling (Star schema and Snowflake schema, SCD types- 1, 2, 3), and data modeling (star schema) at logical and physical level.
• Involved in Performance tuning of the informatica mappings, sessions and SQL’s.
• Expertise in integration of various data source definitions like Netezza, SQL Server, Oracle, Flat Files, Excel, SAP, and XML.
• Experienced with Metadata Manager to generate Lineage and load MM resources .
• Extensively worked with SQL loader for bulk loading into the Netezza database.
• Experience in complete life- cycle of test case design, test plans, test execution, defect management.
• Experience in UNIX Shell and Perl Scripting.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Team player with good interpersonal and problem solving skills, ability to work in team and work independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/9.1/8.6.1, Power Exchange and Power Connect

Databases: Netezza, Oracle 11g/10g/9i, SQL Server 2012/2008, and Teradata.

BI Reporting Tools: Oracle Business Intelligence (OBIEE 11.1.1.5/11. X, OBIEE 10.1.3.4.1/10. x), Dashboards, BI Publisher, BI Administration.

Languages: SQL, PL/SQL, HTML, DHTML, XML, UNIX Shell Script, Power shell.

Data Modeling Tools: MS Office Suite, MS project, MS Visio, Model Right (Data Modeler Tool), Erwin Data Modeler 4.1, UML

Web: Oracle Apex, Microsoft Front-page, HTML, DHTML and XML.

Operating Systems: Linux (RHEL),Windows 8/7/NT, UNIX

Multimedia Tools: Adobe Photoshop and Dreamweaver.

PROFESSIONAL EXPERIENCE:

Confidential, KS

Informatica ETL Developer/Technical Data analyst

Responsibilities:

• Technical analysis on data flow and requirement gathering.
• Interacted with the product owners as Technical Data Analysts/ETL developer to understand the process flow and the business.
• Created business documents for ETL process and Analyzing Source to Target mapping Excel document (BRS).
• Created Data Flow Mappings to extract data from source system and Loading to Target.
• Designed SCD-2 and SCD-3 data flow and developed the mappings.
• Created and used various transformations, re-usable tasks, workflows, worklets, mapplets, and re-usable transformations.
• Extensively used UNIX Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Involved in Prod Support to research and resolve the daily load issues.
• Document the Prod job failures and provide the root cause analysis to the management.
• Used Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA and PROD).
• Developed UNIX scripts for scheduling the delta loads and master loads using Autosys Scheduler.

Environment: Informatica Power Center 9.1, Flat files, Oracle 11g, SQL Server 2012/2008, Windows 7/NT, UNIX/Linux, Autosys and Netezza.

ETL Developer & Technical Data Analyst

Responsibilities:

• Technical Data analysis for the complete project life cycle and development.
• Responsible for developing, support and maintenance for the ETL processes
• Interacted with product owners & DBA teams to design the project for ETL process.
• Developed Mappings and Workflows with various transformations.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively used UNIX Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Troubles shoot the Productions failure and provide root cause analysis. Worked on emergency code fixes to Production.

Environment: Informatica Power Center 9.1/8.6.1, Netezza, Oracle 11gr1, DB2 9.7, AIX 6.1/ Linux RHEL 6.x, SQL SERVER 2008/2010, SQL Navigator, SQL, PL/SQL, SAP, Autosys.

ETL/Informatica Developer

Responsibilities:

• Responsible for designing and preparing LLDs and Technical Design Documents for client, offshore team which includes all transformation level detail.
• Developing the mappings, sessions and workflows with by considering all dependencies and maintaining all project standard.
• Performed Data Profiling, Data Quality and Used Erwin for data modeling.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center
• Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Analyzed business process workflows and developed ETL procedures to move data from various source systems to target systems

Environment: Informatica Power Center 9.0.1/8.6.1, Netezza, Oracle 9i, Toad, Control-M, UNIX, Flat Files.

Confidential

ETL Developer

Responsibilities:

• Interact with end users and Business Analyst to gather and understand the Business process and requirements.
• Worked with the Source analysts to figure out the different source systems involved for the project and provided necessary information as per development perspective.
• Involved in design review meetings to finalize the Data Model and the design documents necessary for the development. Prepared and reviewed Technical design documents for ETL coding. Worked on SCD Implementation in Data Stage.
• Created Sessions and workflows for related mappings

Environment: Informatica Power Center 8.1, Oracle 8, SQL Developer, UNIX, HP Quality Center.