- IT Professional with 5+ years of Experience in the Business Requirements Analysis, Application Design, Data Warehousing, Development, Implementations and Testing of software systems in various verticals such as Financial, Retail, Insurance industries.
- 7+ years of strong experience in Data Warehousing and ETL using Informatica Power Center 9.6/9.51/9.0.1/8.x/7.x/6.1,Oracle 11g/10g/9i, Taradata 13/12/V2R6 and Erwin.
- 3 years of experience on real-time data Warehouse development using CDC tool Informatica Power Exchange 9.1/8.6/8.1.
- Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica understands complex mappings transformation rules, data formats and efficient in performance tuning of sources, mappings, targets and sessions.
- Experience in Power Exchange to connect and import sources from external systems like SAP R/3, DB2, Salesforce, Mainframes, and AS/400.
- Designed and developed mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure, Update Strategy, SCD's Type1, Type2 and Type3.
- Knowledge of Informatica administration in windows and Linux environment
- Proven experience at building, motivating and leading professional teams, managing projects and supporting client relationships.
- Knowledge of tools such as Erwin and MS Visio Professional.
- Experienced with Multiple Databases including Oracle 11g/10g/9i, Teradata13/12, MS SQL Server 2008/2000 and DB2.
- Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
- Worked on Oracle Procedure, Function, Package and Trigger.
- Worked on Teradata utilities BTEQ, FLOAD, FEXPORT, MLOAD and TPUMP.
- Developed test case’s for business and user requirements to perform System/ Integration / Performance testing.
- Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
- Expertise in Performance Tuning of overall data warehouse, database, ETL and OLAP tuning coordinating with DBAs and UNIX Administrator for better performance.
- Confident self-starter, independent worker and team player.
- Data Profiling use IDQ for data profiling , mapping Use Informatica Analyst generate data profiling report .
SKILLS
ETL Tools:
Informatica Power Center 9.6/9.5/9.1/8.6/8.1/7.1, Informatica PowerExchange 9.1/8.6
Databases:
Oracle 11g/10g/9i, DB2 8.0/7.0/6.0, Teradata 13/12, MS SQL Server 2000/7.0/6.5, MS Access 7.0/97/2000
Other Tools:
Oracle Report Writer, MLOAD, TPUMP, BTEQ, FLOAD, SAS, SQR 3.0, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer
Languages:
SQL, UNIX Shell Scripting, Unix Commands, XPath, XSLT
Operating Systems:
Windows Server 2008/2003, UNIX, Sun Solaris 2.x.
Scheduler& Reporting Tools:
ESP, Autosys, OBIEE 11g, Cognos 7