Senior Informatica ETL Developer Resume San Francisco, California - Hire IT People

SUMMARY:

7+ years of IT experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Data Warehousing, Data Integration and Business Intelligence applications
Expertise in Informatica, Integration with Salesforce API's.
Expertise in Informatica Power Center and Informatica Developer.
Expertise in SAP BI Reporting & Universe Design and SAP BI Java SDK's.
Proficiency in developing SQL with various relational databases like SQL Server, Oracle, MySQL.
Experience with dimensional modeling using star schema and snowflake models.
Understand the business rules completely based on High - Level document specifications and implementing the same in data transformation methodologies.
Expertise creating UNIX shell scripts to run the Informatica Workflow and controlling the ETL Flow.
Independently perform complex troubleshooting, root-cause analysis, and solution development.
Successful implementation of Datastax Cassandra & Proof of Concept of Grid Grain Ignite with Informatica and Mulesoft.
Team player, motivated, able to grasp things quickly with analytical and problem-solving skills.
Comprehensive technical, oral, written and communication skills.

SOFTWARE KNOWLEDGE:

Operating System: Windows, Linux, Ubuntu

ETL Tools: Informatica Power Center 10.2 / 9.6.1 / 8.6.1 , Informatica Developer 10.2

Reporting Tools: SAP Business Intelligence 4.2 / 4.1, SAP Business Objects 3.X, Tableau 9.1

CRM: Salesforce

Databases: MySQL, SQL Server 2012/2008, Oracle 11g

Languages: SQL, PL/SQL, Java

Web/Application Servers: Tomcat 5, Tomcat 7

Tools: Eclipse, Toad, Notepad ++

Scheduling Tools: Autosys, Custom scheduler for BI reporting

PROFESSIONAL EXPERIENCE:

Senior Informatica ETL Developer

Confidential, San Francisco, California

Technology: Informatica, Unix, MS SQL, Salesforce

Responsibilities:

Involved in the analysis of the user requirements and identifying the sources.
Involved in the preparation of High-level design and Low-level design documents.
Involved in Design, analysis, Implementation, Testing and support of ETL processes for Staging & SFDC
Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Staging & SFDC
Administered the repository by creating folders and logins for the group members and assigning necessary privileges.
Designed and developed Informatica Mappings and Sessions based on business user’s requirements and business rules to load data from source SQL tables to SFDC targets.
Developed reusable Mapplets and Transformations.
Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
Involved in monitoring the workflows and in optimizing the load times.
Involved in writing procedures, functions in PL/SQL.
Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
Developing ETL code and writing UNIX scripts for the project and integrating it with other modules developed by other developers.
Written complex SQL overrides for source qualifier and lookups in mappings
Extensively worked with aggregate functions like Avg, Min, Max, First, Last and Count in aggregator transformations.
Used Informatica Debugger to troubleshoot information about data and error conditions.
Unit testing the code and checking standards.
Getting involved in bug fixing task when code gets moved to upper environment like QA, UAT.
Performance tuning and code cleanup of existing applications.
Defect Tracking and reports are done by Version One.

Confidential

Technologies: JSP, spring, OOPS, Design Patterns

Application Server: JBoss

Database: Oracle10g

IDE: Eclipse

Java Developer

Responsibilities:

Understanding the Design Specifications and Developing bug free code components
Bug fixing
Involved in customization of Confidential according to client specifications
Involved in the implementation of Chauffeur Module
Adhering to quality standards for effective code management.
Teaming with internal resources for better coordination and achieve timelines.
Implementation using Spring Framework along with POJO (Plain Old Java Objects) for achieving middleware service delivery.

We provide IT Staff Augmentation Services!

Senior Informatica Etl Developer Resume

San Francisco, CaliforniA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship