Senior ETL Informatica Developer Resume SFO - Hire IT People (2024)

SUMMARY

• 7 years of IT experience in Analysis, Design, Development, Implementation, Testing and Production Support for Data warehousing applications.
• Experience in all aspects of project development life cycle in Data Warehousing.
• 7 years experience in Informatica Power Center (versions 8.1/7.1/6.2), client tools like Designer, Workflow Manager, Workflow Monitor.
• 7 years of strong data base experience in Teradata V2R6/V2R5, Oracle 9i/8.x/7.x, MS Sql server 2000, DB2 and Mysql.
• In - depth knowledge in Data modeling techniques like star and snowflake schemas using Erwin tool.
• Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases. Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model.
• Expertise in Performance Tuning of the mappings, ETL Environments, processes.
• Expertise in handling high volumes of data on daily basis and loading millions of data into data warehouse in a given load window.
• Expertise in PL/SQL development and SQL Query tuning for better performance.
• Expertise in development of stored procedures and functions to develop business rules.
• Expertise in writing BTEQ scripts and loading data in to Teradata using FASTLOAD, MLOAD and TPUMP tools.
• Extensive experience with Shell and Perl Scripting in the UNIX and Linux Environments.
• Good exposure on the OLAP, DSS tools like Business Objects, Cognos and Micro Strategy.
• Extensively worked on SAP r/3 source system (ABAP Functional Modules)
• Extensively worked on BAPI mappings and RFC enabled functional modules using Informatica Power connect adaptor.
• Excellent communication skills and Ability to work in-groups as well as independently.
• Thorough understanding of change control management and release management.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.x/7.x/6.2/, Power Connect 7.x, Push Down Optimization, OBIEE 10g, Data Stage 8.1, Abinitio 1.15

ERP: SAP ECC, R/3 4.7, SAP BI 7.1, CRM

Business Intelligence: Business Objects (Designer 5.0, Supervisor, Reporter), Crystal Reports 5.0/6.0/7.0/8.0/8.5 , SQL Reports, Forms 4.5, Reports 2.5.

Data Modeling: Erwin 3.5.5/3.5.2 , Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions

Databases: Oracle 9i/8.x/7.x, MS SQL Server 2000/7.0/6.5 , Sybase 12.0/11.x, SQL Server, Teradata V2R5.0, MS Access 7.0, DB2 8.1.

Testing Tools: Mercury Interactive Tools (Win Runner, Load Runner) with Mercury Interactive Test Director and Rational Suite, IBM Clear Quest.

Programming: SQL, Transact SQL, PL/SQL, Embedded SQL, C, Java, J2EE, UNIX Shell Scripts, VBScript, Visual Basic 6.0/5.0/4.0, HTML 4.0, DHTML, XML.

Operating Systems: Windows 95/98/NT/2000/XP, UNIX (Sun Solaris, HP-UX, IBM-AIX), MS-DOS, OS 400.

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Informatica Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into ECF databases.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Interacted with business users, source system owners and Designed, implemented, documented ETL processes and projects completely based on best data warehousing practices and standards.
• Extensively involved in Informatica Power Center upgrade from version 7.1.3 to version 8.5.1.
• Designed, developed Informatica mappings, enabling the extract, transform and loading of the data into target ECF tables on version 7.1.3 and 8.5.1.
• Involved in performance tuning and fixed bottle necks for the processes which are already running in production. Also gained 3-4 hours load time for each process.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window or load intervals.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Extensively worked with global teams like US, UK, South Africa and Latin America in the requirements, development, data loads.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively developed shell scripts for Informatica Pre-Session, Post-Session Scripts.
• Extensively involved in migration of Informatica Objects, Database objects from one environment to another.
• Tested data integrity among various sources, targets and various performance related issues.

Environment: Informatica Power Center 7.1.3, 8.5.1, ETL, Oracle 10g, PL/SQL, Toad, UNIX (HP-UX, Sun Os) and Linux servers.

Confidential, SFO

Senior ETL Informatica Developer

Responsibilities:

• Extensively involved in writing ETL Specs for Development and conversion projects.
• Closely worked with DA group in data models design and to find data model dependencies.
• Created detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Designed and documented ETL process for one complete project based on IDW standards.
• Designed, developed Informatica mappings, enabling the ETL of the data into target tables.
• Designed and implemented mappings using SCD type 2 and CDC methodologies.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window/ load interval.
• Created reusable objects in Informatica, Teradata and reusable shell scripts.
• Involved in performance tuning and fixed most of the bottle necks for the processes which are already running and got better performance.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Expertise in writing BTEQ scripts in Teradata and running them by writing korn shell scripts in Linux and UNIX environments.
• Expertise in creating MLOAD, Fast load and T Pump control scripts to load data to the IDW.
• Extensively involved in migration of ETL environment, Informatica Objects, Database objects and IDW.
• Expertise in creating control files to define job dependencies and for scheduling using Autosys tool.
• Involved in jobs scheduling, monitoring.

Environment: Informatica Power Center 7.1.3, ETL, Business Objects, Oracle 10g/9i, MS Sql server 2000, Teradata V2R6 as IDW, HP - Unix, Linux, Erwin, PL/SQL, Autosys for scheduling.

Confidential, GA

Senior ETL Informatica Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into Business intelligence database.
• Based on the EDS business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Designing and developing ETL solutions in Informatica Power Center 7.1.4
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files from web servers and hosted files.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window.
• Effectively used all the kinds of data sources to process the data and finally creating load ready files (LRF) as out bound files which are inputs to the BID.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Maestro scheduling tool. Created Maestro control files to handle job dependencies.
• Expertise in writing BTEQ scripts in Teradata and running them by writing korn shell scripts in HP UNIX and Sun OS environments.
• Expertise in creating MLOAD, Fast load and T Pump control scripts to load data to the BID.
• Expertise in creating control files to define job dependencies and for scheduling using maestro tool.
• Involved in jobs scheduling, monitoring.

Environment: Informatica Power Center 7.1.4, ETL, Teradata V2R5 as a BID, Business Objects, Oracle 10g/9i/8i, HP - Unix, Sun OS, Perl scripting, Erwin, PL/SQL, Maestro for scheduling.

Confidential, OH

ETL Developer

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Created complex mappings using Aggregator, Expression, Joiner transformations.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load intervals.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Designed and implemented mappings using SCD and CDC methodologies.
• Designed and developed process to handle high volumes of data and large volumes of data loading in a given load window.
• Extensively involved in migration of ETL environment, Informatica, Database objects.
• Involved in splitting of Enter price data warehouse environment and Informatica environment in to 3 of each company.
• Involved in jobs scheduling, monitoring.

Environment: Informatica Power Center 7.1.1, Teradata V2R6, Micro Strategy, MS Sql server 2000, Oracle 10g, 9i/8i,Trillium, HP Unix, Perl scripting and Windows 2000, Erwin 4.2, PL/SQL.

Confidential, CA

Data Analyst/ ETL Developer

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for Extraction, Transformation and Loading.
• Design and development of ETL solutions in Informatica Power Center 7.1
• Understanding various source systems in FSP SAP R/3 and Oracle Financials data., JD Edwards AS400
• Extensively worked on SAP r/3 source system (ABAP Functional Modules)
• Developed mapping based on ABAP Functional modules developed by ABAP developers and closely co-coordinated with them in migrating the data to staging tables using Informatica Power connect adaptor.
• Extensively worked on BAPI mappings and RFC enabled functional modules using Informatica Power connect adaptor.
• Developed Informatica mappings, enabling the ETL of the data into target tables.
• Created Workflow to schedule the loads at required frequency using Workflow Manager.
• Associated with Production support team in various performances related issues.

Environment: Informatica Power Center 7.1.1, ETL, Business Objects 6.x, Oracle 9i/8i, Linux (RHEL 4.0), Windows 2000, Erwin 4.2, PL/SQL, UNIX Shell scripting.

Confidential, NY

Responsibilities:

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications
• Analyzed and created Facts and Dimension tables.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning and object creation) for Oracle as per business requirements using Erwin
• Used DB2, legacy systems, Oracle, and Sybase sources and Oracle as target.
• Developed Informatica Power Center mappings for data loads and data cleansing.
• Wrote stored procedures in PL/SQL and Unix Shell Scripts for automated execution of jobs
• Wrote Shell Scripting for Informatica Pre-Session, Post-Session Scripts.

Environment: Informatica, Oracle, PL/SQL, Cognos Impromptu 6.0, Cognos Power Play 6.6, Oracle 9i, Erwin 4.0, UNIX, Windows NT.

Confidential

Responsibilities:

• Creating informatica standards documentation to code efficiently and maintain the same naming standards.
• Interact with business representatives for requirement analysis, to define business and functional specifications.
• Involved in development of logical and physical models for relational and dimensional data models.
• Developed Complex transformations, Mapplets, Mappings using Informatica to Extract, Transform and load data into Data marts, Central Data warehouse and Operational data store (ODS).
• Developing/Creating Database objects like PL/SQL packages, Stored Procedures, Triggers, Materialized Views, Tables, Views, and Indexes.
• Debugging and Tuning the mappings and workflows to test the business logic coded and increase the performance.
• Worked on Error handling techniques and configuring the sessions and workflows to handle errors and notifying them with automated Email and voice message to mobile.
• Developed workflows/Sessions using multiple tasks like session, decision, control, command etc to implement dependencies among different tasks
• Created parameter file to reuse the mapping for different criteria and wrote pmcmd, pmrep command scripts to automate the process
• Created the mappings/workflows to FTP the files merge the files and integrate them in datastore.
• Validate the data in warehouse and data marts after loading process balancing with source data.

Environment: Oracle 9i, PL/SQL, Sql Server 2000, Windows NT, Sun Solaris, Erwin, Informatica Power center(Powermart) 6.2/5.1

Confidential

Responsibilities:

• Developed ETL Design extracting data from flat file, Excel, UBD database, transforming into stage area and then loading data into Enterprise Data warehouse, Datamarts using Power Center.
• Designed around 25 ETL Mappings, Workflows using various transformations like Normalizer, Update Transformation, Lookups, Filters and Routers, Joiners etc flat file and relational data structures.
• Used Erwin to design Physical, Logical data model like Star Schema. Written SQL, PL/SQL, Procedures, Functions, Complicated SQL queries to tune the ETL Mappings to achieve required Performance timing.
• Written UNIX Scripts to run the Autosys Jobs and Informatica Workflow from Command Prompt.
• Developed Business Objects Universe, Reports for various Balance Scorecards, Reports for monthly, Quarterly, Yearly, and Charts, Bar Graphs, Drill Down reports and Trend Reports.
• Created Business Requirement, Technical ETL Design Specs, Detail Data Analysis, System Blueprints, Technical Memo, Knowledge Transition document, etc.
• 24/7 production support to make sure the load process completion properly.
• Involved in like upgrading to new version, migrations from development to production and vice versa, granting user privileges, setting standards, mentoring, directing best ways to do according to specifications etc.

Environment: Informatica 6.2, UNIX Scripts, DB2, Rapid SQL, ERWIN, TOAD, Windows NT, AIX UNIX, Sun Solaris, Crystal Reports.