Senior Informatica Developer And Team Lead Resume
SUMMARY
- Data warehouse/Business Intelligence professional wif 7+ Years of experience in designing Data warehouse and Business Intelligence solutions to support senior management decisions.
- Complete development lifecycle knowledge of data warehousing - ETL process, OLAP, worked extensively on ETL tools Informatica, OWB, Oracle programming like SQL, PLSQL and OLAP tool OBIEE.
- Looking for long-term associations wif a people oriented organization where individual talent acknowledged and conductive culture is provided.
- Expertise in Informatica Power Center 9.x/8.x/7.x data integration tools - Repository Manager, Designer, Workflow manager, Workflow monitor.
- Extensive experience in Retail, Logistics, Banking and Manufacturing domains.
- Knowledge on Oracle APPS modules like Oracle management and Account Receivables, Account Payables, Finance, Manufacturing, Purchase Order and HR.
- Good knowledge on Data warehouse concepts like Normalization, Star and Snowflake schema, Slowly Changing Dimensions, Dimensional modeling.
- Strong experience working wif different RDMS like Oracle, Microsoft SQL Server and wif different file systems like flat files and XML files.
- Extensive experience in Extraction, Transformation and Loading of data from multiple source systems to Data warehouse.
- Hands on experience wif Informatica Administration performing tasks like creating user accounts, creating folders, setting privileges to users, Repository migrations, Version enabling and Deployment Group.
- Experience wif Informatica Advanced Techniques - Dynamic Caching, Memory Management, Push down optimization, Parallel Processing to increase Performance throughput.
- Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
- Experience in Data Profiling using Informatica Data Quality tool (IDQ)
- Strong skills in Oracle Programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Collections, regular expressions, exception handling.
- Extensive experience in identifying performance issues, debugging and performance tuning, analyzing Explain plan, Indexing, Hints, Partitioning, Bulk processing, DBMS Trace.
- Knowledge on Oracle VPD (Virtual Private Database) implementation for security and Exchange Partition for improving the OLAP performance.
- Extensive experience in data migration techniques using SQL* Loader, Import/Export.
- Skilled in writing and debugging Unix Shell Scripts.
- Knowledge on developing repository file, hierarchies and Reports/Dashboards using Business Intelligence tool OBIEE.
- Knowledge of Hadoop Architecture and various components such as HDFS, JobTracker, TaskTracker, NameNode, Data Node, Map Reduce, Sqoop and Hive.
- Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and Vice-versa.
- Experience in preparing Estimation documents, SOW’s (Statement of work), High and Low level Mapping Design documents, RCA (Root Cause Analysis), Unit Test Case documents, Weekly status reports.
- Experience in Client interaction & leading teams in delivering end-to-end solutions and familiar wif the onsite/offshore model.
- Experience in the full-cycle software development including by Savepass">requirement s gathering, prototyping, proof of concept, design, documentation, implementation, testing, maintenance and production support.
- A highly motivated self-starter and a good team-player wif excellent verbal and written communication skills.
TECHNICAL SKILLS
ETL: Informatica 7.1.1/8.6/9.1/9.5, Informatica IDQ, SSIS 2008, OWBHadoop
OLAP: OBIEE, Spotfire
RDBMS: Oracle 9i/10g/11g, Microsoft SQL Server 2005/2008
Languages: SQL, PL/SQL, HQL, Unix Shell scripting, C, C++, Java
Scheduling Tools: Tivoli, UC4, Control-M, Crontab, Autosys
Other Tools: MS Office, TOAD, SQL Loader, SQL Developer 11g, APEX, Concurrent
Operating Systems: Windows 98/NT/2000/XP, UNIX
PROFESSIONAL EXPERIENCE
Confidential
Senior Informatica Developer and Team Lead
Environment: Oracle 11g, Informatica 9.5, Informatica IDQ, OBIEE 10g/11g, UNIX, Tivoli, Shell scripting, PVCS, APEX, OWB
Responsibilities:
- Technical lead of an offshore team, duties included managing end to end BI system from sourcing application data to end user reports.
- Facilitaterequirements gathering and design sessions wif product owners.
- Provide technical and functional direction to our customers in matters of implementing technology wifin their by Savepass">Business processes.
- Create Dimension models for OBIEE subject areas.
- Create SOW’s, High level and low level design documents for the ETL load.
- Work on Informatica Power Center to create mappings, sessions and workflows to populate the data into the dimension, fact, and lookup tables from different source systems (Oracle EBS, SQL Server, Flat files).
- Create mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
- Implement Incremental data loading using Session Parameter file and mapping variables.
- Develop a number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
- Create users and folder in Informatica Server and assign users to groups as per the roles defined.
- Create user defined functions to use in Informatica as per business requirements.
- Used Mapping Parameters, Mapping Variables, Workflow Variables, Parameter file to implement the business logic
- Worked on data analysis and profiling using Informatica IDQ.
- Create Unix Shell scripts to automate the Point of sales data load across regions. Obtain load statistics and set up the distribution list for success or failures according to regions.
- Create Shell scripts to read the files from the external server and transfer to the Informatica server, delete the old log files, archive the source files.
- Implement Performance tuning by identifying and eliminating the bottlenecks, implementing persistent cache, partitioning.
- Involved in the impact analysis and enhancement of Informatica and OBIEE subject areas during R12 migration.
- Created mappings and workflows for Booking Subject area using OWB.
- Development, enhancement and monitoring of job scheduling using the UC4 tool.
- Perform the production support activities which involve managing the smooth functioning of OBI servers and environment.
- Involved in interaction wif the various end users across the globe on understanding their BI issues and providing a strong solution to the same in a strict time frame.
- Administration and maintenance of BI users which includes providing necessary access permissions to the BI environment.
- Used OBIEE Answers, Dashboards, iBOTs and Delivers for the report and dashboard development and scheduling.
Confidential
Senior PLSQL Developer
Environment: Oracle 11g, Microsoft SQL Server 2008, SQLLoader, PLSQL, Informatica 9.1, SSIS, OBIEE 10g, UC4, CVS, Autosys
Responsibilities:
- Co-ordinate sessions wif Business analyst for performing data analysis and gathering business requirements.
- Develop technical specifications of the ETL process flow and create the high level and low level design documents.
- Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
- Implement Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures
- Design, develop and maintain Oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, nonunique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects. Use Collections like Index by table, variable arrays and by Savepass">Nested tables.
- Create SQL Loader control files/procedures to load the Point of Sales data into Oracle
- Create PL/SQL packages, stand alone procedures, and stand alone functions.
- Implement incremental load using project specific log tables.
- Experience in writing complex SQL queries wif sub-queries, analytical functions, scalar subqueries and inline views.
- Performance tune and optimize SQL using explain plans, temporary tables and optimizer hints, bulk processing.
- Experience in PLSQL tuning using explain plans, SQL trace, tkprof, DBMS Profiler
- Develop Unix shell scripts to establish check rules for flat file sources before loading into the warehouse.
- Create SSIS mappings to load CRM data from SQL server to Oracle.
- Used Autosys utility to schedule batch processing and on call for supporting batch.
- Provide on call and daily production support for Oracle PL/SQL ETL processes.
- Manage User Acceptance Testing of new applications and new versions of existing applications.
- Manage the packaging and release of applications to the training, UAT and production environments.
- Perform the project related activities like preparing the status reports and driving the weekly status calls.
Confidential
ETL Developer
Environment: XP, Oracle 11g, Informatica 8.6, SQL Server, UNIX
Responsibilities:
- Interacted wif the Business Users in the requirement gathering and design of technical specification documents.
- Work on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Extensively Used Informatica to load OLTP data into the Staging Area and Data Warehouse. Source Systems are mainly flat files and relational tables.
- Extensively used Transformations like Router, Joiner, Expression, Filters, Lookups, Update Strategy, Transaction Control and Sequence Generator/Oracle sequence.
- Develop SCD Type 1 and Type 2 mappings by using Source qualifier, Look up, Router, Expression, Update Strategy and Sequence Generator Transformations.
- Extensively involved in Performance tuning of the mappings and then made performance improvements to the database by creating indexes and partitions.
- Create Unix shell scripts to remove log files older than 3 months.
- Develop schedules to automate the update processes and Informatica Sessions/Batches.
- Prepare the Unit test plan and Integration test plan document as per our business requirement.
- Prepared ETL mapping Documents for every mapping and Data Migration document for the smooth transfer of the project from development to testing environment and then to the production environment.
Confidential
Developer
Environment: XP, Oracle 11g, Informatica 7.1.1, Spot fire
Responsibilities:
- Extracting data and transforming the data before loading the data into the target (warehouse) Oracle tables. The transformations included generating unique sequence numbers and aggregations for the star schema target tables. The data sources were Oracle database and flat files and the target tables were in an Oracle database.
- Lookup transformations to compare the source and target values and Update strategy transformations are used for Update or insert the records.
- Create mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
- Validate Informatica Mappings for Performance Tuning.
- Schedule the ETL jobs using Control-M.
- Create Scenario Tracker by understanding Business Scenarios related to project.
- Business Logics for each KPI using Spot fire.
- Create Dashboards using Spot fire Tool.
- Format the reports to meet the user requirements using Multi-Dimensional Analysis like slice and Dice, Drill down.
- Create the unit test cases (UTC) and test scenarios to test the reports according to the business requirement.
Confidential
Developer
Environment: XP, OBIEE 10.1.3, Oracle 11g, PLSQL.
Responsibilities:
- Created new procedures, functions, triggers, packages, tables, views and SQL*Loader scripts
- Fine tuned SQL queries using hints for maximum efficiency and performance.
- Develop the various reports wif conditional formatting by using Presentation Services.
- Involved in creating the repository using administrator.
- Develop hierarchies to support drill down reports.
- Format the reports to meet the user requirements using Multi-Dimensional Analysis like slice and Dice, Drill down.
- Create various standard reports and Adhoc reports based on the existing objects.
- Create the unit test cases (UTC) and test scenarios to test the reports according to the business requirement.