ETL Informatica Developer at Remote, Remote, USA |
Email: [email protected] |
From: pallavi, Nitya Software solutions [email protected] Reply to: [email protected] Role: ETL Informatica Developer Skills Summary Over 7+ years of IT experience in analysis, design, modeling, development, implementation and testing of Data Warehousing and Client/Server applications and also in locations like India and USA. Extensively worked on ETL developer using Informatica Master Data Management, Informatica Power Center (Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer, Transformation developer) Repository manager, Workflow manager & Workflow monitor. Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources like Oracle, DB2, SQL Server, XML and Flat Files. Hands on experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL solution using Informatica Power Center Knowledge in ETL and Data warehousing with OLAP technology. Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling. Experience on Informatica designer tools transformations, reusable transformations, mapping, and mapplets. Experience in RDBMS such as ORACLE 12c/11g/10g/9i/8i, MS SQL Server 2008/2005/2000, Teradata 12.0, DB2, SQL, T-SQL and PL/SQL. Good understanding and working experience in Logical and Physical data models that capture current/future state data elements and data flows using Erwin. Experience working in Oracle 9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes. Efficient in all the phases of System development life Cycle (SDLC) using different methodologies like Agile and Waterfall. Extensive experience in dealing with High Volume Data, Performance Tuning, Maintaining, Multiple Job. Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse. Designed using Informatica Power Center in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, configuring the Informatica Server and scheduling the Workflows, sessions and Experience in writing daily batch jobs using UNIX shell scripts. Having exposure in UNIX, worked on CONTROL M and TWS to schedule the jobs. Implemented Performance Tuning Techniques and Error Handling at various levels such as sources, Target, mappings. Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon and surrogate key assignment and CDC (Change Data Capture) using Informatica. Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups Thank you, Pallavi [email protected] NITYA Software Solutions Inc Keywords: information technology microsoft procedural language ETL Informatica Developer [email protected] |
[email protected] View all |
Wed Aug 28 06:40:00 UTC 2024 |