Description
Summary: * Over 8 yrs. in ETL-data warehousing with emphasis on business requirements analysis, application design, development, testing, implementation, and maintenance of client data warehouse and data mart systems. * Experienced in all phases of the Software Development Life Cycle and data analysis. * Hands on experience in design, development, testing, implementation using Informatica cloud. * Hands-on experience in the ETL tool Informatica Power Center, as well as various SQL editors such as Toad, SQL Plus, and Query Analyzer. * Involved in all aspects of gathering business requirements to facilitate ETL development for reporting. * Hands-on experience in Autosys batch scheduling tool. * Experienced in Designing and Developing ETL Mapping, sessions and Workflows using Informatica PowerCenter tool. * Experienced in Designing and Developing ETL Mapping, mapping configuration task and Task flows using Informatica cloud. * Experienced in using workbench to query the data in sales force objects. * Good hands on experience and understanding skills about the data and its relation in sales force objects. * Good knowledge on Informatica cloud, Informatica cloud secure agent, ICRT, Informatica cloud Repository. * Experienced in using Informatica cloud to integrate the data in salesforce with other databases. * Experienced on SQL Language and worked on creating ad-hoc SQL queries for Oracle, SQL Server DB and sales force. * Good in taking responsibility for developed code quality and responsible for code review with ETL admins and business. * Good in understanding the framework and applications used in banking, mortgage, and insurance. * Responsible for taking required signoffs and promoting the code to higher environments. * Good in coordinating with business users during design, development and keep updating the team on PCR's received if any. * Understanding of SQL DML statements and stored procedures in Oracle * Experience in designing process flows to integrate different data sources with Multiple Relational Databases like Oracle, Teradata, and integration of data from different fixed width and delimited flat files. * Good hands on experience in creating, maintaining, and supporting Autosys command language (JIL) in a complex UNIX server environment and windows. * Experienced in building jobs for scheduling batches using Autosys Scheduler as per the business requirements. * Experienced in working with TIBCO team to get the file transfer mechanism setup to business users. * Hands-on in creating ETL design documents and technical design specification documents for the ETL process based on requirements. * Detail oriented with strong analytical and problem-solving skills. * Good in balancing the work requests among the offshore and to ensure that offshore team is aware of standards and process required. * Quick learner, Individual Contributor and flexible to work on developing a new application.
Accomplishments
Highlights:
Keywords
