SUMMARY

• 12+ years of IT experience as Data Warehousing - ETL Development Lead
• 12+ years of experience in using Informatica Power Center Client- Designer, Workflow Manager and Workflow Monitor as an ETL tool.
• Extensive knowledge in architecture design of Extract, Transform, Load environment, also worked as Analyst gathering user’s requirements.
• Involved in end to end Agile and Waterfall full life cycle implementation of data warehouse project
• Experienced in AWS Redshift Cloud Data Warehouse.
• Experienced in ETL job schedulers like Maestro and Autosys.
• Experience in identifying bottlenecks in ETL processes and performance tuning of applications using Database tuning, Session partitioning and transformation tuning.
• Experienced in ETL Unit testing, Integration testing and QC.
• Expertise in mapping design, HLD, LLD and unit test documentation.
• Experienced in developing UNIX shell scripts.
• Well versed with Informatica parallelism techniques.
• Expertise in the concepts of Data Warehousing, Data Marts, Dimensional Data Modeling Star and Snow flake schema, Fact and Dimensional Tables.
• Proficient in RDBMS (Relational Database Management Systems) with experience in Teradata and Oracle.
• Knowledge of Talend, Hadoop HDFS framework, NoSQL MongoDB and Hive.
• Familiar with BI reporting tools Tableau, Business objects, Cognos.
• Strong experience in managing medium to large teams.
• Proficient in Project Planning, Estimation, Implementation, Coordination, Reporting, Onsite-offshore coordination, Effective Communication, Stakeholder management.
• Able to deal with complex situation.
• Good Leadership Qualities, Project Management and Communication Skill.

TECHNICAL SKILLS

• Informatica Power Center
• Dimensional modeling
• Unix Shell scripting
• Teradata
• Oracle 10
• AWS Redshift

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL Senior developer

Responsibilities:

• Implemented E2E data warehouse cycle using Agile methodology.
• Gathered requirements according to HLD document and prepared LLD documents.
• Analyzed source tables/file structures, Target tables’ structures. Created new source/target tables and updated existing tables for DEV, TEST and PROD environments.
• Created source to target mapping documents to achieve desired data transformations.
• Developed new Informatica PowerCenter mappings to enhance functionality and integrated it with existing code to handle failures in data processing.
• Optimized existing ETL mappings to achieve performance tuning and reduce resource consumption. Updated existing documentation.
• Designed and developed Teradata views to generate reports for end users.
• Created Teradata Bteq scripts to perform Teradata SQL operations.
• Created shell wrapper scripts to set environment variables.
• Performed unit testing, integration testing, sanity testing, System testing and supported User acceptant testing.
• Prepared deployment document in order to support production code deployment and execution.
• Developed ETL code using Informatica to populate data from Flat files to AWS Redshift.

Technology/Software: Informatica PC 10.1, Teradata, Agile, AWS Redshift.

Confidential, NY

Informatica PC Senior developer

Responsibilities:

• Developed high quality Mappings, Sessions and Workflows using Informatica PC.
• Used various transformations like Filter, Router, Expression, Lookup(connected and unconnected), Aggregator, Sequence generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in Informatica Designer to develop code with very low defects and in given timeline.
• Implemented Pass Through, Auto hash, User defined hash key and Database partitions for performance tuning in Informatica.
• Worked on analysis of source systems, business requirements gathering with extensive interaction with Business analysts, customers and reporting teams.
• Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio.
• Designed and developed Mappings, Sessions and Workflows as per the business requirements.
• Done Individual rule validation and analyzed the linage diagram for the expected flow.
• Helped team in fixing technical issues and ensure that they use proper code, db performance tuning techniques.
• Designed and reviewed HLD, LLD documents to ensure high quality.
• Prepared impact analysis and implementation plan documents.
• Coordinated system/Integration/UAT testing teams along with development team and reviewed test strategy.

Technology/Software: Informatica PC 9.6, Oracle.

Confidential

Informatica Sr. Developer

Responsibilities:

• Lead the team and interacted with Business Analyst to understand the business requirements.
• Reviewed HLD, LLD, impact analysis, test documents to ensure high quality.
• Prepared Inventory list of objects to be migrated and worked on Estimations.
• Used various transformations like Filter, Router, Expression, Lookup(connected and unconnected), Aggregator, Sequence generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in Informatica Designer to develop code with very low defects and in given timeline.
• Implemented Pass Through, Auto hash, User defined hash key and Database partitions for performance tuning in Informatica.
• Worked on XSD to XML file generation through Informatica ETL process.
• Prepared validation SQL scripts.
• Followed Peer review, Group review for the source code.
• Created Informatica Mappings, Sessions and Workflows in Development environment and then migrated them to Test followed by Production Environments.
• Helped team in fixing technical issues and ensure that they use proper code, db performance tuning techniques.
• Coordinated system/Integration/UAT testing teams along with development team and reviewed test strategy.

Technology/Software: Informatica PC 8.6, Teradata, Oracle, Maestro.