We provide IT Staff Augmentation Services!

Sr. Informatica/teradata Developer Resume

PhiladelphiA

SUMMARY

  • 15+ years of overall IT Experience, including 10+ years of analysis, design, development, and implementation and troubleshooting of Data Warehouse applications.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts especially with large data sets.
  • Experience in integration of various data sources including Oracle, SQL server, DB2, Sybase, and MS access and non - relational sources like flat files into staging area.
  • Experience in writing, testing and implementation of PL/SQL stored procedures, triggers, functions, packages using Oracle and stored procedures and triggers using SQL Server and T-SQL.
  • Strong knowledge in writing BTEQ scripts, and other load utility scripts in Teradata 13.10 and 14.10.
  • Experienced in UNIX work environment, file transfers, job scheduling and error handling.
  • Experienced in working with scheduling tools such as CA Unicenter Scheduler, Informatica Scheduler and Unix crontab.
  • Created UNIX shell scripts to automate and implement workflows, sessions and dynamic source/target databases.
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various aspects of the data warehouse infrastructure including but not limited to sources, targets, mappings and sessions.
  • Excellent analytical/communication skills and good team player.
  • Excellent leadership skills with experience in mentoring and managing a team of developers.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter 9.x, 8.x, 7.x (Repository Manager, Designer, Workflow Manager, Admin console, Unicenter Workload Manager)

Databases: Oracle 8.x/9x/10g/11g, SQL Server 2000/2005/2008 , Teradata 12/13.10/ 14, DB2 UDB 7.2, MS-Access

Database Tools: Oracle PL/SQL Stored procedures,triggers and packages;Teradata BTEQ, Teradata load utilities - MLOAD, FLOAD, TPUMP, Oracle Enterprise Manager, SQL Navigator, Toad, Oracle SQL*Loader, SQL*PLUSMS SQL Server Management Studio, SQL Server Cli config Util, bulk copy utils, SSIS packages using SSIS designer.

Operating Systems: UNIX, Windows, Chrome OS

Programming Skills: UNIX Shell scripting, Microsoft C#.net, .net Framework,, SQL, PL/SQL, T-SQL, stored procs and triggers, Windows PowerShell 2.0

PROFESSIONAL EXPERIENCE

Confidential - Philadelphia

Sr. Informatica/Teradata Developer

Responsibilities:

  • Technical and Functional requirement analysis, design and implementation of solution
  • Designed the critical parts of the data warehouse that manages customer revenue in relation to the agents' performance.
  • Prepared detailed technical specifications of the data warehouse and the ETL codebase.
  • Designed and developed both the Informatica portion and the Teradata BTEQ parts of the solution in a time/cost-sensitive atmosphere.
  • Created, tested and debugged PL/SQL stored procedures, triggers, packages and SQL queries and embedded SQL in Unix shell scripts.
  • Created complex mapping in Informatica that integrate, transform, standardize, format, aggregate data from all the source systems.
  • Created, tested and debugged BTEQ scripts, Teradata SQL queries
  • Extensive code analysis of the team's BTEQ code and Informatica code to determine the efficiency and accuracy of the code.
  • Worked with Data Modelers extensively to suggest and implement database guidelines and structure.
  • Created ETL schedule workflow with job dependencies using UC4 Automation Engine.
  • Worked with the DBA and Tier2 team for solution implementation and guidance for production processes.
  • Debugged, corrected and successfully implemented several bug-fixes and performance improvement measures.

Confidential - Richmond, VA

Sr. Informatica Developer

Responsibilities:

  • Gathered requirements from users / Functional Team for Design, Development, Testing and Deployment stages.
  • Designed the architecture of the data warehouse which involves thorough understanding of the sources staging areas, operating data stores (ODS) and the warehouse.
  • Prepared technical specification document for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
  • Worked with the business users to understand and document the use cases and expectations of the Data Mart.
  • Define and implement ETL development standards and procedures(coding guidelines, best-practices, naming convention)
  • Created high level and low level design documents in coordination with the DEV lead for the ETL transformation and load processes.
  • Created complex mapping in Informatica that integrate, transform, standardize, format, aggregate data from all the source systems.
  • Created, tested and debugged BTEQ scripts, Teradata SQL queries and Teradata macros.
  • Created, tested and debugged PL/SQL stored procedures, triggers, packages and SQL queries and embedded SQL in unix shell scripts.
  • Designed ETL workflow with job dependencies and scheduling/sequencing using Unicenter WLM tools.
  • Analyzed and removed/reworked the bottlenecks in sources, targets, mappings and sessions.
  • Coordinated the technical work of multiple project teams who are responsible for the development, integration, administration, and evolution of the data warehouse.
  • Kept in-line with introduction of new practices, methods, and emerging technologies and how they can be applied to the ETL environment
  • Efficiently co-ordinated with Off-Shore team in INDIA for on-shore-off-shore hand-off and continuation of tasks.

Environment: Informatica Power Center 9.1/8.6, UNIX, Unicenter WLM, Teradata db, Teradata BTEQ scripts, Unix Shell scripts, Flat Files, mainframe data set files

Confidential, Fort Lee, NJ

Sr. Informatica Developer

Responsibilities:

  • Gathered requirements from users / Functional Team for Design, Development, Testing and Deployment stages.
  • Designed the architecture of the data warehouse which involves thorough understanding of the sources, staging areas, operating data stores (ODS) and the warehouse.
  • Prepared technical specification document for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
  • Worked with scrum master in creating and understanding user stories.
  • Created the design of the Fact and Dimension tables using ERWin, working together with the ETL data architect.
  • Worked with BI Developers to design various types of reports like pie chart, bar, slice and dice and KPIs and web reports.
  • Contributed functionally and technically to Business Intelligence Strategy development using Business Objects
  • Worked with the business users to understand and document the use cases and expectations of the Data Mart.
  • Developed data quality reconciliation methods and policies in association with the data architect and DBA.
  • Define and implement ETL development standards and procedures(coding guidelines, best-practices, naming convention)
  • Created high level and low level design documents in coordination with the DEV lead for the ETL transformation and load processes.
  • Created complex mapping in Informatica those integrate, transform, standardize, format, aggregate data from all the source systems.
  • Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL and T-SQL .
  • Designed ETL workflow with job dependencies and scheduling/sequencing.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features such as round robin/key-range partitions, data/index cache and parameter files to manage very large volume of data.
  • Analyzed and removed/reworked the bottlenecks in sources, targets, mappings and sessions.
  • Used slowly changing Dimension techniques to load and keep track of dimension data.
  • Promoted repository objects, services and scripts from development environment to production environment
  • Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information required for the Maintenance and Operation of the application.
  • Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
  • Coordinated the technical work of multiple project teams who are responsible for the development, integration, administration, and evolution of the data warehouse
  • Kept in-line with introduction of new practices, methods, and emerging technologies and how they can be applied to the ETL environment
  • Co-ordinated with Off-Shore team in INDIA.

Environment: Informatica Power Center 9.1/8.6, Informatica Admin Console, Informatica Power Exchange, CDC,Salesforce.com,Oracle11g/10g,SQL Server 2005/2008, Business Objects XI R2, Flat Files, Toad9.0, UNIX, Autosys, Erwin Designer4.1.

Confidential, Providence, RI

Sr. ETL Developer/Designer

Responsibilities:

  • Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
  • Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
  • Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards
  • Used slowly changing Dimensions techniques to load the dimensions.
  • Worked with various Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
  • Removed Duplicate records, rejected invalid Data using Informatica.
  • Developed standard and re-usable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup (connected/unconnected), filter.
  • Created Mapplets, reusable transformations and used them in different mappings.
  • Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
  • Involved in Unit testing, System testing to check whether the data loaded into target is accurate, which was extracted from different source systems according to the user requirements.
  • Migrated repository objects, services& scripts from development to production environment.
  • Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
  • Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 8.6, Informatica Admin Console, Oracle11g/10g,SQL Server 2005/2008, Business Objects XI R2, Flat Files, Toad9.0, UNIX, Autosys, Erwin Designer4.1.

Confidential, NEW YORK, NY

Informatica Developer

Responsibilities:

  • Actively Participated in collecting user requirements.
  • Involved in drafting Software Requirement Specification for the project.
  • Developed High Level Technical Design specification and Low-level Design based on business requirements.
  • Drove the development of the logical and physical data models, ETL programs/scripts, metadata definitions, schedules, work processes, and maintenance procedures
  • Prepared database DDL scripts for create, delete, alter table.
  • Created ETL specifications describing the mapping logic for developers.
  • Identified bottlenecks in source, target, mapping, session and resolved them by implementing better logic and/or database object/query optimization.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumes of data.
  • Monitoring Production system, performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed mapping into the production environment.
  • Oversaw the design of the data and technical architecture for the data warehouse.
  • Evaluate the Change Data Design, including slowly changing dimensions and Operational Data Store Design.
  • Prepared time estimates and tracked each task against the estimated task and assisted in keeping project delivery deadline.

Hire Now