PROFESSIONAL SUMMARY:

Ambitious IT Professional with 5+ years of ETL development looking to acquire a full time position. Data Management skills include Informatica Power Center 9.1/8.x/7.x, ETL, SQL, Microsoft Access, Microsoft Excel, Toad, Oracle, DB2, etc.

CORE COMPETENCIES:

Database Management Informatica Power Center 9.1/8.x/7.x, ETL SQL Microsoft SQL, Oracle, TOAD, MySQL Windows 7, Windows 8, Windows XP Office 365 SQL Script Generation and SQL Querying SharePoint MS Office, Access, Word, Excel, PowerPoint, Project, Outlook, Visio Active Directory Pivot Tables, V - Lookup Agile, Scrum and Waterfall

PROFESSIONAL EXPERIENCE:

Confidential

Informatica ETL DEVELOPER

Responsibilities:

• Using Informatica Power Center 9.X-Developer & Admin
• Involved in all stages of the SDLC process including requirement gathering, design, development, testing, production, user and support for production environment
• Generated new mapping designs using assorted tools in Informatica Designer, such as Source Analyzer, Mapping Designer, Warehouse Designer, and Mapplet Designer
• Developed the mappings using needed Transformations in Informatica tool according to technical specifications.
• Created composite mappings that involved execution of Business Logic to pack data in to staging area.
• Generated Worklets, Workflow and Tasks to schedule the loads at demanded frequency using Workflow Manager.
• Developed utile email correspondence in Workflow manager for process exception handling.
• Participated in user meetings, gathered Business requirements & specifications for the data warehouse design. Translate the user inputs into ETL design docs.
• Optimized performance tuning at source, target, mapping and session level.
• Strong knowledge of logistics organization, stock control system, storage management, and management improvement

Confidential

Jr. ETL Developer

Responsibilities:

• Converted the business requirements into technical specifications for ETL process.
• Design source definitions and target definitions based on requirements
• Creating Informatica Mappings and workflows to migrate data from one environment to another and data enhancements.
• Created New Staging tables in Staging DB to store data from client files
• Parsing high-level design specs to simple ETL coding and mapping standards.
• Analysis/Preparation of High Level Design (HLD) and preparation of Low level design (LLD).
• Populated the Fact and Dim. Table of data warehouse from various sources like Oracle, Ms Access and Flat files and xml files
• Created staging tables to do validations against data before loading data into original fact and dim. Tables.
• Extensively used Update Strategy and Lookup transformations for updating the target tables and also extensively used the Debugger to check the data flow and the mappings were modified depending on the requirements.
• Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, population and maintenance.
• Designed and developed complex Aggregator, Joiner, Router, Lookup and Update strategy transformation rules.
• Created sessions, database connections and worklets using Informatica Power center
• Involved in performance tuning by identifying bottlenecks, eliminating them and tuning the SQL used in Transformations.
• Created session partitions to increase the performance of Informatica Server Manager.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Automated the daily scheduling of ETL process for populating the data warehouse.
• Scheduled the ETL jobs daily, weekly and monthly based on the business requirement.
• Performing Review/Checks for component's Design, Codes and Quality as per Informatica Standards.

Confidential

Technical Support Engineer/MySQL Database Admin

Responsibilities:

• Installed and Administered patches and updates
• Successfully creates, manages relational databases and performs data cleansing using SQL scripts.
• Effectively masks sensitive customer data/information like Credit Card information and social security numbers, using complex SQL queries, during data extraction and analysis for customer status update ad-hoc, monthly or quarterly reports.
• Created customer database with relational sub-tables for easier access and reduced data processing time. Maintained customer payment database in an oracle environment.
• Using SQL queries to extract and analyze data and produce ad-hoc reports reflecting specific business needs.
• Writes SQL scripts to update existing databases, creating and presenting informational reports for management based on data generated, using SQL queries.
• Successfully writes queries that generate precise and detailed data from databases to analyze trend and data comparison for management reports and decision-making.
• Successfully writes complex SQL queries using complex joins, grouping, and aggregation subqueries to compare and analyze disparate data for a more detailed productivity report.
• Installed packages on servers.
• Configured and managed Server networking.
• Performed user accounts administration.
• Managed Password aging configuration on servers
• Configured and mounted NFS resources.
• Maintained file systems and host security.
• Disabled direct ssh root login on servers.
• Setup ssh keys for secured key-based authentication
• Responded to ticket needs
• Guided students & teachers hands on with technical issues.
• Monitored and controlled system processes.
• Monitored and Managed Server performance using associated tools.
• Performed logs administration to detect and resolve system errors
• Managed systems storages using LVM

Confidential

Technical Support Engineer

Responsibilities:

• Use Oracle based system ( Confidential ) in order to work on trouble tickets assigned and try to resolve issues.
• Resolution can include backend changes, configuration changes, external customization etc.
• Work with Managed Services to resolve configuration related problems
• Detailed technical analysis of issues that requires code change and update with analysis report.
• Use SQL code to fix,edit, or change data and code.
• Check log files and identifying exceptions
• Provide workaround and bring down the severity and priority of an issue
• Monitor fixed issues for re - surfacing
• Combine business and technical knowledge to determine the most appropriate approach to meeting a business need
• Participate in UAT process