Sr. Informatica Developer Resume
Sunnyvale, CA
SUMMARY
- 6+ years of extensiveexperiencesin the field of Information Technology, with experience in analysis, design, development, Data Warehouse, Unit testing and Documentation.
- An expert in thedata warehousing projects as a TERADATA Developer and ETL Tool INFORMATICA which includes components like Power Center, Power Exchange, Designer, Workflow Manager, Workflow Monitor, Repository Manager and implemented data integration solutions across domains like Insurance, Health care.
- Expert in writing BTEQ, FAST LOAD and MULTI LOAD scripts according to the business demand with the given transformation or business logics and good exposure on FAST EXPORT, TPUMP, TPT (Teradata Parallel Transporter)etc
- Worked with Joins, Sub Queries, and Set Operations extensively.
- Observed the usage of various Teradata features like UPI, USI, and PPI, JOINIndexes.
- Worked with Explain Command and Collect Statistics and identified JoinStrategies.
- Identifying long running queries bottlenecks (Spool Space Issues and Skewness etc.…) implementing appropriate tuningmethods.
- Good understanding of TeradataArchitecture, protection concepts like Locks, Fallback, Journals, RAID, Clique etc...
- Written Unit Test casesand submitted Unit test results as per the quality process.
- Gained exposure of Software Development Life Cycle(SDLC).
- Worked on various Teradata versions like TD12, TD13, and TD14.TD15
- Expert in creatingInterfaces,Packages,Generating,Exporting,ImportingandExecutingScenarios
- Experience in using the Informatica’s advanced utilities like Pushdown optimization, CDC techniques, Partition and implemented Slowly Changing Dimensions Type 1, Type 2 methodology.
- Experience in working with various Informatica power center transformations like, Source Qualifier, Aggregator, Router, Joiner, Rank, Sequence Generator, Transaction Control, Lookup, Normalizer and implemented solution Tuning for Transformations.
- Experience on Data Extraction, Transformation, and loading with RDBMS,Flat files etc.
- Sound knowledge in performance tuning &optimization both in Informatica and database side, Error handling and Troubleshooting using various log files.
- Configure standard mappings using mapplets and transformations to move data from staging to the target with maximum precession meeting expected results.
- IntegratedMappings and Mapplets with Power Center and automated the scheduling process.
- Participated in Design team and Requirement gathering meetings.
- Worked on ftp for file transmissions, monitoring system activity for resource contentions, system sanity checks, etc. Knowledge in Star Schema, Snow Flake Schema, Dimensions and Fact tables.
- Experience in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems and Having exposure in OLTP and OLAP Transactions.
- Extensively involved in using Quality Center to report bugs.
- Prepared Daily status reports and Weekly status reports.
- Involved in the migration of Informatica mapping from Dev to SIT, UAT environments.
- Flexible to learn advancements in the IT industry, Quick learner, Team Player, willing to learn new technologies.
- Proficient in data analysis, defect identifications and resolutions, analyzing business/data requirements, writing metadata definitions, and writing data mapping specifications.
- Conduct code walkthroughs and review peer code and documentation which involves reviewing code for Quality and adherence to established standard practices.
- Excellence in oral/written communications, interpersonal relations, team cooperation and demonstrated ability to communicate with both technical and business stakeholders.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 10.x/ 9.x/8.x,informatica IDQ
RDBMS/Others: Oracle 10g/11g, Netezza, DB2, RedShift,Flat Files,Teradata
Database Languages: Sql*Plus, PL/SQL, SQL*Loader, Teradata sql assistant
Programming Languages: UNIX Shell Scripting
Operating Systems: Unix, MS DOS, Windows XP/7/8/10
Reporting Tools: Tableau
PROFESSIONAL EXPERIENCE
Confidential, Sunnyvale, CA
Sr. Informatica Developer
Responsibilities:
- Analyzed source data files and gathered requirements from the business users.
- Design and build Teradata SQL,TPT, BTEQ and UNIX shell script
- Performance tuning for Data warehouse Database (Teradata) and Data warehouse operations.
- Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data
- Prepare technical specifications to develop source system mappings to load data into various tables adhering to the business rules.
- Analyzed and created Facts, Dimension tables, modeled the data warehousing data marts.
- Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and warranty support for production environment.
- Involved in preparing Plan and effort estimations required to execute the project.
- Designing and building Informatica solution and PDO( Push down optimization ) where required
- Extensively worked with Informatica Power Center.
- Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
- Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner and reusable transformations
- Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
- Created reusable transformations and mapplets and used them in mappings.
- Wrote detailed design specs for ETL. Converted the functional specs written by Data Modelers into the detailed design spec for ETL
- Implemented Fullpushdownoptimizationtechniques in Informatica in order to extract and load high volume tables.
- Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
- Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
- Developed Interfaces to load the data from Flat Filesto stage and from stage to Teradata Data warehouse.
- Migrated Informatica Mappings from Dev to SIT and UAT.
Environment: Informatica Power Center 10.1,flatfiles, Teradata 15, Teradata SQL Assistant, Unix, HP quality center, Remedy, Winscp,Microsoft Office Suite,Snow tool,SVN
Confidential, Centerville, VA
Sr. Informatica Developer
Responsibilities:
- Extensively involved in business requirements gathering.
- Involved in design sessions to translate user requirements to technical specs.
- Designed and developed complex Informatica mappings in conjuction with Unix scripts to load source data into Data Warehouse by applying business logic.
- Used most of the informatica provided functionalities (Transformations: Expression, Aggregator, Filter, Router, Sorter, Lookup, Stored procedure, Normalizer etc…. other objects like Maplets, Pre - Sql, Post-Sql, Pre-Session, Post-Session) to create complex process to meet the business requirements.
- Used FastExport Utility to extract large volumes of data at high speed from Teradata RDBMS. Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
- Built complex processes to load inconsistent data from flat files.
- Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformationdeveloperand mapplet designer inInformaticaPower Center 9.1.0.
- Designed and Developed complex process for reporting on all source files received from various vendors.
- Wrote transformations for data conversions into required form based on the client requirement using Teradata ETL processes
- Performance tuning for Data Warehouse Database (Teradata) and Data Warehouse operations. Identify and Remove Bottlenecks to improve the performance of mappings and workflows.
- Developed complex regexp in informatica to validate email address.
- Developed UNIX shell scripts to run batch jobs in production. Worked with BTEQ in UNIXenvironment and execute the script from UNIX platform.
- Automatedexisting Informatica workflows to run every day in UNIX.
- Worked extensively with Netezza procedures & SQL.
- Created and executed queries on repository to report on the Informatica objects.
Environment: Informatica Power Center 9.6, DB2,Netezza 5.0/6.0,Oracle10g/11g, AIX, WinSQL Professional, Teradata.
Confidential
Informatica Developer
Responsibilities:
- Extensively used Informatica Power Center tools like the Source Analyzer, Transformation Developer, Warehouse Designer, Mapping Designer and Mapplet Designer to design informatica objects to move data from OLTP to Oracle Data warehouse.
- Worked extensively on different types of Transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup, Stored Procedures, Sequence Generator, Normalizer and Joiner to design new mappings.
- Worked with type 1 and type 2 dimensional mappings to load data from source to target.
- Optimize SQL queries for better performance.
- Developed Packages, Procedures and function to maintain the Business logic using PL/SQL.
- Created PL/SQL complex procedures.
- Developed complex mappings to replace Oracle proprietary PL/SQL APIs.
- Customized SQL Override queries where ever possible, to minimize the use of joiner, Aggregator and Lookup transformations.
- Extensively used informatica Scheduler for scheduling jobs.
- Involved in writing korn shell scripts to automate the whole process for incremental load by using the pre and post session command options.
- Extensively worked on designing work flows and creating dependencies by using unix and informatica interfaces.
- Worked extensively in finding out the bottle necks in mappings and tuned to optimize the performance and response times..
- Redesigned / Tuned the jobs to achieve maximum performance.
- Involved in workflow documentation, which gives extensive information about the control flow and the dependencies.
- Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data loading processes.
- Worked on ftp for file transmissions, monitoring system activity for resource contentions, system sanity checks, etc. Knowledge in Star Schema, Snow Flake Schema, Dimensions and Fact tables.
- Involved in running jobs and SQL scripts on the Database as a part of UAT.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Worked on NDM logs and Worked on AWK to format the data in the files.
- As a part of daily loading into the warehouse, used UNIX shell scripting to triggers the workflows in a particular order.
Environment: Informatica PowerCenter 8.x/9.1, Netezza Performance Server,ORACLE 10g,Business Objects xi, SQL, PL/SQL, MS Visio, SQL *Loader, NZ Load, Toad, Winsql, UNIX Shell Script, Win XP Pro.