We provide IT Staff Augmentation Services!

It Analyst Resume

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

Hire Now