SUMMARY

• Over 9 years of experience in Business Intelligence, Data Modeling and Data Warehousing across multiple domains in various roles as a Project Lead, Lead ETL(Informatica) developer, Teradata/ SQL developer and Informatica Admin
• 4 years of leadership experience in architectural design, technical decision - making and solution estimation. Architected and developed solutions for highly scalable, highly available systems
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Expertise in communicating with cross-functional teams and across organizational levels to drive a shared vision and to foster a culture of excellence.
• Strong presentation skills with the ability to take very technical concepts and present them to non-technical teams
• Participate in technology leadership meetings to provide feedback and recommendations to other leaders
• Expertise in scoping and creating agile release for projects
• Spear-headed different initiatives like organizing knowledge sessions, creating knowledge repositories, reference checklists and templates for sharing knowledge and mentoring junior developers
• Professional experience using advanced SQL coding in various platforms, such as Oracle, Teradata and SQL server for data mining and report generation.
• Solid background in using Teradata utilities like MULTILOAD, BTEQ and FASTEXPORT to load/import/export the data.
• Exposure to the entire process of Software Development Life Cycle implementation.
• Extensive expertise in creation and automation of workflows using Autosys.
• Managed onsite-offshore model and coordinated with SMEs and project managers.
• Provided technical oversight and guidance during client’s engagement execution
• Worked with the Production Support team during month-end cycles to troubleshoot failures, provide workarounds and perform RCA for the bugs identified during the batch processing.
• Worked with the Production Support Team during the Production Release cycles and provided support for the release.
• Proficient in troubleshooting and fixing the bottlenecks in performance
• Supported Informatica admin activities in all environments and migrated the code from one environment to another.

TECHNICAL SKILLS

• ETL Informatica Developer & Admin, Teradata Developer
• Unix shell scripting, SQL, PL/SQL, BTEQ
• Reporting OBIEE
• Amazon AWS
• Oracle, Teradata, SQL server
• Job scheduling AutoSys, CA Workload Automation
• MS Visio 2010/2013, Erwin
• SVN
• Jira
• ServiceNow, AR Remedy Ticket Tracking System

PROFESSIONAL EXPERIENCE

Confidential

Lead Informatica/Teradata Developer

Responsibilities:

• Periodically met with the client team, gathered, documented and analyzed Business requirements. Developed detailed design documents and mapping documents.
• Scoped the project and created an agile release plan
• Created data models using Erwin
• Developed Data Standardization guidelines to ensure uniform enterprise naming convention
• Developed Code review checklists to ensure consistency across the codebase and to reduce technical debt
• Designed & developed various metrics to accommodate adhoc reports
• Implemented different techniques to improve the performance in Informatica level.
• Used Push down Optimization for better performance. Even used TPT for better performance.
• Wrote multiple Bteqs to load data from Stage tables to Fact tables.
• Developed the ETL mechanisms to load the data incrementally from the source database into the staging area and from there to feed the satellite applications in the form of flat files, XML files and relational tables. Most of the extract process was incremental, while others were full loads and snapshots.
• Extensively worked with XML files as the Source and Target.
• Effectively worked on Onsite and Offshore work model. Delivered two modules by leading a team of more than 6 developers in offshore and coordinating with on-shore members.
• Designed dataflow layout for the project through AutoSys to run all the jobs smoothly.
• Involved in and hosted numerous review meetings with project teams and developers to report, demonstrate, prioritize and suggest resolution of issues discovered during testing.
• Designed and developed reusable mapplets for each rule.
• Supported Informatica admin activities in all environments and migrated the code from one environment to another.
• Used Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Worked on Slowly Changing Dimensions.
• Extensive experience in debugging, troubleshooting, monitoring and performance tuning in SQL queries.
• Production support experience on Informatica PowerCenter and UNIX/TERADATA.
• Prepared test plan documents, test cases and test scripts for Development & Migration projects and tested accordingly.
• Automated the Informatica Administrative tasks like Purge older version objects, Purge older version Session/Workflow logs.
• Developed and enhanced custom unix scripts for source file validations

Environment: Informatica: 9.5.1, 10.1.1; Teradata, SQL Server, Oracle, Sybase; AutoSys; UNIX

Confidential

Lead Informatica Developer

Responsibilities:

• Analysis of the specifications provided by the clients and mapping them to the technical requirements.
• Working with the Architecture team and Informatica Admin team to get the required databases and Informatica environments set up.
• Developed and enhanced multiple custom UNIX scripts.
• Created Autosys Scripts for job scheduling. Batch design for one project.
• Created Functional specifications and testing documentations
• Coordinated and worked on Monthly releases to migrate code from multiple environments into Production.
• Performed unit testing and identified the gaps between the functional requirements and mappings and fix bugs if any. Worked closely with the Business to provide demos and provide the required support for the POC mappings for UAT.
• Documented the known issues and roadblocks for the development of the actual mappings after the POC mappings have been approved.
• Supported batch in SIT, UAT, Regression testing, also in production parallel and post go live warranty period support.
• Implemented the Global Parameter file to simplify the usage of Parameters across the environments.
• Created Folders/Connection Strings using Informatica PowerCenter tools
• Performed the code reviews

Environment: Informatica: 8.6, 9.1.6; Oracle (10g, 11g), SQL Server; AutoSys; UNIX