We provide IT Staff Augmentation Services!

Informatica/teradata Developer Resume

Nashville, TN

SUMMARY

  • 4 years of IT experience and specialized capability in building Enterprise Data Warehouse, Data Marts, Operational Data Stores in real industry segments like Finance, Health, Insurance and Retail Using Informatica Power Center 10.4/10.2/9.6.1/9.5.1/8.6.1.
  • Experience in whole life cycle of DWH with Analysis, Modelling review, ETL Design, Performance improvement, Unit/System testing and support.
  • Strong involvement in Understanding Dimensional Modeling - Star and Snow Flake Schema, Identifying Facts and Dimensions.
  • Extensive involvement in creating Stored Procedures, Functions, Views and Triggers, Complex SQL queries.
  • Developed mappings in Informatica to stack the information from different sources into the Data Warehouse, using transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner,normalizer etc.
  • Experience in determining on-going upkeep issues and bug fixes; observing Informatica sessions and in addition execution tuning of mappings and sessions.
  • Hands on experience in writing UNIX shell scripts and computerization of the ETL forms utilizing UNIX shell scripting.
  • Experience in implementing performance tuning techniques both ETL & Database level.
  • Experience in utilizing Automation Scheduling instruments like Autosys and Maestro,Active Batch.
  • Experience in working with both Waterfall & Agile Methodologies.
  • Knowledge in writing expressions with in tmap as per the business need using Talend Studio.
  • Knowledge in performing administrator roles includes installing, updating,maintaining and configuration of Informatica Powercenter.
  • Experienced in migrating the repositories from Informatica 9.5.1 to 9.6.1 and also create logins and groups and provide privileges to the users.
  • Knowledge of developing Ab Initio graphs to unload required data from database.
  • Experience in working with many databases such as Oracle 11g/12c, Teradata 16/15/14/12, Microsoft SQL Server, MySQL, DB2.

TECHNICAL SKILLS

Basic Programming: Visual Basic, Java, HTML, CSS.

Software: Microsoft Word, Excel, PowerPoint, Informatica Power Center, TOAD, SQL Plus, Adobe Photoshop, Visual Studio, Microsoft Sql Server Management Studio 2012-2016, SSIS, SQL Developer, Teradata 12/14/15/16,AQT(Advance Query Tool),HP Quality Center,Winscp, Putty, Maestro, Cognos,Team foundation Server, Snipe Hunter, Gitlab, Jenkins, uDeploy,Active Batch.

ETL Tool: Informatica Power Center 8.6, 9.1/9.6,10.2,10.4, Talend, SSIS

Database: Oracle,SQL server,Teradata,HIVE.

QA Tool: HP Quality Center

Operating System: Unix, Windows

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Informatica/Teradata Developer

Responsibilities:

  • Responsible for working with product owner to gather all the requirements to perform the analysis,development and testing.
  • Responsible for working with design authority to identifying the existing data mapping flow.
  • Responsible for analyze the Active Batch jobs,store procedures, sql queries and informatica processes to identify the source,target tables and transformations logics in order to create mapping documents to perform development.
  • Responsible for creating tables and views in Teradata as well as Microsoft SQL Server Management Studio.
  • Responsible for creating plans,jobs and assign dependencies in Active Batch along with scheduling informatica Jobs.
  • Experience in writing queries using SQL Developer, Teradata Assistant and Microsoft SQL Server management studio.
  • Responsible of development of mappings using Informatica PowerCenter 10.4 and worked with many transformations such as Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator.
  • Create deployment groups and perform migration of objects from DEV to QA and UAT by creating branches and modules in Jenkins and then upload the code in GitLab and deploy the code using IBM uDeploy.
  • Responsible for creating unit test case document and perform unit testing and functional testing after code development.
  • Responsible for conducting QA and UAT testing after code migration.
  • Responsible for deploying code to PROD by raising Change Management ticket and preparing all the scripts for prod migration.

Environment: Informatica PowerCenter10.4, Active BatchV12, Oracle, Teradata Sql Assistant, Microsoft Visio, Flat Files, Windows, Sql Assistant, WinSCP, Putty, ServiceNow, Notepad++, SQL Server Management Studio, Jenkins, GitLab, IBM Udeploy, BOTiQE, ServiceNow,HP Service Management, Toad, Team Foundation Server(TFS), Jira Agile.

Confidential

ETL Informatica Developer

Responsibilities:

  • Design and develop ETL mappings and workflows using Informatica Power Center 10.2.
  • Write complex SQL queries for validating the data against different kinds of reports.
  • Performance tuning on sources, targets and Informatica.
  • Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations, Java transformation using Informatica Power Center.
  • Experienced in writing Unix Shell Scripts for different purposes such as scheduling jobs and moving the files from remote server to local informatica server.
  • Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
  • Hands on experience in programming such as JAVA .
  • Effectively worked on Onsite and Offshore work model.
  • Executing the project both in agile and waterfall methodologies.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Environment: Informatica PowerCenter10.1, Active Batch, Oracle, Flat Files, Windows, Sql Assistant, WinSCP, Putty, ServiceNow, Notepad++, SQL Server Management Studio, Microsoft Visio.

Confidential, Cary, NC

ETL Informatica Developer

Responsibilities:

  • Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations, Java transformation using Informatica Power Center.
  • Responsible for scheduling workflows using IBM Maestro Scheduler.
  • Responsible for error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
  • Responsible for creating designing documents and unit test documents.
  • Experience in writing queries using SQL Developer, AQT and Microsoft SQL Server.
  • Create deployment groups and perform migration of objects from DEV to QA and UAT and extensively work on validating the objects after migration and perform functional testing. Also worked on Prod Migration.
  • Experience in fixing defects after code migration.
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Write Shell script for running workflows in unix environment.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews.
  • Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Executing the project both in Waterfall methodologies.
  • Effectively worked on Onsite and Offshore work model.
  • Participated in daily status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica PowerCenter 10.1, IBM Maestro, Microsoft Visio, Oracle,Hive, Flat Files, Windows, Sql Assistant, WinSCP, Putty, ServiceNow, HP Quality Center, Notepad++, SQL Server Management Studio,AQT.

Hire Now