PROFESSIONAL SUMMARY:

• Software Professional with 10+ Years of experience in Development, Design, Enhancement, Migrationand Data Analysis Projects.
• Good Knowledge of ETL and Data Warehousing Concepts,Informatica10.2, DM Express 9.x, Teradata 14.0 and above, ORACLE 9i/10g,SQL, PL/SQL, SQL*Plus, SQL*Loader Well versed in using TOAD, SQL Developer 3.0, SQL Developer 4.0 interfaces.
• Proficiently used Informatica as an ETL tool to do the data transformations & processing in a corporate wide ETL Solution to pull data from source Systems, Cleanse, Transform and load data into Data Base.
• Have used Parallelism and Multi File System techniques in Informatica and improved the Performance by using the Push down Optimization.
• Proficient in various data warehouse techniques - efficient data integration, source data profiling, identifying data dependencies, data cleansing, slowly changing dimension, change data capture, incremental/full load design.
• I have experience on DM Express ETL Jobs and DM Express Tasks and SQL Server Integration services and scheduler.
• Implemented Slowly Changing dimensions Type 1, Type 2 and Type 3methodology.
• Expertise in tuning the performance of Mappings and sessions in Informatica and determining the performance bottlenecks.
• Proficient in applying Performance tuning concepts to Informatica Mappings, Session Properties and Databases.
• Hands on experience in handling data from various source systems such as Flat Files, XML Source, Oracle, MS SQL Server, IBM DB2, Teradata, Excel Files,XML, Salesforce Services.
• Proven record in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation, Data Integration and Data Mining.
• Actively involved in Performance Tuning, Error and Exception handling on various ETL processes.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Power Center, Repository Manager, Designer, Workflow Manager andWorkflow Monitor.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and many more.
• Extensive knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Worked extensively on Error Handling, Performance Analysis and Performance Tuning of Informatica ETL Components and Teradata Utilities, UNIX Scripts, SQL Scripts, macro’s
• Expert Developer skills in Teradata RDBMS initial Teradata DBMS environment setup, development.
• Having experience on large data warehouse containing 75 TB.
• Sound Working Experience in Databases like Oracle, TERADATA RDBMS and Utilities like FAST LOAD, TPUMP, BTEQ, MLOAD, and Fast Export.
• Expertise in Query Analyzing, performance tuning and testing.
• Exceptional skills in writing complex SQL queries and procedures involving multiple tables, constraints and relationships for efficient data retrieval from relational database for data validation using SQL and TOAD.
• Data Quality & Analysis: 4+ years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Have worked on analysis Data from multiple sources, profiled the data, gathered the data as per the Business use cases, worked closely with the Business to understand and helped them in Data Analysis.
• Worked with Dm express and Informatica integration projects.
• Have Worked on Projects with requirements in UNIX, FTP, SSH and SFTP in combination with Informatica.
• Have worked on Three Projects and managed a project single handedly till the end and also achieved Customer appreciation for all the three Projects.
• Well-versed with Configuration Management using version control systems and working under structured and controlled Change Management system.
• Expertise in preparing Functional & Technical Specifications besides User Guides. Good experience in providing ETL Effort duration estimates with the WBS (Work Breakdown Structure) activities involved.
• Experienced in the use of agile approach SCRUM using TFS,JIRA tools.
• Can perform Ad hoc data analysis and communicates with business users effectively.
• Expertise in fine tuning of Physical data Models for Oracle and Teradata DB systems.
• Extensive experience in developing Unit, Integration and UAT Test plans and Cases and also has experience in generating/executing SQL Test Scripts and Test results.
• Good Knowledge on Business Intelligence and Data Warehousing design principles and industry best practices
• Expertise in Off-shore/On-site work culture, leading and mentoring Data Warehouse teams.
• Provided 24 x 7 supports for the projects during go-live and post production support activities.

TECHNICAL SKILLS:

• Primary Skill category: Informatica 8.6,10.2, Teradata14 and above, ORACLE 9i/10g/11g, SQL, PL/SQL,T - SQL, SQL*Plus, SQL*Loader
• Project Acquired skills: Unix, FTP, SFTP, SSH, Shell Scripting, Python
• RDBMS, SQL/PL: SQL, ETL and DW Concepts, Informatica 8.6,10.2, Teradata 14 and above, DMEX Press, SSIS, Red point ETL
• Operating Systems: Windows 9x/XP/Vista/7/8, DOS, UNIX, Linux
• Databases: ORACLE, Teradata, SQL Server, MYSQL, DB2
• Tools: Informatica 8x,10.2, Oracle s Toad, SQL Developer 3.1/3.5, TD SQL Assistant, Fast load, Multi load, Bteqs, Fast Export, Trump, Teradata Parallel Transporter, Putty, Toad, SecureFX, CyberArk, RSA token, Telnet, MS Office, TFS (Team Foundation Server), JIRA, Confluence, GitHub,Red gate Source Control, Autosys

WORK EXPERIENCE:

Confidential, San Antonio TX

Senior Software Engineer

Responsibilities:

• Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.
• Work with business analysts to gather business requirements from end-users and translate them into technical specifications.
• Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process.
• To be responsible for providing technical guidance/solutions.
• Provide estimates for development.
• Perform data analysis and data profiling against source systems and data warehouse.
• Design data marts to support Business Intelligence reporting.
• Design ETL processes using Informatica Power Center.
• Assist developers with difficult Microsoft SQL code needed for queries, triggers, and stored procedures.
• Conduct reviews of developed code.
• Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements.
• Provide end-user support in post-deployment phases; assess and evaluate all feedback to ensure that the requirements necessary to correct issues are addressed.

Environment: Informatica 10.2, UNIX, CyberArk,SecureFX, Windows

Databases: SQL Server, DB2, Flat Files

Confidential. Nashville, TN

Senior Informatica Developer

Responsibilities

• Development of Automated Process to get data from Multiple Source system.
• Data Analysis-- Analyze functional and non-functional business requirements
• Data Mining & Sanitization
• Worked on Teradata,DB2,SQL Server, Files in order to pull data form multiple servers
• Create or Update existing logical and physical data models.
• Create data models (logical) and DB designs (physical), that depict the business areas and systems
• Implement data technology solutions in the area of master data, metadata, and data.
• Implement Data Quality solution for Models
• Design and implement data analytics solution using analytics tools like dash boarding, reporting
• BTEQ were written with complex queries to load the data from Staging area to Core tables by using Teradata Utility.
• ETL Development, Data Engineer. Database Management.
• Informatica Mappings, Workflows and session were created for the development phase and also the mapping were schedule using zeke schedule.

Environment: Informatica,Teradata, UNIX, Windows

Databases: Teradata, SQL Server, DB2, FlatFiles

Confidential, Nashville, TN

ETL Developer, Informatica/Teradata Developer

Responsibilities

• Working on this project which requires multiple data present from Oracle, SQL Server Database to be loaded to Flat Files and Teradata basically these requirements being Ad-hoc, have to handle these with great understanding.
• Working with different Teams in building the Data Services which cater the needs of the requirements.
• Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Used Error Handling in the stored procedures and Functions.
• Created InformaticaWorkflows and sessions to load data from multiple sources and then perform transformations on the data in the staging area
• BTEQ were written with complex queries to load the data from Staging area to Core tables by using Teradata Utility.
• Used Teradata BTEQ Scripts to load the data the data into the warehouse and created sample reports for the users.

Environment: Teradata,INFORMATICA, SQL Server, Putty, UNIX, Windows

Databases: Teradata, SQL Server, DB2

Confidential,

ETL Informatica /Teradata Developer

Responsibilities

• Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
• Designing and Implementing the ETL processes as per the mapping document created
• Carnot Workflow was implemented for Processing the files from sftp location to invoke the Dmexpressjob’s.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with onsite folks and leading and mentoring the offshore team.
• SVN repository was monitored for job versioning.
• Agile Methodology was used for proactive requirement changes.

Environment: Oracle, Teradata, Informatica 8.6, SQL Developer, Putty, UNIX, Windows Shell Scripting, SVN,JIRA,Java ANT scripts

Operating System: Windows, Unix

Databases: Oracle, Teradata, SQL Server, DB2,Flat Files

Confidential

ETLDMexpress, Informatica/Teradata Developer

Responsibilities

• This project had a need to understand Infomatica mapping and convert the same business logic to DMExpress jobs
• Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Extensively used the Teradata utilities like BTEQ, Fast load, Multiload, Tpump, DDL Commands and DML Commands (SQL).
• Have implemented Parameter concept in DMexpress.
• Implemented CDC, SCD types, MERGE in DMexpress as per logic in Informatica
• Basically, this is Dmexpress ETL reporting through CSV Files where the Flat Files data the requirements keep changing instantly.
• Implemented the usage of Stored Procedure Transformation in Dmexpress as per the design and development related requirements of the project.
• Implemented Unix shell scripting to run DMExpress jobs.

Environment: Dmexpress, Informatica 8.x, Toad, SQL Developer, Putty, UNIX, Windows Shell scripting