We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

San Antonio, TX

PROFESSIONAL SUMMARY:

  • 7+ years of experience in IT Industry and worked on Data Warehousing projects, Data Integration Projects and Data migration projects with development/Enhancement Projects and also have Production Support Experience.
  • Strong experience with Informatica Data Quality IDQ 9.6, Informatica Analyst and Informatica Power Center ETL 9X, 10X ETL tools.
  • Good experience with developing Data profiling, Scorecards, Mapplets, Rule, Mappings, workflows, Data Cleansing, Data Standardization process, data exceptional handling using Informatica Data Quality Developer IDQ and Informatica Analyst tools.
  • Good experience with Informatica Analyst and Developer IDQ tools.
  • Expertise in identifying performance bottlenecks and optimizing performance with in Informatica mappings, sessions and workflows.
  • Expertise in troubleshooting and analyzing issues/errors and providing resolutions accordingly.
  • Extensively worked with XML transformations like XML Generator and XML Parser to transform XML files.
  • Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
  • Good experience with automating Informatica workflows with third party scheduling tools.
  • Expertise in developing reusable transformations, Mapplets, Workflows, worklets and sessions/tasks in Power Center Tool.
  • Hands on experience to conduct scrum meetings and sprint planning by using tools like JIRA, Confluence & HP - ALM to track the progress of projects.
  • Expertise in working with Business Analysts, Architects/Project members from different areas including technical and non-technical resources.
  • Proficiency in developing SQL with various relational databases like Netezza, Oracle, Teradata, Toad and SQL Server.
  • Exposure and experience in different methodologies like Agile and Waterfall.
  • Used to work with in Sprints and deliver the efficient code.
  • Ability to meet deadlines and handle multiple tasks, work under both Agile and Waterfall methodologies
  • Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.x 9.5/9.0/8.x/7.x, OLTP.

Databases: Teradata V2R12/V2R6/V2R5, Oracle 11

Languages: SQL, PL/SQL, Java, C, Shell Scripting, Perl, PHP, XML, HTML.

Data Modeling: MS Visio, Erwin.

Big Data: Hadoop, Hive, Pig, Map Reduce, HDFS, Sqoop.

Tools: SQL Developer, Toad, SQL*Plus, Autosys, MS Office.

Environment: Unix, Windows 7/XP/Vista, Linux.

IT Concepts: Data Structures and Algorithms, Software Development Life Cycle.

WORK EXPERIENCE:

Confidential, San Antonio, TX

ETL INFORMATICA DEVELOPER

Responsibilities:

  • Design and develop quality integration workflows between multiple applications utilizing Informatica tools.
  • Built mappings using Informatica Data Quality and export them as Mapplet to Informatica Power Center to read JSON format files.
  • Involved in writing shell scripts for file transfers & file attachments and several other database scripts to be executed from UNIX.
  • Worked on SQL server, Oracle, Sybase databases.
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • Excellent knowledge on Informatica Power Center development.
  • Used UNIX scripts for scheduling and executing Informatica workflows.
  • Worked on Informatica- Repository Manager, Designer, Workflow Manager & Workflow Monitor.
  • Worked extensively with sources and target like Flat files, SQL Server tables
  • Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
  • Involved in preparing the migration list inventory.
  • Involved in requirement gathering for redesign candidates.
  • Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
  • Worked with BA in the QA phase of testing.
  • Did performance tune of Informatica components for daily and monthly incremental loading.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
  • Involved in the preparation of High-level design documents and Low-level design documents.
  • Designed and developed Informatica's Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

Environment: Informatica Power Exchange, Business Objects, Oracle, UNIX, Shell scripting, Teradata, Toad, Windows.

Confidential, New York, NY

ETL INFORMATICA DEVELOPER

Responsibilities:

  • Extensively used Informatica data Quality, Informatica Power Center to create and manipulate source definitions, target definitions, mappings, Mapplets, transformations, re-usable transformations, etc.
  • Extracted data high volume of data sets from SalesForce.com (SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Warehouse.
  • Used UNIX scripts for scheduling and executing Informatica workflows.
  • Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
  • Worked on Writing and tuning complex SQL queries and shell scripts.
  • Worked on SQL server, Oracle, Sybase databases.
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
  • Involved in monitoring the workflows and in optimizing the load times.
  • Involved in writing procedures, functions in PL/SQL.
  • Wrote complex SQL overrides to join heterogenous databases.
  • Designed universes, classes, checked cardinalities and detecting loops using Business Objects Designer.
  • Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
  • Expertise in SQL and Performance tuning on large scale Oracle, Teradata & Microsoft SQL Server.
  • Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
  • Built interfaces and automated them with Informatica ETL tool.
  • Extensively used I nformatica for loading the historical data from various tables for different departments and data marts.

Environment : Informatica Power Center 7.1, ORACLE 9i, SQL Loader, Windows, ERWIN, PL/SQL, windows batch scripting.

Confidential, Atlanta, GA

ETL INFORMATICA DEVELOPER

Responsibilities:

  • Translated the business processes into Informatica mappings.
  • Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server.
  • Worked with high volume datasets from various sources like Oracle, Text Files, relational Tables, and xml targets
  • Created and configured database for development and production environments in SQL Server.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  • Developed ETL jobs to extract information from Enterprise Data Warehouse.
  • Designed universes, classes, checked cardinalities and detecting loops using Business Objects Designer.
  • Developed stored procedures and database triggers using SQL Server.
  • Expertise in ETL reporting based on the Flat Files data sourced in different platforms.
  • Responsible for file archival using Unix Shell Scripting.
  • Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
  • Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
  • Involved in requirement gatherings from users and translated into technical specifications.
  • Monitoring SQL Server Logs, Application logs and analyzing the logs.
  • Translation of Business Processes into Informatica mappings for building Data Marts

Environment: SQL Server 2000, Oracle, Teradata, Business Objects, Informatica power center, Crystal Reports, PL/SQ, Windows NT.

Confidential

INFORMATICA DEVELOPER

Responsibilities:

  • Involved in analyzing and development of the Data Warehouse.
  • Analyzed business needs, created and developed new functionality to meet real time data integration that facilitated decision making.
  • Involved in information gathering from end user and analyzing the data to developed ER diagram, data dictionaries, and flow charts.
  • Actively participated in the requirement analysis, database design and modeling.
  • Designed universes, classes, checked cardinalities and detecting loops using Business Objects Designer.
  • Created and configured database for development and production environments in SQL Server.
  • Developed stored procedures and database triggers using SQL Server.
  • Database and log backups & restoration, backup strategies, scheduling the backups. Backing up System & User Databases and restoring them when necessary.
  • Loaded the SQL Server database using Bulk Export and Import
  • Created database for production environment in SQL.
  • Used Informatica reusability at various levels of development.
  • Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
  • Develop informatica mappings and workflows for new change requests.
  • Preparing Test Results, Unit testing, Defect Fixing
  • Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.

Environment : Informatica Power Center, PowerBuilder, Oracle, Oracle SQL Developer, Quest-Toad, Shell Scripts, SQL*Loader, UNIX and Windows .

Hire Now