#Vsam files in informatica training full#
#Vsam files in informatica training software#
#Vsam files in informatica training windows#

Created the technical architecture (Hardware and Software) that will support ETL.

Incorporated the refresh strategy, maintaining the historical data, archiving strategies for the source flat file, Audit balance and Control (ABC) etc in Integration design document.

Captured the data volumes, upserts/truncate and load strategies etc in Integration design document.

Created the ETL performance expectations document based on the source data profile results.

Worked closely with business analysts to understand and document business needs for decision support data.

Informatica Architect/Developer Responsibilities:

Created exception management process flow for bad records and duplicate records.Д®nvironment: Informatica Power Center 9.6.1, Informatica Data Quality 9.5, Informatica Power Exchange for Oracle CDC, IBM DB2 10.5, Oracle 11g, SQL Developer, WinSCP, Putty, Linux, shell scripting.

Created scorecards for the source data for data redundancy, duplicity etc.

Automated some of the IDQ plans by incorporating it into Power Center as mapplets.

Used numerous transformations of Informatica data quality like match/merge, case converter, standardizer, labeler etc.

Configured LDAP authentication for Informatica analyst logins.

Installed/configured address doctor for Informatica data quality.

Worked on Creating Data quality customized plans for data harmonization, cleansing, profiling using Analyst tool etc.

Created the data quality road map for the source systems.

Created the road map for future developments, creation of versioned repositories, usage of shared folders, usage of parametrization etc.

Created the unit testing, STM document templates for future development.

Created base tables in DB2 for multidimensional clustering table.

Validated the data from the source DB2 and loaded into Oracle for 650 tables of DB2.

Created the report for the Informatica CDC workflowвЂ™s performance.

Generated report to check the data synchronization into multiple systems for resync process.

Worked on creating the error and performance matrix reports from Informatica repository.

Created the architecture, best practices and ETL standards documents.

Evaluated RailIncвЂ™s Informatica Power Center and Power Exchange for Oracle CDC architecture.

#Vsam files in informatica training windows#

Operating System: Windows XP / Windows 2000, WinNT, UNIX (AIX, HP, SCO), Linux, Sun Solaris Others: Citrix, Telnet, PLSQL developer, Toad 9.7.2/6.5, T-Pump, ISQL, Workbench Aginity, Management Studio, Visio pro, COBOL, IMS, VSAM Script Languages: Perl, Script, Java script, korn shell script, Application Server IBM WebSphere 5 RDBMS: Oracle Exadata, Oracle 11g/10g/9i/8i/8.0, DB2, Oracle EBS 11g, Siebel 7.8, Ms SQL Server 2012/2008 R2/2005, Sybase, Teradata (BTEQ, Fast load, multi load, TPump, SQL Assistant, Fast Export), Netezza TwinFin 3/6/skimmer.

Languages: C, Java (jdk1.2, Servlets, JSP), J2EE, SQL, PL/SQL, T - SQL, NZ-SQL.Дata warehousing Tools: Informatica Power Center 9.6.1/9.5.1/9.1.0/8.6.1/8.5.1/7.1, Informatica Power Exchange, Informatica Metadata Manager, Informatica Data Quality, Informatica Data Explorer, DataStage Server Edition, Talend Open Studio, Oracle Data Integrator, Talend data profiler, Business objects 5.1/6.5, Cognos BI suite 6.0/7.2.Reportnet1.1, QlickView (Netezza), OBIEE. Excellent communication/Presentation, communication, interpersonal presentation and analytical skills.Sound knowledge of Data warehousing concepts and Informatica ETL tool.Extensive experience in using Business intelligence report tools like Business Objects, Cognos BI Suite for warehouses and data marts, OBIEE etc.Strong in converting business requirements to project documentation and technical specifications.Strong in Dimensional Modeling, Star/Snow Flake Schema, Extraction, Transformation & Load and Aggregates.

Developed staging areas to Extract, Transform and Load new data from the OLTP database to warehouse.Creating data models, building Informatica ETL processes, dimensional data modeling primarily star schema, performing data migration, defining user interfaces, executing large projects, assuring quality and deployment.Strong understanding of Conceptual Data Modeling ( CDM), Logical Data Modeling ( LDM), Physical Data Modeling ( PDM).9+ years experienced Informatica ETL expert with experience in online analytics, system analysis, creating technical design documents, project plans, managing Data Warehouse projects.

#Vsam files in informatica training full#

Carried out Full Data warehouse life cycle in the project, requirement analysis, Modeling and designing, database and end user application development.

#Vsam files in informatica training software#

Around Eleven years of Professional experience as Software developer including over Nine Plus years of experience in designing and development of Data warehouse/ Data Migration/ Data Conversion projects as Informatica ETL consultant and client/server applications.