PROFESSIONAL SUMMARY:

• 10+ years of professional experience as ETL Developer including experience in designing and development of Data warehouse/Data Migration/ Data Integration on projects as Informatica ETL consultant. Looking for an opportunity that utilizes my business analysis, technical expertise, and skills in design, development, and testing using Informatica.
• Strong in Dimensional Modeling, Star/Snow Flake Schema, Extraction, Transformation & Load and Aggregates.
• Creating data models, building Informatica ETL processes, dimensional data modeling primarily star schema, performing data migration, defining user interfaces, executing large projects, assuring quality and deployment.
• Developed staging areas to Extract, Transform and Load new data from the OLTP database to Data warehouse.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Powercenter 9.x/8.x/7.x.
• Extensively used Informatica client tools like Powercenter Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Workflow Manager, Repository Manager, and Workflow Monitor and Informatica Admin console.
• Extensively worked on Informatica Powercenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer and Union.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and files like Flat files, CSV.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power center.
• Hands on experience in Performing tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, transformations, mappings and sessions.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Experienced in environments requiring direct customer interaction during design specification, development and acceptance testing and implementation phases.
• Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as proactive team member in an Agile methodology.
• Performed evaluation of ETL tools and recommended the most suitable solutions depending on business needs.
• Excellent knowledge with Unit Testing, Regression Testing, Client Acceptance testing, production implementation and maintenance.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data.
• Ability to learn & adapt to new technologies at rapid speed.
• Excellent Communication, Presentation, Documentation & Analytical skills using tools like Visio and PowerPoint.
• Has a very strong technical foundation with excellent communication with executives and clients on both the business and IT side.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. ETL developer

Responsibilities:

• Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL - related activities
• Develop and ensure adherence to locally defined standards for all developed components
• Maintain "common code" libraries, so objects can be shared for all environments (Dev, Test, and Production)
• Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
• Participate in requirements, design, and development reviews
• Conduct or participate in meetings with owners of key system components to fully understand current data and systems environments
• Assist in production support by resolving source data issues and refining transformation rules
• Analyze source system data and work with technical and business representatives to determine strategies for handling data anomalies that are identified
• Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes that assist in implementing enterprise-class data warehousing solutions
• Use the Informatica platform to extract, transform, and load data through development, testing, and integration of ETL routines, using ETL tools and external programming/scripting languages as necessary
• Assist in writing unit test cases when necessary
• Provide data analysis and technical documentation for both source and target mappings
• Identify problems, develop ideas, and propose solutions within differing situations requiring analytical, evaluative, or constructive thinking in daily work
• Prepare and present ideas and recommendations to colleagues and management
• Apply creative thinking to identify possible reporting solution alternatives
• Other duties assigned as needed

Confidential, Lake Mary, FL

Sr. ETL developer / Data Modeler

Responsibilities:

• Participate in Scrum ceremonies along with business owners and team members.
• Worked closely with business users and product owners to gather requirements and effectively provided resolutions for the defects/questions raised by them.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator, SQL, XML Parser etc.
• Extensively used Informatica to load data from flat files, Oracle and DB2 databases for staging the data and to capture Changes using SCD Type 2.
• Developed/Modified various UNIX shell scripts to run Informatica workflow and job executions.
• Created templates for parameter files for different environments.
• Used parameter files and pmcmd command for the execution of Informatica Workflows.
• Developed Complex Mappings as per the design document with proper naming conventions for transformations and Mapping variables
• Created Workflows and Worklets and scheduled them using Workflow Manager.
• Designing mapping documents which includes details of field to field mapping between sources and target, Business Rules, Processing Flow and details of sessions, workflows, pre dependencies, post dependencies, exception error processing methodology.
• Created Impact Analysis Document on existing Data Mart for versioning.
• Involved in Data validation, Unit Testing and String Testing, created Unit and String Test Documents.
• Created Labels and deployment groups for Informatica objects for migration from lower environment to higher environments.
• Analyzed on existing Data Mart and worked on UNIX scripts to load the data and file archiving
• Fine-tuned Transformations and Mappings for better performance, Used Debugger for debugging mappings.
• Worked closely with Oracle DBAs in analyzing query performance and suggesting Indexes.
• Created/Updated various Autosys automation jobs to schedule and run Informatica jobs.
• Provided extensive Detail design documentation on the design, development, implementation, loads and process flow for Production Support Team.

Environment: Informatica Power Center 10.2/9.6, PL/SQL, SQL, Oracle 11g, TOAD 10.1.1, Flat Files JIRA, Unix, Autosys, ServiceNow.

Confidential

ETL DEVELOPER / DATA MODELER

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created Mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• 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.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center, PL/SQL, SQL, Oracle 11g, TOAD 10.1.1.

Confidential

Database developer

Responsibilities:

• Responsible to Load the data from legacy systems to Siebel Customer Service Application By using Informatica.
• Map the different legacy systems to Siebel Customer Service application by using Informatica.
• Developed Oracle procedures and Informatica Mappings.
• Drafted the Functional design, Technical design and Master Build documents.
• Scheduled the workflows by using Redwood to perform an End to End load for Batch runs.

Confidential

ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Power Center Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Extracted data from the flat files and other RDBMS databases like Oracle into staging area and populated onto Data warehouse.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement and Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager and Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Created detailed Unit Test Document with all possible Test cases/Scripts and involved in Unit, Integration, System and Performance testing levels.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created Mapplets and Worklets to re-use them in different Informatica mappings and workflows.
• Used Debugger to test the mappings and fixed the bugs and tuned the Informatica mappings for optimal load performance.
• Worked on Query Optimization and ETL performance tuning for improving the performance of the data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in writing procedures, functions in PL/SQL.
• Conducted code reviews developed by my teammates before moving the code into QA and Prepared migration document and deployment checklist to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 9.6, Oracle 11g, SQL, Flat files.

Confidential

MS SQL Server Developer / BI Developer (SSIS)

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Created a CRM Entity Modification tool, functional diagrams, and workflow diagrams
• Updated design documents as necessary to reflect changes necessitated by change requests and implementation issues(MS Dynamics CRM)
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources through ETL tool
• Multi-dimensional cube modeling and reporting using (Data warehouse / data mart modeling and implementation)
• Design and Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Using MDX created calculated members for customized calculated measures
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Generated daily, weekly and monthly reports for the managers using SSRS
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Conducted quantitative analysis of financial data to forecast revenue, identify future trends, and risk associated with capital expenditures by creating cubes (SSAS)
• Utilized pivot tables to provide structure to reports in proper format like months etc
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Created reports and scheduled using SSRS to support Financial Planner to deliver informational sales presentations to potential clients
• Developed various operational Drill-through, Drill-down, and linked reports using SSRS
• Developed different kind of reports such a Sub Reports, Chars, Matrix reports, and Linked reports
• Designed, deployed, and maintained of various SSRS Reports in SQL Server.

Environment: SQL Server 2012/2008R2, Microsoft Visual Studio, SQL server Integration Services(SSIS), SQL server Reporting Services(SSRS), SQL server Analysis Services(SSAS), Crystal Reports, Windows 7, MS Office 2007/2010