PROFESSIONAL SUMMARY:

• Informatica and Teradata consultant with 6 years of extensive experience in Design, Development, Testing, Deployment and Support of various Datawarehouse technologies including Teradata, Informatica, Oracle, Hadoop, Cognos, SQL Server, DB2, UNIX Shell Scripting, Control M, Java.
• Experience in gathering business requirements, designing, implementing development, and enhancement of projects as per end customer requirements along with cross team brainstorming sessions.
• Having good experience in Development, Implementation, testing and Support in various Data warehousing applications.
• Co - ordinated and worked with SME’s, Business Analysts and Users to translate functional specifications into technical designs for implementation and deployment.
• Experience in working with Informatica Power Center Designer, Work Flow Manager, Work Flow Monitor
• Experience in Agile methodology and JIRA
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Expertise in physical modeling with knowledge to use Primary, Secondary, PPI and join Index.
• Configured and administered SQL server.
• Experienced in developing desktop applications and web applications using JAVA scripting.
• Have a good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1, SCD2).
• Worked extensively in various kinds of queries such as Sub-queries, Correlated Sub-queries and Uninon Queries. Worked on SQL query preparation and query analysis.
• Developed complex Cognos reports using Teradata SQL scripts
• Created Unix Shell Scripts to automate and Schedule Informatica jobs, Teradata Scripts, Shell Scripts and error reporting in Teradata.
• Experience in installing, configuring, developing, customizing, upgrading, integrating and migrating various Documentum suite of products
• Responsible for performing the data analysis, data validations, process flow, dependency, functionality testing and user acceptance testing.
• Provided 24/7 support to monitor production jobs and successfully resolved production issues without missing SLAs.
• Coordinated and worked with different teams and DBA’s in fixing P1 issues .
• Good knowledge and experience in using Oracle Utility Tool like TOAD, SQL Developer and other tools like Putty, SSH, WinSCP and Jira.
• Performed data modeling using Erwin modeler.
• Resource acquisitions, Team building activities and improving cohesiveness among the team and with other teams (data and QA).

TECHNICAL SKILLS:

RDBMS: Teradata V13/14, Oracle 10g/11g, DB2, SQL Server

ETL tools: Informatica Power Center 8.6/ 9.1.0/9.5.0/9.6.1, AbInitio

Query Tools: Bteq

Scheduling/Automation Tools: Control M

Operating systems: Windows XP/NT/ 2000/2003/2007, UNIX, LINUX

UNIX: Shell scripting, shell commands

Languages: HTML, Java Script

Other Tools: Putty, SQL Developer, SSH, Toad, Winscp and Jira

MS Office: Excel/Word/PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential

IT Analyst

Responsibilities:

• Gathering project requirements and specifications from the business and determine the technical responses for the given specifications by analyzing the requirements and project objectives.
• Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
• Developed Teradata queries to retrieve customer
• Develops and maintains applications and databases required for the Integration process.
• Request the Extraction file from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created Informatica mappings and workflows to compare Teradata and Hadoop data.
• Created/Modified mappings/sessions/workflows and developed Teradata scripts to load the data from files to tables.
• Error checking and Unit testing of ETL procedures using Informatica session log and various tracing options.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.

Environment: Informatica Power Center - 9.6, Teradata 14.0, Control M, UNIX, Hadoop, JIRA

Confidential

IT Analyst

Responsibilities:

• Gathering project requirements and specifications from the business and determine the technical responses for the given specifications by analyzing the requirements and project objectives.
• Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
• Developed Teradata queries to retrieve customer
• Develops and maintains applications and databases required for the Integration process.
• Request the Extraction file from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created Informatica mappings and workflows to compare Teradata and Hadoop data.
• Created/Modified mappings/sessions/workflows and developed Teradata scripts to load the data from files to tables.
• Error checking and Unit testing of ETL procedures using Informatica session log and various tracing options.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.

Environment: Informatica Power Center - 9.6, Teradata 14.0, flat files, Control M, UNIX, Cognos, JIRA

Confidential

IT Analyst

Responsibilities:

• Gathering project requirements and specifications from the business and determine the technical responses for the given specifications by analyzing the requirements and project objectives.
• Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
• Developed Teradata queries to retrieve customer
• Develops and maintains applications and databases required for the Integration process.
• Request the Extraction file from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created Informatica mappings and workflows to compare Teradata and Hadoop data.
• Created/Modified mappings/sessions/workflows and developed Teradata scripts to load the data from files to tables.
• Error checking and Unit testing of ETL procedures using Informatica session log and various tracing options.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.

Environment: Informatica Power Center - 8.6, Teradata 14.0, Control M, UNIX

Confidential

IT Analyst

Responsibilities:

• Gathering project requirements and specifications from the business and determine the technical responses for the given specifications by analyzing the requirements and project objectives.
• Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
• Developed Teradata queries to retrieve customer
• Develops and maintains applications and databases required for the Integration process.
• Request the Extraction file from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created Informatica mappings and workflows to compare Teradata and Hadoop data.
• Created/Modified mappings/sessions/workflows and developed Teradata scripts to load the data from files to tables.
• Error checking and Unit testing of ETL procedures using Informatica session log and various tracing options.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.

Environment: Informatica Power Center - 8.6, Teradata 14.0, Control M, UNIX

Confidential

IT Analyst

Responsibilities:

• Gathering project requirements and specifications from the business and determine the technical responses for the given specifications by analyzing the requirements and project objectives.
• Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
• Developed Teradata queries to retrieve customer
• Develops and maintains applications and databases required for the Integration process.
• Request the Extraction file from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created Informatica mappings and workflows to compare Teradata and Hadoop data.
• Created/Modified mappings/sessions/workflows and developed Teradata scripts to load the data from files to tables.
• Error checking and Unit testing of ETL procedures using Informatica session log and various tracing options.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.

Environment: Informatica Power Center - 8, Teradata 14.0, Control M, UNIX

Confidential

IT Analyst

Responsibilities:

• Gathering project requirements and specifications from the business and determine the technical responses for the given specifications by analyzing the requirements and project objectives.
• Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
• Developed Teradata queries to retrieve customer
• Develops and maintains applications and databases required for the Integration process.
• Request the Extraction file from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created Informatica mappings and workflows to compare Teradata and Hadoop data.
• Created/Modified mappings/sessions/workflows and developed Teradata scripts to load the data from files to tables.
• Error checking and Unit testing of ETL procedures using Informatica session log and various tracing options.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.

Environment: Informatica Power Center - 7, Teradata 14.0, Control M, UNIX

Confidential

IT Analyst

Responsibilities:

• Gathering project requirements and specifications from the business and determine the technical responses for the given specifications by analyzing the requirements and project objectives.
• Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
• Developed Teradata queries to retrieve customer
• Develops and maintains applications and databases required for the Integration process.
• Request the Extraction file from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created Informatica mappings and workflows to compare Teradata and Hadoop data.
• Created/Modified mappings/sessions/workflows and developed Teradata scripts to load the data from files to tables.
• Error checking and Unit testing of ETL procedures using Informatica session log and various tracing options.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.

Environment: Informatica Power Center - 8.6, Teradata 14.0, Control M, UNIX