PROFESSIONAL SUMMARY:

• Over 8+ years of total IT experience and technical proficiency in building Data Warehouses, Data Marts, Data Integration, Operational Data Stores and ETL processes for clients in Retail and HealthCare domains.
• 8+ years of strong experience in working with large scale Data Warehouse implementations using Informatica PowerCenter 9.1/9.5/9.x, Oracle, DB2, SQL Server,sybase on UNIX and Windows platforms.
• Strong knowledge in OLAP systems, Kimball, and Inmon methodology & models, Dimensional modeling using Star and Snowflake schema.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Workflow Manager, Workflow Monitor, and Informatica Administration Console).
• Excellent expertise with different types of data load strategies and scenarios like Historical Dimensions, Surrogate keys Summary facts etc.
• 8+ years advanced experience with SQL relational databases
• Experience using reporting tools such as Salesforce, Oracle Business Intelligence, Tableau and SAS
• Experience working with the project management teams.
• Experience with data mining, report creation, modeling, and trend forecasting
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Informatica Administration Console)
• Experience in performance tuning of Informatica mappings and sessions to improve performance of the large volume projects.
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica PowerCenter
• Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views, and Indexes in distributed environment.
• Experience in Migration, Configuration and Administration of Informatica PowerCenter
• Proficient in Data warehousing theory, practice and combined with strong hands - on experience in data warehousing, frameworks development and data architecture
• Strong written communication skills; outstanding interpersonal and oral communication skills
• Responsible for database schema design, extensive T-SQL development, integration testing and other projects that may be necessary to help the team achieve their goals
• Experience in project management, estimations, and resource management activities.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.
• Good knowledge on generating various complex reports using Tableau.

SKILL:

• Informatica Power Center 9.1/9.5/9.6
• Oracle 10g/11g,SQL server
• SQL developer
• SQL,T-SQL,PL?SQL
• Linux,Unix,windows
• SalesForce,Tableau
• Business Analysis
• Data Warehousing
• Database design
• Data modeling
• Agile Scrum
• Master data management
• Data profiling
• Troubleshooting
• Microsoft Excel

WORK HISTORY:

Senior Informatica Developer/Data Analyst

Confidential, Plano, TX

Responsibilities:

• Interacted with business users to gather both functional and technical requirements. Also worked closely with them to gather requirements.
• Worked with informatica client tools Mapping Designer,Source Analyzer,Warehouse Designer,Mapplet Designer,Transformation Developer,Workflow Manager and Workflow Monitor.
• Designed and developed informatica mappings to load data from source systems to customer ODS and then to Enterprise Data Warehouse.
• Developed SQL queries to extract, manipulate, and summarize information.
• Documented technical details to facilitate collaboration with other team members and ensure quality control
• Completed initial data assessment, data quality analysis, source-to-target mappings for data migration and integration, and testing support.
• Applied quality assurance best practices for data mining and analysis.
• Created PL/SQL stored procedure and called them from informatica PowerCenter.
• Used Agile methodology for SDLC and utilize scrum meetings for creative and productive work.
• Designed, developed, and tested Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Transferred data from various sources like XML, flat files, DB2 into Oracle data warehouse.
• Developed and used SQL Queries to validate data in both source and target databases.
• Worked with DBA's and systems support personnel in elevating and automating successful code to production.
• Worked with Data Architect and Application Owners to analyze data in legacy application to determine data migration complexity, to identify information gaps against new requirements or conflicts across multiple applications.
• Coordinated activities with data source application owners to ensure integration, data integrity and data quality.
• Worked independently, preparing project status reports and formal presentations as required.
• Moving mappings and workflows from Dev to QA and QA to Production environment and unit testing the process at every level.
• Monitoring loads (workflows) whether loads are scheduled to respective timings.
• Recovery or Re-start in loads in case of any failures.
• Performed Informatica Power Center 8.x/9.x System Administration and Power Exchange System Administration including Team Based Development administration.
• Mined data to uncover insights and identify market trends and inflection points.
• Spearheaded diverse projects, including data capture, storage, configuration and forecast analysis.
• Analyzed and tracked data to prepare forecasts and identify trends.
• Prepared Business Requirement Documents (BRDs) to provide scope of work for technical team.

Environment: Informatica Power Center 9.0.1/9.5x,SQL Developer,Oracle 10g/11g,stored procedures,XML, Shell Scripts,UNIX, ER studio,windows XP.

ETL Informatica Developer/Master Data Manager

Confidential, Flagstaff, AZ

Responsibilities:

• Contributed to development of data architecture and data modeling including developing extracts,dashboards,and data solutions.
• Lead data analysis, data quality validation, requirement gathering, data modeling and data warehouse design and maintains and develops documentation to identify and define processes or procedures in accordance with industry best practices.
• Created workflows and sessions, developed ETL mapping solutions within data warehouse environment and actively looked to improve support and monitoring of ETL systems.
• Performed extensive data analysis of source transaction processing systems.
• Developed new and modified existing data marts organizing data in Star Schemas.
• Developed SQL queries to extract, manipulate, and summarize information.
• Responsible for designing, implementing, and maintaining core data elements (master data, measure definitions, hierarchies, algorithms, etc.)
• Maintained confidentiality with regard to information and data being processed, stored or accessed.
• Provided support of all system/service components, including installation, configuration, maintenance and support.
• Ensure data integrity and compliance by performing data profiling and data validation.
• Applied quality assurance best practices for data mining and analysis.
• Monitoring, troubleshooting and analyzing ETL process failures, data anomalies, inconsistencies and other ETL related issues identified by monitoring, technical staff.
• Involved in debugging failed mappings and developing error-handling methods.
• Developed and supported Extraction,Transformation,and Load(ETL) for data migration using informatica power center.
• Experience in analyzing multiple source systems and based on business requirements build transformation rules to extract,transform and load data in target systems.
• Involved in tuning of informatica mappings and sessions for optimum performance.
• Developed and used SQL Queries to validate data in both source and target databases.
• Involved in writing UNIX Shell scripts to invoke workflows at scheduled timings.
• Created mappings to perform tasks such as cleansing data and populate that into staging tables,Populating Enterprise Data Warehouse by transforming data into business needs and Populating Data Mart with only required information.
• Consistently met deadlines and requirements for all production work orders.
• Was involved in setting up access roles and privileges,code page setups and appropriate ETL migration activities.
• Scheduling and monitoring Informatica repository backups.
• Tuned database for performance.
• Performed informatica Power Center 9.x system Administration including Team Based Development administration.

Environment: Informatica Power Center 8.6, Oracle 10g/11g,DB2,SQL,PL/SQL,UNIX,Shell scripting,Windows.