• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 29th Aug 2024

• 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